Senior Database Analyst

Senior Database Analyst

We’re the obstacle overcomers, the problem get-arounders. From figuring it out to getting it done… our innovative culture demands “yes and how!” We are UPS. We are the United Problem Solvers.

JOB DESCRIPTION

UPS is seeking an experienced Sr. Database Analyst to support Software Developers, Database Architects, and Data Analysts across multiple projects involving cross-functional teams. The Sr. Database Analyst will support multiple data integration initiatives and is responsible for the design, development, deployment, and maintenance of databases and ETL processes. If you are looking for an exciting technology career, we want to hear from you!

Responsibilities and Duties

• Creates and maintains 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, and optimizing process performance
• Builds overall infrastructure required for the optimal extraction, transformation, and loading of data from a variety of data sources
• 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 database solutions for team members to assist with the building and running of network optimization programs
• Collaborates closely with subject matter experts 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 solution.
• Exhibits a passion for problem-solving and has the persistence to pursue a problem until a solution is found.
• Expert knowledge with relational database design, data normalization concepts, and best practices for data integrity and minimization of data redundancy.
• Expert knowledge with developing automated ETL processes. This involves the construction of automated workflows to acquire source data, the transforming of source data according to business rules, and the persistence of the data to a specific destination and format.
• Ability to work with project teams to establish the creation and automation of data QA procedures for network optimization programs and ETL processes.
• Ability to create detailed documentation regarding data elements, database schema, and ETL processes.
• Strong T-SQL development skills involving the writing of moderate to complex stored procedures, user-defined functions, 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 in an ETL process for the purposes of progress monitoring and QA.
• Experience developing solutions with scripting languages such as PowerShell or Python is highly desirable.
• Experience with using an object-oriented programming language (For example, C#, Java, or C ) – Preferred.
• Minimum of 5 years’ experience in a database development role utilizing Microsoft SQL Server – preferred. Experience with other commercial and open-source relational database products will be considered (For example: Oracle, DB2, Postgres, or MySQL).
• 1 - 5 years of experience with SSRS (SQL Server Reporting Services) – Preferred.
• 1 - 5 years of experience with SSAS (SQL Server Analysis Services) – Preferred.
• 1 - 2 years of experience with developing dashboards using Microsoft Power BI Desktop – Preferred.

QUALIFICATIONS

• Bachelor's Degree or International equivalent
• Bachelor's Degree or International equivalent in Computer Science or related discipline - Preferred
• Master's Degree or International equivalent in Computer Science or related discipline - Preferred
• Experience participating in production support calls - Preferred

This position offers an exceptional opportunity to work for a Fortune 50 industry leader. If you are selected, you will join our dynamic technology team in making a difference to our business and customers. Do you think you have what it takes? Prove it! At UPS, ambition knows no time zone.

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