Sr. Business Systems Analyst (Job Code: AA0910)
Sr. Business Systems Analyst (Job Code: AA0910)
DETAILS:
Gather business requirements & interface with clients (40%), including: reviewing client requests; analyzing impact to existing applications, if any; proposing alternative solutions to meet business requirements; reviewing proposed solutions with clients and vendors for selection; producing finalized requirements document; and facilitating user acceptance testing. Design, develop and maintain data warehouse components and processes (35%), including: producing data modeling and data flow diagrams; defining database tables and indexes; writing/modifying computer programs; writing Extract-Transform-Load (ETL) instructions; performing quality assurance testing; maintaining system processing run schedules; monitoring system performance and fine tune when necessary; and providing after-hours on-call support. Provide guidance to fellow Data Warehouse team members (25%), including: transferring auto industry knowledge; assisting with data access design via SQL; communicating business rules to developers by interpreting requirements into technical specifications; and testing developed applications and provide feedback. May work from home.
REQUIREMENTS:
Bachelor’s degree (or foreign equivalent) in Information Technology, Computer Science, Computer Engineering, or Information Systems/Information Technology related field plus 2 years of experience in the offered position or related position.
SPECIAL SKILLS REQUIREMENTS:
Must possess expertise/ knowledge sufficient to adequately perform the duties of the job being offered. Expertise/knowledge may be gained through employment experience or education. Required expertise/knowledge includes:
- Experience in the role of a Business Systems Analyst in a Data Warehouse/BI environment.
- Data modeling experience using ERwin r7 or higher.
- Experience creating, maintaining, and fine-tuning Oracle database objects using Toad for Oracle 11 or higher.
- Understanding of data warehousing methodology, data mapping and modeling, ETL, databases, and Business Intelligence and their processes.
- Knowledge of SQL, Oracle database, stored procedures and ad-hoc query development.
- Ability to work with star schema designs and extensive knowledge in building and designing logical /physical data modeling.
- Detailed and process oriented data modeling skills.
- Business analysis experience to capture data and reporting requirements and translating to technical specs for the enterprise data warehouse.
- Experience in data analysis and developing data mapping and functional solution design documents for ETL developers.
- Experience performing source data model/data analysis and target EDW data model/data analysis.
- Experience capturing business rules and building physical design document to meet user requirements.
- Experience interpreting logical design document and data model diagrams to understand requirements to build physical design document.
- Ability to effectively communicate the functional design to developers and confirm the same with the business teams.
- Ability to effectively document overall business processes and data/information flow; suggest and implement process improvement and data collection opportunities; and functional testing of reports and ETL data auditing.
Other:
Job Site: Fountain Valley, CA;
40 hours/week;
Salary range: $99,341 per year to $130,000 per year;
If offered employment, must have legal right to work in U.S. EOE.
Contact:
Hyundai AutoEver America, LLC, Attn: Sandhya Sivaraman, 10550 Talbert Ave, Fountain Valley, CA 92708 (Must Reference Job Code: AA0910)
#LI-DNI
#LI-DNI