Data Engineer

Description
The Data Engineer is the key architect and developer of our data infrastructure. This individual manages the systems used to integrate and access disparate data sources throughout the school district.

Qualifications
REQUIRED QUALIFICATIONS:
 

1. Associate or bachelor's degree in computer science, data science, information technology, statistics or other relevant technical program
2. Experience creating and maintaining optimal data architecture
3. Strong analytical skills related to working with unstructured datasets
4. Demonstrated ability to integrate disparate data sources utilizing FTP, API, and flat file imports
5. Strong ability to work with end users to plan the design of data infrastructure
6. Demonstrated skill in project management, as well as excellent planning, organizational and analytical skills.
7. Demonstrated ability to communicate effectively, both orally and in writing.
8. Demonstrated ability to apply problem-solving techniques to complex information analysis.
9. Self-motivated, disciplined individual who can perform at a high level in a fast-paced environment
10. Flexibility and capability to effectively prioritize workload to meet project deadlines and multiple tasks
11. Ability to work with a high degree of accuracy
12. Exceptional attention to detail
13. Analytical mindset to identify, test, develop, and document data validations to improve data integrity
14. Professionalism and integrity when handling confidential information
15. Knowledge of Microsoft Excel
16. Advanced knowledge of SQL

ESSENTIAL FUNCTIONS: 

1. Develops and maintains all data infrastructure for the Office of Data Analytics 
2. Integrates disparate data sources for eventual analysis and consumption by end-users in Business Intelligence solutions
3. Designs, implements, and manages ETL processes to help extract and manipulate data from multiple sources
4. Develops processes to ensure data is clean and usable
5. Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it
6. Collaborates with research and analytics staff to map data required for predictive models, data visualizations, and data analysis
7. Deploys data models to production in partnership with the Office of Data Analytics team
8. Designs data integrations and data quality framework
9. Develops and maintains data dictionary
10. Creates scripts to improve data entry efficiency within key data systems
11. Partners with key community stakeholders and consultants to enhance the district’s data sources
12. Leverages data controls to maintain data privacy, security, compliance, and quality for allocated areas of ownership
13. Partners with the Department of Technology to ensure the performance of SQL server cluster and other relevant technological systems
14. Develops and maintains technical documentation of district data ETL processes and database architecture