Lead Data Engineer

Responsibilities

• Lead the design and productionalization of ETL/ELT processes to ensure efficient data ingestion and transformation
• Architect and implement Data Platforms and Data Warehousing solutions using Microsoft SQL Server, Azure Data Warehouse, or Azure Synapse
• Craft reporting data models using multidimensional/Kimball design principles for high-performance analytics
• Develop ML algorithms or frameworks with Python to support advanced analytics initiatives
• Oversee fine-tuning of T-SQL queries and performance optimization for existing solutions
• Define and enhance workflows leveraging tools like Power BI, Tableau, or QlikView for business intelligence needs
• Create conceptual and logical solution designs through ERD diagramming and Project Start Architecture documentation
• Implement Master Data Management strategies and design interfaces such as APIs for seamless data exchange
• Ensure scalable and efficient pipelines using platforms like Azure Data Factory, Data Lake, and Databricks

Requirements

• Minimum 6 years of experience designing and developing data ingestion processes within Data Warehouse and Data Lake environments
• Proficiency in Microsoft SQL Server, Azure Data Warehouse, or Azure Synapse
• Advanced competency in multidimensional/Kimball modeling and structured data management
• Strong skills in T-SQL, including advanced query optimization techniques and execution plans
• Proficiency in BI tools such as Power BI, Tableau, or QlikView
• Knowledge of Python for ML algorithm development
• Experience with Azure Data Lake, Data Factory, and Azure DevOps or equivalent cloud tools
• Background in agile environments with a focus on collaborative, cross-functional problem-solving
• Familiarity with ITIL processes related to change, incident, and problem management

Preferred Qualifications

• Agile/SAFe certifications
• Azure Data Engineer or equivalent AWS/GCP certifications
• Azure Administrator or Solutions Architect certifications
• Certified Data Management Professional (DAMA)

About the Company

EPAM is a global leader in digital platform engineering and software product development, helping organizations solve complex business challenges through cutting-edge technology and innovative data solutions.