Soni’s client is looking for a Data Warehouse Business Intelligence (BI) Engineer with over 10 years of experience in data engineering, strong expertise in ETL processes using Informatica, and a Snowflake background. The ideal candidate should have experience extracting data from SAP (any module) and bringing it into data environments for analysis and reporting. This person will play a key role in designing, developing, and maintaining data pipelines, validating data integrity, and supporting the data warehouse and LakeHouse environments.
Responsibilities:
- Define the overall data warehouse architecture, including ETL (Extract, Transform, Load) processes, Operational Data Store (ODS), Enterprise Data Warehouse (EDW), and Data Marts.
- Establish best practices and ensure data standardization across all aspects of data warehouse architecture, including load strategies, package scripts, schemas, dimensions, and fact tables.
- Perform basic DBA functions in Snowflake, such as creating tables, indexes, and stored procedures.
- Utilize experience with Informatica IDMC; Power BI and LakeHouse experience are considered advantageous.
- Lead the data warehouse team in configuring and auditing the data warehouse, ensuring quality control and data consistency with corporate financial results.
- Serve as the project lead for BI initiatives, managing all tasks including the creation of BI reports and dashboards.
- Collaborate closely with business partners to define key business drivers.
- Work with senior management and technical design teams to prioritize new BI requirements.
- Define metadata standards for the data warehouse.
- Understand source systems, particularly SAP, to facilitate efficient data extraction.
- Lead the design and direction of information access and delivery efforts for the data warehouse.
- Participate in the selection of technical solutions to meet business needs.
Requirements:
- Bachelor’s degree in Computer Science, Information Systems, or a related field (Master’s preferred) with 7+ years of experience in Business Intelligence and over 10 years in IT.
- Strong hands-on experience with ETL tools, particularly Informatica.
- Proven experience working with Snowflake for data storage and management.
- Expertise in SAP data extraction from various modules, with experience in integrating SAP data into data lakes and data warehouses.
- Proven experience in leading multiple successful enterprise data warehousing projects.
- Expertise in data warehousing technologies, including ETL, ODS, Database Management Systems (DBMS), and BI tools.
- Strong skills in data modeling (both normalized and multidimensional).
- Solid knowledge of database technologies and data warehouse methodologies.
- Excellent business and communication skills, with the ability to present ideas clearly and in a user-friendly manner.
- Committed to providing high levels of customer service to both internal and external clients.
- Proficient in Microsoft Office Suite.
- Exceptional problem-solving and analytical skills.
- High initiative with the ability to prioritize tasks in a fast-paced, high-pressure environment.
- Capable of managing multiple projects simultaneously.