Senior Data Warehouse Analyst

BuzzClan; Tallahassee (FL); On-site; USD 110,000 - 150,000; Full time

Job summary

BuzzClan in the United States is seeking a Mid-Senior level data engineer with contract engagement to lead data integration and warehousing efforts. The role emphasizes Snowflake Data Cloud and Informatica IICS Cloud Data Integration, along with ETL/ELT development and BI reporting.

The position involves strategic planning for enterprise data architecture, modeling for reporting with Power BI and Tableau, mentoring teammates, and contributing to governance and metadata practices in a fast-paced

Qualifications

• Extensive experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration.
• Proven ETL/ELT development experience and data warehousing design.
• Experience designing BI data models for Power BI and Tableau.
• Familiar with COBOL, JCL, and DB2 for data sourcing and analysis.
• Experience with data governance tools and metadata management.
• Ability to mentor peers in data warehousing concepts.

Responsibilities

• Lead data integration and warehousing initiatives with Snowflake and Informatica.
• Develop and optimize ETL/ELT processes and data models.
• Participate in strategic Snowflake enterprise data design.
• Analyze transactional data stores to optimize analytics reporting.
• Coach peers in warehouse concepts and tooling.
• Prototype and test BI reports and dashboards with Power BI and Tableau.
• Document methods and best practices.

Skills

Snowflake Data Cloud

Informatica IICS Cloud Data Integ.

ETL/ELT Development

Power BI & Tableau

Data Warehousing Concepts

Mentoring / Coaching

Data Governance & Metadata

Tools

Informatica PowerCenter

Informatica IICS

PowerExchange

Snowflake

Tableau

Power BI

COBOL / JCL / DB2

Job description

At least 7 years of IT experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions. Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake is preferred.

Primary Job Duties / Tasks:

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

Job Specific Knowledge, Skills, and Abilities (KSAs):

• 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

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Information Technology

Industries

IT Services and IT Consulting and Government Administration

Referrals increase your chances of interviewing at BuzzClan by 2x