Reporting/BI Analyst

Lentech•Elkridge, MD

9h•Onsite

About The Position

Lentech is seeking a Reporting/BI Analyst for a mission-critical project involving the technical implementation of a Microsoft Dynamics 365 and Power Platform-based case management system (CMS) for legal services to children. This role is crucial for designing, developing, and validating the project’s analytical ecosystem, translating complex case data into actionable insights for various stakeholders including the legal team, Legal Service Providers, and the Government customer. The position requires a strong understanding of data modeling, Power BI, DAX, and federal reporting requirements, with a focus on delivering a governed reporting architecture and ensuring data integrity and security. The primary implementation timeline is 180 days, followed by steady-state operations, with a potential for a five-year follow-on contract.

Requirements

8+ years of Power BI and DAX experience
Expert-level proficiency in Power BI and DAX
Experience designing governed semantic models within the Power Platform (Dataverse) environment
Strong understanding of data modeling, ERDs, and the ability to map atomic data elements to high-level contractual metrics
Experience in evidence-based acceptance for metrics, ensuring that every calculation is auditable and traces back to the Requirements Traceability Matrix (RTM)
Familiarity with federal reporting cadences and the security constraints associated with handling sensitive program data and attorney work product
U.S. Citizenship is required
Ability to pass a public trust background investigation

Nice To Haves

MS Power Platform Functional Consultant associate
MS Fabric Analytics Engineer Associate

Responsibilities

Design and implement the full report catalog, including operational, compliance, financial, security, and transition-in dashboards.
Build and test all calculated metrics defined in the Metrics Spec, including documenting provisional handling for unresolved Government inputs.
Develop a single governed semantic model to ensure consistent definitions across live views, dashboards, and exported formats.
Implement role-based dashboards for appropriate visibility for Organization leads, LSPs, finance, and compliance audiences.
Provide detailed acceptance evidence for every metric, identifying the specific formula, numerator, denominator, exclusions, grouping dimensions, and atomic fields used.
Treat Government-facing templates as presentation mappings over governed data to accommodate potential changes in templates.
Complete report catalog, dashboard designs, and finalized metric calculation specifications.
Provide results from testing demonstrating that all metrics and reports pass validation against known-answer synthetic data sets.
Create report definitions and user guides for independent management and updating of reporting after final transition.