Power BI, Analytics Engineering Lead

DecisionPoint Corporation

. Own the technical design and maintenance of shared semantic models supporting enterprise analytics and reporting .

Posted 10/28/2026full-timeRemote • Illinois • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in developing and maintaining shared semantic models, DAX measures, and reporting standards using Power BI, SQL, and Power Query. Proven ability to optimize BI performance and implement controlled deployment processes while ensuring compliance with security and access control requirements.

Highest-signal resume keywords

Power BI DesktopDAX Measures DevelopmentSQLBI Performance OptimizationActive Secret Clearance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Semantic Model DesignReporting Standards EstablishmentData PreparationQuery Patterns SelectionAccess Controls DesignControlled Deployment ProcessesTesting and ValidationData MappingOperational Runbooks MaintenanceKPI Definition

Soft Skills

CommunicationCollaborationLeadership

Tools & Technologies

Power QueryBI DashboardsData-Source ConnectionsGateway Connectivity

Certifications & Qualifications

DoD 8570 Certification

Industry Keywords

Enterprise AnalyticsGovernment StakeholdersCybersecurityBusiness IntelligenceData Analytics

Tech Stack

Tools & technologies

Cyber SecuritySQL

About the role

Key responsibilities & impact

Own the technical design and maintenance of shared semantic models supporting enterprise analytics and reporting
Develop and govern reusable DAX measures, calculation logic, relationships, and common analytical definitions
Establish reporting standards for model design, visual presentation, naming, documentation, testing, and deployment
Lead development of dashboards, reports, analytical products, and governed self-service reporting capabilities
Use Power BI Desktop, Power Query, and SQL to prepare data and implement approved reporting requirements
Coordinate with mission owners and business analysts to define KPIs, business rules, calculations, and acceptance criteria
Select appropriate query and refresh patterns within approved hosting and security configurations
Configure and support approved gateway connectivity, data-source connections, refresh schedules, and operational dependencies
Monitor and improve semantic model, query, refresh, and report performance
Design and validate access controls, role assignments, and data visibility with Government and cybersecurity personnel
Maintain controlled development, testing, approval, deployment, and rollback processes for BI changes
Coordinate reconciliation and testing of measures, aggregations, filters, relationships, security behavior, and reporting outputs
Work with data engineers and database teams to resolve source-data, transformation, schema, and performance issues
Maintain traceability between reporting requirements, source data, model logic, test evidence, and released products
Review technical designs and provide guidance to BI developers and analysts
Maintain model documentation, measure definitions, data mappings, deployment instructions, and operational runbooks
Support release-readiness reviews, user acceptance testing, operational handoffs, and knowledge transfer
Communicate technical risks, data limitations, performance findings, dependencies, and improvement recommendations to Government stakeholders and program leadership

Requirements

What you’ll need

Active Secret clearance or higher
Minimum of 12 years of relevant professional experience
Bachelor’s degree in information systems, computer science, data analytics, or a related field, or a permitted equivalent
Experience with Power BI Desktop, Power Query, and SQL
Experience developing and maintaining shared semantic models and DAX measures
Ability to establish and maintain reporting standards
Experience optimizing BI model, query, refresh, and reporting performance
Experience designing access controls for BI capabilities
Experience implementing controlled BI deployment processes
Experience working with approved hosting configurations and gateways
Experience selecting and implementing appropriate query and refresh patterns
Applicable DoD 8570 certification for the assigned duties

Benefits

Comp & perks

Opportunity to support the USMEPCOM ENLIST program under an active competitive government contract bid
Opportunity to collaborate with Government stakeholders, business analysts, data engineers, database personnel, governance specialists, cybersecurity teams, and testers
Knowledge transfer and professional collaboration opportunities
Equal employment opportunity and affirmative action protections