ZipRecruiter

Log In

1

Data Warehouse Developer Jobs in Pennsylvania (NOW HIRING)

Ask IT consulting

Oracle Developer with PL/SQL

Harrisburg, PA · On-site

$50 - $63.25/hr

Position : Sr. Data Warehouse Developer/ PL/SQL Database Developer Location : Harrisburg PA Duration: 2+ months Position Description: The position serves as a senior data warehouse developer in ...

VUC Inc.

Microsoft SQL Developer

Allentown, PA · On-site

$44.75 - $61.25/hr

We are looking for a skilled SSIS (SQL Server Integration Services) and SQL Data Warehouse Developer who will be responsible for designing, developing, and maintaining data integration and data ...

VUC Inc.

Microsoft SQL Developer

Allentown, PA · On-site

$44.75 - $61.25/hr

Develop, create, and maintain data warehouses combining multiple disparate source systems for downstream financial and operational reporting * Work directly with project leads to understand ...

eTeam

Databricks Senior Data Engineer

Pittsburgh, PA · On-site

$111K - $133K/yr

Job Summary : eTeam is seeking a Databricks Senior Data Engineer to enhance their data architecture ... warehouse performance. Responsibilities : • Develop/Modify the architecture for the EDW ...

next page

Showing results 1-20

All JobsData Warehouse Developer JobsData Warehouse Developer Jobs in Pennsylvania

Data Warehouse Developer information

See Pennsylvania salary details

$13

$54

$73

How much do data warehouse developer jobs pay per hour?

As of Aug 25, 2026, the average hourly pay for data warehouse developer in Pennsylvania is $54.56, according to ZipRecruiter salary data. Most workers in this role earn between $47.45 and $65.05 per hour, depending on experience, location, and employer.

What is a data warehouse developer?

A data warehouse developer designs and implements data warehouses, which are meant to store large amounts of data for easy retrieval by a business or organization. In this role, your duties are to develop storage architecture, design big data models, and create ways to input transactions, such as sales, receipts, customer data, and user downloads. Working with other developers, you ensure that the warehouse can both receive customer and client data and return it as output to analysts who can make recommendations based on their interpretation.

What are the key skills and qualifications needed to thrive as a data warehouse developer?

To thrive as a Data Warehouse Developer, you need expertise in data modeling, ETL processes, SQL, and a solid understanding of database systems, often supported by a degree in computer science or a related field. Familiarity with data warehousing tools (such as Informatica, Talend, or SSIS), OLAP systems, and cloud data platforms is highly valuable, along with relevant certifications. Strong analytical thinking, problem-solving abilities, and effective communication skills set standout professionals apart in this role. These skills are crucial for designing efficient data solutions, ensuring data integrity, and enabling business intelligence for informed decision-making.

What are some common challenges data warehouse developers face when integrating data from multiple sources?

Data Warehouse Developers often encounter challenges with data consistency, varying data formats, and incomplete or poor-quality data when integrating information from multiple sources. Resolving these issues typically involves designing robust ETL (Extract, Transform, Load) processes, implementing data cleansing routines, and collaborating closely with data owners and business analysts to understand data lineage and requirements. Adapting to frequent changes in source systems and ensuring the warehouse remains scalable and performant can also be demanding, but they provide valuable opportunities to develop problem-solving skills and deepen technical expertise.

What is the difference between Data Warehouse Developer vs Data Analyst?

AspectData Warehouse DeveloperData Analyst
CredentialsBachelor's in Computer Science, Data Management, or related field; certifications like Microsoft Certified: Data Analyst AssociateBachelor's in Statistics, Mathematics, or related field; certifications like Microsoft Certified: Data Analyst Associate
Work EnvironmentDesigning, developing, and maintaining data warehouses; working with ETL tools and database systemsAnalyzing data sets, creating reports, and providing insights using BI tools
Industry UsageUsed across industries for data storage and managementUsed across industries for data analysis and reporting

The main difference is that Data Warehouse Developers focus on building and maintaining data storage systems, while Data Analysts interpret data to support business decisions. Both roles require strong technical skills and often overlap in data handling tasks, but their core responsibilities differ.

Is data warehouse a good career?

A career as a Data Warehouse Developer is in demand due to the increasing need for data management and analytics in organizations. It typically requires skills in SQL, ETL processes, and tools like Snowflake or Redshift, with opportunities for growth in data engineering and business intelligence roles.
More about Data Warehouse Developer jobs

What are popular job titles related to Data Warehouse Developer jobs in Pennsylvania?

For Data Warehouse Developer jobs in Pennsylvania, the most frequently searched job titles are:

What job categories do people searching Data Warehouse Developer jobs in Pennsylvania look for?

The top searched job categories for Data Warehouse Developer jobs in Pennsylvania are:

What cities in Pennsylvania are hiring for Data Warehouse Developer jobs?

Cities in Pennsylvania with the most Data Warehouse Developer job openings:

What are popular job titles related to Data Warehouse Developer jobs in PA?

For Data Warehouse Developer jobs in PA, the most frequently searched job titles are:

Data Warehouse Developer jobs near you
Infographic showing various Data Warehouse Developer job openings in Pennsylvania as of August 2026, with employment types broken down into 1% As Needed, 80% Full Time, 17% Part Time, and 2% Contract. Highlights an 85% Physical, 4% Hybrid, and 11% Remote job distribution, with an average salary of $113,475 per year, or $54.6 per hour.

Oracle Developer with PL/SQL

Ask IT consulting

Harrisburg, PA • On-site

$50 - $63.25/hr

Contractor

Re-posted 2 days ago

Job description

Company Description

Ask IT Consulting Inc, backed by a $500 million Microtek group company, provides an industry leading blend of technology, business consulting, and outsourcing services. Ask IT is a minority-owned enterprise; it has been founded on providing the highest quality possible and on the devotion to customer satisfaction. ASK IT consulting is an equal opportunity employer, which is a global staffing, consulting and technology solutions company, offering industry-specific solutions to fortune 500 clients and worldwide corporations.  

Job Description

Position Description:


Position : Sr. Data Warehouse Developer/ PL/SQL Database Developer

Location : Harrisburg PA

Duration: 2+ months  


Position Description: The position serves as a senior data warehouse developer in PennDOT's Bureau of Business Solutions & Services. The incumbent will perform new development and maintenance for an enterprise data warehouse built on an Oracle 11g platform. This individual will also do analysis, design, and development of ETL using Oracle PL/SQL and Informatica PowerCenter 9.5. The incumbent will develop and maintain tables, create views, write queries, build PL/SQL packages, write stored procedures, triggers and functions, and design and develop complex ETL processes. Responsibilities also include data modeling, primarily dimensional modeling. Technologies leveraged include Oracle 11g, PL/SQL, Informatica PowerCenter 9.5, and Erwin 7.3


Specific Duties:


Meet with end users and technical staff to gather data requirements

Perform intensive data analysis on source system data bases. Analyze and understand source system 

database, find required data, and profile the data.

Review and create dimensional and normalized data models.

Develop Oracle SQL and PL/SQL code, including packages, procedures, functions, views and complex analytical 

queries.

Develop complex ETL using Oracle PL/SQL and Informatica PowerCenter

Diagnose, analyze, troubleshoot and choose appropriate solution to fix data related issues.


Required Skills and Experience


1. Required: 7+ years Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning

2. Required: 5+ years data warehouse development experience

3. Required: 5+ years of data modeling experience 

4. Required: 2+ years dimensional modeling experience

5. Required: 3+ years experience using data integration/ETL software tool(s)

6. Required: Strong oral and written communication skills

7. Desired: 2 years Informatica PowerCenter ETL development experience

8. Desired: 2 years MS SQL Server and/or DB2 experience

9. Desired: 1 year experience with Business Objects BI Tool suite or comparable BI tool suite


Skill Required / Desired Amount Candidate exp last used 

Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning Required 7 Years  

Data warehouse development experience Required 5 Years  

Review and create dimensional and normalized data models Required 5 Years  

Dimensional modeling experience Required 2 Years  

Experience using data integration/ETL software tool(s) Required 3 Years  

Strong oral and written communication skills Required      

Informatica PowerCenter ETL development experience Desired 2 Years  

MS SQL Server and/or DB2 experience Required 2 Years  

Experience with Business Objects BI Tool suite or comparable BI tool suite Desired 1 Years  



Additional Information

For immediate consideration send emails to vpsingh @ askitc.com

Ask IT Consulting logo

About Ask IT Consulting

Sourced by ZipRecruiter

Ask IT Consulting, based in Holtsville, NY, US, is a dynamic player in the IT and business solutions industry. Their services portfolio, as outlined on their official website (askitc.com), spans across a broad spectrum which includes IT consulting, talent management, digital and technology solutions. Founded with the goal to provide clients with the highest quality IT services, the company has steadily evolved and expanded as a leading resource, maintaining a powerful presence in the fields of information technology and business solutions alike. Ask IT Consulting believes firmly in its core values, which pivots upon integrity, excellence, respect, commitment, and diversity. As part of its mission, the company strives to deliver innovative and effective solutions for their clients that are tailored to meet their unique needs and objectives.

Industry

It services

Company size

51 - 200 Employees

Headquarters location

Holtsville, NY, US

Year founded

2008

Social media

FacebookTwitter

View All Ask IT Consulting Jobs

Apply