Dieses Jobangebot ist archiviert und steht nicht mehr zur Verfügung.
Vakante Jobangebote finden Sie unter Projekte.

BIDW ETL Developer

Eingestellt von Enclipse Corp.

Gesuchte Skills: Sql, Olap, Consultant, Oracle

Projektbeschreibung

AS34874- BIDW ETL DEVELOPER

PASADENA, CA 91101

POSITION TYPE: W2

CONTACT DURATION: 6MONTHS + (STRONG POSSIBILITY OF EXTENSION)

Infrastructure Decision Support (IDS) Technology Consultant Lead

The IDS team is looking for a technical generalist to develop web-based reporting solutions, assist with the creation of a centralized Datawarehouse, and liaise with business partners. Integrating information from across the enterprise is a key role of the IDS team.

Good decisions require good information, and there is an increasing demand for tools which will provide that information. As an IDS Technology Consultant Lead, you will have the opportunity to create these tools. You will also have the opportunity to assist in the design and implementation of a Datawarehouse, which will combine data from numerous sources into a single repository.

Your job will be to collaborate with internal service providers and subject matter experts to rapidly deliver the right information at the right time to the right person. Along the way, you will need to create a business justification for your work, and be prepared to present it to senior leadership.

Excellent communication skills, motivation, flexibility, and the ability to self-teach are all critical to success in this role.

Responsibilities
Support the Infrastructure Management Group (IMG) with reporting, data analysis, and operational support.
Convert business needs into technical requirements.
Create automated reports to deliver actionable information which enable effective business decisions.
Propose solutions leveraging appropriate toolsets following thorough analysis of requirements and data sources.
Experience with UI design, coding in C#, and writing SQL stored procedures.
Data analysis using OLAP tools.
Data architecture, to include data modelling, development and reporting.
Creation and maintenance of ETL packages.
Present solutions at various stages of development to business partners.
Contribute to project timelines, budgets, and justifications.

Basic Qualifications
Bachelor's degree or 4 years of additional equivalent work experience required
Ability to learn new technologies quickly, and without formal training.
Ability to communicate ideas to a non-technical audience.
5 years of experience with a wide range of database technologies, including SQL Server, DB2, and Oracle.
5 years of experience with web development.
2 years of experience with an OLAP technology.
2 years of experience with an ETL technology.
2 years of experience with data warehousing.

Essential Skills/Qualifications
Experience with MS SQL Server Reporting Services (SSRS).
Experience with ASP.NET development and IIS hosting.
Experience with MS SQL Server Analysis Services (SSAS).
Experience with MS SQL Server Integration Services (SSIS).
Top 3 - 5 Daily responsibilities
1. Gather requirements and create automated reporting solutions.
2. Development of data driven, ASP.NET forms applications.
3. Design a Datawarehouse and accompanying data marts to integrate several data sources.
4. Construction of SSAS cubes to fulfil reporting needs
5. Oversight of ETL development

Top 3 - 5 Required Skills
1. ASP.NET/C# coding
2. UI Design
3. T-SQL knowledge
4. ETL design and development using SSIS
5. Create and administer SQL Server databases
6. Building OLAP solutions using SSAS

Desired Skills
1. Data Warehousing
2. MS SQL
3. OLAP
4. ETL

Projektdetails

  • Vertragsart:

    Contract

  • Berufserfahrung:

    Keine Angabe

Geforderte Qualifikationen

Enclipse Corp.