Sightline Data Engineer II (Sightline Information Technology)
Role summary
Sightline is seeking a Data Engineer II to design, build, and maintain integrations and data models within Workday Prism Analytics. This role involves developing Workday analytical reports and dashboards to ensure consistent delivery across HR, Finance, and Supply Chain functions. The Data Engineer will support ERP users, collaborating with Workday, IT, EDMS, and data governance teams to transform Workday data into robust analytical solutions. Key responsibilities include developing and maintaining data pipelines, ETL/ELTs, web scraping systems, and data architecture, as well as performing data quality assurance, monitoring, and troubleshooting software infrastructure. The position requires a Bachelor's degree and five years of related experience in database management, design, and business requirement gathering. A remote work arrangement is offered.
We are seeking a
*Sightline*
*Data Engineer II*
who will lead the design, build, and maintenance of integrations and data models within Workday Prism Analytics as well as developing Workday analytical reports and dashboard by ensuring uniform delivery across HR, Finance, and Supply Chain. This role supports all ERP users and collaborates closely with functional Workday, IT, EDMS, and data governance teams to transform Workday data into robust analytical solutions.
Specific Duties & Responsibilities
- Contribute to the design, production, and maintenance of data pipelines for data acquisition, management, transformation, and back-end code development to power data web applications and convert raw data into usable information.
- Write and maintain ETL/ELTs that operate on a variety of structured and unstructured sources.
- Develop and maintain web data scraping systems for automatic data acquisition.
- Help design data architecture and provide ongoing support.
- Input/output data from databases and perform queries.
- Create scripts to clean, transform, and analyze data.
- Put into production data pipelines using data warehousing systems.
- Create and implement production software to monitor data quality and detect data anomalies.
- Perform daily manual data quality assurance tasks.
- Support, maintain, and troubleshoot the software infrastructure.
- Source data, conduct analyses, visualize data, and generate insights to support ongoing research projects and other requests across the organization.
- Collaborate with developers, analysts, data scientists, researchers, policy experts, and other partners.
- Communicate with Division leadership, and others on the team.
- Collaborate with external partners, contractors, and vendors.
- Other duties as assigned.
On-Call Required
- Yes
Minimum Qualifications
- Bachelor's Degree.
- Five years of related work experience focused within database management and design and business requirement gathering.
- Additional education may substitute for required experience and additional related experience may substitute for required education beyond a high school diploma/graduation equivalent, to the extent permitted by the JHU equivalency formula.
Preferred Qualifications
- Ten plus years working with SAP ERP and SAP data warehousing software.
Classified Title: Data Engineer II
Job Posting Title (Working Title): Sightline Data Engineer II (Sightline Information Technology)
Role/Level/Range: ATP/04/PG
Starting Salary Range: $99,800 - $175,000 Annually (Commensurate w/exp.)
Employee group: Full Time
Schedule: Mon-Fri 8:30am-5:00pm
FLSA Status: Exempt
Location: Remote
Department name: Sightline
Personnel area: University Administration