Azure, Data Analytics, Data Modeling, Data science techniques, Design, DevOps, ETL/ELT technologies, Github, GitLab, Oracle, Pandas, Planning and organization, Python Programming, SQL
In this role, you will be responsible for deploying supporting the E2E management of our data, including: ETL/ELT, DW/DL, data staging, data governance, and manage the different layers of data required to ensure a successful BI & Reporting for the PEC while also utilizing your data analysis expertise to derive meaningful insights from our datasets. This position offers a unique opportunity to work with both technical and analytical aspects of data management and contribute to data-driven decision-making across the organization.
This role will work with multiple types of data, spreading across multiple functional areas of expertise, including Fleet, MRO & Energy, Travel, Professional Services, among others.
How you will do it?
Deploy data ingestion processes through Azure Data Factory to load data models as required into Azure Synapse. Build, design, and support ETL/ELT processes with Azure Data Factory (ADF) and/or Python, which once deployed, will require to be executed daily and weekly.
Conduct in-depth data analysis using SQL or Python, and other data analysis tools to extract insights and identify trends from complex datasets.
Collaborate with business stakeholders to understand data requirements and translate them into actionable analytical solutions.
Assemble data sets that meet functional / non-functional business requirements. Develop data models that enable DataViz, Reporting and Advanced Data Analytics, striving for optimal performance across all data models.
Maintain conceptual, logical, and physical data models along with corresponding metadata. Manages the DevOps pipeline deployment model, including automated testing procedures Performs the necessary data ingestion, cleansing, transformation, and coding of business rules to support annual Procurement bidding activities. Participate in compliance to system architecture, methods, standards and best practices.
Deploys data stewardship and data governance across our data warehouse, to cleanse and enhance our data, using knowledge bases and business rules. Support the deployment of a global data standard. Other Data Engineering duties as assigned.
What are we looking for?
Johnson Controls International plc is an Irish-domiciled multinational conglomerate headquartered in Cork, Ireland, that produces fire, HVAC, and security equipment for buildings. As of mid-2019, it employed 105,000 people in around 2,000 locations across six continents.
Bangalore, Karnataka, India
4-6 year