This position is no longer accepting applications
Closed on November 4, 2026.
This role is filled — get an email when new Data Processing roles open on EngineerJobs.io:
Junior Data Engineer
Analytics
Business Analytics
Business Intelligence
Cloud Operations
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Visualization Tools
Data Viz
Data Warehouse
Database
Databases
Dataviz
Digital Marketing
ETL
Informatica
Oracle Bi
Reporting and Analytics
SQL
Sql Server Integration Services
Tableau
View similar jobs
Get alerted when similar jobs are posted — set up a New Data Processing jobs on EngineerJobs.io alert.
See other roles at Brooksource.
Job Description
Brooksource seeks a Junior Data Engineer for a hybrid role in Philadelphia, PA.
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
- Support data integration and transformation using SSIS and related technologies
- Gain hands-on exposure to AWS data engineering technologies while supporting cloud-based data solutions
- Assist with relational and dimensional data model design, including star-schema structures for data warehousing
- Validate data throughout ingestion and transformation to support quality, accuracy, and consistency
- Participate across the SDLC, including requirements analysis, development, unit testing, UAT, deployment, and production support
- Perform unit testing and support User Acceptance Testing (UAT) for data transformations and business requirements
- Troubleshoot data pipeline, SQL, and data-quality issues with senior engineers
- Use JIRA for ticket management, development tracking, and project workflows
- Support reporting and visualization using 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 varying technical levels
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical discipline
- Approximately 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, 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 work collaboratively in a technical team
- Strong interest in developing skills in AWS and cloud-based data engineering
Technologies
- T-SQL
- ETL
- SSIS
- AWS
- SQL
- Tableau
- Oracle BI (OBI)
- JIRA
Benefits
- Dental insurance
- Health insurance
- Vision insurance
- 401k plan with company match; fully vested after you become eligible
- Paid time off
- Sick time
- Paid company holidays
- Employee Assistance Program (EAP) with services including virtual counseling, financial services, legal services, life coaching, etc.
- Health Savings Account
- Dependent Care FSA
- Supplemental coverage
Pay Disclaimer
The pay range for this job level is a general guideline only and not a guarantee of compensation or salary.
Compensation: USD 27 per hourly
Location: Philadelphia, PA (hybrid)
Similar Jobs
A
