What are the responsibilities and job description for the Data Engineer position at United Wheels Inc.?
Overview of the Company
United Wheels Inc. (“UWI”) is an international, privately held business, with affiliated companies and operations in Asia, the Americas and around the world. UWI is a world leader in the design, manufacture and international distribution of bicycles, e-bikes, and rideable toys, manufacturing more than 6 million bicycles and e-Bikes each year. In additional to cycling, UWI is at the forefront of materials science though Allite Inc. and its affiliated companies, which utilizes its proprietary magnesium alloys across numerous industries (e.g., sporting goods, robotics, electronics, aerospace, etc.).
UWI owns and operates several bicycle-related subsidiaries. These subsidiaries include:
United Wheels Inc. (“UWI”) is an international, privately held business, with affiliated companies and operations in Asia, the Americas and around the world. UWI is a world leader in the design, manufacture and international distribution of bicycles, e-bikes, and rideable toys, manufacturing more than 6 million bicycles and e-Bikes each year. In additional to cycling, UWI is at the forefront of materials science though Allite Inc. and its affiliated companies, which utilizes its proprietary magnesium alloys across numerous industries (e.g., sporting goods, robotics, electronics, aerospace, etc.).
UWI owns and operates several bicycle-related subsidiaries. These subsidiaries include:
- Huffy Corp. (https://www.huffybikes.com/), the iconic bicycling company based in Dayton, Ohio, with more than 125 years of bicycling history.
- Buzz Bicycles (https//.buzzbicycles.com)
- Batch Outdoors Inc. (https://www.batchbicycles.com/)
- Niner Brands International Inc. (https://ninerbikes.com/)
- VAAST Bicycles, (a division of Allite Inc.) (https://www.vaastbikes.com/)
Summary
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.
Competencies
- Customer Focus - Aims to satisfy all customers while maintaining effective relationships, both internal and external. Maximizes those relationships to improve personal, department, and organizational performance. Holds co-workers and customers to a similar standard.
- Energy - Have a tremendous amount of energy and passion for our people, products, and brands. Approaches each date willing to take on the day’s challenges. Operating at their individual peak performance without encouragement.
- Energize - Energize teams with enthusiasm and excitement without intimidating them. Projects a positive mental attitude and can-do spirit, who lifts up members of his / her team. Does not get discouraged by setbacks.
- Edge - Have a competitive edge and an overwhelming desire to win. Hates losing and will give 100% commitment to achieving or exceeding their plan. Willing to make difficult decisions, when called upon.
- Execution - Action and performance oriented and are focused on attaining results. A team player who is reliable and follows through on tasks to completion. Attention to details.
- Increases Company Value - Strives to increase sales, reduce costs, improve efficiency, and maximize profits to increase the value of the Company.
- Innovative / Continuous Improvement - Committed to improving processes, products, services, and a willingness to embrace change for the benefit of our team, department, organization, and shareholders.
- Integrity - The quality of being honest and having strong moral principles; moral uprightness. Elevating challenges to collaborate with co-workers, SLT, ELT, and the Board.
Supervisory Responsibilities
No current supervisory responsibilities.
No current supervisory responsibilities.
Education and Experience
- Bachelor's degree in Data Engineering, Computer Science, Information Systems, or related field; master’s degree or graduate level coursework related to data engineering/data science preferred.
- 3 years of experience in designing and developing analytical queries, reports, and visualizations using AWS Quicksight or similar reporting tools.
- Hands-on experience with AWS services such as Amazon S3, AWS Glue, Amazon Redshift, AWS Lambda, and Amazon RDS and proficiency in two or more programming languages (Python, SQL, Java, C#, Scala, R).
- Solid understanding of data engineering principles and fundamental data architecture and design skills.
- Demonstrated experience in data modeling, design, and development for relational databases using complex SQL (e.g., Snowflake, BigQuery, Redshift, Azure SQL DB), including documentation of data models and data lineage.
- Familiarity with API-first architectures.
Language Skills
Ability to read, analyze, and interpret the most complex documents. Must be able to communicate ideas both verbally and in writing to management, business, and IT sponsors, and technical resources in language that is appropriate for each group.
Mathematical Skills
Ability to apply mathematical operations to such tasks as frequency distribution, determination of test reliability and validity, analysis of variance, correlation techniques, sampling theory, and factor analysis.
Reasoning Ability
Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
Computer Skills
Microsoft Office, knowledge of systems, software, and hardware, including application systems and operating systems.
Certificates, Licenses, Registrations
AWS Data Engineer Associate certification preferred.
Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually quiet.
