Data Engineer
- Employer
- University of North Carolina at Greensboro
- Location
- Greensboro, NC
View more
- Employment Type
- Full Time
- Institution Type
- Four-Year Institution
Job Details
002944
Functional Title:Data Engineer
Position Type:Staff
Position Eclass:EP - EHRA 12 mo leave earning
University Information:UNC Greensboro, located in the Piedmont Triad region of North Carolina, is 1 of only 57 doctoral institutions recognized by the Carnegie Foundation for both higher research activity and community engagement. Founded in 1891 and one of the original three UNC System institutions, UNC Greensboro is one of the most diverse universities in the state with 20,000+ students, and 3,000+ faculty and staff members representing 90+ nationalities. With 17 Division I athletic teams, 85 undergraduate degrees in over 125 areas of study, as well as 74 master’s and 32 doctoral programs, UNC Greensboro is consistently recognized nationally among the top universities for academic excellence and value, with noted strengths in health and wellness, visual and performing arts, nursing, education, and more. For additional information, please visit uncg.edu and follow UNCG on Facebook, Twitter, and Instagram.
Primary Purpose of the Organizational Unit:The Enterprise Data Architecture team delivers enterprise datastores, data integrations, and business intelligence platforms to enhance UNCG’s ability to unlock the value of its institutional data assets.
Position Summary:The Data Engineer has broad responsibility for the design, development, and maintenance of data warehouse and data lake solutions in an increasingly cloud-based infrastructure. These solutions transform data from on-premises and cloud-based sources across institutional domains into data structures optimized for reporting and analytics.
Minimum Qualifications:•Bachelor’s degree in a related discipline with 2 or more years experience or equivalent education and experience in a data engineering or data warehouse development role required.
•Proven experience with ETL/ELT design and development.
•Proven experience working with data warehouses, including dimensional modeling.
•Excellent communication and requirements gathering skills.
•Cloud data platform architecture and development skills. Strong preference for Azure experience (Data Factory, Data Lake Storage Gen2, Synapse Analytics, Databricks).
•Proven experience securing data lakes/warehouses in hybrid architectures – both data and platform.
•DBA and/or cloud infrastructure experience.
•Data lake design skills (zones, partitioning, etc.).
•RDBMS development and performance tuning skills, with both Oracle (PL/SQL) and SQL Server (T-SQL).
•Experience with cataloging data, metadata, and data lineage.
Salary commensurate with experience
Org #-Department:Info Technology Services - 23101
Job Open Date:04/16/2021
For Best Consideration Date:04/19/2021
Open Until Filled:Yes
FTE:1.000
Type of Appointment:Permanent
Number of Months per Year:12
FLSA:Exempt
Percentage Of Time:40
Key Responsibility:Design and development of data warehouse and data lake solutions.
Essential Tasks:-Design and develop data warehouse and data lake solutions using cloud-based and on-premises platforms.
-Use GUI-based tools and write code to develop ETL/ELT pipelines that integrate data from cloud-based sources and on-premises sources.
-Use dimensional modeling and other modeling techniques to translate business requirements into data models.
-Employ data lake organization techniques to facilitate self-service data exploration and staging for warehouse.
-Identify new data sources for incorporation into data lake and data warehouse solutions.
-Research emerging cloud technologies and architectures for incorporation into data warehouse and data lake solutions.
-Serve a lead role in ITS and University initiatives that require expertise, coordination, and technical knowledge for data warehousing and data lake solutions.
-Develop standard operating procedures for data warehouse and data lake solutions.
20
Key Responsibility:Maintain and support data warehouse and data lake solutions
Essential Tasks:-Monitor, troubleshoot, and performance tune processes and programs associated with data warehouse and data lake solutions.
-Provide support to clients that ensures high satisfaction with data solutions.
35
Key Responsibility:ERP (Ellucian Banner and ODS) reporting solutions strategy, design, and development; and ODS application administration
Essential Tasks:-Perform analysis and design work for reporting solutions and data integrations in Banner and ODS.
-Develop Banner and ODS reporting solutions and data integrations.
-Monitor, troubleshoot, performance tune all processes and programs associated with ERP reporting solutions (includes Oracle database objects, Oracle Data Integrator objects, and ODS associated Application Manager/UC4 objects).
-Deploy and test ODS patches and upgrades.
-Determine impacts of source system upgrades (Banner and Degree Works) and perform necessary tasks (e.g. modify programs, run processes).
5
Key Responsibility:Follow ITS Divisional policies, procedures, and job requirements – Compliance and Integrity, Customer Oriented
Essential Tasks:-Adhere to the attached Divisional defined requirements as they relate to your job responsibilities regarding SLA’s, Security, and Asset Management.
Physical Effort:Hand Movement-Repetitive Motions - F, Reading - f, Writing - f, Hearing - f, Talking - f, Sitting - f
Work Environment:Inside - c
Organization
UNCG at a Glance
Founded in 1891, The University of North Carolina at Greensboro is the largest and most diverse state university in the Piedmont Triad. Standing apart from other universities, the UNCG community is joined together by a shared value: We define excellence not only by the people we attract, but by the meaningful contributions they make.
With more than 19,400 students and 2,500 faculty and staff, UNCG is the largest state university in the Piedmont Triad and has an annual economic impact of more than $1 billion. The campus has grown to include 30 residence halls and 30 academic buildings on 210 acres.
UNCG takes pride in being a learner-centered public research university. The College of Arts & Sciences and seven professional schools offer 79 undergraduate majors, 65 master's programs and 30 doctoral programs.
The university holds two classifications from the Carnegie Foundation for the Advancement of Teaching, as a “research university with high research activity” and for “community engagement” in curriculum, outreach and partnerships. More than $35 million in grants and contracts for research and creative activity are awarded to faculty members annually. Among the most prominent of UNCG's research initiatives are the Gateway University Research Park and the Joint School of Nanoscience and Nanoengineering. Both are partnerships with North Carolina Agricultural and Technical State University.
Globalization of the curriculum has expanded opportunities for international education, through new programs such as the UNC Exchange Program and the Lloyd International Honors College. In addition, innovative signature programs such as Building Entrepreneurial Learning for Life (BELL), Communication Across the Curriculum, Undergraduate Research and Freshman Seminars enhance the student experience.
As a cultural leader, UNCG offers concerts, lectures, dance and theater performances, exhibitions at the internationally known Weatherspoon Art Museum and readings by nationally known authors. In athletics, Spartan teams compete in nine women's and nine men's sports in Division I of the National Collegiate Athletic Association. With ethnic minority students making up 26 percent of the student body, UNCG is the most diverse of the UNC system's historically white campuses.
Although much has changed, some things remain the same. The university motto — “Service” — continues to be a guiding principle put into practice through all aspects of university life.
UNCG Schools and College of Arts & Sciences
The University's Academic Affairs Division consists of seven academic schools, the College of Arts & Sciences, the Graduate School and the Lloyd International Honors College. The names below are the ones currently in use. In some cases, the names have changed since the academic units were founded. The schools and their dates of establishment are: Graduate School 1921-22;College of Arts & Sciences 1969, Lloyd International Honors College 2005, Joint School of Nanoscience & Nanoengineering 2007, Joseph M. Bryan School of Business & Economics 1969, School of Education 1921, School of Health and Human Sciences 2011, School of Music, Theatre and Dance 2010, and School of Nursing 1966.
Achievements & Accolades
UNCG is garnering national attention and awards for its challenging academic programs, supportive environment and engaged community. Take a look at some of our latest accomplishments and meaningful contributions on campus, in the community and around the globe. Curious about more accolades, achievements, our student body, faculty and staff excellence and other signs of our success? Find out more at UNCG Now: http://newsandfeatures.uncg.edu/.
Challenging Academic Programs
UNCG’s slate of online programs has earned a top 10 ranking for affordability from BestColleges.com.
Supportive Environment
Engaged Community
Careers at UNCG
UNCG is committed to the creation of an inclusive, collaborative and responsive university by attracting, retaining and developing a diverse community of talented individuals in support of the university's mission.
- Website
- https://spartantalent.uncg.edu/
- Telephone
- 336-334-5009
- Location
-
723 Kenilworth Street
Greensboro
NC
27402
US
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert