Soni’s client is looking for a
Data Warehouse BI Architect to join their team. This person will design and implement data warehouse in a global environment.
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.
- 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).
- Deep understanding of business data and its various sources, particularly SAP.
- 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.