Information Technology - Senior Data Engineer

Sacred Heart University - Fairfield, CT

Full-time - Mid Level

Fairfield, CT

5,001-10,000 employees

Educational Services

About the position

The Senior Data Engineer at Sacred Heart University is responsible for designing and managing data integration solutions that facilitate seamless data flow across various systems. This role focuses on developing efficient data pipelines, maintaining data quality, and optimizing performance for scalability. The position requires collaboration with data infrastructure teams and stakeholders to ensure alignment with institutional goals.

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.

Requirements

• 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.
• 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.

Nice-to-haves

• 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.