Data and BI Developer (Senior)
About The Position
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. The role connects data preparation and warehouse development with analytical reporting to deliver reliable analysis and actionable insights. The developer translates approved requirements into maintainable data structures, transformations, and reporting products while supporting accuracy, consistency, performance, and usability. The Senior Data and BI Developer collaborates with data engineers, database administrators, governance personnel, business analysts, BI specialists, testers, and Government stakeholders throughout development, validation, deployment, and ongoing maintenance. The position is remote, with Chicago-area candidates preferred. Applicants acknowledge and consent to having their resumes included in an active competitive government contract bid.
Requirements
- Active Secret clearance or higher.
- At least 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.
Nice To Haves
- 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.
Responsibilities
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
