Data Engineer IV – Power BI

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, construct, and maintain ingestion and transformation pipelines for Jira Commercial Cloud, Jira Align when applicable, LMS, surveys, and authorized enterprise data sources.

• Utilize SQL and Python to clean, reconcile, combine, validate, and document datasets from multiple sources.

• Create Power BI semantic models, DAX calculations, governed KPI definitions, refresh processes, and dashboards for leadership.

• Generate reports on Agile maturity, training completion, Jira adoption, onboarding phases, and portfolio progress.

• Implement access controls, quality monitoring, lineage documentation, error handling, and optimize report performance.

• Collaborate with business analysts, administrators, and governance stakeholders on defining metrics and validating dashboards.

• Assist with ongoing reporting, enhancements to dashboards, and operational transitions.

• Design ingestion, staging, transformation, and refresh processes that integrate approved REST API extracts and structured enterprise data sources.

• Establish robust SQL/Python transformation routines, quality tests, exception handling, provenance records, and scheduled refresh monitoring.

• Develop semantic models, DAX measures, dimensional relationships, accessible visuals, and reporting controls for leaders and practitioners.

• Define and document KPI logic for training completion, Jira adoption, team readiness, maturity changes, and implementation progress, including appropriate cohort denominators.

• Enhance report refresh and query performance, support role-based access, investigate discrepancies, and transfer runbooks and model documentation to sustainment teams.

⛳️ Requirements

• Bachelor's degree in computer science, engineering, data engineering, data science, information systems, or a related technical field; four additional years of relevant experience may replace a Bachelor's degree.

• Over 5 years of experience in data engineering, BI engineering, analytics engineering, or a similar field.

• Proficient in SQL and Python with experience in building production data pipelines.

• Advanced skills in Power BI, including DAX, modeling, transformation, and dashboard publication.

• Experience with data validation, privacy-aware access controls, and stakeholder KPI requirements.

• Ability to obtain and keep a favorable Public Trust determination and meet applicable federal personnel vetting, security, privacy, accessibility, and data-handling requirements.

• Certification as a Microsoft Power BI Data Analyst (PL-300) or Fabric Data Engineer (DP-700); previously issued Azure Data Engineer (DP-203) credentials are acceptable.

• Experience in implementing governed Power BI datasets or semantic models, with well-documented calculations and controlled refresh or publication processes.

• Capability to validate data with business owners, articulate uncertainty and gaps, and resolve discrepancies from source to report.

• Previous experience supporting the Department of Veterans Affairs (VA), Veterans Health Administration (VHA), or federal health programs is highly desirable.

• Familiarity with Jira and Atlassian APIs, Azure data services, and enterprise portfolio reporting.

• Experience in merging survey, LMS, HR, and software delivery data.

• Familiarity with Azure data services, cloud API pagination, monitoring, and reusable enterprise dashboard design patterns.

• A Master's degree in data engineering, computer science, applied statistics, data science, or analytics is highly desirable.

• Additional certifications such as Microsoft Fabric Analytics Engineer Associate (DP-600) or Azure Database Administrator Associate (DP-300) are preferred.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health and wellness benefits.

• Opportunities for professional development and continuing education.

• Flexible work arrangements and a supportive work environment.

• Generous paid time off and holiday policies.