Senior Data Engineer

BCBS Global Solutions; King of Prussia (PA); On-site; USD 110,000 - 160,000; Full time

Job summary

BCBS Global Solutions is seeking a Senior Database Developer to design, develop, and maintain enterprise Oracle and SQL Server databases. You will implement ETL with SSIS, design data warehouses, and lead data initiatives within SDLC frameworks.

The role requires expert PL/SQL and T-SQL skills, experience with data integration, and mentoring of junior developers. Collaboration across teams and adherence to security and performance standards are essential.

Qualifications

• Minimum 6 years of hands-on database development and data integration experience.
• Expert Oracle Database development with PL/SQL, performance tuning and optimization.
• Expert Microsoft SQL Server development with T-SQL, SSIS, and related tooling.
• Strong ETL, data integration, and data warehouse design knowledge.
• Experience implementing AI-enabled data solutions and iPaaS integrations.
• Proficiency with SDLC best practices, version control, testing, and deployment.

Responsibilities

• Design, develop, configure, and maintain Oracle database objects using PL/SQL.
• Develop and maintain SQL Server solutions with T-SQL, procedures, views, and functions.
• Develop, enhance, and support ETL and data integration via SSIS.
• Design data warehouses with relational and dimensional models for analytics.
• Perform data analysis, validation, and reconciliation across systems.
• Troubleshoot complex database and performance issues in various environments.
• Participate in full SDLC with Agile and Waterfall practices.
• Implement AI-enabled data solutions and iPaaS-based integrations.
• Ensure security, compliance, performance, and scalability of data solutions.
• Provide mentoring and technical guidance to junior developers.

Skills

Database design

Data integration

SDLC proficiency

Agile

Waterfall

Mentoring

Cross-functional collaboration

Analytical thinking

Effective communication

Independent work

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle

PL/SQL

SQL Server

T-SQL

SSIS

SSRS

Power BI

PowerShell

Linux/Unix scripting

Batch job scheduling tools

Visual Studio

Job description

The Senior Database Developer will be responsible for designing, developing, configuring, and maintaining enterprise database solutions across Oracle and Microsoft SQL Server platforms. This role requires deep hands-on expertise in Oracle PL/SQL, SQL Server T-SQL, and SSIS, along with strong experience in full Software Development Life Cycle (SDLC) methodologies, including Agile and Waterfall. The individual will also contribute to modern data initiatives, including AI-enabled solutions and iPaaS-based integrations, while adhering to SDLC and database development best practices. This position works collaboratively with cross-functional teams to deliver high-quality, scalable, and secure data solutions.

Responsibilities:

• Design, develop, configure, and maintain Oracle database objects including packages, procedures, functions, triggers, views, and data structures using PL/SQL and SQL.
• Design, develop, and maintain Microsoft SQL Server database solutions using T-SQL, including stored procedures, functions, views, and performance-optimized queries.
• Develop, enhance, and support ETL and data integration solutions using SQL Server Integration Services (SSIS) and related technologies.
• Design and implement database and data warehouse solutions, including relational and dimensional models, to support analytics and reporting needs.
• Perform data analysis, validation, and reconciliation to ensure data accuracy, completeness, and consistency across systems.
• Troubleshoot, debug, and resolve complex database, ETL, and performance issues in production and non-production environments.
• Participate in the full SDLC, following established best practices for requirements analysis, design, development, testing, deployment, and support.
• Apply Agile and Waterfall methodologies effectively, collaborating with project managers, product owners, business analysts, testers, and other developers.
• Implement and support AI-enabled data solutions and leverage iPaaS platforms for system integration, data orchestration, and automation.
• Ensure database solutions adhere to security, compliance, performance, and scalability standards.
• Observe and follow all IT policies, procedures, and service level agreements (SLAs).
• Provide technical guidance, code reviews, and mentoring to junior and mid-level developers.
• Support ongoing application maintenance, enhancements, and operational support activities in a fast-paced environment.
• Communicate effectively with both technical and non-technical stakeholders to translate business requirements into technical solutions.
• Perform other related duties as assigned.

Requirements:

• Minimum of 6 years of hands-on experience in database development and data integration.
• Bachelor’s degree in Computer Science, Information Technology, or a related field preferred, or equivalent practical experience.
• Expert-level experience with Oracle Database development, including PL/SQL, SQL, DML/DDL scripting, performance tuning, and optimization.
• Expert-level experience with Microsoft SQL Server, including T-SQL, SSIS, and Visual Studio-based database development.
• Strong experience with ETL processes, data integration, and data pipeline development.
• Strong knowledge of database and data warehouse design, including relational, dimensional, and star/snowflake schema modeling.
• Experience implementing and supporting AI-enabled solutions within data platforms (e.g., AI-driven analytics, automation, or data processing use cases).
• Experience working with iPaaS solutions for application and data integration.
• Proficiency with database development tools and IDEs for Oracle and SQL Server.
• Strong knowledge of SDLC best practices, including coding standards, documentation, version control, testing, and deployment processes.
• Hands-on experience with Agile and Waterfall development methodologies.
• Experience participating in or coordinating development activities within project teams.
• Strong analytical skills with the ability to understand complex business requirements and translate them into robust technical solutions.
• Excellent written and verbal communication skills, with the ability to collaborate effectively across technical and business teams.
• Ability to work independently, manage multiple priorities, and adapt quickly in a high-demand environment.
• Demonstrated attention to detail, thoroughness, and commitment to quality.
• Willingness to provide mentoring and technical leadership within the team.
• Experience with reporting tools such as SSRS or Power BI is a plus.
• Experience with PowerShell, Linux/Unix scripting, or batch job scheduling tools is a plus.
• Overtime and schedule flexibility is occasionally necessary in this position. The individual may be required to perform certain business-critical job functions outside of normal working hours.