Data Warehouse (Contract)

MUST BE LOCAL AND US CITIZEN OR GC

3 month contract with expected extension

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.

Primary Job Duties/ Tasks

Participates in strategic planning for the Informatica and Snowflake infrastructure, environment and process

Administers the Informatica and Snowflake infrastructure, environment and process

Analyzes transactional data stores and develops 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

Ensures data warehouse metadata is collected and maintained

Prototypes, builds, and tests Power BI reports and dashboards

Prototypes, builds, and tests Tableau reports and dashboards

Assists with the development and maintenance of methods and practices documentation.

Job Specific Knowledge, Skills, and Abilities (KSAs)

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 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

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