10652 - Business Systems Consultant

Purpose
As a member of the CVA team, the Data Warehouse Developer/Analyst will perform requirements gathering, Data pipeline reviews and development, data analysis, data mapping, logical data modeling, functional design, and data quality improvements. This individual will be working closely with end users, ETL developers, Data Modelers / Architects, Report Developers and Functional teams.
Essential Functions

• Responsible to review, build and maintain data pipelines that efficiently move data from various sources to the data storage system using Python, Informatica PowerCenter and IICS.
• Ability to integrate data from multiple sources into a centralized data store. This includes designing and implementing data integration processes and tools, such as ETL (Extract, Transform, Load) processes, to ensure that data is accurately and efficiently transferred from source systems to the data warehouse.
• Responsible for gathering and documenting business requirements for MDM initiatives. This involves working with business stakeholders to identify data requirements and define use cases for data access and integration across the enterprise.
• Responsible for communicating with stakeholders and end-users to ensure their understanding of MDM concepts, data governance policies, and system functionality. This includes providing training and support to users and stakeholders to ensure their successful adoption and use of the MDM system.
• Responsible for ensuring that the data stored in the data warehouse is secure and meets privacy requirements. This includes implementing appropriate access controls and data encryption measures to protect sensitive data, as well as complying with data privacy regulations and standards.
• Ensure that the data stored in the data warehouse is accurate, complete, and consistent. This includes implementing data quality checks and validation processes to identify and correct data errors, as well as monitoring data quality over time to ensure ongoing accuracy and consistency.
• The MDM-focused is responsible for designing and implementing MDM systems that meet the organization's business requirements. This includes selecting and configuring appropriate MDM software, defining data mappings and transformations, and developing data validation rules and processes.
• Ability to write SQL queries to validate data in the back end systems.
• Responsible for maintaining and optimizing the performance of the data storage and retrieval systems. This includes monitoring system performance, identifying and resolving performance bottlenecks, and implementing system upgrades and patches to ensure ongoing stability and reliability.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Basic Requirements

• Possess a collaborative working style and the ability to work independently in a team environment
• Performs source data model / data analysis, and target EDW data model / data analysis
• Automotive industry experience is a plus
• Strong ability to work with star schema designs and extensive knowledge in building and designing logical /physical data modelling
• Must be an initiative taker and possess ability to work independently with minimal supervision
• Strong knowledge of SQL, Oracle database, stored procedures and ad-hoc query development
• Should have 10+ years of experience in database design, data modeling, data warehousing, ETL (Extract, Transform, Load) processes, and programming languages such as Python, SQL, and Informatica.
• Capture business rules and builds physical design document to meet user requirements
• Strong business analysis experience to capture data and reporting requirements and translating to technical specs for the enterprise data warehouse
• Ability to effectively communicate the functional design to developers and confirm the same with the business teams
• Ability to work under pressure, adapt to changing environment, and multi-task
• BS/BA degree required.
• Ability to effectively document overall business processes and data/information flow. Suggest and implement process improvement and data collection opportunities. Functional testing of reports and ETL data auditing
• Extensive experience creating, maintaining, and fine-tuning Oracle database objects using Toad for Oracle 11 or higher.
• Excellent communication and presentation skills
• Extensive experience in data analysis and develop data mapping and functional solution design documents for Informatica/ETL developers
• Strong expertise to understand and interpret logical design document and data model diagrams to understand requirements to build physical design document
• Strong data modeling skills be detail and process oriented
• Strong understanding of data warehousing methodology, data mapping and modeling, ETL, databases, and Business Intelligence and their processes
• Extensive data modeling experience using ERwin r7 or higher.

Salary Range - $98,060 to $151,008