Data Engineer

The Data Engineer is an integral part of the Information Technology Services department (ITS), reporting to the Director of Business
Intelligence (BI). The role will be involved in efforts to ensure the accuracy, integrity, and security of data within the BI system that
supports data processing and analysis needs.

Interaction with stakeholders such as data governance workgroups, machine learning
engineers, integration data pipeline builders, and BI developers is a key aspect of the role. The role involves designing, building, and
maintaining test pipelines, data transformation or systems performance logs, and metadata or data catalogs. The Data Engineer is responsible
for ensuring accurate and complete data collection, per business requirements, KPIs, and SLAs or SLOs. Gaining a thorough understanding of
the data maintained in the enterprise data warehouse is mandatory. Advocating for data quality across teams is essential.

This is a
full-time role with at least two required days at the Excelsior home office in Albany, NY. The remaining days can be worked from home. The
Data Engineer will play a significant role in shaping the data operations strategy and infrastructure of the University.

Duties and
Responsibilities:

• Work with data analysts, data governance workgroups, and other stakeholders to understand their needs and
  translate them into technical requirements.
• Maintain a strong understanding of business workflows, processes, and events, and
  relate this understanding to how these are captured in transactional systems.
• Develop and implement strategies to ensure data is
  clean and reliable.
• Design and execute tests to validate data transformations, migrations, and storage within the data warehouse
  environment.
• Identify any errors or inconsistencies in the enterprise data warehouse.
• Write technical documentation and
  term definitions in the Data Governance Platform.
• Implement data governance and ensure data integrity across all BI
  initiatives.

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty
satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations
may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor’s degree in computer science,
  information technology, systems engineering, database management, or related field
• 8 years of experience writing and
  troubleshooting complex SQL queries (PL/SQL and TSQL) and Python or R data frame functions.
• Strong understanding of relational
  database systems and data warehousing concepts.
• Strong analytical, research, and critical thinking.
• Experience in creating
  data quality requirements analysis documentation.

Strongly Preferred Qualifications:

• Experience with reporting tools
  (Power BI, QlikView, or QlikSense).
• Ability to work with a diverse group of stakeholders in a collaborative manner and communicate
  effectively.
• Excellent organizational skills

The hiring salary range for this position is $100,000.00 – $110,000.00. The
hiring salary range above represents the University’s good faith estimate at the time of posting.

Tagged as: Employment