Lead Data Engineer

MetaPhase Consulting • Reston, VA

13h • Remote

About The Position

At MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do a lot of important mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Today, we have a team that is invested in creating new solutions that lean forward, challenge the status quo, but also reflect our intimate knowledge of our customers’ business. Over the years we have fostered a culture in which we are united by shared values—passion, solidarity, generosity, curiosity, and boldness—and these come alive in the work we do and how we do it. Together, we know our people are our difference—for our clients and our colleagues. Are you ready to: Work alongside a dedicated and diverse set of people to offer honest advice and practical guidance to our clients? Learn and grow by taking advantage of every opportunity available to you? Join a company which prides itself on its shared values and inclusive culture? Be the difference and make it happen? Role Summary MetaPhase is seeking an experienced and strategic Data Engineer with 7+ years of experience to provide hands-on technical expertise with data architecture, data modeling, and data engineering tasks in an Azure environment. This role will provide both hands-on technical leadership and people management for a team of three data engineers supporting enterprise-wide data initiatives. In addition, the ideal candidate will lead database development work and help coordinate tasks with the web developers to ensure a robust integrated solution is built.

Requirements

• 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 performance-tuning databases, SQL scripts, and clean coding techniques.
• Team leadership experience.

Nice To Haves

• 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.
• Demonstrated proficiency through Microsoft Azure Data & AI certifications, including certifications such as DP-700, DP-300, AZ-305, DP-420, and/or DP-100.

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.
• Leverage Python and PowerShell as needed for automation and data cleaning.
• 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

Benefits

• MetaPhase Consulting is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability or veteran status, or any other factors protected by federal, state, or local law.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior