Junior Data Engineer

Brooksource; Philadelphia (Philadelphia County); Hybrid; USD 56,000 - 64,000; Full time

Benefits offered by this job

Dental insurance

Health insurance

Vision insurance

401k plan with company match

Paid time off

Sick time

Paid company holidays

Employee Assistance Program (EAP)

Health Savings Account

Dependent Care FSA

Job summary

Brooksource is hiring a Junior Data Engineer for a hybrid role in Philadelphia, PA. You will help build and support enterprise data pipelines, ingestion processes, and data warehouse solutions with exposure to cloud-based data engineering technologies.

The role emphasizes SQL/T-SQL development, ETL workflows, and data modeling within an SDLC framework. Collaboration with analysts and stakeholders is expected, along with JIRA-based tracking and reporting tools like Tableau and Oracle BI.

Qualifications

• Bachelor’s degree in a related technical discipline.
• 0–2 years of experience with SQL, data engineering, or analytics.
• Working knowledge of SQL/T-SQL and relational databases.
• Familiarity with ETL concepts and data integration processes.
• Understanding of data warehousing and dimensional modeling concepts.
• Understanding of SDLC and software testing practices.
• Strong analytical, communication, and problem-solving skills.
• Interest in AWS and cloud-based data engineering.

Responsibilities

• Develop, maintain, and optimize T-SQL queries, stored procedures, and scripts for data processing, ingestion, and reporting.
• Build and maintain ETL workflows and data pipelines to ingest, transform, and load data from multiple sources.
• Use SSIS and related technologies to support data integration and transformation.
• Validate data throughout ingestion and transformation for quality and consistency.
• Assist with designing relational and dimensional data models, including star-schema structures.
• Contribute across the SDLC, including requirements analysis, development, unit testing, UAT, deployment, and production support.
• Perform unit testing and support UAT to validate transformations and business requirements.
• Troubleshoot data pipelines, SQL, and data quality with senior engineers.
• Use JIRA for ticket management and project workflows.
• Support reporting with Tableau and Oracle BI (OBI).
• Document data flows, transformations, and business rules.
• Follow data governance, privacy, security, and compliance standards.
• Collaborate with engineers, analysts, and business stakeholders across technical levels.

Skills

SQL

Analytical thinking

Communication

Team collaboration

Problem solving

AWS interest

Education

Bachelor’s degree in Computer Science or related field

Tools

Tableau

Oracle BI (OBI)

JIRA

SSIS

T-SQL

Job description

Brooksource is hiring a Junior Data Engineer for a hybrid position in Philadelphia, PA. In this role, you will help build and support enterprise data pipelines, ingestion processes, and data warehouse solutions, with increasing exposure to cloud-based data engineering technologies.

What you’ll do

• Develop, maintain, and optimize T-SQL queries, stored procedures, and scripts used for data processing, ingestion, and reporting.
• Build and maintain ETL workflows and data pipelines to ingest, transform, and load data from multiple sources.
• Use SSIS and related technologies to support data integration and transformation.
• Validate data throughout ingestion and transformation to support quality, accuracy, and consistency.
• Assist with designing and implementing relational and dimensional data models, including star-schema structures for data warehousing.
• Contribute across the SDLC, including requirements analysis, development, unit testing, UAT, deployment, and production support.
• Perform unit testing and support User Acceptance Testing (UAT) to validate transformations and business requirements.
• Troubleshoot issues in data pipelines, SQL, and data quality, partnering with senior engineers to identify solutions.
• Use JIRA for ticket management, development tracking, and project workflows.
• Support reporting and visualization efforts using tools such as Tableau and Oracle BI (OBI).
• Document data flows, transformations, technical processes, and business rules.
• Follow established standards for data governance, privacy, security, and compliance.
• Collaborate with engineers, analysts, and business stakeholders across different technical levels.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical discipline.
• About 0–2 years of professional experience working with SQL, databases, data engineering, analytics, or related technologies.
• Working knowledge of SQL/T-SQL, including queries, joins, stored procedures, and relational database concepts.
• Familiarity with ETL concepts and data integration processes.
• Understanding of data warehousing and foundational data modeling concepts, including dimensional modeling and star schemas.
• Understanding of the SDLC and software testing practices.
• Strong analytical, critical-thinking, and problem-solving skills.
• Ability to communicate effectively and work collaboratively within a technical team.
• Strong interest in developing skills in AWS and cloud-based data engineering.

Tools and technologies

• T-SQL, ETL, SSIS
• AWS
• SQL
• Tableau
• Oracle BI (OBI)
• JIRA

Benefits

• Dental insurance
• Health insurance
• Vision insurance
• 401k plan with a company match, fully vested after eligibility
• Paid time off
• Sick time
• Paid company holidays
• Employee Assistance Program (EAP) including virtual counseling, financial services, legal services, life coaching, etc.
• Health Savings Account
• Dependent Care FSA
• Supplemental coverage

Pay: USD 27 per hour (pay range is a general guideline only and not a guarantee of compensation or salary).