Power BI Developer

Randstad USA; Tallahassee (FL); On-site; USD 90,000 - 96,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401K plan

AD&D

Life insurance

Short-term disability

Job summary

Randstad USA in Tallahassee, FL seeks a Power BI Developer to design, build, and govern enterprise analytics using Power BI and Azure Synapse. You will implement secure access, data models, and scalable dashboards for regulatory data environments.

The role requires 5+ years BI/analytics experience, 3+ years Power BI at scale, and strong collaboration with data engineers and InfoSec. This contract position reports to the OIT program teams and adheres to CJIS/HIPAA policies.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field required or equivalent work experience on a year-for-year basis.
• Minimum 5 years of experience in business intelligence or analytics, including 3+ years building Power BI solutions at enterprise scale.
• Expert DAX and strong Power Query/M skills with deep tabular modeling and SQL across complex datasets.
• Experience implementing RLS, OLS, and secure sharing in CJIS/HIPAA environments.
• Experience with Deployment Pipelines, Azure DevOps, and GCC license management; knowledge of Premium capacities.
• Strong collaboration with data engineers, stewards, PMO, InfoSec, and stakeholders across OIT and programs."],
• job_responsibilities_description:[

Responsibilities

• Design, build, secure, and operationalize analytic solutions on Power BI and Azure Synapse to deliver trusted insights from the Enterprise Data Warehouse.
• Design star-schema tabular models, define facts and dimensions, and ensure auditable data structures.
• Develop performant DAX measures and reusable templates for enterprise reporting.
• Build accessible Power BI reports with advanced features and parameterized views for operational and leadership audiences.
• Implement robust Power Query transformations and maintain data lineage and cleansing standards.
• Support paginated reporting and ensure governance, security, and compliance with CJIS/HIPAA policies.
• Use Deployment Pipelines and Azure DevOps for DEV/PROD promotions, CI/CD, and automations.
• Collaborate with data owners, stewards, PMO, and InfoSec; provide coaching to Super Users and report developers.
• Maintain documentation, data dictionaries, lineage notes, and Purview catalog entries.
• Publish governance guides and SOPs; contribute to enterprise data catalogs.

Skills

Power BI

DAX

SQL

RLS/OLS

Azure DevOps

Data governance

Data modeling

Stakeholder collaboration

Education

Bachelor's degree in Computer Science / Information Systems

Tools

Power BI

Azure Synapse Analytics

Microsoft Purview

Azure DevOps

Job description

Job Summary

job summary:

Required Qualifications

• A bachelor's degree from an accredited college or university in Computer Science, Information Systems, or other related field is required. Alternatively, equivalent work experience can be substituted for the educational requirement on a year-for-year basis, when applicable.
• The Department requires the following experience, skills, and knowledge for this position:
• A minimum of five (5) years of experience in business intelligence or analytics, including three (3) years building Power BI solutions at an enterprise scale;
• Expert DAX and strong Power Query and M skills syntax, backed by deep tabular modeling experience and Structured Query Language (SQL) proficiency across complex datasets;
• Proven experience implementing RLS, OLS, workspace governance, and secure sharing protocols in highly regulated environments (CJIS and HIPAA);
• Experience with Deployment Pipelines, Azure DevOps, and environment promotion within GCC tenants, alongside a solid familiarity with Premium capacities and licensing considerations; and
• Exceptional collaboration skills to engage data engineers, stewards, PMO, InfoSec, and business stakeholders effectively across OIT and program teams.
• NOTE: In addition to the above list, the selected Candidate must successfully complete a Level II Background Check.

Preferred Qualifications

• Expertise in BI technologies (e.g., Microsoft Certified: Power BI Data Analyst Associate [PL-300]), Fabric Analytics Engineer Associate [DP-600], Azure Data Engineer [DP-203], and Azure Fundamentals [AZ-900];
• Hands-on experience with Azure Synapse Analytics workloads, including Power BI integrations, Data Warehousing, Lakehouse architectures, and Synapse integration pathways;
• Practical familiarity with Microsoft Purview for automated enterprise cataloging, classification, and lineage tracking; and
• Exposure to performance engineering at scale, including composite models, aggregations, Incremental Refresh (IR) policies, and formal data governance processes.

Scope of Work/Job Characteristics

The Power BI Developer will design, build, secure, and operationalize analytic solutions on Microsoft Power BI and Azure Synapse Analytics to deliver trusted, timely insights from the Department Enterprise Data Warehouse and related Department systems. The role spans semantic model design, report development, governance, performance optimization, and deployment lifecycle management, with strict adherence to Criminal Justice Information Services (CJIS), Health Insurance Portability and Accountability Act (HIPAA), and agency data-governance policies. The duties and responsibilities of this position are as follows:

Report, Dashboard, and Semantic Model Development

• Design star schema tabular models that consume Silver and Gold datasets, defining clear facts, dimensions, hierarchies, and relationships that reflect business rules and formal audit needs;
• Develop performant Data Analysis Expressions (DAX) measures, calculation logic, key performance indicators (KPIs), and reusable measure templates to ensure consistent reporting standards across the enterprise;
• Build user-centric, accessible Power BI reports and dashboards, incorporating advanced features like drill-through, bookmarks, tooltips, and parameterized views tailored for both operational and leadership audiences;
• Implement robust Power Query/M transformations during model preparation while strictly respecting upstream cleansing and data lineage standards defined by the Data Warehouse team;
• Support paginated reporting pipelines when required to fulfill regulatory mandates or operational print workflows.

Governance, Security, and Compliance

• Implement Row Level Security (RLS) and Object Level Security (OLS) aligned to CJIS and HIPAA requirements, agency retention rules, and OIT governance decisions, while thoroughly documenting access matrices and test coverage;
• Administer workspace roles and dataset permissions, ensuring full alignment with the M365 Government Community Cloud (GCC) licensing posture for Power BI Pro and Premium;
• Partner with security and data governance teams to register datasets, lineage, and classifications, leveraging Microsoft Purview where applicable for cataloging, policy awareness, and consumer trust;
• Embed strict internal controls for audit logging, data refresh auditing, and change tracking per OIT and program compliance standards.

Performance Engineering and Reliability

• Optimize dataset size, entity relationships, and measure logic by utilizing composite models, aggregations, and Incremental Refresh where appropriate to strictly meet agreed-upon service levels;
• Target, monitor, and continuously improve report render times and dataset refresh performance to adhere to defined service level agreements (SLAs);
• Collaborate with the Data Warehouse team on distributed processing choices that directly impact DirectQuery, Direct Lake, and Import modes to ensure optimal capacity utilization and cost-efficient infrastructure management.

Deployment Lifecycle and DevOps

• Use Power BI Deployment Pipelines and Azure DevOps for versioning, environment promotion Development and Production (DEV/PROD), approvals, and rollback strategies; and
• Automate refresh schedules, key vault secrets, service principals, and Continuous Integration and Continuous Delivery (CI/CD) checks consistent with OIT change and incident management processes.

Collaboration and Stakeholder Engagement

• Work closely with Data Owners, stewards, analysts, Project Management Office (PMO), and Information Security (InfoSec) to translate business use cases into governed analytics, participating actively in Data Owners and Governance meetings as scheduled;
• Provide coaching and knowledge transfer to Super Users and report developers within the Bureau of Research and Data and other stakeholder groups.

Documentation and Best Practices

• Maintain model documentation, DAX catalogs, data dictionaries, lineage notes, RLS and OLS matrices, refresh schedules, and standard operating procedures (SOPs);
• Publish workspace governance guides, report accessibility standards, and User Acceptance Testing (UAT) scripts consistent with OIT documentation frameworks;
• Contribute to the enterprise data catalog in Microsoft Purview and to SharePoint knowledge bases with versioned artifacts linked directly to Correctional Information Management System (CIMS) datasets and interfaces.

Location

location: Tallahassee, Florida

Job Type

job type: Contract

Salary

salary: $65 - 70 per hour

Work Hours

work hours: 8am to 5pm

Education

education: Bachelors

Skills

audit logging,Azure Data,Azure Synapse Analytics,complex datasets,change tracking,test coverage,Continuous Integration and Continuous Delivery (CI/CD),InfoSec,Information Security,Analytics,Data Analysis

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [e-mail].

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

Required QualificationsA bachelor's degree from an accredited college or university in Computer Science, Information Systems, or other related field is required. Alternatively, equivalent work experience can be substituted for the educational requirement on a year-for-year basis, when applicable.The Department requires the following experience, skills, and knowledge for this position:A minimum of five (5) years of experience in business intelligence or analytics, including three (3) years building Power BI solutions at an enterprise scale;Expert DAX and strong Power Query and M skills syntax, backed by deep tabular modeling experience and Structured Query Language (SQL) proficiency across complex datasets;Proven experience implementing RLS, OLS, workspace governance, and secure sharing protocols in highly regulated environments (CJIS and HIPAA);Experience with Deployment Pipelines, Azure DevOps, and environment promotion within GCC tenants, alongside a solid familiarity with Premium capacities and licensing considerations; andExceptional collaboration skills to engage data engineers, stewards, PMO, InfoSec, and business stakeholders effectively across OIT and program teams.NOTE: In addition to the above list, the selected Candidate must successfully complete a Level II Background Check.Preferred QualificationsThe Department prefers the Candidate to have the following experience, skills, and/or knowledge for this position:Expertise in BI technologies (e.g., Microsoft Certified: Power BI Data Analyst Associate [PL-300]), Fabric Analytics Engineer Associate [DP-600], Azure Data Engineer [DP-203], and Azure Fundamentals [AZ-900];Hands-on experience with Azure Synapse Analytics workloads, including Power BI integrations, Data Warehousing, Lakehouse architectures, and Synapse integration pathways;Practical familiarity with Microsoft Purview for automated enterprise cataloging, classification, and lineage tracking; andExposure to performance engineering at scale, including composite models, aggregations, Incremental Refresh (IR) policies, and formal data governance processes.