Data Freelance Hub
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
Primary Responsibilities
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.
Minimum Qualifications
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 PowerCenter 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.
General Skills
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.
Education Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
#J-18808-Ljbffr
Location: United States
Contract: 12 months
Primary Responsibilities
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.
Minimum Qualifications
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 PowerCenter 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.
General Skills
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.
Education Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
#J-18808-Ljbffr