Data Warehouse Analyst (On-site)

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.

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!

Title

Data Warehouse Analyst (On-site)

Knowledge, Skills and Abilities

* At least 7 years of IT experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions.
* Experience designing data models for Business Intelligence tools like Power BI and Tableau.
* Experience with Informatica on-premises products like PowerCenter and Data Quality.
* Experience with ELT with Change Data Capture solutions like PowerExchange.
* Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.
* Experience with IICS Cloud Administration and Snowflake Data Cloud Administration.
* Ensures data warehouse metadata is collected and maintained.
* Experience with Informatica IICS Cloud Performance Tuning.
* Experience with Snowflake Data Cloud Performance Tuning.
* Experience with Data Governance products, like EDC, Axon, and CDGC.
* Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake is preferred.

Primary Responsibilities

* Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools.
* Strong Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks
* Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development.
* Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics.
* Coaches and mentors’ peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
* Prototypes, builds, and tests Power BI and Tableau reports and dashboards.
* Assists with the development and maintenance of methods and practices documentation.
* Responsible for gathering and assessing business information needs and preparing system requirements.
* Performs analyses, development, and evaluation of data mining in the Snowflake cloud data warehouse environment which includes data design, database architecture, and data management utilizing Informatica.
*PowerCenter, Intelligent Data Quality, and Enterprise Data Catalog.
* Uses data mining and data analysis tools including Power BI and Tableau.
* Reviews and validates data loaded into the data warehouse for accuracy.
* Interacts with user community to produce reporting requirements.
* Provides technical consulting to users of the various data stores and advises users on conflicts and inappropriate data usage.
* Responsible for prototyping solutions, building solutions, preparing test scripts, and conducting tests for Snowflake data population including data replication, extraction, loading, cleansing, and transforming the data.
* Responsible for enterprise data modeling.
* Maintains knowledge of software tools, languages, scripts, and shells that effectively support the Snowflake cloud data warehouse environment.

Education

* Bachelor’s Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement.

Location

Tallahassee, FL

Duration

Long-Term

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 other numerous awards including the coveted INC magazine s 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.