Engineer II, Software Development
S&P Global2 days ago
Raleigh, NC, USAMid Level
H1B sponsor
Base Salary
$89k - $116k/yr
Responsibilities
- Design, develop, enhance, and optimize SQL Server database objects, stored procedures, tables, constraints, scheduled jobs, and data-processing workflows.
- Build, deploy, monitor, and troubleshoot ETL and cloud data pipelines across on-premises databases, AWS services, and Snowflake.
- Investigate production failures, data-feed issues, performance problems, and business data inquiries; perform root-cause analysis and implement short- and long-term fixes.
- Prepare and execute database and cloud workflow releases, validate post-release outcomes, and provide incident and production support.
- Perform peer code reviews, document processes, create and track work items, and participate in Agile/Scrum ceremonies.
- Apply security best practices including role-based access control, encryption, secrets management, and network security configurations.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, or a related IT field.
- At least two years of experience in software development or a related occupation.
- Two years of experience with SQL/T-SQL and Microsoft SQL Server for enterprise data-processing workloads.
- Experience developing and troubleshooting ETL/data pipelines, automating jobs, and performing root-cause analysis.
- Experience with AWS Lambda, Step Functions, ECS, Glue, S3, CloudWatch, SNS, and operational monitoring.
- Experience developing and migrating Snowflake workloads from on-premises databases to cloud platforms.
- Experience with code reviews, production releases, incident support, Agile/Scrum methodologies, and work-tracking tools such as Azure DevOps.
Benefits
- Hybrid work schedule with telecommuting permitted within normal commuting distance of the Raleigh, NC office.
- Health care coverage and wellness support.
- Generous paid time off and flexible downtime.
- Continuous learning and career-development resources.
- Retirement planning, continuing education support, company-matched student loan contributions, and financial wellness programs.
- Family-friendly benefits, retail discounts, and referral incentive awards.
- Eligibility for an annual incentive plan and additional S&P Global benefits.