Senior Data and BI Developer

DecisionPoint Corporation

. Design, build, and maintain data models supporting warehouse, analytical, and reporting requirements .

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 designing and maintaining data models, ETL processes, and data warehouse components to support analytical and reporting needs. Proficient in developing dashboards and visualizations that provide actionable insights while ensuring data quality and governance.

Highest-signal resume keywords

Data Model DevelopmentETL Process DevelopmentData Warehouse ComponentsDashboard and Report DevelopmentData Governance

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

Data ModelingETL ProcessesSQLDAXPower BIPower QueryDimensional ModelingMetadata ManagementData Quality ChecksAutomated Testing

Soft Skills

Analytical TroubleshootingDocumentationCommunicationCross-Team Collaboration

Tools & Technologies

Power BISSISCloud Data PlatformsVersion Control

Certifications & Qualifications

Active Secret ClearanceDoD 8570 CertificationMicrosoft Certified: Power BI Data Analyst Associate

Industry Keywords

Federal Data EnvironmentsDepartment of DefenseData GovernanceMetadata ManagementSelf-Service Reporting

Tech Stack

Tools & technologies

CloudETLSQLSSIS

About the role

Key responsibilities & impact

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 integrating 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

Requirements

What you’ll need

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
Microsoft Certified: Power BI Data Analyst Associate or a relevant data engineering certification preferred but not required
Experience with Power BI, Power Query, DAX, and SQL preferred
Experience supporting federal or Department of Defense data and reporting environments preferred
Experience with dimensional modeling, shared semantic models, and reusable analytical measures preferred
Familiarity with SSIS or comparable ETL/ELT platforms preferred
Experience with data governance, metadata management, lineage, and authoritative-source definitions preferred
Experience developing accessible dashboards and self-service reporting products preferred
Experience implementing automated reconciliation, data-quality, and regression checks preferred
Familiarity with cloud data platforms, version control, and controlled deployment processes preferred
Strong analytical troubleshooting, documentation, communication, and cross-team collaboration skills preferred

Benefits

Comp & perks

Regular full-time employment
Opportunity to support the USMEPCOM ENLIST program
Remote work arrangement
Chicago-area candidates preferred
Opportunity to collaborate with technical teams, Government stakeholders, and other professionals
Knowledge transfer and continuous improvement opportunities