Sr. Data Architect
- Employer
- University of North Carolina at Chapel Hill
- Location
- Chapel Hill, NC
View more
- Administrative Jobs
- Academic Affairs, International Programs, Technology, Analysts & Programming
- Employment Type
- Full Time
- Institution Type
- Four-Year Institution
Job Details
UNC’s Kenan-Flagler Business School is a nationally ranked professional business school. Kenan-Flagler offers a range of professional and academic degree programs, including BSBA, full-time MBA, Executive MBA, MBA@UNC, Master of Accounting, and PhD. Beyond its research efforts and degree programs, Kenan-Flagler also directs and maintains the Frank Hawkins Kenan Institute for Private Enterprise, the Kenan Conference Center, the Wachovia Center for Corporate Finance, and International Programs office and the Paul J. Rizzo Conference Center, which houses its nationally-ranked executive education programs.
The Senior Data Architect position will serve as a key resource in enhancing and maintaining our enterprise data warehouse here at Kenan Flagler. This individual will work with key stakeholders, business partners, and IT counterparts to define requirements, identify source data, assist with detailed data models, analyze and validate data, troubleshoot data issues, and promote data quality. S/he directly supports data integration efforts (within the data warehouse, data marts, ad-hoc queries, and data services) by providing services that ensure Kenan Flagler is aligning IT efforts with business information needs.
The selected candidate will be part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes. Tasks will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.
The selected candidate will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The selected candidate must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The role requires the applicant to be a hands-on data architect and business analyst. This position will report to the DIA (Data Integration and Analytics) Director.
Educational RequirementsMaster’s and 1-2 years’ experience or Bachelors and 2-4 years’ experience or will accept a combination of related education and experience in substitution.
Qualifications and ExperienceStrongly preferred:
5 years’ experience – DBA (Data Base Administrator)
3 years’ experience – Data Warehousing
3 years’ experience – ETL
3 years’ experience with Microsoft SQL Server preferred
And strongly preferred demonstrated previous experience in the following:
-RDBMS, star schema
-SQL, strong skills, complex queries
-ETL
-Data Integration
-Data governance and meta data management
-Kimball methodology
-Deep experience with Data Architecture and Database Design
-Data Security, Integrity and Access Control protocols
-BI tools, Dashboards, and enterprise level reporting tools (e.g. Tableau, SSRS)
The University of North Carolina at Chapel Hill is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or status as a protected veteran.
Special InstructionsIn compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.
Quick Linkhttp://unc.peopleadmin.com/postings/167105 Department Contact Information Department Contact Name and TitleDepartment Contact Telephone or EmailOffice of Human Resources Contact InformationIf you experience any problems accessing the system or have questions about the application process, please contact the Office of Human Resources at (919) 843-2300 or send an email to employment@unc.edu
Please note: The Office of Human Resources will not be able to provide specific updates regarding position or application status.
- Cover Letter
- Curriculum Vitae / Resume
- List of References
Required fields are indicated with an asterisk (*).
- * Please select the response below that describes your level of education that best or mostly closely satisfies the education requirements for this Level II IT position.
- Master's degree and 1-2 years of experience
- Bachelor's degree and 2-4 years of experience
- A combination of related education and experience
- None of the above
- * Do you have experience working with Tableau? If yes, please describe.
(Open Ended Question)
- * Do you have experience writing ETL? If so, please describe.
(Open Ended Question)
- * Do you have experience with data warehousing methodology? If so, please describe.
(Open Ended Question)
- * Do you have experience with Kimball methodology? If yes, please describe.
(Open Ended Question)
Organization
The nation’s first public university is at the heart of what’s next, preparing a diverse student body to become creators, explorers, innovators and leaders in North Carolina and throughout the world. Carolina’s nationally recognized, innovative teaching, campus-wide spirit of inquiry and dedication to public service continue the legacy that began in 1795 when the University first opened its doors to students.
Here, in one of America's most beautiful college settings, we offer exceptional careers in richly diverse fields. Come explore what UNC-Chapel Hill has to offer you.
Undergraduate Enrollment: 19,117
Graduate/Professional Enrollment: 10,894
Total Student Enrollment: 30,011
Founded: 1789, as the first state university in the United States
Type of Institution: Public, four-year
Undergraduate Admission: 15,961
Graduate/Professional Enrollment: 10,039
Total Student Enrollment: 26,000
Faculty: 3,000
Percentage of faculty who hold Ph.D.s or the highest degrees in their field: 94 percent
Faculty/student ratio: 1/14
Location: UNC is located in the heart of Chapel Hill, the best college town in America! It's a friendly town of about 40,000 in the geographical center of North Carolina. Chapel Hill is at the western point of the Research Triangle, an area of about one million people, comprised of Chapel Hill, the cities of Durham and Raleigh, and the Research Triangle Park, home of many corporate offices and scientific research centers. Carolina is about 30 miles from the state capital, Raleigh, and 20 minutes from Raleigh-Durham International Airport.
Chapel Hill's main street, Franklin Street, borders the campus and offers shops, coffee houses, cafés, movie theaters and houses of worship. The town has a historic district, museum, library, parks, malls, and many recreational facilities.
Origins of Carolina's students: 82 percent of UNC's freshmen are from North Carolina and 18 percent are from out-of-state. Our students come from 42 different states and our international students represent 37 countries.
Size of freshman class: Approximately 3,400
Class size: Barely five percent of undergraduate classes contain more than 100 students; two-thirds of undergraduate classes have fewer than 30 students. Forty-one percent have fewer than 20 students, including First Year Seminars, in which first-year students work closely with professors.
Sports and athletic programs: UNC is an NCAA Division I school with 28 varsity teams. Carolina is the proud home of the Dean Smith Center, Kenan Stadium, Carmichael Auditorium, Koury Natatorium, and many other fine athletic facilities. Students join more than 60 intramural and club sports, which include baseball, bowling, crew, golf, lacrosse, rock climbing, rugby, tae kwon do, and ultimate frisbee. The Student Recreation Center offers weight training, aerobics, stair machines, and all the equipment you would expect to find at a great health club! Carolina offers a newly renovated outdoor pool and indoor pools, a golf course, tennis courts, and the longest zipline in America!
Number of residence halls: Incoming undergraduates will live in one of Carolina's 29 residence halls, which are wired for Internet access and cable television. housing.unc.edu
Scholarships and financial aid: About 40 percent of UNC-Chapel Hill students receive scholarships and/or some form of financial aid. studentaid.unc.edu
Special research institutes: Institute for Research in Social Science, Institute of Outdoor Drama, Morehead Planetarium, Kenan Institute of Private Enterprise, Institute of Government, Institute of African American Research.
Career services: On-campus counseling, job fairs, résumé writing service, internships, placement services. www.unc.edu/depts/career
Technological facilities: Students find multiple uses for Carolina's state-of-the-art technological resources. They can access Carolina's computer services through Academic Technology and Networks, which manages academic computing, e-mail, microcomputing labs, interactive media presentation, video and classroom support, and a help desk. The MetaLab oversees the development of SunSITE, one of the world's busiest digital library and electronic publishing projects.
Students may open e-mail accounts, and many use campus computer resources to construct personal Web pages. Students in residence halls have hardwired network connections to the Internet and cable television in their rooms. At the ATN Training center, students may take classes on software packages and utilities. Computer labs are available for student use all over campus.
Carolina Computing Initiative: Beginning with the freshman class of 2000, undergraduates must purchase laptop computers. The University has arranged for IBM to offer computers at excellent prices. Students, faculty, and staff will enjoy cost savings, higher quality compatible equipment, and better technical support through CCI. www.unc.edu/cci
The Study Abroad program allows students to live and learn in Europe, the Middle East, Asia and the Pacific Rim, Africa, and the Americas. www.unc.edu/depts/abroad
The Honors Program offers special seminars, research programs, and the chance to design your own independent studies. www.unc.edu/depts/honors
Carolina students spend time in public service through student organizations, the Campus Y, the Carolina Center for Public Service, and courses that incorporate community service.
UNC's chapter of Phi Beta Kappa, a national collegiate honor society, is the oldest in North Carolina, dating from 1904. There are many other honorary societies at Carolina.
UNC offers ROTC programs in all branches of national military service.
Through the First Year Seminars program, first year students will understand what it means to study at a premier research university. They will learn from faculty members and share in their research in seminars of no more than 20 students.
Life outside the classroom: More than 370 clubs, teams, and student organizations offer something for everyone! You can choose from among musical and dramatic performing groups, publications, ethnic and religious clubs, the Campus Y and other service organizations, fraternities and sororities, and pre- professional organizations. Whatever your interests, you will find others at Carolina who share them! www.unc.edu/depts/union/student/listintr.htm
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert