Data and BI Developer (Senior)

DecisionPoint Corporation

United States

Remote

USD 120,000 - 180,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

DecisionPoint Corporation is seeking a Senior Data and BI Developer to design, build, and maintain data models, metadata, ETL, warehouse components, dashboards, reports, and visualizations for the USMEPCOM ENLIST program. The role is remote with Chicago-area candidates preferred.

Responsibilities include translating requirements into robust data structures, ensuring accuracy, performance, and usability, and collaborating with data engineers, governance personnel, and government stakeholders

Qualifications

  • Active Secret clearance or higher.
  • Minimum of eight years of relevant professional experience.
  • Bachelor's degree in computer science, information systems, data analytics, or a related field, or a permitted equivalent.
  • Experience developing data models.
  • Experience developing ETL processes.
  • Experience developing data warehouse components.
  • Experience developing dashboards and reports.
  • Applicable DoD 8570 certification for the assigned duties.

Responsibilities

  • Design, build, and maintain data models for warehouse and reporting.
  • Develop and maintain metadata, definitions, mappings, and transformation docs.
  • Build and optimize ETL processes from approved sources.
  • Create warehouse tables, views, and relationships for analysis.
  • Translate requirements into data transformations and reporting logic.
  • Develop dashboards, reports, and visualizations for stakeholders.
  • Support self-service reporting and reusable components.
  • Validate mappings, counts, totals, and outputs.
  • Maintain alignment between warehouse structures and reports.
  • Ensure data processing efficiency and report performance.
  • Investigate data transformation issues and schema changes.
  • Maintain data lineage and access controls.
  • Support testing, deployments, and QA.

Skills

Data modeling
ETL processes
Dashboards & reports
Metadata management
Data warehousing
Analytical thinking

Education

Bachelor's degree in computer science / information systems / data analytics

Tools

Power BI
Power Query
DAX
SQL
SSIS

Job description

Overview DecisionPoint seeks a Senior Data and BI Developer to design, build, and maintain data models, metadata, ETL processes, warehouse components, dashboards, reports, and visualizations supporting the USMEPCOM ENLIST program. This position will connect data preparation and warehouse development with analytical reporting to deliver reliable analysis and actionable insights. The developer will translate approved requirements into maintainable data structures, transformations, and reporting products while supporting accuracy, consistency, performance, and usability. The Senior Data and BI Developer will collaborate with data engineers, database administrators, governance personnel, business analysts, BI specialists, testers, and Government stakeholders throughout development, validation, deployment, and ongoing maintenance. This position is remote, with Chicago-area candidates preferred.

Duties & Responsibilities

The Senior Data and BI Developer will:

  • Design, build, and maintain data models supporting warehouse, analytical, and reporting requirements.
  • Develop and maintain metadata, data definitions, mappings, and transformation documentation.
  • Build and optimize ETL processes that integrate data from approved sources.
  • Develop warehouse tables, views, relationships, and other components supporting reliable analysis.
  • Translate mission requirements and business rules into data transformations, calculations, and reporting logic.
  • Build dashboards, operational reports, analytical products, and visualizations.
  • Develop reusable reporting components and support approved self-service reporting capabilities.
  • Validate source-to-target mappings, record counts, totals, calculations, and reporting outputs.
  • Maintain consistency between warehouse structures, analytical models, and published reports.
  • Optimize data processing, queries, models, refresh behavior, and report performance.
  • Investigate and resolve issues involving data transformations, warehouse components, calculations, and visualizations.
  • Coordinate schema and source-system changes with affected technical teams.
  • Maintain lineage and traceability between source data, transformations, models, and reporting products.
  • Implement approved access requirements and coordinate security-related changes with responsible personnel.
  • Support automated testing, regression checks, defect resolution, and user acceptance testing.
  • Conduct demonstrations and incorporate approved stakeholder feedback.
  • Follow established version control, review, deployment, and change-management procedures.
  • Maintain technical specifications, test evidence, deployment instructions, and operational documentation.
  • Support operational handoffs, knowledge transfer, and continuous improvement of data and BI solutions.
Qualifications Required

The following must-have qualifications are drawn from the supplied position requirements:

  • Active Secret clearance or higher.
  • Minimum of eight years of relevant professional experience.
  • Bachelor's degree in computer science, information systems, data analytics, or a related field, or a permitted equivalent.
  • Experience developing data models.
  • Experience developing ETL processes.
  • Experience developing data warehouse components.
  • Experience developing dashboards and reports.
  • Ability to design, build, and maintain metadata and visualizations supporting reliable analysis and actionable insights.
  • Applicable DoD 8570 certification for the assigned duties.
Preferred Qualifications
  • Microsoft Certified: Power BI Data Analyst Associate or a relevant data engineering certification.
  • Experience with Power BI, Power Query, DAX, and SQL.
  • Experience supporting federal or Department of Defense data and reporting environments.
  • Experience with dimensional modeling, shared semantic models, and reusable analytical measures.
  • Familiarity with SSIS or comparable ETL/ELT platforms.
  • Experience with data governance, metadata management, lineage, and authoritative-source definitions.
  • Experience developing accessible dashboards and self-service reporting products.
  • Experience implementing automated reconciliation, data-quality, and regression checks.
  • Familiarity with cloud data platforms, version control, and controlled deployment processes.
  • Strong analytical troubleshooting, documentation, communication, and cross-team collaboration skills.

Our Equal Employment Opportunity Policy EEO and Affiantive Action Policy:

DecisionPoint Corporation is an Equal Employment Opportunity and Affiantive Action employer. It is the policy of DecisionPoint Corporation to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affiantive Action laws, directives and regulations to all employees and qualified applicants without regard to race, ethnicity, color, religion, national origin, sex, age, disability status, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected status under Federal, State or Local laws.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Power BI/Analytics Engineering Lead
Power BI/Analytics Engineering Lead

DecisionPoint Corporation • United States

Remote
USD 140,000 - 190,000
Data Quality & Test Automation Engineer (Senior)
Data Quality & Test Automation Engineer (Senior)

DecisionPoint Corporation • United States

Remote
USD 120,000 - 180,000
Senior Full-Stack Software Developer
Senior Full-Stack Software Developer

DecisionPoint Corporation • United States

Remote
USD 140,000 - 190,000
Lead Data/ETL Engineer
Lead Data/ETL Engineer

DecisionPoint Corporation • United States

Remote
USD 140,000 - 180,000
Data/ETL Engineer (Journeyman)
Data/ETL Engineer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 110,000 - 150,000
Software Developer (Journeyman)
Software Developer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 110,000 - 170,000
CI/CD Engineer (Journeyman)
CI/CD Engineer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 120,000 - 170,000
Data/ETL Engineer (Senior)
Data/ETL Engineer (Senior)

DecisionPoint Corporation • United States

Remote
USD 120,000 - 180,000
Data and BI Tester (Journeyman)
Data and BI Tester (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 90,000 - 130,000
Senior Integration Developer
Senior Integration Developer

DecisionPoint Corporation • United States

Remote
USD 120,000 - 125,000