SP Software Solutions | SQL Developer | philadelphia, pa
4 days ago
Position: SQL Developer with Analysis Skills
Location: Philadelphia, PA (Hybrid – 2 Days Remote, 3 Days On-Site)
Contract Length: Long-Term
Key Responsibilities:
- SQL Scripting & Query Writing: Design, develop, and optimize complex SQL scripts for data extraction, transformation, and reporting. This includes writing advanced queries with joins, subqueries, unions, and aggregations.
- Database Design & Table Creation: Responsible for the creation and maintenance of database tables, schemas, and other structures. Ensure proper indexing and normalization to optimize performance.
- Data Transformation & Integration: Work with large data sets, transforming and integrating data from various sources into a data warehouse or operational databases.
- Performance Tuning: Monitor and optimize SQL queries for maximum efficiency, including indexing strategies, query execution plans, and minimizing resource consumption.
- Data Quality & Validation: Ensure the accuracy and quality of data through validation and troubleshooting queries. Address any data quality issues that arise during the ETL processes or in the data warehouse.
Key Skills & Requirements:
- SQL Expertise:
- 5+ years of hands-on experience in SQL development, with a deep understanding of:
- Writing complex queries (e.g., joins, subqueries, aggregations)
- Optimizing queries for performance
- Handling large datasets
- Proficiency in writing stored procedures, functions, and triggers.
- Database Design & Table Management:
- Strong experience in creating and managing tables, views, and other database objects.
- Understanding of normalization, indexing, and best practices for structuring data in databases.
- Data Transformation & Integration:
- Experience with ETL (Extract, Transform, Load) processes and transforming data from source systems into target databases or data warehouses.
- Familiarity with handling structured and unstructured data.
- Database Optimization & Troubleshooting:
- Experience with query optimization and performance tuning in SQL to improve the efficiency of data retrieval and processing.
- Ability to troubleshoot and debug complex queries and data issues.
- Communication Skills:
- Strong written and verbal communication skills, with the ability to document database design, query logic, and troubleshooting steps.
- Experience with Relational Databases:
- Experience with relational databases like SQL Server, Oracle, MySQL, or similar technologies.
Preferred Skills:
- Experience with BI Tools: Familiarity with Business Intelligence (BI) tools for reporting, visualization, and data analysis.
- Familiarity with ETL Tools: Knowledge of ETL tools and frameworks for data integration.
- Version Control: Familiarity with version control systems like Git for managing codebase changes.
-
philadelphia, United States SP Software Solutions Full timeTitle: SQL Developer (Consultant)Duration: 12-16 month; Long term contract w/ potential to convertSeniority: Mid-Level; 2+ yearsLocation: Philadelphia, PAAbout Them: Our client is a leading healthcare company dedicated to improving patient outcomes through innovative data solutions. Their team is committed to leveraging technology to process and analyze...
-
philadelphia, United States SP Software Solutions Full timeTitle: SQL Developer (Consultant)Duration: 12-16 month; Long term contract w/ potential to convertSeniority: Mid-Level; 2+ yearsLocation: Philadelphia, PAAbout Them: Our client is a leading healthcare company dedicated to improving patient outcomes through innovative data solutions. Their team is committed to leveraging technology to process and analyze...
-
philadelphia, United States SP Software Solutions Full timePosition: Data Engineer / AnalystLocation: Philadelphia, PA (Hybrid – 2 Days Remote and 3 Days On-Site Per Week)Contract Length: Long-TermKey Responsibilities:Data Profiling & Quality: Perform data profiling to identify and address data quality issues prior to loading into the data warehouse, ensuring data integrity and accuracy.Functional Specifications &...
-
philadelphia, United States SP Software Solutions Full timePosition: Data Engineer / AnalystLocation: Philadelphia, PA (Hybrid – 2 Days Remote and 3 Days On-Site Per Week)Contract Length: Long-TermKey Responsibilities:Data Profiling & Quality: Perform data profiling to identify and address data quality issues prior to loading into the data warehouse, ensuring data integrity and accuracy.Functional Specifications &...
-
SQL Developer
7 days ago
Philadelphia, United States SP Software Solutions Full timeTitle: SQL Developer (Consultant)Duration: 12-16 month; Long term contract w/ potential to convertSeniority: Mid-Level; 2+ yearsLocation: Philadelphia, PAAbout Them: Our client is a leading healthcare company dedicated to improving patient outcomes through innovative data solutions. Their team is committed to leveraging technology to process and analyze...
-
SQL Developer
4 days ago
Philadelphia, United States SP Software Solutions Full timePosition: SQL Developer with Analysis Skills Location: Philadelphia, PA (Hybrid – 2 Days Remote, 3 Days On-Site)Contract Length: Long-TermKey Responsibilities:SQL Scripting & Query Writing: Design, develop, and optimize complex SQL scripts for data extraction, transformation, and reporting. This includes writing advanced queries with joins, subqueries,...
-
philadelphia, United States Philadelphia Gas Works Full timePhiladelphia Gas Works Looking for a challenge and ready to light up your career? Free Health Insurance Options– Free Dental Insurance – Flex Spending - Commuter Benefits - Pension Plan – Free Parking – Wellness Programs – Onsite Gyms – Tuition Assistance- PSLF Eligible Employer- Parental Leave - Hybrid Work EnvironmentPGW does not provide...
-
Oracle PL/SQL developer
1 month ago
Philadelphia, United States Ohm Systems, Inc Remote Work Freelance Full time $50 - $55Summary:The DHS PMT IT Application Development team seeks an Oracle PL/SQL developer to support mission-critical applications by developing back-end software, fixing legacy code defects, and interpreting business requirements. The role involves collaborating with team members to produce scalable code, testing, and providing production support.Position...
-
Senior Salesforce Developer
1 month ago
philadelphia, United States SP Software Solutions Full timeRole: Salesforce Architect / DeveloperLocation: Philadelphia, PA (Onsite/Hybrid)Duration: LongtermWe prefer local and w2 candidatesJob Overview: We are seeking a highly skilled Salesforce Architect with a strong background in Salesforce Marketing Cloud (SFMC) and Salesforce CRM to join our teamThe Salesforce Architect will be responsible for designing and...
-
Senior Salesforce Developer
1 month ago
Philadelphia, United States SP Software Solutions Full timeRole: Salesforce Architect / DeveloperLocation: Philadelphia, PA (Onsite/Hybrid)Duration: LongtermWe prefer local and w2 candidatesJob Overview: We are seeking a highly skilled Salesforce Architect with a strong background in Salesforce Marketing Cloud (SFMC) and Salesforce CRM to join our teamThe Salesforce Architect will be responsible for designing and...
-
Application Development
7 days ago
Philadelphia, United States Philadelphia Gas Works Full timePhiladelphia Gas Works Looking for a challenge and ready to light up your career? Free Health Insurance Options– Free Dental Insurance – Flex Spending - Commuter Benefits - Pension Plan – Free Parking – Wellness Programs – Onsite Gyms – Tuition Assistance- PSLF Eligible Employer- Parental Leave - Hybrid Work EnvironmentPGW does not provide...
-
Java Developer
1 month ago
philadelphia, United States V-Soft Consulting Group, Inc. Full timeTitle: Java Developer (Hybrid) (Only W2)Location: Philadelphia, PA or West Chester, PA onsite 3 days a week. Contract; expected to run through 12/2025 and could extend further Interview Process: 2 rounds, 1st being a Teams call then 2nd round coding challenge/screen share Responsibilities:∙ Manage the complete software development process from...
-
Java Developer
1 month ago
philadelphia, United States V-Soft Consulting Group, Inc. Full timeTitle: Java Developer (Hybrid) (Only W2)Location: Philadelphia, PA or West Chester, PA onsite 3 days a week. Contract; expected to run through 12/2025 and could extend further Interview Process: 2 rounds, 1st being a Teams call then 2nd round coding challenge/screen share Responsibilities:∙ Manage the complete software development process from...
-
Java Developer
1 month ago
Philadelphia, United States V-Soft Consulting Group, Inc. Full timeTitle: Java Developer (Hybrid) (Only W2)Location: Philadelphia, PA or West Chester, PA onsite 3 days a week. Contract; expected to run through 12/2025 and could extend further Interview Process: 2 rounds, 1st being a Teams call then 2nd round coding challenge/screen share Responsibilities:∙ Manage the complete software development process from...
-
Senior Data Engineer
7 days ago
Philadelphia, United States SP Software Solutions Full timePosition: Data Engineer / AnalystLocation: Philadelphia, PA (Hybrid – 2 Days Remote and 3 Days On-Site Per Week)Contract Length: Long-TermKey Responsibilities:Data Profiling & Quality: Perform data profiling to identify and address data quality issues prior to loading into the data warehouse, ensuring data integrity and accuracy.Functional Specifications &...
-
philadelphia, United States Dale WorkForce Solutions Full timePrincipal Security ArchitectMUST BE LOCAL TO GREATER PHILADELPHIAJob SummaryThis global technology team invites candidates to join a company dedicated to developing innovative technology solutions and enhancing user experiences across media, technology, and customer engagement platforms. In this award-winning team, employees turn big ideas into pioneering...
-
Big Data Developer
3 weeks ago
philadelphia, United States Ket Software Full timeJob Title: Big Data EngineerLocation: Philadelphia, PAQualifications:Proficiency in Python programming Strong expertise in SQL, Presto, HIVE, and SparkExperience in big data technologies such as Spark and developing distributed computing applications using PySparkExperience with libraries for data manipulation and analysis, such as Pandas, Polars and...
-
Big Data Developer
3 weeks ago
Philadelphia, United States Ket Software Full timeJob Title: Big Data EngineerLocation: Philadelphia, PAQualifications:Proficiency in Python programming Strong expertise in SQL, Presto, HIVE, and SparkExperience in big data technologies such as Spark and developing distributed computing applications using PySparkExperience with libraries for data manipulation and analysis, such as Pandas, Polars and...
-
philadelphia, United States Source One Technical Solutions Full timeSource One is a consulting services company and we’re currently looking for the following individuals to work as right-to-hire consultants to our direct client in the Philadelphia area.** We are unable to work C2C for these roles.Title: 2 Senior Java eCommerce Developers & 1 Team Lead Developer (Contract to Perm)Developer Pay Rate: $75/hr / Lead Pay Rate:...
-
Senior Sql Database Administrator
1 month ago
philadelphia, United States A2C Full timeW2 Only - no Third parties Exciting opportunity for a Senior SQL Server Developer/DBA with out direct client in Philadelphia, PA. In this role you will work 3 days/week in Philadelphia, PA. Specific Duties:Advanced Database Development experience with Microsoft SQL Server Database.Experience with Senior level Database Administration support. (e.g.,...