Data Solutions Architect 3rd

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.

The shift timings for this role is 5:00 PM - 2:00 AM IST (7:30 AM - 4:30 PM ET)

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.
• Serve as subject matter expert on Business Intelligence engineering platforms (e.g., 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.
• 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.
• 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 concept 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, Business Analytics, 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:

• 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.

Skills

Azure, Data Integration, Data Lake, Data Warehouse, ELT, ETL