POWER BI DEVELOPER / AZURE DATA ENGINEER (EXPERT)

Hi,

 

Role: POWER BI DEVELOPER / AZURE DATA ENGINEER (EXPERT)
Location: Remote within the United States; occasional on-site work in Columbia, SC
Duration: Two years
Hours: Variable. Year 1 total is about 1,500 hours (about 0.8 FTE):

• Months 1–3: 60 hours/month (reporting assessment and requirements)
• Months 4–9: 140 hours/month (Power BI reporting and dashboard build)
• Months 10–12: full-time, 160 hours/month (Azure data platform and real-time data build)
• Year 2, if continued: about full-time for six months, then about half-time
  Client: A state criminal-justice agency responsible for community supervision, parole and pardons

About the role
An expert-level role that owns reporting and the data platform end to end. The agency is modernizing its reporting with Power BI development and dashboard redesign, adding telemetry-based operational reporting, and building an Azure enterprise data platform (data warehouse and/or data lake) for structured, semi-structured and unstructured data with real-time ingestion. The platform is the foundation for future analytics and AI. This candidate is selected for deep, proven expertise, and the resume must show it clearly.

Responsibilities

Reporting and dashboards

• Gather reporting requirements with the business analyst from executives, supervisors and field operations.
• Design and build Power BI reports and dashboards on supervision, parole, pardon and ignition interlock operations.
• Redesign existing reports and dashboards, including converting legacy SSRS reports to Power BI.
• Build telemetry-based operational reports on application usage, performance and system health.
• Implement row-level security; manage workspaces, deployment pipelines, scheduled refreshes and gateways.

Data modeling

• Build semantic models (star schema, dimensional modeling); write DAX and Power Query; optimize performance and refresh times.

Azure data platform architecture and build

• Design the Azure data platform architecture (data warehouse and/or data lake) with the solution architect.
• Build pipelines from the agency’s SQL Server applications and external sources using Azure Data Factory, Synapse or Microsoft Fabric.
• Support structured, semi-structured and unstructured data, including documents and files.
• Build real-time and streaming data ingestion.
• Prepare curated datasets for analytics and the agency’s AI pilot.

Data quality and governance

• Validation, quality checks and reconciliation between source systems and reports.
• Document data sources, definitions and lineage.
• Follow CJIS and state data security requirements for criminal-justice data.

Support

• Fix report and pipeline issues; support users with report questions.
• Update reports as applications are enhanced and upgraded.

Required qualifications (must be clearly proven on the resume)

• 7+ years of hands-on Power BI development at enterprise scale: semantic models, DAX, Power Query, report and dashboard design. The resume must state the number of users, data volumes and number of reports or dashboards delivered.
• Power BI Service administration: workspaces, deployment pipelines, gateways, scheduled refresh, row-level security.
• Designed and built at least one Azure data platform (data warehouse and/or data lake) using Azure Data Factory, Azure Data Lake Storage, and Azure Synapse or Microsoft Fabric.
• Built real-time or streaming data pipelines (Azure Event Hubs, Stream Analytics or Fabric Real-Time Intelligence).
• Structured, semi-structured and unstructured data.
• Strong SQL Server / T-SQL and data warehouse design (star schema, dimensional modeling).
• SSRS to Power BI conversion experience.
• At least one current Microsoft data certification: PL-300, DP-600, DP-700 or DP-203.
• Based in the U.S.; able to pass a CJIS fingerprint background check.
• Available for the full two-year term; accepts variable hours.

Preferred qualifications

• Government or public-sector reporting or data work; criminal justice, law enforcement or public safety is a strong plus.
• CJIS experience or clearance, or an active federal clearance (Public Trust, Secret).
• Power BI in a government cloud (Microsoft 365 GCC C High).
• Preparing data for Azure AI or machine learning.

Technical environment: Power BI (Desktop and Service), DAX, Power Query, Azure Data Factory, Azure Data Lake Storage, Azure Synapse / Microsoft Fabric, Azure Event Hubs / Stream Analytics, SQL Server, T-SQL, SSRS, SSIS, Azure DevOps.

HR screening questions

1. Describe the largest Power BI solution you built end to end: data sources, model design, number of reports, number of users and data volume.
2. Describe an Azure data warehouse or data lake you designed and built. Which services did you use, and what was your role?
3. Describe a real-time or streaming data pipeline you built. Which tools did you use?
4. How have you implemented row-level security and deployment pipelines in Power BI?
5. Have you converted SSRS reports to Power BI? How many?
6. Which Microsoft certifications do you hold? Please give credential IDs.
7. Have you done reporting or data work for a government agency? Which type?

Candidates should submit

• An updated resume showing, for each major project: number of users, data volumes, number of reports or dashboards, tools and their own role.
• Sample dashboards or screenshots with confidential data removed.
• Certifications with credential IDs or verification links.
• Confirmation of U.S. residency, two-year availability and willingness to undergo a CJIS background check.