Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
ETL Data Modeler SQL Server 2008 R2 Oracle datawarehouse MOLAP Cube Modeling & Desig
 
Requirement id 3124
Job title Architect
Job location in Philadelphia, PA
Skills required ETL, SQL, Data Modeler, SQL Server 2008 R2 Oracle datawarehouse
Open Date 09-Mar-2011
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type Phone Screen and Face to Face interview
Apply
   Email Recruiter: coolsoft
Job Description Architect: ETL, SQL, Data Modeler, SQL Server 2008 R2 Oracle datawarehouse

[Note:3 MANAGERIAL references will be required for this position
[PERSONAL INTERVIEW will be REQUIRED at the expense of your company or the candidate]

The Application Engineer:

Is responsible for the development & coding complete hands-on, with BI development using SSAS, backend database Sql server 2008 R2 & Oracle big plus. Candidate should have clear understanding dimensional modeling and ETLs for Dimensions and Facts, worked with DSVs and creating custom dimensions. Experience with ETLs for Cube and dimension. This position will also review existing Reports and modify them as per business requirement, Work experience with KPIs and Dashboard reporting is a must. Good Understanding of DataMarts/ Data warehouse Concepts and Good understanding of MOLAP/ROLAP Cubes structure. This position can create first level program and systems designs and will develop highly maintainable software by anticipating future changes and providing code flexibility. This position will also comprehend all detailed requirements before starting to design or code the solution.



Primary Duties and Responsibilities:

* Design and Develop MOLAP/ROLAP/HOLAP Cubes using SSAS/SSIS/SSRS
* Create SQL/MDx, DMx and XMLA queries and should built custom functions SSAS.
* Create KPIs and Dashboard reporting using SSAS and Performance Point as per Business unit requirement.
* Create and schedule cube with data updates
* Create, document, and implement unit test plans, scripts, and test cases.
* Create and maintain technical documentation using defined technical documentation templates.

Job Specifications:

* Design, prototype build, code, document and unit test solutions for projects.
* Determine level of effort to design, build, and code, document and unit test so that estimates can be provided to the Technical Supervisor.
* Contributes to the creation of solid coding techniques and recommends and reviews coding standards.
* Analyze application requests and business requirements for completeness and understanding.
* Keeps abreast of trends and developments in IT and mortgage insurance.

Technical Experience:

· 10-15 years of experience

· ETL Design Experience

· Data Modeling – Star Schema Design

· Minimum of 3-6 years programming experience

· Demonstrable Software Development experience

· Knowledge of database architecture and design

· Ability to interpret written requirements and technical specification documents.

· Ability to code software according to published standards and design guidelines.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 3124 while calling.
 
Other jobs in PA: Dauphin (1), Dauphin County (3), Downingtown (2), Glen Milla (1), Harribsurg (1), Harrisburg (47), Horsham (6), Malvern (2), Pennsylvania (13), Phila (2), Philadelphia (16), Pittsburgh (1), Radnor (2), Reading (1), Sharon (3), WAYNE (1), West Cheste (1), West Chester (33),
ETL job openings in Philadelphia, PA
Jobs List

PCI Software Developer - 65138
Create date: 20-Jul-2020
Note :Looking for someone with Data Engineering/Programming background.

Candidate must be our W2 Employee.

Candidate must be local : Yes

Job Description :

It is looking for a Data Engineer for one of our largest technology clients in Philadelphia OR Denver. This candidate must have strong scripting skills.... (This job is for - ETL MY SQL Jobs in PA Philadelphia Developer - (in Philadelphia, PA))

Informatica/ETL Lead Developer - NTTJP00017018
Create date: 27-Feb-2019
Start Date:3/18/2019
End Date:12/31/2019
Submission Deadline :3/12/2019

Description :
we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our ability to help our clients stay a step ahead of th.... (This job is for - ETL Jobs in PA Philadelphia Developer - (in Philadelphia, PA))

ETL Developer - 35634
Create date: 13-Jun-2018
Required Skills :
Must Have: PL/SQL, ETL, Informatica experience
Must be available for on-site interview - NO OPT-STEM Candidates
Basic Qualifications :
Additional Skills :
Job Description :

Responsibility:
-Develop and test ETL components to high standards of quality and performance.
- Perform design/.... (This job is for - ETL Pentaho Jobs in PA Philadelphia Developer - (in Philadelphia, PA))

Data Analyst - 30367
Create date: 14-Dec-2017
Candidate must be our W2 Employee



Group/Team Details: fast-paced, innovative team that works heavily with customer data, call volume data, customer experience satisfaction data
Length: 12 month contract (possibility to be extended)
Tech Landscape: SQL, Tableau, Excel

Responsibilities of the Da.... (This job is for - ETL Jobs in PA Philadelphia Analyst - (in Philadelphia, PA))

Lavastorm Application Lead - J-11-080-875
Create date: 18-Jan-2016
Note:
Start date : 2/1/2016
End date : 1/31/2017
Submission deadline: 1/22/2016
Description:

Role: Lavastorm Application Lead
Location: Philadelphia, PA (19103)
Type: Contract
Duration: 12 months

Qualifications:
Total 8+ years of experience
Good knowledge of EAI La.... (This job is for - ETL EAI Tuning Jobs in PA PHILADELPHIA Developer - (in Philadelphia, PA))
 
 ETL job openings in other states
Jobs List

Scrum Master- 168053
Create date: 12-Nov-2026
Start date : 12/14/2026

End Date : 06/30/2027

Submission deadline : 11/19/2026 4:00:00 PM

Client Info : ETF

Note:

*Interview Process: remote via MS Teams (may have two rounds of interviews)

*Onsite or Remote? No WI residency required. Open to nationwide candidates. This position .... (This job is for - ETL SCRUM MDM Jobs in WI Madison Consultant - (in Madison, WI))

NC Fast Data Scientist- Mid Level (812170)
Create date: 06-Nov-2026
Start date : 10/05/2026

End Date : 10/04/2027

Submission deadline : 11/12/2026

Client Info : NCDHHS-NCFAST

Note:

*Hybrid
*In Person Only

Description:

The client is requires the services of a Senior Data Analyst that will help us design, manage, and optimize ente.... (This job is for - ETL Jobs in NC Raleigh Consultant - (in Raleigh, NC))

Data Warehouse Developer III- 167157
Create date: 20-Oct-2026
Start date: 11/02/2026

End Date : 06/30/2027

Submission deadline: 10/22/2026 4:00:00 PM


Client Info: ETF

Note:

*Interview Process: 1-2 rounds via Microsoft Teams.
*Onsite or Remote? No WI residency required. Open to nationwide candidates. This position can work 100% remote or i.... (This job is for - ETL Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III- 167039
Create date: 15-Oct-2026
Start date :11/2/2026

End Date : 06/30/2027

Submission deadline : 10/19/2026 4:00:00 PM

Client Info : ETF

Note:

*Interview Process: 1-2 rounds via Microsoft Teams.

*Onsite or Remote? Candidate must be a WI Resident. No relocation is allowed. This position can work 100% remote or.... (This job is for - ETL Jobs in WI Madison Developer - (in Madison, WI))

IA-DOM-DOIT-TS4 VISION Power BI Lead (812377)
Create date: 29-Sep-2026
Start date :10/26/2026
End Date :06/30/2027

Submission deadline :10/2/2026

Client Info :3280 IT Infrastructure Services Consulting

Note:

*Agency Interview Type: Either Web Cam or In Person Interview

*Work Arrangement: Remote

Description:

The VISION – CWIS FACS Conve.... (This job is for - ETL Jobs in IA DesMoines Consultant - (in Des Moines, IA))
 
 ETL job openings in PA
Jobs List

Data Engineer (PySpark - Data Bricks) - 73189
Create date: 22-Mar-2021
Candidate must be our W2 Employee.

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens.

Job Description:


Please send candidates for this role and we can accept pass through candidates.

Delhaize

Data Systems Analyst -- Arch-Bus Intel & Analytics

6 month contract to hi.... (This job is for - ETLSME Jobs in PA Carlisle Engineer - (in Carlisle, PA))

Data Operations Developer - 64243
Create date: 18-Jun-2020
Candidate must be local : Yes

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens.

Candidate must be our W2 Employee.

Job Description :

It is recruiting a Data and Data Operations Developer for one of our clients here in the Pittsburgh area. The qualified candidate will work within an agile tea.... (This job is for - ETL SSAS Jobs in PA Pittsburgh Developer - (in Pittsburgh, PA))

ETL / Data Warehouse Tester - 64185
Create date: 16-Jun-2020
Note:(Must be able to convert with no current or future sponsorship issues)

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens.

Job Description :

Title: ETL / Data Warehouse Tester

Location: Ft. Washington, PA (initially remote due to COVID-19)

Duration: 6 Months w/ Right to Hire (ca.... (This job is for - ETL Oracle Jobs in PA FortWashington Tester - (in Fort Washington, PA))

IT - Data Analytics Consultant - Senior - 58701
Create date: 30-Jan-2020
Candidate must be our W2 Employee.



Job Description :

Data Engineer / Data Warehouse Developer

20 week project

680 BLAIR MILL RD Horsham Pennsylvania USA 19044
************Must be within 2 hour drive and available for on-site interview! NO VIDEO INTERVIEWS - DO NOT ASK ME ABOUT VIDEO INTE.... (This job is for - Oracle ETL T SQL Jobs in PA Horsham Consultant - (in Horsham, PA))

ETL Developer - 49748
Create date: 15-Jul-2019
Description:
The BFF/Data Services team is seeking a Senior Informatica ETL Developer to do design, development for OPERATIONAL REPORTING project within Insurance Solutions . Work with initiative leads, business areas, technical leads, architects, subject matter experts, developers, technical support groups and test teams to integrate data and.... (This job is for - ETL Teradata Jobs in PA Horsham Developer - (in Horsham, PA))
(Architect: ETL, SQL, Data Modeler, SQL Server 2008 R2 Oracle datawarehouse in Philadelphia, PA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us