Closed or Expired Job Posting This job posting is closed or has expired and is no longer open for applications.
Upload
Job Description
Job Purpose:
The data warehouse developer will be responsible for developing and supporting the Enterprise Datawarehouse framework, processes, and best practices.
As part of the BI Team, the individual will collaborate with business and technology partners to define and implement new data management and governance infrastructure. The success of this role is dependent on an understanding of complex data environments, the ability to influence and lead, and the ability to partner with teams to enable capabilities.
Functional Accountabilities:
Populate the Data Warehouse using Data Modeling Techniques for Target Structures such as Star Schemas, Snowflake Schemas, and Highly Normalized Data Models
Build specific Datamart answering business expectations
Develop and Deploy the Extraction, Transformation, and Loading Routine for the Data Warehouse Environment by Sourcing the Data from the Operational Systems, Applying the Business Transformation Rules, and Loading it to the Data Warehouse and Data mart Environments
Analyze and Develop Strategies for Data Acquisitions, Archives, Recovery, and Implementation of the ETL Repository and Load Jobs
Determine the Optimal Approach for Obtaining Data from Diverse Source System Platforms and moving it to the Data Warehouse
Implement and execute strategy for Change Data Capture
Create Testing Methodology and Criteria
Perform Detailed Data Analysis including Data Quality and Consistency by Monitoring Production Data
Investigate, analyze, document, and correct reported defects
Develop Specifications for Data Cleansing, ETL, and Data Migration Processes
Develop and Maintain Standards, Common Processes, and Best Practices for ETL Architecture including Batch Jobs Auditing and Balancing
Design and Implements Automation of Data Loading and Cleansing Processes
Modify ETL Processes to Accommodate Source System Changes with New Business User Requirements
Interpret written business requirements and transform them into technical specifications
Create and maintain technical specification documentation
Skills
Education:
BSC in Computer Science, Engineering Degree, or a very relevant field
Master's Degree is a +
Experience, Skills & Competencies
4-6 years of work experience as a data warehouse developer.
Exposure to the retail Industry is a Great Advantage
Experience with business requirements analysis, entity relationship planning, database design, reporting structures, and so on.
Extensive knowledge of data manipulation languages (Microsoft SSIS) and ETL/ELT (Talend, Alteryx,…).
Full understanding of the processes of data quality, data cleansing, and data transformation
Excellent knowledge of data warehouse concepts, technologies, and best business practices including: data sourcing, data transformation, data loading, data cleansing, data integrity checking, and end-user tools
Experience with database platforms, including SQL and Oracle
Experience in Database design and well-versed with SQL Server best practices
Ability to manage data and metadata migration.
Understanding of Web services (SOAP, XML, UDDI, WSDL).
Excellent client/user interaction skills to determine requirements.
In-depth technical knowledge of network, PC, and platform operating systems, including ….
Working technical knowledge of current systems software, protocols, and standards.
Experience with data processing flowcharting techniques
