Manager, ETL/Database Development

API, Accessibility, Analytical skill, Attention to detail, Best practices, Budget, Business analysis, Business process, Collaboration, Communication skills, Data engineering, Data extraction, Data governance, Data integration, Data modeling, Data processing, Data structure, Data warehouse, Database, Database performance tuning, Decision-making, Documentation, ETL, Education, Estimating, Flat file, Git, Health care, IBM InfoSphere DataStage, IT, IT management, Implementation, Insurance, Integration, Leadership, Linux, Mapping, Meta-data management, Microsoft SSIS, Onboarding, PL/SQL, Pentaho, Performance tuning, Problem solving, Project management, Python, Query optimization, Recruitment, Requirements analysis, Research, Revision control, Ruby, SQL, Scheduling, Science, Scripting, Security, Semantics, Shell scripting, Software development, Stored procedures, Strategy, Systems architecture, Technical drafting, Test cases, Test plans, Training, Transact-SQL, Transformation, Web services, cron
Full Time
Depends on Experience
Work from home available

Job Description

***Please note, this position is not eligible for H-1B or Green Card sponsorship


Position Overview:

The Health Science Technology (HST) department at the University of Minnesota seeks a Database Development Manager to support data integration, data warehousing, and other database development efforts for schools and units within the University of Minnesota’s Health Sciences community and beyond, in support of various operational, decision making, strategic, and research initiatives. 

 

This position will be responsible for identifying and implementing best practices as it relates to data engineering across our data warehousing and data integrations portfolio. The position will manage the ETL/Database development team and oversee the design, building, implementation, and maintenance of data processing channels for data extraction, transformation, and loading in order to connect data sets from a variety of sources. The position will interface with new and existing clients, promote the team’s service offerings, and manage staffing resources and budgets. The position will conduct hands-on ETL, data warehousing, and data integration efforts for clients, while also providing technical leadership that will drive the evolution and maturity of the team.

Ideal candidates for this position will demonstrate an action-oriented, positive approach to complex problem-solving, the ability to make decisions and work well both independently and collaboratively, and with the ability to effectively manage expectations and competing priorities. Ideal candidates will have excellent analytical, technical, interpersonal, and communication skills, as well as a passion for the University’s mission of research, education, 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: 

  • ETL / Database Development Leadership (50%)
    • Manage the work and direction of the ETL/Database development team, set and communicate team vision and strategy, and foster a diverse, equitable, and inclusive work environment. 
    • Conduct or participate in the hiring, onboarding, training, direction, performance feedback process, and development of staff.
    • In collaboration with our Systems Architect, research and identify best practices and appropriate tools and resources to support our data warehousing and data integrations portfolio.  Lead the ETL / Database development staff in the implementation of best practices, tools, and resources.
    • Ensure practices comply with federal, state, local, and institutional mandates and standards as well as digital accessibility best practices.
    • Promote the team’s service offerings to clients, meet regularly with client leadership, and foster positive relationships throughout the organization.
    • Develop and manage work estimates, plan and monitor staff resource capacity, and manage project budgets.
    • Collaborate with the HST leadership team on department-wide initiatives and foster collaboration and the sharing of knowledge between HST teams.
  • ETL / Database Development (50%)
    • Data warehouse development and support
      • Create target data models and identify, develop, and document accurate source-to-target database mapping logic for the development of a data warehouse and for other efforts.
      • 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.
      • Set up and execute extract, transformation and load (ETL) functions using database connections, API calls, web services, flat files, etc. to pull data  into database schemas, and set-up CRON jobs to run scripts.
      • Develop and review standards and guidelines for the creation, maintenance and use of the data warehouse.
      • Create, document, and execute test plans/test cases/scripts to validate data models, metadata, and completeness and accuracy of data.
      • 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.
    • Requirements analysis and documentation
      • 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.
      • Assist in the research and selection of tools, products, and frameworks to support project-specific business initiatives.
      • Work with various stakeholders to identify correct data source(s) and analyze source data to understand and document data structure, definitions, accuracy, and anomalies.
      • Develop and maintain technical design, metadata, and business definition documentation.

 

*Please document qualifications on your resume.

Required Qualifications:

  • BA/BA plus six years of related experience to include data warehousing and manipulation/ETL (extract, transformation and load) -- or -- a master’s degree plus at least four years of related experience.
  • Experience developing PL/SQL and/or T-SQL, stored procedures, indexes, partitioning, and database tuning.
  • Experience working with ETL tools (e.g., Pentaho, SQL Server Integration Services, IBM Datastage).
  • Experience with programming languages (e.g., Python, PL/SQL, Ruby, Shell scripting).
  • Experience working with API’s and web services.
  • Familiarity with version control (e.g., Git).
  • Strong organizational and analytical skills and close attention to detail.

 

Preferred Qualifications:

  • Experience with Linux server administration
  • Understanding of data governance
  • Understanding of business analysis and/or project management methodologies

 

The University of Minnesota is an Equal Opportunity Educator and Employer.


Dice Id : RTL90967
Position Id : 345478
Originally Posted : 2 weeks ago
Have a Job? Post it

Similar Positions

Manager, Project Management Office (PMO)
  • University of Minnesota - OIT
  • Minneapolis, MN, USA
Data Analyst
  • University of Minnesota - OIT
  • Minneapolis, MN, USA
Data Analytics Architect
  • Randstad Technologies
  • Suamico, WI, USA
Business Intelligence Operations Manager
  • Request Technology, LLC
  • Lake Bluff, IL, USA
Senior Director, Core Data Integration
  • The Northwestern Mutual Life Insurance Company
  • Milwaukee, WI, USA
Data Engineer Sr
  • Volkswagen Group of America
  • Libertyville, IL, USA
ETL Developer
  • Apex Systems
  • Chicago, IL, USA
Database Administrator
  • AAOS
  • Rosemont, IL, USA