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.
#Workwolf
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.
#Workwolf
