• Define and implement the end-to-end architecture for the Lakehouse, ensuring support for high-volume batch processing, real-time streaming, and GenAI/LLM initiatives using Mosaic AI and MLflow • Design solutions that prioritize data quality at the source • Establish and enforce architectural patterns that ensure reliability and trust in data assets • Implement automated testing and observability frameworks (e.g., Delta Live Tables expectations) to maintain data health • Translate complex business requirements into robust logical and physical data models • Document and maintain clear data flow architectures for applications to ensure alignment between business intent and engineering output • Lead virtual Scrum teams and provide deep technical mentorship to data engineers and developers • Advocate for Spark/Databricks best practices, conduct code reviews, and drive the adoption of CI/CD and DevOps principles in data workflows • Architect the frameworks for data lineage, security, and lifecycle management (utilizing Unity Catalog) • Ensure strict compliance with internal policies and external regulations from the point of data ingestion to final consumption • Partner directly with business stakeholders to understand their roadmap and priorities • Ensure all data and AI initiatives are strictly aligned with tangible business value • Manage the architectural roadmap to balance immediate business needs with long-term technical scalability

• Architect, implement, and maintain scalable data pipelines across core systems. • Build and manage analytics infrastructure using both open-source and commercial tools. • Ensure data quality and schema discipline for operational reliability. • Deliver clean, consistent models and dashboards utilized by multiple teams. • Collaborate with stakeholders to support analytics, business intelligence, and decision-making initiatives.

• Develop, and maintain database solutions and data warehouse architectures using MSSQL 2019/2022 and MySQL 8. • Collaborate with stakeholders to gather requirements and understand business needs for data storage and processing. • Develop and maintain ETL processes using SSIS, BIML, and DBT to ensure efficient data integration and transformation. • Implement and manage solutions within Power BI Fabric for enterprise-scale data analytics. • Write complex SQL queries, stored procedures, functions, and triggers to support application and reporting requirements. • Optimize query performance through indexing strategies, execution plan analysis, and database tuning techniques. • Troubleshoot and resolve database performance issues, data integrity problems, and system bottlenecks. • Monitor database health, perform capacity planning, and implement proactive maintenance strategies. • Develop automation scripts using PowerShell and Python to streamline database operations and maintenance tasks. • Ensure data security, backup and recovery procedures, and compliance with organizational standards. • Utilize version control tools such as Git and project management tools like Jira and Confluence or similar platforms as required. • Work effectively in a team environment, collaborating on concurrent developments and contributing to team success. • Document database architectures, ETL processes, standards, and procedures. • Stay current with database technologies, best practices, and emerging trends in data warehousing. • Provide technical guidance and support to team members and end-users as needed. • Contribute to continuous improvement initiatives related to data management and analytics infrastructure.

• Lead data analysis, mapping, and transformation efforts • Collaborate with project teams to define requirements • Perform comprehensive data analysis and cleansing • Develop, test, and implement SQL-based ETL scripts • Validate migration outcomes through rigorous testing