Associate Analytics Engineer

Allegion; Carmel (IN); Hybrid; USD 60,000 - 85,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401K with 6% match

Tuition Reimbursement

Unlimited PTO

Employee Discounts

Community involvement

CliftonStrengths coaching

Job summary

Allegion seeks an Associate Analytics Engineer to join the Global Data & Analytics Team. This entry‑level role supports embedding analytics into standard work streams under leadership guidance. You will collaborate across the team to design and roll out solutions that enable end users to consume and analyze data at scale.

You will contribute to creating and maintaining analytics assets, including Power BI dashboards, data models, and data transformations, with hybrid work options available.

Qualifications

• 0–2 years’ experience in Analytics, BI, or data analysis or related roles.
• Basic experience with Power BI, building datasets/reports and familiarity with DAX functions.
• Working knowledge of T-SQL and data transformations.
• Bachelor’s degree in a related field or equivalent coursework/certification.

Responsibilities

• Assist in implementing Lakehouse schemas and semantic dataset layers powering core reporting and analytics.
• Build and maintain Spark/SQL data transformations to produce analytics-ready tables.
• Develop and maintain Power BI dashboards and reports for self-service analytics and data-driven decisions.
• Create DAX measures and time‑intelligence calculations to support KPIs.

Skills

Power BI

T-SQL

Data modeling

DAX basics

Communication

Team collaboration

Education

Bachelor's degree in related field

Tools

Spark

Job description

Creating Peace of Mind by Pioneering Safety and Security

At Allegion, we help keep the people you know and love safe and secure where they live, work and visit. With more than 40 brands, 14,000+ employees globally and products sold in 130 countries, we specialize in security around the doorway and beyond.

Additionally, Allegion is proud to be recognized with the 2026 Gallup Exceptional Workplace Award (GEWA) for the third consecutive year, earning distinction in both the employee engagement and strengths categories. This year, Allegion also received Gallup’s With Distinction honor — a designation reserved for a select group of organizations that go above and beyond in building exceptional workplace cultures.

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

At Allegion, we are driven by a bold vision: redefining safety while empowering our employees to thrive. When you join our team, you become part of a culture that values innovation, purpose, and excellence. This role offers the benefits of our dynamic hybrid work model—combining in-person collaboration for meaningful moments with the flexibility of remote work. Since hybrid arrangements can vary based on the needs of the individual, team and business, your talent acquisition partner will provide specific hybrid details about this role.

We are committed to fostering a healthy work-life balance and building meaningful connections, ensuring you have the tools, resources, and support needed to excel in any environment. Together, we’ll unlock your potential and create a lasting impact.

While this is the current structure and we currently have no plans to change, we reserve the right to make changes to the hybrid schedule as needed at the Company’s discretion.

Qualified candidates must be legally authorized to be employed in the United States. The company does not intend to provide sponsorship for employment visa status (e.g., H-1B, TN, etc.) for this employment position.

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?

Allegion is a Great Place to Grow your Career if:

• 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

We Celebrate Who We Are!

Allegion is committed to building and maintaining a diverse and inclusive workplace. Together, we embrace all differences and similarities among colleagues, as well as the differences and similarities within the relationships that we foster with customers, suppliers and the communities where we live and work. Whatever your background, experience, race, color, national origin, religion, age, gender, gender identity, disability status, sexual orientation, protected veteran status, or any other characteristic protected by law, we will make sure that you have every opportunity to impress us in your application and the opportunity to give your best at work, not because we’re required to, but because it’s the right thing to do. We are also committed to providing accommodations for persons with disabilities. If for any reason you cannot apply through our career site and require an accommodation or assistance, please contact our Talent Acquisition Team.

© Allegion plc, 2023 | Block D, Iveagh Court, Harcourt Road, Dublin 2, Co. Dublin, Ireland

REGISTERED IN IRELAND WITH LIMITED LIABILITY REGISTERED NUMBER 527370

Allegion is an equal opportunity and affirmative action employer

Privacy Policy