Data Warehouse Analyst (On-site)

Kyra Solutions

Tallahassee, FL

Full Time

Senior

8 days ago

Job Description

About the Role

Join Kyra Solutions as a Data Warehouse Analyst (On-site) to contribute to government transportation and regulatory solutions that aim to improve public safety and accessibility. The role involves working on data management, business intelligence, and data warehousing projects within a company recognized for its growth, innovation, and commitment to employee development. Located in Tallahassee, FL, this full-time position offers opportunities to make a meaningful impact in government digital transformation initiatives.

Key Responsibilities

Utilize data management tools, business intelligence tools, and data warehousing techniques to support organizational goals.
Design, develop, and support ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and on-prem solutions.
Model transactional data for data warehousing purposes.
Apply knowledge of data warehouse and data mart concepts to support data integration and reporting needs.
Work with Snowflake cloud data warehouse functionality to optimize data storage and retrieval.
Use Informatica PowerCenter Cloud Platform and Informatica Data Quality, Data Catalog functionalities to ensure data accuracy and quality.
Create and maintain reports using Power BI, Tableau, and other reporting tools.
Work with relational database platforms including DB2, SQL Server, and Oracle.

Requirements

A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.
7 years experience in Data Warehousing and Data Integration.
4 years experience designing, developing, and supporting ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and Informatica on-prem solutions.
Extensive knowledge of data warehouse and data mart concepts.
Ability to model transactional data for data warehousing usage.
Knowledge of and skill in Snowflake cloud data warehouse functionality.
Expert skill in use of Informatica PowerCenter Cloud Platform.
Knowledge of and skill in Informatica Data Quality and Data Catalog functionalities.
Knowledge of reporting tools such as Power BI and Tableau.
Knowledge of relational database platforms including DB2, SQL Server, and Oracle.
Bachelor's Degree in Computer Science, Information Systems, or related field, or equivalent work experience.

Qualifications

Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.

Working at Kyra Solutions

Kyra Solutions is a recognized leader in transportation technology and regulatory solutions, committed to digital transformation in government. The company values employee growth, innovation, and excellence, having received multiple awards including Best Companies to Work for in Florida and INC magazine's Fastest Growing Companies. Kyra emphasizes diversity, project management best practices, and solution development, fostering a collaborative and award-winning work environment.

Apply Now