DecisionPoint Corporation Logo

DecisionPoint Corporation

Data and BI Developer (Senior)

Posted 19 Days Ago
Be an Early Applicant
In-Office
Chicago, IL, USA
Senior level
In-Office
Chicago, IL, USA
Senior level
Designs and maintains data models, metadata, ETL processes, warehouse components, dashboards, reports, and visualizations for a government program. Translates requirements into data transformations and reporting logic, validates data quality and outputs, optimizes performance, supports testing and deployment, coordinates system changes, and maintains technical documentation, lineage, and operational handoffs. Collaborates with engineers, database administrators, analysts, testers, governance teams, and government stakeholders.
The summary above was generated by AI
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. 

Note: By applying to this position, you acknowledge and consent to having your resume included in an active competitive government contract bid. 

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 Qualifications 

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 

The following qualifications are preferred but are not required: 

  • 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 Affirmative Action Policy: DecisionPoint Corporation is an Equal Employment Opportunity and Affirmative Action employer. It is the policy of DecisionPoint Corporation to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affirmative 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.
  • 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.

Similar Jobs

13 Minutes Ago
Hybrid
2 Locations
84K-202K Annually
Internship
84K-202K Annually
Internship
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Supports advisory consulting engagements through research, data review, information gathering, presentation development, meeting summaries, and project coordination. Contributes to strategy, operations, technology, risk management, value realization, integration, and business transformation projects while applying AI-enabled workflows and learning consulting methods.
Top Skills: AIDigital Tools
13 Minutes Ago
Hybrid
Chicago, IL, USA
124K-280K Annually
Senior level
124K-280K Annually
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead source-to-pay and procurement initiatives to drive cost savings, improve supplier collaboration, and strengthen supply chain resilience. Analyze client needs, implement digital procurement solutions (Coupa, GEP, ZIP, SAP Ariba), manage supplier relationships, direct teams through complex sourcing challenges, apply systems thinking, and validate outcomes with clients while coaching and developing high-performing teams.
Top Skills: CoupaGepSap AribaZip
13 Minutes Ago
Hybrid
2 Locations
77K-202K Annually
Senior level
77K-202K Annually
Senior level
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Provides pharmaceutical pricing and market access consulting, analyzing pricing models, customer profitability, market trends, promotional pricing, and sales performance. Develops recommendations to optimize revenue, profitability, and customer value; engages stakeholders, manages project resources and budgets, and supports business transformation. The role also includes mentoring, navigating complex client situations, and maintaining professional, ethical, and independence standards.

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account