Data Analytics Data Solutions Architect

Jobright.ai; Connecticut; On-site; USD 140,000 - 190,000; Full time

Job summary

Crowe is seeking a Data Solutions Architect in the United States to lead data platform design and analytics across client engagements. You will oversee data pipelines, reporting frameworks, and ML-enabled analytics while mentoring a team of data analysts and consultants.

You will apply expertise in Azure Data Platform, data governance, and regulatory requirements related to BSA/AML to deliver compliant, insightful solutions.

Qualifications

• Data analytics and regulatory compliance experience in financial services.
• Bachelor's degree in a related field required.
• At least 7–10 years building data platforms and leading teams.

Responsibilities

• Serve as SME on BI platforms and oversee data pipelines and analytics
• Lead design and deployment of data pipelines and reporting frameworks
• Apply advanced analytics, ML, and statistical methods to detect anomalies
• Ensure data quality, governance, and compliance with regulations
• Mentor a team of data analysts and consultants
• Collaborate across functions to embed data insights into strategy
• Translate regulatory requirements into analytics strategies
• Contribute to client proposals and represent the firm at events
• Drive innovation with emerging technologies

Skills

Data Solutions Architecture

Azure Data Platform

Data Analytics

Machine Learning

Team Leadership

Regulatory Compliance

ETL/ELT

SQL / Snowflake / DBT

Education

Bachelor's degree

Tools

Azure Data Factory

Azure Synapse Analytics

SQL Server

Power BI

Snowflake

DBT

Azure SQL

Job description

Crowe is one of the largest public accounting, consulting and technology firms in the United States, dedicated to delivering excellent service through innovation. They are seeking a Data Solutions Architect to help clients solve complex business issues by overseeing the design and deployment of data pipelines, utilizing advanced analytics and machine learning techniques, and mentoring a team of data analysts.

Big Data Legal Sustainability Information Technology Accounting Analytics Compliance Environmental Consulting Tax Consulting

No H1B

Responsibilities

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

Qualification

Data Solutions Architecture Azure Data Platform Business Intelligence Engineering Data Analytics Machine Learning Data Governance ETL/ELT Processes Financial Services Experience Data Warehousing Client Consulting Analytical Skills Team Management Communication Skills Mentoring Integrity

Required

Bachelor's degree in Computer Science, Data Science, Information Systems, Finance, or a related field is required

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 7-10 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

Preferred

Advanced degree (Master's/Ph.D.) is 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)

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

Public accounting firm providing audit, tax, and consulting services.

Data Solutions Architecture Azure Data Platform Business Intelligence Engineering Data Analytics Machine Learning