Data Engineer

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

We are seeking a Junior Data Engineer to join a collaborative data engineering team responsible for building and supporting enterprise data pipelines, ingestion processes, and data warehouse solutions. This role will primarily work with T-SQL, ETL/SSIS, and relational databases, with increasing exposure to AWS cloud-based data technologies.

This is an excellent opportunity for an early-career engineer who has a solid foundation in SQL and data concepts and wants to continue developing into a cloud-focused Data Engineer. The team provides strong mentorship from senior engineers and values candidates who bring curiosity, problem-solving ability, strong communication, and a willingness to learn.

The Junior Data Engineer will participate throughout the full Software Development Life Cycle (SDLC), including development, testing, UAT support, implementation, and ongoing maintenance.

Key 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 used to ingest, transform, and load data 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 the continued evolution of cloud‑based data solutions.
• Assist with the design and implementation of relational and dimensional data models, including star‑schema structures used for data warehousing.
• Validate data throughout ingestion and transformation processes to ensure quality, accuracy, and consistency.
• Participate throughout the SDLC, including requirements analysis, development, unit testing, UAT, deployment, and production support.
• Perform unit testing and assist with User Acceptance Testing (UAT) to validate data transformations and business requirements.
• Troubleshoot data pipeline, SQL, and data‑quality issues and work with senior engineers to identify solutions.
• Use JIRA for ticket management, development tracking, and project workflows.
• Support reporting and visualization solutions using tools such as Tableau and Oracle BI (OBI).
• Document data flows, transformations, technical processes, and business rules.
• Follow established standards related to data governance, privacy, security, and compliance.
• Collaborate with engineers, analysts, and business stakeholders across varying levels of technical expertise.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical discipline.
• Approximately 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 basic data modeling concepts, including dimensional modeling and star schemas.
• Understanding of the Software Development Life Cycle (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.

Preferred Qualifications

• Hands‑on exposure to SSIS or another ETL/data integration platform.
• Exposure to AWS services or cloud‑based data platforms.
• Experience with Tableau, Oracle BI (OBI), or similar business intelligence tools.
• Experience using JIRA or a similar ticketing/project management platform.
• Familiarity with unit testing, UAT, and data‑validation processes.
• Academic, internship, project, or professional experience building data pipelines or data‑processing workflows.

About Us

At Brooksource, relationships are the foundation of everything we do. Since 2000, we’ve built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program. Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company’s unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs.

We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions.

EEO Statement

Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances.

Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.

Pay Disclaimer

The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.