Senior Data Engineer

CVP is a healthcare, technology, and consulting services firm serving healthcare, national security, and public sector clients. The Senior Data Engineer will lead delivery initiatives for federal human capital clients, developing and maintaining database management systems, producing reports and dashboards, and managing client and partner relationships. The role also provides technical expertise in data quality, Power BI, Excel, SQL, and workflow automation.

Responsibilities:

• Provides administrator support to the Government SharePoint Administrator, at the direction of the Federal PM, for data management and enterprise database solutions to support the evolution of data in meeting customer needs
• Applies advanced analytical and evaluative methods to diagnose data quality issues within the ServiceNow data model, identify root causes, and guide corrective actions in collaboration with analysts
• Demonstrates strong data management and quality assurance skills by evaluating data attributes, ensuring consistency across systems, and supporting complex updates for reconciliation
• Leverages cross-functional communication and coordination skills to collaborate with staffing, classification, executive resources, and data teams, ensuring shared understanding of position data and hiring needs
• Provides expert guidance on sourcing authoritative data for dashboards and reports, advising analysts on selecting appropriate source systems, understanding data lineage, and identifying reliable upstream inputs for analytic products
• Offers advanced expertise in Power BI data modeling, including shaping fact and dimension structures, defining calculated measures, and troubleshooting DAX logic
• Advises colleagues on Excel-based data engineering techniques, leveraging PowerQuery, structured references, and multi-sheet data models to standardize inputs prior to ingestion into enterprise dashboards
• Serves as a technical problem-solving resource for BI tools, participating in troubleshooting sessions to resolve logic, data-join, and visualization design issues
• Demonstrates experience in descriptive and diagnostic analytics to produce metric reports and coordinate information for dashboard visualization using tools such as Power BI and Tableau
• Utilizes SQL Server Query Editor and Microsoft Excel to perform work within the data management environment
• Utilizes PowerAutomate to support data collection and business process workflows

Requirements:

• Strong demonstrated experience with database management systems and understanding of dataset relationships
• Strong data management and quality assurance skills
• cross-functional communication and coordination skills
• advanced expertise in Power BI data modeling, including shaping fact and dimension structures, defining calculated measures, and troubleshooting DAX logic
• Excel-based data engineering techniques, leveraging PowerQuery, structured references, and multi-sheet data models
• experience in descriptive and diagnostic analytics
• Ability to obtain a Public Trust Clearance (U.S. Citizenship required)
• Master of Arts/Master of Science in a technical field
• Minimum 10 years of professional experience
• experience and understanding of SQL, XML, and JSON in support of data management operations
• experience with R and Python for data cleansing, manipulation, and data pipeline orchestration
• experience and understanding of database management systems, dataset relationships, data joins, and database referential integrity (DRI)
• Advanced proficiency with Microsoft Access, SQL Server Query Editor, and Microsoft Excel
• Detail-oriented with the ability to multi-task
• Proven leadership skills demonstrating strong judgment, problem-solving, and decision-making abilities
• Strong customer relationship management skills
• DHS or other Federal Human Capital experience
• Management consulting background or experience