Mediabistro logo
job logo

Business Systems Analyst (BSA)

Nava Software Solutions, Fountain Valley, CA, United States


Job position: Business Systems Analyst (BSA)
Location: Fountain Vally, CA – Fully Onsite (Preferred local candidates or nearby location)
W2 Contract

Interested in learning more about this job Scroll down and find out what skills, experience and educational qualifications are needed.

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 o Job position: Business Systems Analyst (BSA)
Location: Fountain Vally, CA – Fully Onsite (Preferred local candidates or nearby location)
W2 Contract
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 plusf 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. xywuqvp
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