Data Modeler/ETL Developer - 12976BR
Data Modeler/ETL Developer
Extract, Transform, & Load (ETL) Developers work closely with BI Analysts and the Data Architect to extract data from source systems, transform data as necessary, and ultimately load data into the university’s Data Warehouse. These extracts must be modeled into dimension and fact tables (i.e. STAR Schema) that ultimately support end user requirements. The developer will also monitor daily jobs to ensure they were successful and troubleshoot any issues that arise from jobs failing, loading data incorrectly, etc.
- Develop and maintain ETL processes and/or SQL queries from various source systems.
- Assist the Data Architect with developing a Dimensional Fact Model (i.e. STAR Schema) for the various modules and subject areas of the university’s data.
- Work on the design and implementation of data integrations.
- Develop and maintain the automation of data flowing into and out of the source systems.
- Work on web services to extract data from various source systems.
- Work with BI analysts, functional users, and data scientists to develop and further enhance data models.
- Participate in an Agile environment and complete assigned sprint tasks.
- Adhere to basic development principles (e.g. change control, separation of duties, etc.)
- Provide feedback from a technical perspective on requirements documents. Additionally, create technical design document with data flows, process models, etc. to help document the technical approach to meeting end user needs.
Application/Integration Support (20%)
- Support a complex Data Integration environment.
- Assist with ETL Application Tool/Server system and database upgrades/maintenance.
- Work with the Network Operations Center (NOC) to ensure extract jobs are monitored.
- Troubleshoot issues as they arise (e.g. failed jobs, data errors, etc.).
- Assist with Modeling and BI Tool/Server upgrades.
Testing and Validation (15%)
- Determining data sourcing strategies and data validation approaches.
- Defining test conditions and test scripts to ensure system stability and validity.
- Develop and maintain audit and validation processes and work with other team members to resolve data integrity issues.
Other projects as assigned (5%)
- Bachelor’s degree in Information Systems, Computer Science/Engineering, Information Technology, Business Analytics, or Business with a focus in Business Analytics.
- 3 years of relevant professional experience.
- At least two years of experience with an enterprise ETL tool (e.g. Informatica, Oracle Data Integrator, etc.)
- Advanced SQL skills.
- Knowledge of data modeling.
- Demonstrated experience in testing and debugging techniques.
- Exceptional time management skills, including the ability to adapt quickly to shifting priorities.
- University experience.
- Experience with and passion for working in an agile team environment.
- Experience with developing Essbase applications.
- Experience with implementing web services.
- Experience working with databases.
- BI and/or data warehousing experience.
Additional Candidate Instructions
The review of applications will begin on October 15, 2018. This position will remain open until filled.