ETL Developer
Company: University of Minnesota
Location: Minneapolis
Posted on: January 27, 2023
|
|
|
Job Description:
Apply for JobJob ID352183
LocationTwin Cities
Job FamilyInformation Technology
Full/Part TimeFull-Time
Regular/TemporaryRegular
Job Code9703DE
Employee ClassAcad Prof and Admin
Add to Favorite JobsEmail this JobAbout the Job
Compensation: $105,000 - $125,000 (depending on experience)About
The Job
The Office of Information Technology (OIT) at the University of
Minnesota seeks an experienced Extract, Transform and Load (ETL)
Developer. This position will serve as the ETL lead and BI
Operations lead, supporting and growing our Enterprise Data
Warehouse (EDW) and data integration environment.
Ideal candidates for this position will demonstrate a
solutions-focused, positive approach to problem-solving with the
ability to work well both collaboratively and independently, and
with the ability to effectively manage expectations and competing
priorities. Ideal candidates will have excellent technical,
interpersonal, and communication skills, as well as a passion for
the University's mission of education, research, and outreach.
We Offer:
University paid contribution (10% of your salary) to your
retirement account - vested immediately
22 paid vacation days per year, in addition to sick leave and 11
paid holidays
Reduced tuition opportunities covering 75% - 100% of eligible
tuition
Excellent and affordable health care benefits
Wellness program with opportunity to earn lower health care
rates
Free disability insurance
Annual merit increase program
Job Responsibilities:
Data warehouse development and support (60%)
Serve as the main point of contact for ETL development and support
to ensure a stable and robust enterprise ETL environment.
Set up and execute extract, transformation and load (ETL)
functions.
Develop and optimize SQL statements, stored procedures, and views
using industry best practices for security and efficiency.
Conduct performance optimization, including query tuning, process
structuring/scheduling, schema adjustments, code refinements, and
scaling analysis.
Monitor systems to ensure data warehouse is running at peak
performance; remediate failures of automated jobs quickly.
Develop and manage methods to create, store, and maintain metadata
for usage tracking, interoperability, and comprehensive management
of business semantics.
Provide guidance to less experienced ETL developers on development
best practices.
Participate in ETL code reviews and efficiency enhancements.
Requirements analysis and documentation (20%)
Meet with clients to elicit and understand requirements, translate
business processes and definitions into data terms, and facilitate
shared understanding of data definitions among multiple
stakeholders.
Develop and maintain technical design, metadata, and business
definition documentation.
Research and Propose operational improvements using workflows and
technical improvements.
Project coordination and other duties as assigned (20%)
Act as the ETL lead in the triage, assignment, and resolution of
operational ETL issues.
Research, understand, and apply appropriate governance and
compliance requirements (e.g., FERPA) and digital accessibility
best practices.
Develop and manage work estimates, expectations, and project plans
including priorities, deliverables, timelines, and coordination of
efforts including scheduling and facilitation of meetings.
Required Qualifications:
Bachelor's degree and four years of relevant experience or a
comparable combination of education, training, and experience.
Experience with data warehousing and manipulation/ETL (extract,
transformation and load) using ETL tools such as SSIS or IBM Data
Stage.
Background in working with enterprise wide Oracle data
structures.
Previous experience providing operational support for an EDW
environment.
Experience developing PL/SQL and/or T-SQL DDL and DML and
performance tuning.
Familiarity with ETL version control.
Preferred Qualifications:
Experience with Informatica, Oracle Analytic Server, Oracle Cloud
Server, Tableau
Understanding of data governance
Experience working in an Agile development environment
Understanding of business analysis and/or project management
methodologies
Experience with programming languages (e.g., Python,, Shell
scripting). Knowledge of API's and web services
Benefits
Working at the UniversityAt the University of Minnesota, you'll
find a flexible work environment and supportive colleagues who are
interested in lifelong learning. We prioritize work-life balance,
allowing you to invest in the future of your career and in your
life outside of work.The University also offers a comprehensive
benefits package that includes:
How To Apply
Applications must be submitted online. To be considered for this
position, please click the Apply button and follow the
instructions. You will be given the opportunity to complete an
online application for the position and attach a cover letter and
resume.Additional documents may be attached after application by
accessing your "My Job Applications" page and uploading documents
in the "My Cover Letters and Attachments" section.To request an
accommodation during the application process, please e-mail
employ@umn.edu or call (612) 624-UOHR (8647).
Diversity
The University recognizes and values the importance of diversity
and inclusion in enriching the employment experience of its
employees and in supporting the academic mission. The University is
committed to attracting and retaining employees with varying
identities and backgrounds.The University of Minnesota provides
equal access to and opportunity in its programs, facilities, and
employment without regard to race, color, creed, religion, national
origin, gender, age, marital status, disability, public assistance
status, veteran status, sexual orientation, gender identity, or
gender expression. To learn more about diversity at the U:
http://diversity.umn.edu.
Employment Requirements
Any offer of employment is contingent upon the successful
completion of a background check. Our presumption is that
prospective employees are eligible to work here. Criminal
convictions do not automatically disqualify finalists from
employment.
Please note: All employees at the University of Minnesota are
required to comply with the University's Administrative Policy:
COVID-19 Vaccination and Safety Protocol by either providing proof
of being fully vaccinated on their first day of employment, or
complete a request for an exemption for medical exemption or
religious reasons. To learn more please visit:
https://safe-campus.umn.edu/return-campus/get-the-vax
About the U of M
The University of Minnesota, Twin Cities (UMTC)The University of
Minnesota, Twin Cities (UMTC), is among the largest public research
universities in the country, offering undergraduate, graduate, and
professional students a multitude of opportunities for study and
research. Located at the heart of one of the nation's most vibrant,
diverse metropolitan communities, students on the campuses in
Minneapolis and St. Paul benefit from extensive partnerships with
world-renowned health centers, international corporations,
government agencies, and arts, nonprofit, and public service
organizations.
Keywords: University of Minnesota, Minneapolis , ETL Developer, IT / Software / Systems , Minneapolis, Minnesota
|
Click
here to apply!
|
