Sr. Data Engineer Ops Data Analytics

Job description:

At Johnson Controls, we are passionate about making a positive impact on the lives of people all over the world. How do we do this? By working together on holistic solutions for smarter buildings and cities today and tomorrow. By protecting people and the environment. By giving back in the communities, we live in. By solving today’s challenges while constantly asking ‘what’s next?’ So, what’s next in your future?

Create your next opportunity and join us as a General Manager to our Order To Cash department in Gurgaon, India.

By joining Johnson Controls, you’ll be part of a team that plays an essential role in helping to create a safe, comfortable, and sustainable world. As a globally diversified technology and multi-industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees work to create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to create smart cities and communities.

We are committed to help our customers win and create greater value for all our stakeholders in everything that we do.

What will you do?

• Design and build robust ETL/ELT pipelines using SQL, Python, and integration tools (SSIS/ADF etc.) to enable efficient data ingestion, transformation, and integration
• Develop, optimize, and maintain complex queries, views, and stored procedures in Snowflake/ SQL
• Ingest and process structured and semi-structured data formats from a variety of data sources
• Implement advanced data modeling, partitioning, clustering, and performance tuning strategies
• Integrate Snowflake with leading BI tools (Power BI) to deliver scalable reporting and analytics solutions.
• Design and maintain scalable data architectures that meet evolving functional and non-functional business requirements.
• Assemble and manage large, complex datasets to support downstream analytics, dashboards, and machine learning workflows.
• Ensure compliance with global data regulations in accordance with the data strategy and cybersecurity initiatives
• Work closely with data engineers, data scientists, and business stakeholders to gather requirements and provide technical guidance
• Create and maintain documentation for architecture designs, data models, and operational procedures
• Keep abreast of Snowflake updates, new features, and industry trends to continually enhance solutions and methodologies

What we look for?

• Minimum: Bachelor’s / Postgraduate/ Master’s degree in any stream
• Minimum 7 years of relevant experience as data engineer /analyst/architect or similar roles
• Strong programming experience in SQL or Python
• Knowledge of Snowflake Data warehouse and understanding the concepts of data warehousing including ELT, ETL processes and data modelling
• Competency in data preparation and/or ETL tools to build and maintain data pipelines and flows
• Strong knowledge of databases, stored procedures (SPs) and optimization of large data sets
• Excellent communication and collaboration skills
• Strong problem-solving abilities and analytical mindset
• Ability to work in a fast-paced, dynamic environment

Johnson Controls does not request pregnancy or HIV testing as a requirement for admission, permanence, or promotion