10654 – Sr. Business Systems Analyst

Purpose

As a member of the CVA (Customer & VIN Analytics) team, the MDM/Data Warehouse Business Systems Analyst will perform requirements gathering and system analysis, 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

• Review client requests
• Define database tables and indexes
• Communicate business rules to developers by interpreting requirements into technical specifications
• Maintain system processing run schedules
• Perform quality assurance testing
• Write/modify computer programs
• Analyze impact to existing applications, if any
• Gather business requirements & interface with clients (40%):
• Review proposed solutions with clients and vendors for selection
• Write Extract-Transform-Load (ETL) instructions
• Produce finalized requirements document
• Provide after-hours on-call support
• Propose alternative solutions to meet business requirements
• Produce data modeling and data flow diagrams
• Test developed applications and provide feedback
• Auto industry knowledge transfer
• Design, develop and maintain data warehouse components and processes (35%)
• Assist with data access design via SQL
• Facilitate user acceptance testing
• Monitor system performance and fine tune when necessary
• Provide guidance to fellow DW team members (25%):

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

• Sound understanding of Customer MDM and ODS. Understanding of privacy laws is a plus.
• 5-7 years of proven hands-on experience in the role of a BSA in a Data Warehouse / Informatica environment
• Performs source data model / data analysis, and target CVA data model / data analysis
• Extensive experience creating, maintaining, and fine-tuning Oracle database objects using Toad for Oracle 11 or higher
• 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
• Excellent communication and presentation skills
• Understanding of CI/CD is preferred.
• Extensive experience in data analysis and develop data mapping and functional solution design documents for ETL developers
• Ability to work under pressure, adapt to changing environment, and multi-task
• Strong understanding of data warehousing methodology, data mapping and modeling, ETL, databases, and Business Intelligence and their processes
• Must be an initiative taker and possess ability to work independently with minimal supervision
• 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
• Strong knowledge of SQL, Oracle database, stored procedures and ad-hoc query development
• Possess a collaborative working style and the ability to work independently in a team environment
• BS/BA degree preferred or equivalent experience.
• Strong data modeling skills be detail and process oriented
• Capture business rules and builds physical design document to meet user requirements
• Strong expertise to understand and interpret logical design document and data model diagrams to understand requirements to build physical design document
• 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

Salary Range - $91,810 to $131,285