Note: The job is a remote job and is open to candidates in USA. MetaPhase is a consultancy that prioritizes employee culture and shared values. They are seeking a Lead Data Engineer to provide technical leadership and manage a team of data engineers, focusing on data architecture, modeling, and engineering tasks in an Azure environment.

Responsibilities

• Act as a servant leader and mentor a lean high performing team of data professionals
• Manage workload prioritization, sprint planning, and delivery oversight for database related tasks
• Maintain and enhance data models (ERDs), Data Dictionaries (DD), Source-to-Target mappings (STM) and other data related documentation to sustain existing operations while building new analytical capabilities
• Design, develop and maintain scripts for Azure SQL database that create/modify database objects (tables, views, constraints, triggers) and data integration routines (ETL) that support change data capture
• Design, develop and maintain Azure Data Factory object and components, Elastic Job Agents and Azure Functions that support database activities
• Review database deployment plans for scheduled releases and provide feedback
• Peer review database code to provide feedback and coach team members
• Create and maintain other technical documentation relating to data architecture
• Troubleshoot or assist team members with troubleshooting data issues to identify root causes, propose recommendations, and implement solutions that will improve data availability, increase data quality, and optimize performance
• Coordinate and act as a liaison with other groups including OCIO, Azure DBAs and Engineers
• Managing Power BI workspaces and on-premises MS data gateways

Skills

• A minimum of 7+ years of hands-on experience with database architecture, design, development, deployment, preferably in Azure environments
• Certified Scrum Master (CSM) certification required; candidates must possess an active CSM certification upon hire or obtain certification immediately following employment
• Data modeling experience with both transactional and analytical data stores
• Data integration experience with Python and Azure Data Factory (ADF), from design to implementation
• Report design, development, and deployment experience with Microsoft Power BI
• Expert in troubleshooting databases, SQL scripts, and clean coding techniques
• Team leadership experience
• Consulting experience in a federal government environment
• Data architecture experience on an enterprise scale, integrating multiple systems with different methods to accommodate various data structures and access protocols
• Leverage Python and PowerShell as needed for automation and data cleaning
• Demonstrated proficiency through Microsoft Azure Data & AI certifications, including certifications such as DP-700, DP-300, AZ-305, DP-420, and/or DP-100

Company Overview