Business Intelligence & Analytics Engineer

Business Intelligence & Analytics Engineer

Full-Time In-Person Work in Lawrence, KS

• 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.

• 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.

• 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.

• 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.

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

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

• 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.