Associate Analytics Engineer at Schlage Lock Company LLC — Carmel, IN

Associate Analytics Engineer

This position functions within Allegion’s Global Data & Analytics Team and sits on the Enterprise Data & Analytics Team. This role is an entry-level or early-career position to support how the business and other IT teams can embed analytics into their standard-work streams. This role will work under guidance of leadership & senior team members in creating the solutions that enable end users to consume and analyze data at scale. This role will collaborate with the entire Global Data & Analytics Team, designing, and rolling out technical solutions in alignment with Analytics Operations Best Practices.

Hybrid:

What You Will Do:

• Assist in implementing Lakehouse schemas and semantic dataset layers that power core reporting and analytics across Allegion—apply dimensional and modern data modeling best practices for consistency and reuse.
• Build and maintain T-SQL and Spark/SQL (or equivalent) data transformations in the Data Lakehouse to produce curated, analytics-ready tables.
• Develop and maintain enterprise-grade Power BI dashboards and reports that enable self-service analytics and data-driven decision-making at scale.
• Create DAX measures and time‐intelligence calculations to support KPIs and scalable self‐service analytics.
• Support and maintain global data assets, ensuring accuracy, performance, and alignment with evolving business needs.
• Document data models, business rules, data lineage, and report specifications
• Ensure upstream data pipelines align with downstream analytics requirements
• Apply Analytics Code Repository templates and processes provided by Analytics Operations Team.

What You Need to Succeed:

• Ability to execute independently and deliver to milestones.
• 0–2 years’ experience in Analytics, Business Intelligence, Data Analysis, or related roles; internships or coursework in data analytics counts.
• Basic experience with Power BI, including building simple datasets and reports; familiarity with fundamental DAX functions.
• Working knowledge of T-SQL and foundational understanding of data transformations.
• Basic understanding of data modeling concepts such as star schema or dimensional modeling.
• Willingness to learn and follow established templates, governance practices, and workflows.
• Strong communication skills and curiosity to learn new tools and best practices.
• Organized, analytical, with the ability to collaborate effectively in team environments.
• Bachelor’s degree in a related field or equivalent coursework / certification.

Why Work for Us?

• You're seeking a rewarding opportunity that allows you to truly help others. With thousands of employees and customers around the world, there’s plenty of room to make an impact. As our values state, “this is your business, run with it”.
• You’re looking for a company that will invest in your professional development. As we grow, we want you to grow with us.
• You want a culture that promotes work-life balance. Our employees enjoy generous paid time off, because at Allegion we recognize that you have a full life outside of work!
• You want to work for an award-winning company that invests in its people. Allegion is proud to be a recipient of the Gallup Exceptional Workplace Award for the second year in a row, recognizing our commitment to employee engagement, strengths-based development, and unlocking human potential.

What You’ll Get from Us:

• Health, dental and vision insurance coverage, helping you “be safe, be healthy”.
• A commitment to your future with a 401K plan, offering a 6% company match and no vesting period
• Tuition Reimbursement
• Unlimited PTO
• Employee Discounts through Perks at Work
• Community involvement and opportunities to give back so you can “serve others, not yourself”
• Opportunities to leverage your unique strengths through CliftonStrengths testing and coaching

Apply Today!

## We Celebrate Who We Are!

Privacy Policy