JOBSEARCHER

Data Engineer

Junior Data Engineer HybridPhiladelphia, PARole Overview 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.