Business Intelligence & Analytics Engineer

Full-Time

Essential Functions

Business Intelligence Development
- Develops and maintains Power BI dashboards, paginated reports, and semantic models.
- Optimizes DAX, Power Query, and model performance based on user needs.
- Builds visualization experiences that support leadership, operations, and program teams.

Data Engineering & Integration
- Builds and manages a data warehouse or analytics platform (Microsoft Fabric or traditional architecture).
- Integrates data from ERP, EHR, HR, finance, and operational systems.
- Executes ETL/ELT workflows and maintains data consistency across systems.

Analytics & Reporting
- Responds to custom data requests for grants, compliance, program evaluation, and outcomes reporting.
- Defines KPIs, metrics, and reporting requirements with stakeholders.
- Provides ad-hoc analysis, trending, forecasting, and operational insights.

Data Governance & Documentation
- Ensures data quality, governance, lineage, and security across reporting layers.
- Defines and maintains data dictionaries, metric definitions, and governance processes.
- Documents architecture and provides training and enablement to internal users.

System Support
- Supports system reporting processes (non-admin development tasks).
- Assists with recurring reporting cycles across multiple organizational programs.

Additional Responsibilities
- Regularly travels to DCCCA locations and other business sites, which may include early morning or evening hours, to support operational needs.

Education, Experience, and Licensure

- Bachelor's degree in Business Administration, Public Policy, Operations Research, Computer Science, or related field, or equivalent industry experience is required.
- Requires a minimum of three (3) years of experience in BI development and data analysis. Experience in healthcare or nonprofit sectors preferred.
- Experience with EHR and ERP systems.
- Must possess a valid state Driver's License, in force automobile liability insurance, and maintain a Motor Vehicle Record (MVR) that meets organization's insurability standard as defined by DCCCA policy. Availability of reliable transportation is required for this position.

EOE