Database Administrator/Architect
Southern Methodist University Inc

Description

Salary Range:

Salary commensurate with experience and qualifications

About SMU

SMU's more than 12,000 diverse, high-achieving students come from all 50 states and 80 countries to take advantage of the University's small classes, hands-on research opportunities, leadership development, community service, international study and innovative programs. The University offers a strong foundation in the humanities and sciences and undergraduate, graduate and professional degree programs through eight schools.

Now in its second century of achievement, SMU is increasingly recognized for the ways it supports students, faculty and alumni as they become ethical leaders in their professions and communities. Now in its second century of achievement, SMU is increasingly recognized for the ways it supports students, faculty and alumni as they become ethical leaders in their professions and communities. The University's entrepreneurial spirit lives in people from every academic discipline who see opportunities to create something new in the world - and work hard to bring their innovations to life. SMU's relationship with Dallas - the dynamic center of one of the nation's fastest-growing regions - offers unique learning, research, social and career opportunities that provide a launch pad for our students, faculty and alumni to make a global impact. On the most beautiful college campus in the country, SMU Mustangs are energized by unbridled opportunities - from teaching, learning and research to creativity, performance and athletic endeavor.

About the Position:

Architect and design enterprise data solutions, including architecture definition, data modeling, design, and implementation of warehousing solutions. Lead data warehousing projects focusing on students, faculty, staff, financial performance, and other university critical metrics.

This position will provide infrastructure, application support, and data integration for a variety of SMU applications and systems, with a substantial amount of duties falling to data warehousing activities.

Other duties may include application administration, performance troubleshooting of applications, documentation of processes and procedures, project planning, change management, integration management, and customer communication.

Essential Functions:

• Analyze data holdings, and develop schema in support of growth and extension. Design and configure the Extract, Transform, and Load (ETL) processes such that the data fits into a unified data architectural model. Build Data Vault 2.0 compliant solutions using DBT and SQL Server Integration Services.
  
• Support other SMU applications, including data source systems. Design and document data flows between systems.
  
• Create effective technical & project documentation. Provide customer and technical documentation for supported systems. Document workflow processes and diagrams in consultation with the customer.
  
• Solid project management. Manage projects with wide scope.
  
• Communications. Communicate effectively with customers, colleagues and management.
  
• Other duties as assigned
  

Qualifications

Education and Experience:

Bachelor's degree is required; preferably degree of study in Computer Science, Data Science, Business, or related field.

A master's degree is preferred.

A minimum of three (3) years of experience is required. Candidate with experience integrating a variety of technologies is required.

Knowledge, Skills and Abilities:

Candidate with experience in data architecture, Data Vault 2.0, SQL Server Integration Services, data warehousing, and business analytics is desired. Candidate must demonstrate experience solving complex data and data integrations. Strong advanced analytical skills is required. Must also demonstrate clear and concise verbal and written skills.

Candidate must demonstrate strong interpersonal and verbal communication skills, with the ability to communicate broadly across the University and develop and maintain effective relationships with a wide range of constituencies. Must also demonstrate strong written communication skills.

Candidate must possess strong problem-solving skills with the ability to identify and analyze problems, as well as devise solutions. Must also have strong organizational, planning and time management skills.

Software Skills:

• Candidate with DBT experience is preferred.
• Knowledge of SQL and SQL Server Integration Services
• Experience with Python, R, and other data analysis tools is a plus

Physical and Environmental Demands:

• Sit for long periods of time

Deadline to Apply:

Priority consideration may be given to submissions received by October 21, 2022.

Deadline to apply: November 3, 2022

EEO Statement:

SMU will not discriminate in any program or activity on the basis of race, color, religion, national origin, sex, age, disability, genetic information, veteran status, sexual orientation, or gender identity and expression. The Executive Director for Access and Equity/Title IX Coordinator is designated to handle inquiries regarding nondiscrimination policies and may be reached at the Perkins Administration Building, Room 204, 6425 Boaz Lane, Dallas, TX 75205, 214-768-3601, accessequity@smu.edu.

Benefits:

SMU offers staff a broad, competitive array of health and related benefits. In addition to traditional benefits such as health, dental, and vision plans, SMU offers a wide range of wellness programs to help attract, support, and retain our employees whose work continues to make SMU an outstanding education and research institution.

SMU is committed to providing an array of retirement programs that benefit and protect you and your family throughout your working years at SMU and, if you meet SMU's retirement eligibility criteria, during your retirement years after you leave SMU.

The value of learning at SMU isn't just about preparing our students for the future. Employees have access to a wide variety of professional and personal development opportunities, including tuition benefits.

This job has expired.