Reporting to the Director of IT Planning & Project Management, the Data Engineer will create efficient data modeling and visualization solutions for cross-functional business units. This role involves designing, implementing, and maintaining a modernized data platform to support informed decision-making. Collaborating closely with the Business Intelligence Lead, the Data Engineer will ensure data quality and accessibility while optimizing performance. The role encompasses the full database development process, from conception to delivery, and includes establishing development standards and procedures.
Essential Duties and Responsibilities include the following. Other duties may be assigned.
Design and Development
- Model, design, develop, test, and implement backend and front-end structures to meet business visualization and reporting requirements.
- Design, develop, test, and implement database solutions and data pipelines for optimal extraction, transformation, and loading (ETL) from various data sources.
- Build aggregate data models, dimension views, and fact tables; perform data transformation using ETL tools.
- Create design documents for data integration and reporting projects.
Data Integrity and Performance
- Maintain the integrity and performance of company databases, ensuring secure and optimal data storage.
- Monitor databases, provide production support, and remediate job failures while automating routine processes.
- Develop data quality metrics and conduct QC tests to verify data integrity.
Collaboration and Coordination
- Coordinate with the Business Intelligence Lead, Reporting/Data Analyst(s), Data Governance Team, and IT Teams to align with change management processes.
- Act as a technical expert to address system and application design, performance, integration, and security issues.
Documentation and Standards
- Follow industry best practices for development standards and create documentation for peer reference and knowledge transfer.
- Document the data blending process, including specifications and workflow/data lineage.
Process Improvement
- Analyze data integration problems, recommend corrective actions, and develop new processes to ensure service levels are met.
- Monitor key performance indicators and recovery time objectives to meet service level agreements and maximize business value.
For more details and to apply, please click on the following link.