Engineer II, Software Development

S&P Global; United States; Hybrid; USD 89.000 - 116.000; Vollzeit

Benefits dieser Stelle

Annual incentive plan

Zusammenfassung

Markit North America, Inc. in Raleigh, NC seeks an Engineer II, Software Development to design and enhance database/back-end components and data feeds. The role involves building ETL workflows, optimizing SQL code, and migrating workloads to cloud data services, with a hybrid work model in Raleigh.

You will participate in Agile/Scrum ceremonies, perform peer code reviews, and deploy database/cloud workflows while ensuring security best practices and reliable data delivery.

Qualifikationen

• Bachelor's degree in Computer Science or related IT field.
• 2+ years in software development with SQL/T-SQL and SQL Server.
• Experience with ETL/data pipelines and production troubleshooting.
• Experience with AWS data services and cloud data migrations.

Aufgaben

• Design and optimize database and cloud workflows across data pipelines.
• Develop/maintain ETL jobs and data processing for high-volume feeds.
• Perform root-cause analysis and implement fixes for data issues.
• Coordinate deployments and validate post-release outcomes.
• Ensure RBAC, encryption and network security in cloud/data platforms.

Kenntnisse

SQL

ETL workflows

Agile/Scrum

Ausbildung

Bachelor's degree in Computer Science or related IT field

Tools

SQL Server

T-SQL

AWS Lambda

AWS Step Functions

AWS ECS

AWS Glue

S3

CloudWatch

SNS

Snowflake

Azure DevOps

Jobbeschreibung

About the Role

Grade Level (for internal use): 09 Company Name: Markit North America, Inc. Job Title: Engineer II, Software Development Location: 421 Fayetteville Street, Raleigh, NC 27601 (Hybrid work schedule. On days not in office, telecommuting permitted within normal commuting distance of Raleigh, NC office)

Job Duties

Markit North America, Inc. seeks an Engineer II, Software Development in Raleigh, NC to design, develop, and enhance database/back-end components supporting an internal technology platform and related data feeds by creating/modifying SQL stored procedures, tables, constraints, and scheduled jobs. Build/update ETL workflows. Test changes to ensure accurate and reliable data storage/retrieval and integration with the application front end. Optimize and troubleshoot data processing and performance by diagnosing slowness and failures in SQL code and automated workflows. Improve runtime of database jobs/packages. Implement corrective actions to maintain high-volume dataflows across multiple databases. Monitor and resolve production/support issues affecting content/data delivery by investigating daily processing failures and data-feed issues, performing root-cause analysis, implementing short- and long-term fixes across the UI and back-end layers, and responding to business/data inquiries requiring analysis of underlying database logic. Build and maintain cloud-based data pipelines on a content/data delivery platform by developing and deploying serverless and container-based components; configuring operational monitoring/alerting; managing cloud storage for file ingestion. Migrate database objects and processing logic to cloud data services. Create end-to-end pipelines that move data between on-premises databases and cloud data warehouses and return processed outputs. Perform peer code reviews to ensure quality, reliability, and adherence to standards. Prepare and execute production deployments/releases for database and cloud workflow changes. Validate post-release outcomes via monitoring and issue remediation as needed. Ensure compliance with security best practices, including role-based access control (RBAC), encryption, secrets management, and network security configurations. Participate in Agile/Scrum delivery by contributing to sprint planning, estimation, daily stand-ups, sprint reviews, and retrospectives. Create and track work items and tasks. Communicate status and results to stakeholders. Create thorough documentation on new and existing processes to ensure maintainability and clarity for other developers and stakeholders. Process ad-hoc requests from other developers. Support software stability and performance by diagnosing issues, implementing bug fixes, and performing effective troubleshooting across applications.

Job Requirements

Bachelor's degree in Computer Science, Information Systems, or a related IT field, plus two (2) years of experience in software development or a related occupation. Two (2) years of experience must include: SQL/T-SQL and Microsoft SQL Server experience for designing, optimizing, and supporting enterprise data-processing workloads; ETL/data pipeline development and production troubleshooting skills, including job automation and root-cause analysis; Experience with AWS data pipeline services (Lambda, Step Functions, ECS, Glue, S3, CloudWatch, SNS) and operational monitoring; Snowflake development and migration experience, including moving workloads from on-premises databases to cloud platforms; Experience in code review, production releases, and incident support for database/cloud workflows; Experience with Agile/Scrum methodologies and work-tracking tools such as Azure DevOps.

Salary and Benefits

The anticipated base salary range for this position is $89,398 to $115,850. Final base salary for this role will be based on the individual's geographic location, as well as experience level, skill set, training, licenses & certifications. In addition to base compensation, this role is eligible for an annual incentive plan. Markit North America, Inc. is part of S&P Global and this role is eligible to receive additional S&P Global benefits. For more information on the benefits we provide to our employees, please see: https://spgbenefits.com/benefit-summaries/us.

What's In It For You?

Our Mission

Advancing Essential Intelligence.

Our People

We're more than 35,000 strong worldwide-so we're able to understand nuances while having a broad perspective. Our team is driven by curiosity and a shared belief that Essential Intelligence can help build a more prosperous future for us all. From finding new ways to measure sustainability to analyzing energy transition across the supply chain to building workflow solutions that make it easy to tap into insight and apply it. We are changing the way people see things and empowering them to make an impact on the world we live in. We're committed to a more equitable future and to helping our customers find new, sustainable ways of doing bus