You are viewing a preview of this job. Log in or register to view more details about this job.

Senior Database Analyst

UPS is seeking an experienced Sr. Database Analyst to support Software Developers, Database Architects, Data Analysts and Data Scientists across multiple projects. He/She supports multiple data integration initiatives and ensures data processes are developed and maintained under a consistent architecture. The Sr. Database Analyst is responsible for the design, development, and optimization of overall data pipeline architecture, while working with cross-functional teams. If you are looking for an exciting technology career, we want to hear from you!
Responsibilities and Duties
  • Creates and maintains optimal data pipeline architecture and ETL processes
  • Assembles, cleans, and transforms large complex datasets that meets business requirements
  • Identifies, designs, and implements internal data process improvements via the automation of manual processes, optimizing process performance, and optimizing data delivery in a continuous and iterative manner
  • Builds overall infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources utilizing multiple formats
  • Builds analytical tools that utilize the data pipeline in order to provide actionable insights into key areas such as customer acquisition and operational efficiency
  • Collaborates closely with Business Users, Subject Matter Experts, and IT on data sources, data formats, and business rules needed to support Trans. Analytics & OR initiatives and projects
  • Creates innovative data tools for Data Science and Analytics team members in an effort to assist with building and optimizing solutions
  • Collaborates closely with data analytics experts in order to derive maximum value from our data
Knowledge and Skills
  • Adaptable to shifting priorities in an agile development environment
  • Ability to collaborate with peers on technical matters to determine optimal solutions, including close engagement with business users on business rules and issues with the end goal of developing a production quality implementation
  • Ability to work with project teams to establish creation and automation of data QA procedures for optimization and ETL processes
  • Exhibits passion for problem-solving and persistence to continually pursue a problem until a resolution is reached
  • Expert knowledge with relational database design, data normalization, and best practices
  • Expert knowledge with developing applications and performing descriptive data analysis using Microsoft SQL Server
  • Strong T-SQL development skills involving the writing of moderate to complex stored procedures, user-defined functions, triggers, views, and common table expressions (CTE’s) (expertise with PL/SQL will be considered in lieu of less than expert knowledge with T-SQL)
  • Expert knowledge with SSIS (experience with other ETL tools such as Informatica will be considered in lieu of less than expert knowledge with SSIS)
  • Expert ability to optimize ETL processes for timely completion and minimization of server resources
  • Expert ability to implement the logging of tasks inside an ETL process for the purpose of progress monitoring and QA
  • Ability to create detailed documentation regarding data elements, database schema, and ETL processes
  • Experience using an object-oriented programming language (e.g., C#, Java, or C++)
  • Experience with NoSQL databases (e.g., Couchbase) - Preferred
  • Experience with SSRS (SQL Server Reporting Services) - Preferred
  • Experience with Microsoft SQL Server OLAP services - Preferred
  • Bachelor’s Degree in Computer Science, Computer Engineering, MIS, or related field - Preferred
  • Must be a U.S. Citizen or National of the U.S., an alien lawfully admitted for permanent residence, or an alien authorized to work in the U.S. for this employer
  • Employer will not sponsor a visa for this or future positions
  • Must be currently located in the same geographic location as the job or willing to relocate yourself
  • Must have a Bachelor’s Degree (or internationally comparable degree) or be a current UPS employee with three years of UPS experience
  • Must have experience using an object-oriented programming language (e.g., C#, Java, or C++)
  • Must have experience writing complex queries using SQL
  • Must have experience using Microsoft SQL Server
Employer will not sponsor visas for position.
UPS is an equal opportunity employer. UPS does not discriminate on the basis of race/color/religion/sex/national origin/veteran/disability/age/sexual orientation/gender identity or any other characteristic protected by law.