Business Systems Analyst

Job position: Business Systems Analyst (BSA)

Location: Fountain Vally, CA – Fully Onsite (Preferred local candidates or nearby location)

W2 Contract

Client Interview :- In-person

Job Posting Title:

The Sr. 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.

REQUIRED SKILLS:

· 10 years of proven hands on experience in the role of a Business Systems Analyst in a Data Warehouse / BI environment

· Extensive data modeling experience using ERwin r7 or higher

· Extensive experience creating, maintaining, and fine-tuning Oracle database objects using Toad for Oracle 11 or higher

· Able to represent as a Project Manager and subject matter expert (SME). Would be the point person to effectively communicate between the business, partner and technical teams (onsite and offshore). Lead communication/status meetings on projects as well as joint application development (JAD) sessions with IT partners.

· Ability to provide day -to- day direction to the project team and regular project status to the client.

· Strong understanding of data warehousing methodology, data mapping and modeling, ETL, databases, and Business Intelligence and their processes

· Strong knowledge of SQL, Oracle database, stored procedures and ad-hoc query development

· Strong ability to work with star and snowflake schema designs and extensive knowledge in building and designing logical /physical data modelling

· Strong business analysis experience to capture data and reporting requirements and translating to technical specs for the enterprise data warehouse

· Extensive experience in data analysis and develop data mapping and functional solution design documents for ETL developers

· Performs source data model / data analysis, and target EDW data model / data analysis

· Capture business rules and builds physical design document to meet user requirements

· Ability to work under pressure, adapt to changing environment, and multi-task

· Must be an initiative taker and possess ability to work independently with minimal supervision

· Possess a collaborative working style and the ability to work independently in a team environment

· Excellent communication and presentation skills

· Self-starter with ability to manage priorities

· Automotive industry experience a plus