What are the responsibilities and job description for the Data Warehouse Analyst (On-site from Day One) position at Kyra Solutions?
Job Details
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, 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 from Day One)
Required Skills and Experience
* A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.
* Extensive experience with Informatica PowerCenter and Snowflake is preferred.
Knowledge, Skills and Abilities
* 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.
* Extensive knowledge of and expert skill in the use of Informatica PowerCenter and Cloud functionality.
* Extensive Knowledge of and expert skill in administration of Informatica and Snowflake.
* Knowledge of and skill in Informatica Data Quality functionality.
* Knowledge of and skill in Informatica Data Catalog functionality.
* Knowledge of and skill in Power BI functionality.
* Knowledge of and skill in Tableau functionality.
* Knowledge of and skill in relational database platforms, including DB2, SQL Server, and Oracle.
Primary Responsibilities
* Participates in strategic planning for the Informatica and Snowflake infrastructure, environment, and process.
* Administer the Informatica and Snowflake infrastructure, environment, and process.
* Analyzed transactional data stores and developed data warehouse models to optimize the warehouse data stores for reporting and analytics.
* Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs.
* Prototypes, builds, and tests data quality processes and related jobs.
* Ensure data warehouse metadata is collected and maintained.
* Prototypes, builds, and tests Power BI reports and dashboards.
* Prototypes, builds, and tests Tableau reports and dashboards.
* Coached and mentored peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
* Assists with the development and maintenance of methods and practices documentation.
Education
* Bachelor s Degree in Computer Science, Information Systems, or other related field Or equivalent work experience.
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 2 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. for more information.
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.
