Software Engineer
The Associate Software Engineer (Data Engineering) role involves designing, developing, testing, and maintaining database solutions to support data-driven business decisions. The position focuses on SQL programming, ETL processes, and collaboration with cross-functional teams to ensure data accuracy, integrity, and performance optimization. This entry-level role is ideal for candidates eager to build expertise in database technologies and data engineering within a full-time, on-site environment.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Design Services, Information Services, and IT System Design Services.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
This Software Engineer Philadelphia PA role focuses on data engineering fundamentals — building, testing, and maintaining reliable SQL-based database solutions that support reporting and analytics.
- Develop, test, and maintain SQL queries, stored procedures, functions, views, and other database objects
- Write efficient, optimized SQL to retrieve, transform, and analyze data
- Assist with relational database design and normalization to support reliable data models
- Perform data extraction, transformation, validation, and loading (ETL) tasks
- Generate reports and data extracts to support business and operational needs
- Troubleshoot and resolve database and query-related issues
- Monitor query performance and support database optimization efforts
- Collaborate cross-functionally with developers, data engineers, analysts, and DBAs
- Support database migration, integration, and data warehouse activities
- Document database designs, SQL scripts, technical processes, and decisions
- Keep current with emerging database and ETL tools and best practices
What We’re Looking For (Required)
- Knowledge of SQL programming and query tuning
- Familiarity with relational databases such as SQL Server, Oracle, MySQL, or PostgreSQL
- Understanding of database fundamentals: tables, keys, indexes, views, constraints
- Experience with joins, subqueries, Common Table Expressions (CTEs), and window functions
- Basic understanding of stored procedures, triggers, functions, and transactions
- Familiarity with database design and normalization concepts
- Basic data analysis and reporting knowledge
- Understanding of data quality, validation, and integrity principles
- Familiarity with Git or another version control system
- Strong analytical, troubleshooting, and problem-solving skills
- Effective verbal and written communication; ability to work on a team
- Bachelor’s degree (or equivalent experience) in Computer Science, Information Systems, or related field
Nice-to-Have (Preferred)
- Experience with Microsoft SQL Server, Oracle, MySQL, or PostgreSQL in production
- Familiarity with ETL tools such as SSIS, Informatica, Talend, or AWS Glue
- Knowledge of data warehousing concepts (star/snowflake schemas)
- Exposure to reporting/visualization tools such as Power BI, Tableau, or SSRS
- Basic programming skills (Python or similar)
- Familiarity with cloud database services (AWS, Azure, GCP)
- Understanding of database performance tuning and query optimization
- Experience working in Agile/Scrum environments
Compensation, Location & Employment Type
- Employment type: Full-time
- Base pay range (provided by the client): $30.00/yr - $35.00/yr (actual pay will depend on skills and experience)
- Location: Philadelphia, PA — candidate must be open to relocate
- Reasonable accommodations for applicants with disabilities are available upon request throughout the hiring process
Why Apply (What You’ll Gain)
- Early-career growth: hands-on experience with ETL, databases, and reporting
- Exposure to cross-functional projects with experienced data and software teams
- Opportunities to learn cloud database services and modern ETL tooling
- Direct employment by a confidential client with access to additional roles via Careertakes
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range