Data Engineer

Excelsior University; City of Albany (NY); Hybrid; USD 100,000 - 110,000; Full time

Benefits offered by this job

Competitive compensation

Generous benefits package

Paid time off

Retirement plans

Health insurance

Job summary

Excelsior University in Albany, NY is seeking a full-time Data Engineer to support business intelligence efforts. The role involves ensuring data accuracy, maintaining test pipelines, and advocating for data quality across teams. Strong SQL and Python skills are required.

The position offers competitive compensation ranging from $100,000 to $110,000, with a generous benefits package that includes health insurance and retirement plans.

The role is primarily on-site with flexibility for remote work.

Qualifications

• 8 years of experience writing and troubleshooting complex SQL queries.
• Strong understanding of relational database systems and data warehousing concepts.
• Excellent organizational skills.

Responsibilities

• Translate stakeholder needs into technical requirements.
• Ensure data quality and reliability.
• Validate data transformations and migrations.

Skills

Complex SQL queries

Python or R data frame functions

Data governance

Data warehousing concepts

Analytical skills

Education

Bachelor's degree in computer science or related field

Tools

Power BI

QlikView

QlikSense

Job description

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.

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 skills.
• Experience in creating data quality requirements analysis documentation.

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.

Excelsior University offers competitive compensation and a generous benefits package that includes paid time off, retirement, and excellent health insurance.

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