We are looking to hire a Application Developer - Data Engineering, with excellent technical and communication skills, to effectively designing, developing, and validating data pipelines using cloud technologies while collaborating with IT and business stakeholders to understand their needs and develop functionality and enhancements
A Application Developer - Data Engineering in his/her day-to-day operations, will monitor production data pipelines to ensure timely and successful execution
This role transcends organizational and geographical boundaries as it aims at supporting and enabling the various divisions of the Herman Miller business across the globe
The ideal candidate should understand the software development lifecycle and use agile methodology to design, develop, test, and implement solutions that deliver on end-user needs
Responsibilities
Translate stakeholder deliverables into the project methodology deliverables that result in design, such as functional specifications, use cases, workflow & process diagrams, data flow & data model diagrams.
ETL design, development and support of data pipelines used for Analytics.
Perform table and interface design, development of logical and physical data model/database and ETL processes while meeting business/user requirements.
Design, develop, deploy, and validate extremely reliable, scalable, and high performing data pipelines.
Ensure quality of the data and code using quality tools and frequent code reviews.
Assist in the development of logical and physical data models for designing/developing Business Intelligence & Data Warehouse requirements.
Ensure proper source code management of data pipelines, stored procedures, and database definitions.
Provide accurate documentation of data pipelines.
Disseminate tasks amongst team members and ensure timely/accurate completion as defined by the business.
Coordinate prioritized work and help to mitigate any blockers for the team.
Efficient communication of known issues/problems with team members as well as appropriate escalation to leadership.
Essential experience
Demonstrated experience in using a graphical ELT/ETL pipeline development.
Experience with data analysis, data modeling and data warehousing is a must .
Ability to troubleshoot technical and functional problems with intuitive problem-solving techniques with little supervision or direction.
Experience in optimizing databases, understanding of referential integrity and the use of indexes.
Possess an extremely sound understanding of columnar database.
Strong SQL knowledge and experience writing queries and DML .
Moderate knowledge of cloud-based tools and how to interact with them.
Ideal candidate
A graduate / post-graduate in computer science / technology / engineering or mathematics.
Having excellent interpersonal and communication skills in English, both written and verbal.
At least 5+ years of strong hands-on experience with Data Engineering expertise using ELT/ETL tools to meet business requirements for analytics/reporting .
Strong experience on parameterization and process optimization.
Experience using Tableau, Alteryx, Matillion, AWS, Python and Snowflake to develop robust data pipelines.
Ability to work individually or within a team environment.
Ability to participate in multiple projects & tasks and priorities in a healthy work environment.
Has attention to detail and a penchant for quality.
Proficient in documentation as well as process and workflow design.
Command of version control methodologies, preferably with GIT / GITHub.
Ability to take direction, constructive criticism, and work to specified deadlines.
Adhere to process and procedures defined for the role, the team, and the organization.
This role requires the individual to work in the extended UK shift (2 PM - 11 PM India time) and during critical issues, releases, updates, migration or other urgent business needs, there could be a requirement to work during US business hours (5:30 PM to 2:30 AM).
