Job description
This individual engages with multiple departments throughout the organization to take their data and transform it into information that will enable them to make better decisions. As an intermediate-level professional, the Data Engineer 2 gathers business requirements and designs, creates, and supports the data warehouse. This individual works with divine guidance to provide or support technology that furthers the mission of the Church and reflects the eternal impact of the gospel.
.
- Write code to build both APIs and back end code to support web tools for different groups
- Help develop UI tools for use by various groups within the department for managing data and work flow
- Write and execute operational analysis scripts of moderate difficulty including queries with reasonable accuracy and predictable production outcomes that meet project and system specifications
- Analyze data using pre-defined scripts and criterion and effectively communicate data and/or system issues and constraints to technical lead, manager, and technical and non-technical stakeholders
- Meet assigned deadlines for projects
- Perform Extraction, Transformation, and Load (ETL) functions to merge various data types from internal sources load into data warehouse
- Work well in operational environment to ensure production cadence is maintained
- Demonstrate knowledge of various databases, structures, and data management tools with ability to learn new tools as needed
- Understand the supported business processes and systems, and requirements for the data warehouse
- Work effectively with other team members to repair data and resolve obstacles
- Report issues with data and systems, and implement improvements
- Resolve with assistance complex data structure and system conformance issues
- Understand operational business needs and processes required to perform essential job duties
- Quickly learn new tools and technology, and adapt business processes accordingly
- Bachelor's degree in related field and 6 years of experience or a combination of professional work experience and education
- Experience with ETL processes
- Experience in manipulating data sets, running complex scripts to meet project and system specifications
- Understanding of and experience in coding, data analysis, structures, modeling, and data warehouse design/development
- Experience with various types of database schemas, protocols, and data querying/management software
- Experience in code development in languages such as Java or Python
- Experience in UI development such as React
Master's degree preferred.