Analytics Engineer

Join Our Team Do you want to make an impact on the world around you? The work we do at OpenKyber directly impacts government entities and the citizens they serve. In Transportation practice, our solutions are designed to save lives on the roadways and in our Regulatory practice, we are designing solutions to make government digital for your accessibility. OpenKyber works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees. Title: Power BI Developer (On-Site) Location: Tallahassee, FL 32301 || Duration: Long-Term Required Skills and Experience * 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; * Exceptional collaboration skills to engage data engineers, stewards, PMO, InfoSec, and business stakeholders effectively across the agency and program teams. Preferred Skills and Experience * 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; * Exposure to performance engineering at scale, including composite models, aggregations, Incremental Refresh (IR) policies, and formal data governance processes. Primary Responsibilities * 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. * Implement Row Level Security (RLS) and Object Level Security (OLS) aligned to CJIS and HIPAA requirements, agency retention rules, and the clients 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 the client and program compliance standards. * 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. * Use Power BI Deployment Pipelines and Azure DevOps for versioning, environment promotion Development and Production (DEV/PROD), approvals, and rollback strategies; * Automate refresh schedules, key vault secrets, service principals, and Continuous Integration and Continuous Delivery (CI/CD) checks consistent with the clients change and incident management processes. * 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. * 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 the clients 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. Education * A bachelors 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. Certification * Microsoft Certified: Power BI Data Analyst Associate [PL-300] (Preferred) * Fabric Analytics Engineer Associate [DP-600] (Preferred) * Azure Data Engineer [DP-203] (Preferred) * Azure Fundamentals [AZ-900] (Preferred) If you are interested in furthering your career with OpenKyber and help us improve the way governments serve their citizens, please send your resume, and make sure to include salary expectation, availability, and contact information. You do not want to miss this opportunity! Why OpenKyber? Founded in 1997, OpenKyber is a national leader of transportation technology and regulatory solutions in government. We specialize in the art and science of digital transformation in government. Our commitment to providing the highest level of service and tailored solutions has supported our consistent double-digit growth for over a decade. We are headquartered in the greater Tampa Bay area with other offices across Florida and an innovation center in Silicon Valley, CA. Because of our dedication to our employees, we have won one of the Best Companies to Work for in Florida 3 years in a row by Florida Trend magazine. OpenKyber has won numerous other awards including the coveted INC magazine's recognition as one of America's Fastest Growing Companies several years in a row. OpenKyber's commitment to our employees, to best practices in project management and business analysis, and to solution development has led to our achievement in becoming the first Project Management Institute certified company in Florida. Our proven successful track record has resulted in several prestigious awards including the State of Florida's Diversity Business of the Year Award. We are proud to be a sponsor for the TaxWatch Productivity Awards and partner to Florida TaxWatch. Background & References Verifiable professional references will be required along with the resume; however, references will be checked/contacted after the interview and before the project starts. Level two background check will be done on the selected candidate for employment, criminal (State & Federal), education, and others as mandated by the client. Please make sure your resume and all other information provided are accurate. Any misrepresentation will mean permanent disqualification by the client.

For applications and inquiries, contact:View email address on us.fitly.work