Data Warehouse Solutions Developer

Our hugely popular client is the Internet's leading provider of spoken audio programming - including books of any genre, magazines, radio shows, daily newspapers, and more. Titles downloaded from this company are compatible with hundreds of mobile devices. Currently this client has a contract opening for a BI DEVELOPER/DATA ANALYST to help them provide listening experiences that enhance the commute, working out at the gym, or simply relaxing at home.

RESPONSIBILITIES:

- Lead, participate in gathering business requirements, analysis of source systems, define underlying data sources and transformation requirements, design suitable data model, and develop metadata for Data Warehouse/Analytical Reporting.
- Prepare Technical Design/Specifications; develop routines for data extraction and loading.
- This is a highly technical role requiring critical thinking, hands on development, and attention to detail from analysis through implementation and post-production QA/oncall.
- Provide technical/user documentation and training; perform peer reviews of work items produced at various stages of the project.
- Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts.
- Demonstrate passion for quality and productivity by use of efficient development techniques, standards and guidelines.
- Analyze and determine the impact of technology capabilities and limitations, translate high level design to detailed design specifications, develop, test and deploy code/application in various environments.
- Perform effort estimation for various Data Warehouse activities; meet project deliverables as per requirements, on time within budgets.

BASIC QUALIFICATIONS:

- Strong Computer Science background required
- Bachelor's degree or higher in computer science required
- 5+ years of industry experience required
- 4+ years in working with large data sets and analysing data to identify patterns
- 5+ years in data warehousing projects with at least 4 years of full life cycle experience in implementation and support of Data Warehouse Solutions on Oracle Platform
- Must have extensive knowledge in ETL, Oracle 9i/10g/11g and SQL and PL/SQL
- Must have extensive knowledge in Data Warehouse designing techniques like Star Schema/Snowflake
- Extensive design and coding skills in Perl, Shell script, XML on Unix Platforms
- Knowledge of tuning and scaling in a Data Warehouse environment highly desired
- Strong customer focus, ownership, urgency and drive
- Excellent communication skills and the ability to work well in a team
- Effective analytical, troubleshooting and problem-solving skills

PREFERRED QUALIFICATIONS:

- Very good technical expertise and strong business skills, as s/he will lead the team in delivering Business Intelligence solutions
- Must be aware of testing process and Data Warehouse implementation methodologies
- Knowledge of Hyperion, Discoverer 10g etc.
- Experience in Erwin Datamodelling and Data Quality tool