Data Analytics Data Solutions Architect

  • Chicago, IL
  • Posted 19 hours ago | Updated 6 hours ago

Overview

On Site
USD 102,400.00 - 204,100.00 per year
Full Time

Skills

Leadership
DNA
Artificial Intelligence
Dashboard
FOCUS
Snow Flake Schema
Reporting
Decision-making
Statistical Models
Data Quality
Collaboration
Legal
Presentations
Data Management
Innovation
Emerging Technologies
Service Delivery
Presales
Software Design
Software Estimation
Project Planning
Systems Engineering
Database
Evaluation
Computer Science
Data Science
Information Systems
Finance
Banking
Management
Advanced Analytics
Data Lake
Data Integration
Team Management
Offshoring
Project Budget
Resource Management
Microsoft SQL Server
Mentorship
Technical Training
Work Ethic
Analytical Skill
Communication
Visualization
Fraud
Data Analysis
Business Analysis
AML
Regulatory Compliance
Financial Services
Modeling
Data Warehouse
Requirements Elicitation
Dimensional Modeling
Extract
Transform
Load
ELT
Data Validation
Documentation
Programming Languages
Python
R
SQL
Data Visualization
Big Data
Machine Learning (ML)
Cloud Computing
Agile
Microsoft Azure
Provisioning
Business Intelligence
Analytics
Microsoft Power BI
Tableau
Customer Service
Enterprise Information Management
Data Governance
Expect
Training
MEAN Stack
SAP BASIS
Career Counseling
Auditing
Taxes
Network
Accounting
Genetics
Recruiting
Sourcing

Job Details

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 people are 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:
We will nurture your talent in an inclusive culture that values diversity. You will have the chance to meet on a consistent basis with your Career Coach that will guide you in your career goals and aspirations. Learn more about where talent can prosper!

More about Crowe:
Crowe ( is one of the largest public accounting, consulting and technology firms in the United States. Crowe uses its deep industry expertise to provide audit services to public and private entities while also helping clients reach their goals with tax, advisory, risk and performance services. Crowe is recognized by many organizations as one of the country's best places to work. Crowe serves clients worldwide as an independent member of Crowe Global, one of the largest global accounting networks in the world. The network consists of more than 200 independent accounting and advisory services firms in more than 130 countries around the world.

Crowe LLP provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Crowe LLP does not accept unsolicited candidates, referrals or resumes from any staffing agency, recruiting service, sourcing entity or any other third-party paid service at any time. Any referrals, resumes or candidates submitted to Crowe, or any employee or owner of Crowe without a pre-existing agreement signed by both parties covering the submission will be considered the property of Crowe, and free of charge.

Crowe will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws. Please visit our webpage to see notices of the various state and local Ban-the-Box laws and Fair Chance Ordinances, where applicable.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.