Junior Data Engineer: SQL & ETL, Cloud Focus

Brooksource; Philadelphia (Philadelphia County); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Health Savings Account

Dependent Care FSA

401k with company match

Paid time off

Sick time

Paid holidays

Employee Assistance Program

Job summary

Brooksource is seeking a Junior Data Engineer to join a collaborative data team in Philadelphia. The role focuses on SQL/T-SQL, ETL/SSIS, and relational databases, with growing exposure to AWS cloud tech.

You’ll participate in the full SDLC, gain mentorship from senior engineers, and contribute to data ingestion, processing, and reporting initiatives. Ideal candidates have a solid SQL foundation, strong problem-solving abilities, and a desire to develop cloud-focused data engineering skills

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical discipline.
• 0–2 years of professional experience 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 basic data modeling concepts, including dimensional modeling and star schemas.
• Understanding of SDLC and software testing practices.
• Strong analytical, critical-thinking, and problem-solving skills.
• Ability to communicate effectively and collaborate within a technical team.
• Interest in developing skills in AWS and cloud-based data engineering.

Responsibilities

• Develop, maintain, and optimize T-SQL queries, stored procedures, and scripts supporting data processing, ingestion, and reporting.
• Build and maintain ETL workflows and data pipelines for ingestion, transformation, and loading from multiple sources.
• Work with SSIS and related technologies to support data integration and transformation.
• Gain hands-on exposure to AWS data engineering technologies while supporting cloud-based solutions.
• Design and implement relational and dimensional data models for data warehousing.
• Validate data throughout ingestion and transformation processes to ensure quality and accuracy.
• Participate in SDLC activities including requirements analysis, development, unit testing, UAT, deployment, and production support.
• Perform unit testing and assist with UAT to validate data transformations and business requirements.
• Troubleshoot data pipeline, SQL, and data-quality issues with senior engineers to identify solutions.
• Use JIRA for ticket management, development tracking, and project workflows.
• Support reporting and visualization using Tableau and Oracle BI (OBI).
• Document data flows, transformations, processes, and business rules.
• Follow data governance, privacy, security, and compliance standards.
• Collaborate with engineers, analysts, and business stakeholders across technical levels.

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical discipline

Tools

T-SQL

SSIS

Tableau

Oracle BI (OBI)

JIRA

Job description

Brooksource is seeking a Junior Data Engineer to join a collaborative data team in Philadelphia. The role focuses on SQL/T-SQL, ETL/SSIS, and relational databases, with growing exposure to AWS cloud tech.

You’ll participate in the full SDLC, gain mentorship from senior engineers, and contribute to data ingestion, processing, and reporting initiatives. Ideal candidates have a solid SQL foundation, strong problem-solving abilities, and a desire to develop cloud-focused data engineering skills