Johnson Controls

Senior Data Architect

Job Location:  Pune
Job Description:  SkillSet: etl, informatica, data modeling, erwin, unix.

Work collaboratively with all levels of stakeholders to architect, implement and test Big Data based analytical solution from disparate sources

Demonstrate an understanding of concepts, best practices and functions to implement a Big Data solution in an enterprise environment

Establish, maintain and adhere to Enterprise Data Standards Policies.

Create and document Logical Physical Data Models using best practices to ensure high data quality and reduced redundancy.

Recommend solutions to improve existing functional data models.

Understand and translate business needs into scalable data models supporting enterprise views

Optimize and update logical and physical data models to support new and existing projects.

Maintain conceptual, logical and physical data models along with corresponding metadata.

Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.

Ensure reusability of data models for future business requirements

Perform reverse engineering of physical data models from databases and SQL scripts.

Connect with the functional and technical leads when prioritizing the technology initiatives to support analytics

What we look for

Assess organization's potential data sources (internal external), develop blueprint to integrate, centralize, protect and maintain data, thus enabling data models for the enterprise.

Work with leadership and stakeholders to define the overall vision, mission, and strategy for business data models that scales up for the enterprise

Mentor guide technical project teams based globally on Azure platform components

Technical leadership role to lead and manage analytics projects to ensure all deliverables meet our JCI standards

Accountable for a team of data modelers


Bachelor of Science degree and/or Masters in Software Engineering / Computer Science or an equivalent discipline

More than 18 years of hands on experience using various development methodologies to deliver robust PaaS and DaaS based analytics solutions on Azure data platform

Proven expertise of Azure data platform, CI/CD

Strong knowledge of Hadoop, MPP Data platform, Azure Data Factory, Azure HDI, Power BI and Open source technologies

Superior documentation and communications skills

Proven ability to lead coach diverse teams of data modelers located globally

Technology Requirement

Azure HDInsight, Synapse Analytics, Access and Security Management, Snowflake

DevOps: GitHub, Azure DevOps

ETL/ELT Framework design and implementation

Object Oriented Programing skills using Java, Python, and .Net

Essential Skills

Strong Leadership, organizational, and prioritization skills

Excellent written and verbal skills to communicate technical solutions to business teams

Demonstrated experience leading and influencing individuals and teams without formal organizational control

Understanding trends, new concepts, industry standards and new technologies in Data and Analytics space

Functional Area:  General / Other Software
Experience:  18 - 22 years
Qualification:  ("Other in B.Sc") OR ("Other in any field")
Salary:  20 Lakh to 22 Lakh INR
Johnson Controls
Job Ad publication date: 15 May 2021  

Related Jobs