Data Warehouse Analyst

About the role

Data Warehouse Analysts at Machine Learning Technologies LLC are responsible for designing and maintaining data warehouses using Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools. They also participate in strategic planning for the enterprise data warehouse and data lake architecture.

Responsibilities

• Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools.
• Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks.
• Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development.
• Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics.
• Coaches and mentors peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
• Prototypes, builds, and tests Power BI and Tableau reports and dashboards.
• Affords assistance with the development and maintenance of methods and practices documentation.

Requirements

• Experience designing data models for Business Intelligence tools like Power BI and Tableau.
• Experience with Informatica on-premises products like PowerCenter and Data Quality.
• Experience with ELT with Change Data Capture solutions like PowerExchange.
• Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.
• Experience with IICS Cloud Administration and Snowflake Data Cloud Administration.
• Ensures data warehouse metadata is collected and maintained.
• Experience with Informatica IICS Cloud Performance Tuning.
• Experience with Snowflake Data Cloud Performance Tuning.
• Experience with Data Governance products, like EDC, Axon, and CDGC.

Qualifications

• Experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools.
• Strong experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks.
• Strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development.
• Analyzing transactional data stores and developing data warehouse models to optimize the warehouse for reporting and analytics.
• Coaching and mentoring peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
• Prototyping, building, and testing Power BI and Tableau reports and dashboards.
• Maintaining methods and practices documentation.

Skills

• Designing data models for Business Intelligence tools like Power BI and Tableau.
• Informatica on-premises products like PowerCenter and Data Quality.
• ELT with Change Data Capture solutions like PowerExchange.
• IBM Mainframes COBOL, JCL, and DB2 analysis.
• IICS Cloud Administration and Snowflake Data Cloud Administration.
• Data Governance products, like EDC, Axon, and CDGC.
• Informatica IICS Cloud Performance Tuning.
• Snowflake Data Cloud Performance Tuning.

Benefits

Machine Learning Technologies LLC offers competitive hourly rates depending on experience, and provides an inclusive environment for employees of diverse backgrounds.

Pay

Depending on experience (DOE)

Schedule

24 Months + Extension

Benefits

Machine Learning Technologies LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V).