Sr Data Integration Developer in Clemmons, North Carolina
Posted 05/19/22
THE TEAM YOU WILL BE JOINING:
Industry leading manufacturer and supplier of products and components in a high-growth commercial industry
Family-owned company for over 65 years with global footprint
Forward-thinking executive leadership team
WHAT THEY OFFER YOU:
Hybrid work-environment (based in Clemmons, NC)
Competitive salary and comprehensive relocation package
World-class compensation and benefits
WHY THIS ROLE IS IMPORTANT:
Design, develop, implement, and support new and existing data integration jobs using Talend or other ETL technologies.
Ingest data from multiple sources including transactional and operational databases, implement complex business logic, and produce 3rd normal form and dimensional model database objects in Snowflake.
Migrate datasets between existing and future database platforms.
Produce ad-hoc data extracts to answer business questions quickly and thoroughly.
Collaborate with Project Managers, IT Architecture, Business Analysts, and Report Developers to achieve business objectives.
Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions.
Troubleshoot, diagnose, and resolve data quality and performance issues related to data integration and transformation.
Present and participate in Architecture Review Board meetings. Review solutions presented by other IT architects and provide constructive feedback.
THE BACHGROUND THAT FITS:
Bachelor’s degree in computer science, information technology, or related field. Equivalent working experience in-lieu of a bachelor’s degree would be considered
5+ years of advanced hands-on experience building data integration and transformation solutions in Talend or other leading ETL tools.
4+ years of advanced SQL skills, preferably in Snowflake or similar cloud data warehouse
3+ years of hands-on knowledge in data warehousing, and particularly in star-schema architecture and how to optimize data structures for consumption in BI tools. Experience in data structures optimization for consumption in BI tools.
Motivation with ability to confidently execute independently with minimal direction.
Experience communicating with (both verbally and written) and supporting senior executives across a global organization.
Flexibility to accommodate non-standard working hours for international meetings in Europe and APAC