Developer ETL - Cloud Data Engineer - Level 2
Duke University2 months ago
Durham, NC, USAMid Level
Responsibilities
- Design, develop, test, execute, monitor, and maintain ETL processes for data integration and data warehousing.
- Work independently with stakeholders to analyze business needs and translate them into technical requirements and deliverables.
- Write, modify, optimize, and troubleshoot SQL queries, stored procedures, scripts, and complex cohort inclusion/exclusion criteria.
- Resolve data integrity issues and participate in database quality assurance, code reviews, and requests for new database tables or attributes.
- Locate data elements, understand domain workflows and infrastructure, and support data design activities.
- Train and mentor new hires and Level 1 team members on relevant tools, technologies, SQL, and tuning practices.
- Manage multiple projects, complete assignments with minimal supervision, and develop or present topics for customers or the team.
- Maintain project documentation and communicate request status clearly and accurately to managers and business analysts.
Requirements
- Bachelor’s degree in a related field or four years of equivalent technical experience.
- Two years of directly related experience for Level 2.
- Advanced knowledge of the assigned domain, data, workflows, and role-specific tools.
- Ability to perform business analysis and develop technical requirements independently more than 75% of the time.
- Ability to write and modify accurate SQL queries independently more than 90% of the time and optimize queries, stored procedures, and scripts.
- Ability to write complex SQL inclusion/exclusion criteria, troubleshoot data integrity issues, and locate data elements independently.
- Knowledge of basic data design and infrastructure and familiarity with ETL technologies, scripting languages, relational databases, and SQL.
- Ability to train and mentor team members, manage multiple projects, participate in code reviews and database QA, and work with minimal supervision.
- No license or certification is required; development-technology certification is preferred where appropriate.
About Duke University
Duke University is a private research university in Durham, NC, that also operates an academic medical center. Its IT organizations build and run clinical information systems, campus learning platforms, research computing, and enterprise applications for faculty, students, clinicians, and staff. Founded in 1838, Duke is funded by tuition, research grants, healthcare services, and philanthropy, and includes Duke University Health System as an affiliated enterprise.