BuzzClan · 2 days ago
Data Warehouse Engineer
BuzzClan is a company seeking a Data Warehouse Engineer to gather and assess business information needs while preparing system requirements. The role involves performing analyses and evaluations of data mining in the Snowflake cloud data warehouse environment, utilizing various tools for data management and reporting.
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
Required
Bachelor's Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement
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
Must be able to comprehend assignments, organize workload, and meet deadlines with little direction
Can clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings
Works well with clients and customers (i.e., business office, public, or other agencies)
Makes sound, well-informed, and objective decisions utilizing critical thinking skills and analysis
Is open to change, new processes (or process improvement), and new information
Shows friendliness, courtesy, understanding, and politeness to others
Motivates, encourages, and challenges others
Able to identify, evaluate, and use sound judgement to generate and evaluate alternative actions, and make recommendations as accordingly
Encourages, inspires, and guides others toward accomplishing the common goal as an equal member of the team
Knowledge of the ideologies, techniques and tools for quality assurance and control
Preferred
Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake is preferred
Company
BuzzClan
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 StageCompany data provided by crunchbase