Group Nine LLC
Data Warehouse Analyst
Group Nine LLC, Tampa, Florida, us, 33646
Data Warehouse AnalystTallahassee, FLLocals Only12 Months
Must-have skills:7+ y of IT exp utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions; Informatica IICS Cloud Data Integration and SnowflakePREFERRED : governmental exp, Power BI, Tableau.
Requirements:• Experience designing data models for Business Intelligence tools like Power BI and Tableau (7+ years);• Integration and warehousing experience;• 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;• Experience with Informatica IICS Cloud Performance Tuning;• Experience with Snowflake Data Cloud Performance Tuning;• Experience with Data Governance products, like EDC, Axon, and CDGC
Responsibilities include but are not limited to the following:• 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;• Assists with the development and maintenance of methods and practices documentation.
Must-have skills:7+ y of IT exp utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions; Informatica IICS Cloud Data Integration and SnowflakePREFERRED : governmental exp, Power BI, Tableau.
Requirements:• Experience designing data models for Business Intelligence tools like Power BI and Tableau (7+ years);• Integration and warehousing experience;• 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;• Experience with Informatica IICS Cloud Performance Tuning;• Experience with Snowflake Data Cloud Performance Tuning;• Experience with Data Governance products, like EDC, Axon, and CDGC
Responsibilities include but are not limited to the following:• 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;• Assists with the development and maintenance of methods and practices documentation.