Work Authorization: US Citizen, Green Card, GC-EAD, OPT-EAD, L2-EAD, TN Visa
Local Candidates Preferred. Non-local candidates must be willing to pay for your own interview travel expenses and relocation costs.
Job Description
Role: Business Analyst
Location: Fountain Valley, CA
Duration: 6+ Months
Rate: 43/hr on C2C (Max)
Interview Type: Phone + F2F
Must Have:
- 5-7 years of proven hands-on experience in the role of a BSA 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
- 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 schema designs and extensive knowledge in building and designing logical/physical data modeling
- Strong data modeling skills, be detail and process-oriented
- 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 developing 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
- Strong expertise to understand and interpret 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. Functional testing of reports and ETL data auditing
- 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
Nice to haves for the role:
- Automotive industry experience a plus
Equal Opportunity Employer
Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability, and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination, and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status, or any other protected status. Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements, or related matters. Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.
#J-18808-Ljbffr