Data Analytics Data Solutions Architect

Chicago, Illinois

Crowe
Apply for this Job
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.

Job Description:

A career in our Business Intelligence practice, within Data and Analytics Technology services, will provide you with the opportunity to help organizations uncover enterprise insights and drive business results using smarter data analytics. Leveraging a collection of organizational technology capabilities, including business intelligence, data management, and data assurance, we help our clients drive innovation, growth, and change within their organization using business intelligence.

Our rapid business intelligence solutions, data visualization, and integrated reporting dashboards allow our team to deliver agile, highly interactive reporting and analytics that help our clients to run their business, understand what business questions can be answered and how to unlock the business drivers more effectively.

Specific responsibilities include but are not limited to:

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 BSA/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.
  • 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
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), or related data analytics certifications are a plus.
Preferred Skills and Experience
  • In-depth understanding of BSA/AML regulations and compliance requirements.
  • Experience working in or consulting for financial services clients is highly desirable.
  • 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
Key Stakeholders This Role Interacts With:

Internal
  • Senior BI Analyst
  • Data Product Manager
  • BI Architect / Senior Architect
  • Data Engineers
  • Analytics Developers (Power BI, Tableau)
External
  • C-Suite Executives (CEO, CFO, CIO, etc.)
  • Clients Operations Leads and Mid-Level Managers
  • Data Owners, Data Stewards
  • Enterprise Information Management and Data Governance Team
We expect the candidate to uphold Crowe's values of Care, Trust, Courage, and Stewardship. These values define who we are. We expect all of our people to act ethically and with integrity at all times.

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Crowe, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $102,400.00 - $204,100.00 per year. Our Benefits:
Your exceptional people experience starts here. At Crowe, we know that great peopleare what makes a great firm. We care about our people and offer employees a comprehensive total rewards package. Learn more about what working at Crowe can mean for you.

How You Can Grow: . click apply for full job details
Date Posted: 30 April 2025
Apply for this Job