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 modelling
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 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
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
Costa Mesa,CA