Lead Data Engineer - UPS DIGITAL

Before you apply to a job, select your language preference from the options available at the top right of this page.

Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion. If you have the qualities and drive to lead yourself or teams, there are roles ready to cultivate your skills and take you to the next level.

Job Description:

We are seeking an experienced Lead Database Developer to architect, develop, optimize, and maintain database solutions across our Azure cloud data platform. The ideal candidate will have deep expertise in Azure SQL Managed Instance, SQL Hyperscale (preferred), and possess strong experience with SSIS, SSRS, SQL Agent, ADF, and SQL performance tuning. This role requires hands-on technical leadership, strong communication skills, and the ability to guide and mentor development teams within an Agile environment.

Key Responsibilities

Database Design & Development

• Design, develop, and maintain robust database schemas, tables, views, stored procedures, and functions.
• Architect scalable and performant solutions using Azure SQL Managed Instance; exposure to Azure SQL Hyperscale is a strong plus.
• Implement ETL pipelines using SSIS and integrate on-prem/cloud data workloads.
• Develop and maintain reports and dashboards using SSRS.

Data Integration & Cloud Services

• Design and orchestrate data workflows using Azure Data Factory (ADF) including pipelines, triggers, and dataflows.
• Manage SQL Agent jobs, automation routines, and operational schedules.
• Collaborate with cloud engineers to ensure optimal performance, security, and reliability in Azure.

Performance Optimization

• Conduct query tuning, indexing, and performance troubleshooting across high-volume transactional and analytical workloads.
• Analyze execution plans and solve performance bottlenecks.
• Implement best practices for monitoring, alerting, and optimization.

Team Leadership

• Lead a team of database developers and/or data engineers, providing technical guidance and code reviews.
• Mentor team members on best practices in SQL development, Azure data services, and optimized data design.
• Collaborate with cross-functional teams (application developers, QA, product owners) in an agile/scrum environment.

Governance & Best Practices

• Ensure database solutions adhere to enterprise standards for security, reliability, documentation, and compliance.
• Drive continuous improvement in database development processes and frameworks.
• Participate in sprint planning, backlog refinement, and technical design discussions.

Required Qualifications

• 14+ years of experience in SQL Server development and database engineering.
• Strong expertise with Azure SQL Managed Instance; exposure to SQL Hyperscale preferred.
• Hands-on experience with:
  • SSIS (ETL development)
  • SSRS (reporting)
  • SQL Agent (job scheduling & automation)
  • ADF (pipeline development)
• Advanced SQL skills including performance tuning, query optimization, indexing, and execution plan analysis.
• Solid experience in database design, normalization, table architecture, and data modeling.
• Proven experience leading development teams or acting as technical lead.
• Experience working within an Agile/Scrum delivery model.

Preferred Skills

• Experience with CI/CD for database deployments (Azure DevOps or similar).
• Knowledge of Azure cloud components such as Key Vault, Azure Storage, and monitoring tools.
• Familiarity with Power BI or other visualization tools.
• Strong communication, analytical, and problem‑solving skills.

Employee Type:
 

Permanent

UPS is committed to providing a workplace free of discrimination, harassment, and retaliation.