Senior Data Analytics Engineer

We Create Products and Brands That People Trust to Clean, Sanitize, and Protect Their Homes, Pools, and Cars.When you join KIK Consumer Products, you’re joining a team that cares about the work we do and also about each other. We bring exceptional brands and products to consumers that help them protect the health and wellness of their families, the cleanliness of their homes and pools, and the life of their automobiles. We are committed to building a culture of performance driven by accountability, empowerment, collaboration, and agility that enables timely fact-based decision-making and exceptional execution with unwavering ethics. As one of North America’s largest independent manufacturers of consumer products, KIK helps a large portfolio of brands and retailers bring their products to life.What You’ll Be Doing

Strategic Data Implementation: Design and implement business and IT data requirements through innovative strategies across all data platforms (relational, dimensional, NoSQL) and tools (reporting, visualization, analytics, machine learning). Collaborate with business units and application/solution teams to build data flows and develop comprehensive data models (conceptual, logical, physical).

Standards and Governance: Define and enforce data modeling and design standards, tools, and best practices. Ensure consistent development across enterprise data models and oversee the architecture, infrastructure, and interfaces to data sources, emphasizing security and efficiency in data handling and visualization.

Technical Expertise and Development: Conduct hands-on modeling, design, configuration, and installation, along with performance tuning and proof of concept creation in sandbox environments. Utilize advanced programming languages and technologies such as .NET, Python, SQL, NoSQL databases, Docker, Kubernetes, and Azure services to build robust data solutions.

Data Analysis and Insights: Employ statistical data analysis techniques to derive actionable insights from large datasets, aiding in evidence-based decision-making. Manage the stability, quality, and performance of the analytics platforms, including Power BI and SQL Server Analysis Services.

Advanced Analytics Models: Extend and create new PowerBI models, incorporating new members, measures, tables, relationships, and roles in both direct query and import models. Provide high-level support and troubleshooting as the owner of level 3 incident resolutions.

Project and Problem Management: Proactively address project requirements, articulate issues, and challenges to mitigate risks and delivery obstacles. Evaluate the business relevance and requirements of projects to align initiatives with strategic goals.

Service Excellence and Professional Conduct: Actively contribute to the firm’s Service Excellence initiative by enhancing its internal and external image. Display professionalism, quality service, and a proactive "can-do" attitude in all interactions, whether through electronic and print correspondence, over the telephone, or in-person.

What You’ll Bring

Bachelor’s degree in Statistics, Information Technology, Computer Science, or a related business field. A Master’s degree in these fields is preferred.

Minimum of 7 years in roles such as analytics/data engineer, with a strong background in data modeling and analyzing large-scale data using modern cloud computing platforms.

Proficiency in SQL, Python, and T-SQL, with expert knowledge of SQL Server versions 2016, 2019, and 2022.

Extensive experience with cloud environments such as Azure, AWS, Databricks, and Snowflake.

Demonstrated capability in dimensional modeling, star schema, and other data modeling techniques.

Hands-on experience with Microsoft Analysis Services Cube and PowerBI data model implementation using the Tabular model.

Data Science Skills: Understanding of data science principles and practical experience in supporting machine learning models.

Analytical Model Development: Skilled in the development and deployment of analytical models.

Project Management: Proven track record of managing projects using Agile/Scrum methodologies.

Collaborative Skills: Experience in direct collaboration with business representatives to understand and translate business requirements into technical solutions.

Tools Proficiency: Familiarity with version control systems, particularly Git.

Communication Skills: Strong ability to communicate effectively across diverse teams and with stakeholders, demonstrating clarity and professionalism in all forms of communication.

Experience with integration to ERP Systems (Oracle / SAP) preferred

Working knowledge of Information Technology Infrastructure Library (ITIL) preferred

What You Will GetKIK offers a competitive salary and comprehensive benefits including health, wellness, dental, vision, life, and disability insurance. You can plan for your future with KIK's retirement savings options including employer match. KIK also recognizes the importance of continuing education and offers Education Assistance to our employees to encourage continued personal development and growth.About KIKWe create the products and brands that people trust to clean, sanitize, and protect their homes, pools, and cars. We are one of North America’s largest independent consumer product manufacturers with 20 North American manufacturing facilities. We also operate globally in Europe, Asia, the UK, Australia, New Zealand, and South Africa. We are known for our portfolio of over 40 brands including Spic and Span® and Comet® cleaning products, Clorox® Pool&Spa™ (under license), BioGuard®, and Natural Chemistry® pool chemicals, and Prestone® and Holts® automotive performance chemicals. We are also the #1 producer in North America of store-brand (“private label”) bleach and a leading private-label provider of laundry detergent and additives, dishwashing products, general-purpose cleaning, and other home care products.Our global team of over 2,500 employees drives our capabilities in product development, product formulation, strategic sourcing, manufacturing, packaging design, brand marketing, project management, quality assurance, compliance, distribution, and logistics.Our organization is constantly evolving and is driven by a set of “One KIK” values – a dedication to following through on commitments in a customer-focused, profit-motivated way; while never compromising on safety, ethics, or integrity.KIK is an Equal Employment Opportunity / Affirmative Action employer. KIK does not discriminate against qualified applicants or employees based on race, color, age, religion, sex, pregnancy, national origin, ancestry, age, physical or mental disability, veteran status, status in uniformed services, sexual orientation, gender identity, gender expression, marital status, genetic information or any other status protected by law.KIK is also committed to providing reasonable accommodations for applicants and employees with protected disabilities to the extent required by applicable laws. If you require a reasonable accommodation to participate in the job application, or interview process, or to perform the essential functions of the job, please contact Human Resources immediately.