View job on Handshake
Employer: United Parcel Service (UPS)
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 DutiesCreates and maintains optimal data pipeline architecture and ETL processesAssembles, cleans, and transforms large complex datasets that meets business requirementsIdentifies, 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 mannerBuilds overall infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources utilizing multiple formatsBuilds analytical tools that utilize the data pipeline in order to provide actionable insights into key areas such as customer acquisition and operational efficiencyCollaborates 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 projectsCreates innovative data tools for Data Science and Analytics team members in an effort to assist with building and optimizing solutionsCollaborates closely with data analytics experts in order to derive maximum value from our dataKnowledge and SkillsAdaptable to shifting priorities in an agile development environmentAbility 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 implementationAbility to work with project teams to establish creation and automation of data QA procedures for optimization and ETL processesExhibits passion for problem-solving and persistence to continually pursue a problem until a resolution is reachedExpert knowledge with relational database design, data normalization, and best practicesExpert knowledge with developing applications and performing descriptive data analysis using Microsoft SQL ServerStrong 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 resourcesExpert ability to implement the logging of tasks inside an ETL process for the purpose of progress monitoring and QAAbility to create detailed documentation regarding data elements, database schema, and ETL processesExperience using an object-oriented programming language (e.g., C#, Java, or C++)Experience with NoSQL databases (e.g., Couchbase) – PreferredExperience with SSRS (SQL Server Reporting Services) – PreferredExperience with Microsoft SQL Server OLAP services – PreferredBachelor’s Degree in Computer Science, Computer Engineering, MIS, or related field – PreferredBASIC 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 employerEmployer will not sponsor a visa for this or future positionsMust be currently located in the same geographic location as the job or willing to relocate yourselfMust have a Bachelor’s Degree (or internationally comparable degree) or be a current UPS employee with three years of UPS experienceMust have experience using an object-oriented programming language (e.g., C#, Java, or C++)Must have experience writing complex queries using SQLMust have experience using Microsoft SQL ServerOTHER 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.