Information Technology - Senior Data Engineer

As the second-largest independent Catholic university in New England, and one of the fastest-growing private doctoral institutions in the U.S., Sacred Heart University is a national leader in shaping higher education for the 21st century. SHU offers nearly 90 undergraduate, graduate, doctoral and certificate programs on its Fairfield, Conn., campus. Sacred Heart also has a campus in Dingle, Ireland, and offers online programs. More than 10,000 students attend the University’s eight colleges and schools: Arts & Sciences; Communication, Media & the Arts; Social Work; Computer Science & Engineering; Health Professions; the Isabelle Farrington College of Education & Human Development; the Jack Welch College of Business & Technology; and the Dr. Susan L. Davis, R.N., & Richard J. Henley College of Nursing. Sacred Heart stands out from other Catholic institutions as it was established and led by laity. 

Sacred Heart University is a contemporary Catholic university rooted in the rich Catholic intellectual tradition and the liberal arts that cultivates students to be forward thinkers who enact change—in their own lives, professions and in their communities. SHU upholds a universal perspective, welcoming and valuing diverse faith traditions, including those from religious and nonreligious backgrounds. This catholicity, which is the basis of inclusivity, enriches dialogue, deepens understanding and strengthens our commitment to creating a more compassionate and just world.

The Princeton Review includes SHU in its Best 388 Colleges–2023 Edition, and Best Business Schools–2023 Edition. Sacred Heart is home to the award-winning, NPR-affiliated radio station, WSHU, a Division I athletics program and an impressive performing arts program that includes choir, band, dance and theatre. www.sacredheart.edu 
 
To apply

Only applications submitted through the official Careers at SHU site will be accepted for employment consideration. If you are viewing this job advertisement through a different site, please visit Careers at SHU to submit a formal application.

Qualified candidates are invited to submit a complete application and resume via our online application system. A cover letter or statement of interest is also preferred for all staff positions.

Sacred Heart University complies with all federal and state employment laws and regulations. Applicants must be lawfully authorized to work for any employer in the United States. We are unable to sponsor or take over sponsorship of an employment Visa for this position.

Position Summary

Responsible for designing and managing data integration solutions that enable seamless data flow across systems supporting operational processes. This role involves developing efficient data pipelines, maintaining data quality and consistency, and optimizing performance for scalability. Collaborating closely with data infrastructure teams and stakeholders ensures that integration solutions are aligned with institutional goals.

Principal Duties & Responsibilities

• Design, build, and maintain scalable data pipelines, ensuring accurate and consistent data.
• Integrate and manage data from various sources, including databases, APIs, and third-party services, ensuring seamless data flow between systems.
• Implement data validation and cleansing techniques to resolve anomalies and inconsistencies, following data quality standards.
• Work closely with business functions and cross-functional teams to gather requirements, develop data pipelines, conduct thorough testing with stakeholders, and document processes.
• Maintain comprehensive documentation of data integrations and processes.
• Troubleshoot and resolve data-related issues, ensuring data integrity and availability.
• Mentor data engineers, providing technical leadership and fostering a collaborative team environment.
• Stay updated with industry trends and technologies to drive innovation within the team.
• Other duties as assigned. 

Knowledge, Skills, Abilities & Other Attributes

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
• At least 5 years of experience in a data engineering or similar role.
• Preferred experience working in a higher education setting.
• Preferred experience with iPaaS tools such as SnapLogic, Informatica, or Talend.
• Preferred experience with star schema data warehouse models.
• Proficiency in data warehousing concepts and tools (e.g., SQL, Synapse, Snowflake, Redshift) and strong programming skills in SQL and Python.
• Experience with ETL tools, data integration technologies, and familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and related data services.
• Excellent problem-solving and communication skills, with the ability to work independently and collaboratively in a fast-paced environment. 

Unusual Working Conditions

 Working after hours and on weekends to complete assigned tasks is sometimes required.

This job posting provides an overview of the role's general nature and expected tasks. It is not meant to be a comprehensive list of all duties performed. The university reserves the right to modify or reassign job responsibilities at any time. This posting description does not constitute an employment contract, either explicit or implied.