Data Engineer - Military veterans preferred

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 http://www.johnsoncontrols.com. 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:

• Manage and monitor our Commercial self-service Snowflake database
• Monitor existing pipeline ingestions (Dynamic tables) from centralized usable layer and implement pipeline enhancements
• Performance tuning of Snowflake database to ensure optimal warehousing, speed, etc.
• Create and implement code changes processes between Dev and Prod environments
• Work with solution team members to put in infrastructure changes needed for new downstream solutions and offerings
• Collaborate with data management team members to ensure optimal data quality
  • Working within a Data & Analytics team consisting of US and India based resources
  • Team works directly with the Commercial organization to support business units as well as executive leadership
  • Partners 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 goals
  • Team responsibilities consist of Snowflake infrastructure, data modeling, data visualization/reporting, data governance
• Manage/document downstream dependencies from other teams using data mart
• Liaison between our team and Enterprise IT (through service tickets & relationships)
• Create standard processes/documentation around security/access, data quality thresholds, and data availability
• Create new Data Mart data sets for reporting where it isn't possible/efficient in Power BI

REQUIREMENTS:

• SnowPro Core Certified would be necessary, SnowPro Advanced would be ideal
• Advanced SQL knowledge
• Familiarity with ADF (Azure Data Factory) a plus
• Previous Snowflake database management experience