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
BASIC QUALIFICATIONS:
- 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
OTHER CRITERIA:
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.