Advanced SQL with Snowflake, Data Modeling & ETL Engineer_186827

Description/Brief Summary of what role entails

R esponsible for the advanced data engineering and architecture. Work as an individual contributor, facilitates data engineering , design implementation as well as developing functional & user acceptance, and constructs solutions that remain scalable, adaptable, and replicable to deliver the standard solution across various platforms. Also, to provide technical expertise as a mentor to other team members.

This role requires experience in Enterprise Datawarehouse infrastructure, as well adopting appropriate emerging technologies and its solutions to answer business problems and identify opportunities impacting the revenue or operating income.

E xpected to closely work with Global team members as well with enterprise IT team to align practices.

Key Tasks and Responsibilities

• Connect with business partners and identify opportunities to drive business value via analytics solutions.
• Design and build publication-ready data pipelines using diverse sets of structured and unstructured data.
• Ensure data pipelines are created using credible qualitative and quantitative methodologies based on key insights.
• Pays high attention to data accuracy. In depth understanding of data identification, collection, processing, and analysis methodologies.
• Drive continuous improvement and innovation. Work with cross functional teams effectively
• Work with Honeywell businesses and Enterprise IT teams to clearly outline how enterprise platforms can enable business growth & productivity by seamlessly combining structured and unstructured data into a single, self-service analytical environment.
• Leverage knowhow and domain knowledge of Honeywell experts to define, design and develop intelligent solutions to operate on large data sets related to Supply Chain.

Qualifications:

• Bachelor in engineering / Technology degree or equivalent
• Specialized in Computer Science, Software Engineering / Information Technology or related field is preferred
• Certifications in Microsoft Certified Solutions Associate (MCSA) / Azure Data Solution Certification / AWS Solution
• Architect Certification / Snowflake certification is desirable
• Azure / Databricks / Scala / Python / and Visualization techniques Certification is preferred

Experience:

• 6+ years of Software development with 4+ years of experience working with data engineering.
• 2+ years of experience with cloud/on premises data warehouses and data modeling.
• 2+ years of hands-on experience in creating technical solutions on Cloud - Snowflake EDW / Informatica IICS / HVR as well as design and development on SQL Server is advantageous
• Demonstrated experience in progressively challenging and Responsible roles.

Essential skills:

• Experience working with any of the data engineering skills like No SQL, ASW, Kafka, Hadoop et.
• Hands on experience in data transformation, exploration and preparation using tools like Alteryx, Wrangler, Paxata, Datameer etc.
• Experience working with cloud data warehouses like Redshift, Azure SQL DW, Snowflake, Google Big Query.
• Excellent Data crunching and presentation/ interpretation skills- Story building.
• Working knowledge of cloud / Big data Platform like Azure or AWS.
• Must be an innovative and integrative thinker quick to visualize solutions and generate ideas
• Strong business acumen, with ability to draw clear connections between data modeling activities and business challenges/opportunities
• Team Player, open to feedback, and flexible & adoptable to changing needs.

Desired skills:

• Knowledge in Elasticsearch Kibana, REST APIs.
• Experience with the agile and DevOps methodologies
• Developing IoT Connectivity Solutions using Azure event hub, Apache Kafka.