Senior Database Analyst
Company: UPS
Location: Alpharetta
Posted on: March 16, 2023
Job Description:
Senior Database AnalystWe'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 DESCRIPTIONUPS 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
Keywords: UPS, Alpharetta , Senior Database Analyst, IT / Software / Systems , Alpharetta, Georgia
Didn't find what you're looking for? Search again!
Loading more jobs...