Power BI, Analytics Engineering Lead

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

📋 Description

• Take ownership of the technical design and upkeep of shared semantic models that facilitate enterprise analytics and reporting.

• Create and oversee reusable DAX measures, calculation logic, relationships, and standard analytical definitions.

• Set forth reporting standards encompassing model design, visual presentation, naming conventions, documentation, testing, and deployment.

• Spearhead the development of dashboards, reports, analytical products, and regulated self-service reporting capabilities.

• Utilize Power BI Desktop, Power Query, and SQL for data preparation and to implement sanctioned reporting requirements.

• Collaborate with mission owners and business analysts to identify KPIs, business rules, calculations, and acceptance criteria.

• Choose suitable query and refresh patterns aligned with approved hosting and security setups.

• Configure and support sanctioned gateway connectivity, data source connections, refresh schedules, and operational dependencies.

• Monitor and enhance the performance of semantic models, queries, refresh processes, and reports.

• Design and validate access controls, role assignments, and data visibility in conjunction with Government and cybersecurity teams.

• Uphold controlled processes for development, testing, approval, deployment, and rollback of BI changes.

• Coordinate the reconciliation and testing of measures, aggregations, filters, relationships, security behaviors, and reporting outputs.

• Partner with data engineers and database teams to address source-data, transformation, schema, and performance challenges.

• Maintain traceability between reporting requirements, source data, model logic, test evidence, and released products.

• Review technical designs, providing direction to BI developers and analysts.

• Keep model documentation, measure definitions, data mappings, deployment instructions, and operational runbooks up to date.

• Facilitate release-readiness reviews, user acceptance testing, operational handoffs, and knowledge transfer.

• Convey technical risks, data limitations, performance insights, dependencies, and recommendations for improvement to Government stakeholders and program leadership.

⛳️ Requirements

• Possess an active Secret clearance or higher.

• Have a minimum of 12 years of relevant professional experience.

• Hold a Bachelor’s degree in information systems, computer science, data analytics, or a related field, or an equivalent qualification.

• Demonstrate experience with Power BI Desktop, Power Query, and SQL.

• Have experience in developing and maintaining shared semantic models and DAX measures.

• Ability to establish and uphold reporting standards.

• Experience in optimizing BI model, query, refresh, and reporting performance.

• Familiarity with designing access controls for BI capabilities.

• Experienced in implementing controlled BI deployment processes.

• Have experience working with approved hosting configurations and gateways.

• Ability to select and implement suitable query and refresh patterns.

• Possess an applicable DoD 8570 certification for the assigned responsibilities.

🏝️ Benefits

• Opportunity to support the USMEPCOM ENLIST program under an active competitive government contract bid.

• Chance to collaborate with Government stakeholders, business analysts, data engineers, database personnel, governance specialists, cybersecurity teams, and testers.

• Opportunities for knowledge transfer and professional collaboration.

• Equal employment opportunity and affirmative action protections.