[Remote] Lead Data Engineer
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