Data Engineer
ukg
Job Description
- Pipeline Development: Design, build, and monitor ADF pipelines, dataflows, and triggers to automate ingestion and transformation of data from multiple systems.
- SQL Development: Write and maintain stored procedures, views, and reporting tables; tune queries for optimal performance.
- Data Modeling: Design and implement star/snowflake schemas to enable efficient reporting and analytics.
- Data Correlation: Analyze cross-system data relationships to create unified reporting views and metrics.
- Automation: Develop Python scripts for validation, reconciliation, and process automation where needed.
- Data Quality: Implement validation checks, reconciliation processes, and alert to maintain data accuracy and reliability.
- Documentation: Create detailed technical documentation for pipelines, data models, and schedules.
- Stakeholder Collaboration: Work closely with finance, supply chain, and operations teams to translate requirements into scalable solutions that deliver measurable business value.