Data Engineer III

Provide for, and supports, the development, analysis, implementation and security of all of the company's analytical data solutions for corporate, affiliated distributors, and independent distributors. This positionwill manage, monitor and maintain company data warehouses, analytics solutions, and ensure the high availability of the data. This position is responsible for designing, building and implementing complex data warehouses, dimensional structures, data replication, and integrations in both on premise and cloud environments. This position will work in conjunction with Domain Architects, Data Analysts, Product Owners and other Data Engineers and work with Business Analysts, Product Owners and IT leadership to obtain business requirements, outline data solutions and implement.

Responsibilities

• Act as a technical mentor and advisor within IT, including mentor junior staff as needed.
• Analyze, plan and implement automated systems to solve complex business opportunities.
• Write detailed design documents and assisting with gathering business requirements with business users and analysts.
• Provide escalation support from other IT team members.
• Ensure that data engineering documentation remains current, including documentation on data warehouse, ETL and structure metadata.
• Design, develop, implement and maintain ETL and modeling processes on premise and in the cloud utilizing current ETL and modeling tools and methods
• Design, implement and maintain semantic layers, datasets and data models.
• Develop, implement, and maintain automated deployment pipelines and automated testing processes for modifications to the data warehouse environments.
• Coordinate with appropriate IT and business stakeholders.
• Participate in the execution and planning of team work utilizing Agile Scrum.
• Assist with analysis for budgeting on future projects, tools, and technology.