Description

Translate complex business requirements into technical solution architectures for Data Warehouse projects, guiding implementation and ensuring data integrity.

This role is on-site.

Responsibilities

• Translate business goals into technical solution architectures and provide strategic guidance to the Transformation Lead.
• Design and review data models against business requirements to ensure logical and complete data structures.
• Write SQL statements based on entity relationship diagrams and source-to-target mapping definitions.
• Identify and write UAT test scripts to validate data integrity and reporting accuracy.
• Create and present report mockups to users to define requirements for the new reporting environment.

Required Skills

• 5+ years of experience in Solution Architecture and Project Management roles.
• Extensive experience with large, complex Data Warehouse (DW) projects.
• Deep domain expertise in ERP systems with a focus on Finance (Chart of Accounts, Revenue, etc.).
• Proficiency in writing SQL statements and performing data table joins for validation.
• Experience with source-to-target field mapping and data conversion processes.
• Ability to review and build simple reports in Power BI.
• Proven experience gathering requirements and crafting technical designs for implementation.

Preferred Skills

• Experience with Snowflake.
• Experience with Oracle OTBI.

Key Skills

Education

Any Graduate