MinneapolisRecruiter Since 2001
the smart solution for Minneapolis jobs

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:

  • Competitive wages, paid holidays, and generous time off
  • Continuous learning opportunities through professional training and degree-seeking programs supported by the Regents Scholarship
  • Low-cost medical, dental, and pharmacy plans
  • Healthcare and dependent care flexible spending accounts
  • University HSA contributions
  • Disability and employer-paid life insurance
  • Employee wellbeing program
  • Excellent retirement plans with employer contribution
  • Public Service Loan Forgiveness (PSLF) opportunity
  • Financial counseling services
  • Employee Assistance Program with eight sessions of counseling at no costPlease visit the Office of Human Resources website for more information regarding benefits.

    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!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Minnesota jobs by following @recnetMN on Twitter!

Minneapolis RSS job feeds