15 days old
2018-06-072018-08-06

Database Developer Analyst - UPS

Alpharetta, Georgia

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

Requirements

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
  • 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 developing applications using Python
  • Experience using an object-oriented programming language (e.g., C#, Java, or C++)
  • Experience using Apache Spark
  • Minimum of 5 years’ experience in a Data Engineer role - Preferred
  • Experience with data pipeline and workflow management tools (e.g., Azkaban, Luigi, or Airflow) - Preferred
  • Experience using other Big Data tools such as Hadoop and Kafka - Preferred
  • 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

     

UPS is an equal opportunity employer – race/color/religion/sex/national origin/veteran/disability/sexual orientation/gender identity.

Categories

Featured Jobs

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Database Developer Analyst - UPS

UPS
Alpharetta, Georgia

Share this job

Database Developer Analyst - UPS

UPS
Alpharetta, Georgia

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast