Data Engineer

Excelsior College; United States; Hybrid; USD 100,000 - 110,000; Full time

Benefits offered by this job

Competitive compensation

Paid time off

Retirement plan

Excellent health insurance

Job summary

A distinguished university in the United States seeks an experienced Data Engineer to enhance data quality within their Business Intelligence department. The role focuses on ensuring the integrity and security of data required for processing and analysis. Responsibilities include working with stakeholders to translate data needs, maintaining business workflow understanding, and developing strategies for reliable data. The position requires a Bachelor’s degree and at least 8 years of SQL and data frame experience, with the potential for remote work alongside mandatory office days.

Qualifications

• 8 years of experience in SQL and data frame functions.
• Strong understanding of relational database systems.
• Experience with data quality requirements documentation.

Responsibilities

• Work with stakeholders to understand data needs.
• Maintain understanding of business workflows and processes.
• Develop strategies for clean and reliable data.
• Design tests for data validation within the warehouse.

Skills

SQL queries (PL/SQL and TSQL)

Python or R data frame functions

Data quality requirements analysis

Organizational skills

Collaboration skills

Education

Bachelor's degree in computer science or related field

Tools

Power BI

QlikView

QlikSense

Job description

Overview

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 Reliability 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

• 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.
• Excellent organizational skills
• 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.

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.

Application Information

If you have problems with online submission, please call 518-608-8238.

Excelsior University offers competitive compensation and a generous benefits package that includes paid time off, retirement, and excellent health insurance. Interested candidates should submit a letter of application, resume, and the names of three professional references. Please submit requested information by clicking the Apply Now button on this page.

AA/EOE/ADA

Excelsior University is an equal opportunity employer committed to ensuring all qualified applicants receive consideration for employment without regard to any legally protected characteristic.