Vacancy expired!
- Gather business requirements & interface with clients (40%):
- Review client requests
- Analyze impact to existing applications, if any
- Propose alternative solutions to meet business requirements
- Review proposed solutions with clients and vendors for selection
- Produce finalized requirements document
- Facilitate user acceptance testing
- Design, develop and maintain data warehouse components and processes (35%)
- Produce data modeling and data flow diagrams
- Define database tables and indexes
- Write/modify computer programs
- Write Extract-Transform-Load (ETL) instructions
- Perform quality assurance testing
- Maintain system processing run schedules
- Monitor system performance and fine tune when necessary
- Provide after-hours on-call support
- Provide guidance to fellow DW team members (25%):
- Auto industry knowledge transfer
- Assist with data access design via SQL
- Communicate business rules to developers by interpreting requirements into technical specifications
- Test developed applications and provide feedback
- 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
- Automotive industry experience a plus
Vacancy expired!