Apply on Employer Site

Crowe · 2 months ago

Data Solutions Architect - Financial Data, Compliance & Business Intelligence

San Francisco CA USA

Full-time

Onsite

Senior Level

$102K/yr - $204K/yr

7+ years exp

Crowe LLP is a leading public accounting, consulting, and technology firm in the United States, recognized for its commitment to innovation and career growth. They are seeking a Data Solutions Architect to lead initiatives in solving complex business issues related to financial data and compliance through advanced analytics and data management strategies.

AccountingAdviceConsultingFinanceFinancial ServicesInformation TechnologyProfessional ServicesTax 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 ArchitectureAzure Data PlatformBank Secrecy Act (BSA)Anti-Money Laundering (AML)Data AnalyticsData WarehousingETL/ELT ProcessesStatistical ModelingTeam ManagementPythonRSQLTableauPower BIMachine LearningCommunication SkillsIntegrity

Required

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

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