Data Solutions Architect

Data Solutions Architect Your journey at Crowe starts here: At Crowe, you can build a meaningful and rewarding career. With real flexibility to balance work with life moments, you're trusted to deliver results and make an impact. We embrace you for who you are, care for your well-being, and nurture your career. Everyone has equitable access to opportunities for career growth and leadership. Over our 80-year history, delivering excellent service through innovation has been a core part of our DNA across our audit, tax, and consulting groups. That's why we continuously invest in innovative ideas, such as AI-enabled insights and technology-powered solutions, to enhance our services. Join us at Crowe and embark on a career where you can help shape the future of our industry. Crowe is looking for a Data Solutions Architect to be a leader on our team of problem solvers with extensive consulting and industry experience. The primary focus will be helping our clients solve complex business issues from strategy to execution. Specific responsibilities include but are not limited to: Serve as subject matter expert on Business Intelligence engineering platforms (Ex - Microsoft SQL Server, Azure Data platform, Snowflake, DBT) demonstrating platform capabilities and promoting application of toolset to address business needs and maximize the value realized from technology investment. Oversee the design and deployment of data pipelines, analytics platforms, and reporting frameworks that improve transparency and support decision-making. Utilize advanced analytics, machine learning, and statistical modeling techniques to detect anomalous activity and patterns in transaction data. Ensure data quality and integrity through best practices in data management and governance. Mentor and lead a team of data analysts and consultants, fostering a collaborative and innovative work environment. Provide technical guidance and career development opportunities to junior team members, ensuring high levels of performance and professional growth. Facilitate cross-functional collaboration among teams to integrate data-driven insights into broader business strategies. Keep abreast of evolving regulations and industry standards related to BSA/AML and financial crime prevention. Develop and implement frameworks that align with regulatory changes and help clients stay ahead of compliance requirements. Work with legal and compliance teams to translate regulatory requirements into actionable data analytics strategies. Contribute to proposals and presentations for potential clients, demonstrating expertise in data analytics and regulatory compliance. Represent the organization at industry events and conferences as a subject matter expert in data consulting for Bank Secrecy Act (BSA) and Anti-Money Laundering (AML). Drive internal innovation by identifying emerging technologies and methodologies that can improve service delivery. Participate in presales engagements to manage the vision and expectations of a client's multiple stakeholders and create a conceptual solution design involving effort estimation, technical and functional solution, execution methodology, project plan, and team. Participate in the systems development process, including planning and monitoring systems development efforts, coordinating activities with other groups, reviewing deliverables and communicating status to the project manager and client. Lead and provide technical guidance and mentorship to other team members. Architect, implement, deploy, and support analytical databases and pipelines in an Azure environment. Create proofs of concepts as necessary for architectural vision, strategy, and tool evaluation. Document, diagram, and present complex/technical material that can be understood by a non-technical audience. Create and deploy accurate client architecture and analyses in a relatively short period of time. Qualifications: Bachelor's degree in Computer Science, Data Science, Information Systems, Finance, or a related field is required. Advanced degree (Master's/Ph.D.) is preferred. Experience working in or consulting for financial services. In-depth understanding of Bank Secrecy Act (BSA), Financial Audits, or Anti-Money Laundering (AML) regulations and compliance requirements. At least 710 years of progressive experience in data analytics, consulting, or financial services; a strong background in banking and regulatory compliance implementations is desired. Proven track record in managing complex data projects and leading cross-functional teams. Experience in working with large datasets, data warehousing, and advanced analytics tools. 8+ years of hands-on experience in enterprise data warehouse and data lake implementations. 5+ years of external client consulting experience. 5+ years of hands-on experience building automated ETL/ELT or data integration processes utilizing multiple source systems. 5+ years of team management experience (including offshore resources). 5+ years of experience leading multiple external client projects simultaneously. 5+ years of preparing detailed external client project budget estimations with strong resource management capabilities. 3+ years of in-depth experience in architecting, designing, and implementing complex data architectures on Azure including Azure Data Factory, Azure/Managed Instance SQL Server, Azure Logic App, and Azure Synapse Analytics. Experience mentoring teammates or conducting technical training. Possess integrity and a strong work ethic. Strong analytical and verbal/written communication skills. Certifications (Preferred): Certifications in BI (ETL tools, visualization tools, cloud architectures) are expected. Certifications such as CAMS (Certified Anti-Money Laundering Specialist), CFE (Certified Fraud Examiner). Preferred Skills and Experience: Hands-on experience with comprehensive dimensional modelling and end-to-end data warehouse projects, including: Requirements gathering Infrastructure planning and deployment Subject matter expert interviews Logical and physical dimensional model design and development ETL/ELT development and maintenance Model and data validation Documentation Previous consulting experience or experience working with external clients. Proficiency in analytics and statistical programming languages (e.g., Python, R, SQL). Experience with data visualization tools (e.g., Tableau, Power BI) and big data technologies. Familiarity with machine learning frameworks and cloud-based data platforms is advantageous. Experience working on projects using agile development practices. Azure experience: building landing zones, provisioning resources, establishing security is a big plus.