Join Our Team
Do you want to make an impact on the world around you? The work we do at Kyra Solutions 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. Kyra works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees.
Title: Data Warehouse Analyst (On-site)
Location: Tallahassee, FL 32301 || Duration: Long-Term
Required Skills and Experience
* Required minimum of 5 years of IT work experience in business intelligence tools and systems.
* A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated reports, performance tuning, and DAX.
* Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.
* Strong understanding of star schema design and fact/dimension modeling.
* Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.
* Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.
* Proficient in building Power BI semantic models with strong DAX and clean dimensional design.
* Experience in integrating Power BI with Snowflake and connection modes.
* Proficiency in Power BI Report Builder, workspace management, and performance optimization.
* Experience with metadata management, data lineage, and documentation.
* Experience embedding Power BI reports into web or internal applications.
Preferred Skills and Experience
* Knowledge of CI/CD for Power BI and version control is a plus.
Primary Responsibilities
* Design and develop Power BI dataflows and semantic models using dimensional modeling practices.
* Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.
* Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.
* Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.
* Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.
* Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
* Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.
Education
* Bachelors degree in computer science, Information Systems, or other related fields. Or equivalent work experience. Equivalent work experience may substitute for the educational requirement.
If you are interested in furthering your career with Kyra 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 Kyra?
Founded in 1997, Kyra Solutions 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. Kyra 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. Kyra'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. Equal employment opportunity employer.
Never miss an opportunity! Create an alert based on the job you applied for.
