In this hybrid role, you will serve as the analytics liaison to the Category Management team at ADI, combining deep technical expertise with business insight to drive data-informed strategies. You will partner with both functional leaders and analysts to build robust data solutions and shape strategic decision-making for our product categories. You will work daily in Snowflake and SQL Server, developing complex queries, procedures, and functions that support category performance tracking, product lifecycle analysis, and promotional ROI reporting. You will also be responsible for maintaining and automating recurring reports through SQL Server Reporting Services (SSRS) and providing support for ad hoc data needs. On the business side, you will actively participate in Category Management and Analytics tier meetings, acting as a conduit for feedback, requirements, and continuous improvement initiatives. You will help shape strategic direction, recommend process optimizations, and ensure alignment between data deliverables and business goals. Expect to be challenged daily in a fast-paced environment where your analytical skills, business acumen, and communication abilities are equally critical to your success. **JOB DUTIES:** + Heavy focus on writing complex SQL queries in Snowflake and SQL Server + Creation and automation of Power BI reporting + Creation and automation of recurring and ad hoc reporting using SSRS + Translate business questions from Category Managers into actionable data solutions + Participate in strategic planning and decision-making discussions for product categories + Bridge communication between the Category Management and Analytics teams + Present data-driven recommendations to improve pricing, product mix, and inventory planning + Gather and refine reporting requirements and share with the analytics development team + Manage analytics-related tasks in broader category initiatives and track project timelines + Use tools such as Power BI or Excel for advanced data visualization and analysis **YOU MUST HAVE:** + 5-8 Years of related experience in the field of Data Science, Computer Science, Business Analytics + An excellent level of **English** (written and spoken) + Expert-level knowledge of SQL, including procedures, functions, and performance tuning + Hands-on experience with Snowflake SQL development + Strong experience with SSRS and automating scheduled reports + Strong experience with Power BI + Demonstrated problem-solving ability with large and complex data sets + Excellent written and verbal communication skills to interface with business leaders **WE VALUE:** + Experience working with or supporting Category Management, Merchandising, or Supply Chain teams + Strong business acumen in areas such as product lifecycle, pricing, and vendor analysis + Experience using Power BI or other data visualization tools + Project management skills; able to drive tasks to completion and manage cross-functional projects + Ability to identify process improvement opportunities and work collaboratively to implement solutions + Familiarity with master data management and schema alignment practices **WHAT'S IN IT FOR YOU?:** + Benefits that go beyond Mexican labor law, ensuring your well-being and peace of mind. + A collaborative and inclusive work environment where your contributions are valued. + Opportunities for continuous professional growth and skill development through training, mentoring, and challenging projects. + Access to cutting-edge tools, resources, and a supportive team to help you excel. + The chance to work with a global, innovative company shaping the future in its industry. \#LI-Hybrid Resideo is a $6.76 billion global manufacturer, developer, and distributor of technology-driven sensing and control solutions that help homeowners and businesses stay connected and in control of their comfort, security, energy use, and smart living. We focus on the professional channel, serving over 100,000 contractors, installers, dealers, and integrators across the HVAC, security, fire, electrical, and home comfort markets. Our products are found in more than 150 million residential and commercial spaces worldwide, with tens of millions of new devices sold annually. Trusted brands like Honeywell Home, First Alert, and Resideo power connected living for over 12.8 million customers through our Products & Solutions segment. Our ADI | Snap One segment spans 200+ stocking locations in 17 countries, offering a catalog of over 500,000 products from more than 1,000 manufacturers. With a global team of more than 14,000 employees, we offer the opportunity to make a real impact in a fast-growing, purpose-driven industry. Learn more at [www.resideo.com](http://www.resideo.com/). At Resideo, we bring together diverse individuals to build the future of homes. Resideo is an equal opportunity employer. Qualified applicants will be considered without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, religion, or veteran status. For more information on applicable U.S. equal employment regulations, refer to the ["EEO is the Law" poster](https://www.resideo.com/us/en/-/media/Resideo/Files/Corporate/Careers/EEO%20is%20the%20Law%20poster.pdf?rv=fdc492d184344b3ea4aec0c96b321632), ["EEO is the Law" Supplement Poster ](https://www.resideo.com/us/en/-/media/Resideo/Files/Corporate/Careers/EEO%20is%20the%20Law%20Supplement%20Poster.pdf?rv=ebe367cad846443e8fa5aa86062813b6)and the [Pay Transparency Nondiscrimination Provision](https://www.resideo.com/us/en/-/media/Resideo/Files/Corporate/Careers/Pay%20Transparency%20Nondiscrimination%20Provision.pdf?rv=11a9cf6533ba426296b137d906b0ce01). Resideo complies with applicable equal employment laws in all countries where we do business. For more information on how we process your information in the job application process, please refer to [Recruitment Privacy Notice](https://www.resideo.com/us/en/-/media/Resideo/Files/Corporate/Resideo%20%20-%20Recruitment%20Privacy%20Notice.pdf?rv=6d871e71bfa24982b181c92fda232b7a). If you require a reasonable accommodation to apply for a job, please use Contact Us form for assistance.