Engineer II, Software Development
S&P Global2 days ago
Raleigh, NC, USAMid Level
H1B sponsor
Base Salary
$89k - $116k/yr
Responsibilities
- Design, develop, and enhance SQL Server database and backend components, including stored procedures, tables, constraints, and scheduled jobs.
- Build, maintain, and troubleshoot ETL workflows and high-volume data-processing pipelines across on-premises databases, cloud data warehouses, and applications.
- Develop and deploy AWS serverless and container-based data pipeline components and configure operational monitoring and alerting.
- Migrate database objects and processing logic to cloud data services, including Snowflake.
- Investigate production failures, data-feed issues, performance problems, and business data inquiries; perform root-cause analysis and implement corrective actions.
- Manage cloud storage for file ingestion and create end-to-end pipelines that transfer and process data between on-premises and cloud platforms.
- Perform code reviews, production deployments, post-release validation, incident support, bug fixes, and application troubleshooting.
- Implement security best practices including role-based access control, encryption, secrets management, and network security configurations.
- Participate in Agile/Scrum ceremonies, create and track work items, communicate status, and document processes for developers and stakeholders.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, or a related IT field.
- 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, and SNS for data pipelines and operational monitoring.
- Snowflake development and migration experience, including moving workloads from on-premises databases to cloud platforms.
- Experience with code review, production releases, and incident support for database and cloud workflows.
- Experience with 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 benefits.
- Generous paid time off and flexible downtime.
- Continuous learning and professional development resources.
- Retirement planning, continuing education, 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.