Senior Data Warehouse Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

BuzzClan · 5 days ago

Senior Data Warehouse Analyst

BuzzClan is seeking a Senior Data Warehouse Analyst with extensive experience in data management and business intelligence tools. The role involves strong data integration and warehousing tasks, particularly with Snowflake and Informatica, as well as mentoring peers and developing reports and dashboards.

ConsultingInformation Technology
check
Growth Opportunities
check
H1B Sponsor Likelynote
Hiring Manager
Dhiraj Mishra
linkedin

Responsibilities

Strong Data Integration and Data Warehousing 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
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

Qualification

Informatica IICSSnowflake Data CloudData WarehousingPower BITableauData GovernanceETL/ELTData ModelingIBM MainframesPerformance Tuning

Required

At least 7 years of IT experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions
Strong Data Integration and Data Warehousing 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
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
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

Preferred

Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake

Company

BuzzClan

twittertwittertwitter
company-logo
BuzzClan is a business consulting company.

H1B Sponsorship

BuzzClan has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (11)
2023 (8)
2022 (2)
2021 (2)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Sachin Jain
Chief Technology Officer
linkedin
Company data provided by crunchbase