Data Warehouse Analyst

Job Overview

This role is for a Data Warehouse Analyst with a 12-month contract, offering a pay rate of "X" per hour. Requires 7 years of data warehousing experience, proficiency in ETL/ELT using Informatica, and knowledge of Snowflake and reporting tools.

Location:

United States

Contract:

12 months

• Prototype, build, and test extraction, transformation, and load (ETL or ELT) jobs.
• Analyze transactional data stores and develop data warehouse models to optimize data stores for reporting and analytics.
• Create designs, diagrams, and documents to support data integration and data warehouse solutions.
• Ensure data warehouse metadata is collected and maintained.
• Coach and mentor peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
• Assist with development and maintenance of methods and practices documentation.

• 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 Snowflake cloud data warehouse functionality.
• Extensive knowledge and expert skill in use of Informatica Power Center Cloud Platform.
• Knowledge and skill in Informatica Data Quality functionality.
• Knowledge and skill in Informatica Data Catalog functionality.
• Knowledge and skill in Power BI, Tableau, and other reporting tools functionality.
• Knowledge and skill in relational database platforms including DB2, SQL Server, and Oracle.

• Communication:
  Clear written and verbal communication, effective listening.
• Customer Service:
  Works well with clients and customers, assess needs, provide assistance.
• Decision Making:
  Makes sound, well-informed, objective decisions.
• Flexibility:
  Open to change, new processes, can adapt and provide constructive criticism.
• Interpersonal:
  Friendly, courteous, understanding.
• Leadership:
  Motivates, encourages, and challenges others.
• Problem Solving:
  Identifies, evaluates, and uses sound judgment to generate alternatives.
• Team Building:
  Encourages and guides others toward common goals.
• Quality Assurance:
  Knowledge of ideologies, techniques, and tools for quality assurance and control.

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