Power BI/Analytics Engineering Lead

DecisionPoint | Cortek; Oregon; Hybrid; USD 130,000 - 180,000; Full time

Job summary

DecisionPoint Corporation seeks a Power BI/Analytics Engineering Lead to provide SME-level leadership for shared semantic models, DAX measures, reporting standards, and secure BI deployment for the USMEPCOM ENLIST program. This role is remote, with Chicago-area candidates preferred.

The Lead will guide design, validation, and delivery of analytic models, dashboards, and self-service reporting while coordinating with government stakeholders, data engineers, and cybersecurity teams to ensure

Qualifications

• Requires active Secret clearance or higher.
• 12+ years of relevant experience.
• Bachelor's degree in information systems, CS, data analytics, or related field.

Responsibilities

• Own the technical design and maintenance of shared semantic models.
• Develop and govern reusable DAX measures and relationships.
• Establish reporting standards for model design and validation.
• Lead dashboards, reports, and governed self-service reporting.
• Use Power BI Desktop, Power Query, and SQL for data prep and delivery.
• Define KPIs, rules, calculations, and acceptance criteria with stakeholders.
• Coordinate with governance and cybersecurity teams on access controls.

Skills

Power BI

Power Query

SQL

DAX

Semantic models

Reporting standards

Access control

BI deployment

8570 DoD

Education

Bachelor's degree

Tools

Power BI Desktop

SQL Server

Job description

OverviewDecisionPoint seeks a Power BI/Analytics Engineering Lead to provide SME-level technical leadership for shared semantic models, DAX measures, reporting standards, performance, access design, and controlled BI deployment supporting the USMEPCOM ENLIST program.This position will guide the design, development, validation, and delivery of consistent analytical models, dashboards, reports, and self-service reporting capabilities. The lead will use Power BI Desktop, Power Query, SQL, approved hosting configurations, gateways, and appropriate query and refresh patterns to support reliable mission reporting.The Power BI/Analytics Engineering Lead will collaborate with Government stakeholders, business analysts, data engineers, database personnel, governance specialists, cybersecurity teams, and testers to ensure reporting products use consistent definitions, provide appropriate access, and deliver accurate, understandable results.This position is remote, with Chicago-area candidates preferred.Note: By applying to this position, you acknowledge and consent to having your resume included in an active competitive government contract bid.

Duties & Responsibilities

• 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 in coordination 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.

Qualifications

Required Qualifications

• 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.

Preferred Qualifications

• Microsoft Certified: Power BI Data Analyst Associate (PL-300) — strongly preferred.
• Experience supporting federal or Department of Defense BI environments.
• Experience implementing reusable enterprise semantic models and standardized KPI libraries.
• Experience with data warehouses, dimensional modeling, data lineage, and metadata management.
• Experience implementing row-level security or other approved data-access restrictions.
• Experience automating BI validation, release processes, or configuration management.
• Familiarity with version control, deployment pipelines, and change-management practices.
• Experience developing accessible dashboards and usable self-service reporting guidance.
• Experience mentoring BI developers and coordinating technical reviews.
• Strong analytical troubleshooting, documentation, stakeholder communication, and technical leadership skills.

Our Equal Employment Opportunity Policy

• EEO and Aff ...
• Pay Transparency Policy: In accordance with Presidential Executive Order 13665, DecisionPoint Corporation will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
• Authorization to Share Resume and Personal Information: By expressing your interest and submitting your resume for this position, you authorize DecisionPoint Corporation to share your resume, as well as personal information included on the resume, with its subsidiaries, affiliates and teaming partners for the purpose of considering you for this position and other available positions requiring comparable skills, education and experience. Should DecisionPoint Corporation. or its affiliates and teaming partners wish to initiate pre-employment discussions, you will be asked to complete an employment application and related employment documents.