Junior Data Engineer

Brooksource is hiring a Junior Data Engineer for a hybrid role in Philadelphia, PA to help build and support enterprise data pipelines and warehouse solutions.

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.
• Support the continued evolution of cloud-based data solutions with hands-on exposure to AWS data engineering technologies.
• Assist with design and implementation of relational and dimensional data models, including star-schema structures for data warehousing.
• Validate data throughout ingestion and transformation to ensure quality, accuracy, and consistency.
• Contribute across the SDLC: 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 and partner 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, 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 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 work collaboratively within 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 a company match; fully vested after you become eligible
• Paid time off
• Sick time
• Paid company holidays
• Employee Assistance Program (EAP) with services such as virtual counseling, financial services, legal services, and life coaching
• Health Savings Account
• Dependent Care FSA
• Supplemental coverage

Pay: USD 27 per hourly.

Pay disclaimer: The pay range for this job level is a general guideline only and not a guarantee of compensation or salary.