Johnson controls is a global diversified technology and industrial leader serving customers in more than 150 countries. Our 162,000 employees create quality products, services and solutions to optimize energy and operational efficiencies of buildings; lead-acid automotive batteries and advanced batteries for hybrid and electric vehicles; and interior systems for automobiles. Our commitment to sustainability dates back to our roots in 1885, with the invention of the first electric room thermostat. Through our growth strategies and by increasing market share we are committed to delivering value to shareholders and making our customers successful. In 2011, corporate responsibility magazine recognized johnson controls as the #1 company in its annual "100 best corporate citizens" list. For additional information, please visit. Jci is an equal opportunity/affirmative action employer, and as such does not discriminate in its recruiting and selection process based on disability or handicap status. If you are a person with a disability and you need an accommodation during the application process, please call our talent acquisition hotline at (414)-524-8999 and press option #0.
job summary
the jci global products data engineer is a crucial member of a larger commercial operations & analytics team that supports 10+ distinct business units, all centralized business functions and a much larger combined sales team. This role is critical to executing and driving the improved processes and management of the snowflake environment for the global products business. This is a growing team that is developing a true professionalized data infrastructure. This role is specifically based on monterrey, mexico to participate as a key commercial operations resource within the jci monterrey business center location.
principal duties:
1. manage and monitor our commercial self-service snowflake database
2. monitor existing pipeline ingestions (dynamic tables) from centralized usable layer and implement pipeline enhancements
3. performance tuning of snowflake database to ensure optimal warehousing, speed, etc.
4. create and implement code changes processes between dev and prod environments
5. work with solution team members to put in infrastructure changes needed for new downstream solutions and offerings
6. collaborate with data management team members to ensure optimal data qualityworking within a data & analytics team consisting of us and india based resourcesteam works directly with the commercial organization to support business units as well as executive leadershippartners with other functional groups across enterprise (pricing, s&op, finance, etc)mix of in office and remote workers. Team members work independently but collaborate to achieve team goalsteam responsibilities consist of snowflake infrastructure, data modeling, data visualization/reporting, data governance
7. manage/document downstream dependencies from other teams using data mart
8. liaison between our team and enterprise it (through service tickets & relationships)
9. create standard processes/documentation around security/access, data quality thresholds, and data availability
10. create new data mart data sets for reporting where it isn't possible/efficient in power bi
requirements:
11. snowpro core certified would be necessary, snowpro advanced would be ideal
12. advanced sql knowledge
13. familiarity with adf (azure data factory) a plus
14. previous snowflake database management experience