Associate Analytics Engineer

About the role

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.

Responsibilities

• Aid 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.
• Create and maintain enterprise-grade Power BI dashboards and reports that enable self-service analytics and data-driven decision-making at scale.
• Develop DAX measures and time-intelligence calculations to support Key Performance Indicators (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.

Requirements

• 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.
• Familiarity with basic 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.

Qualifications

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.

Benefits

We offer a 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.

Pay

The salary range for this role is $60,000 - $80,000 annually, depending on experience and qualifications.

Schedule

This role is offered on a hybrid schedule, combining in-person collaboration for meaningful moments with the flexibility of remote work. Specific details will be provided by your talent acquisition partner.

Skills

Essential skills include:

• Experience with T-SQL and foundational understanding of data transformations.
• Knowledge of data modeling concepts such as star schema or dimensional modeling.
• Proficiency in Power BI for building datasets and reports.
• Understanding of DAX functions and time-intelligence calculations.
• Ability to document data models, business rules, data lineage, and report specifications.
• Strong communication and collaboration skills.

Benefits

At Allegion, we offer:

• Health, dental, and vision insurance coverage.
• A 401K plan with a 6% company match and no vesting period.
• Unlimited PTO.
• Employee discounts through Perks at Work.
• Community involvement and opportunities to give back.
• Opportunities to leverage your unique strengths through CliftonStrengths testing and coaching.

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.
• You're looking for a company that will invest in your professional development.
• You want a culture that promotes work-life balance.
• You want to work for an award-winning company that invests in its people.

Apply Today!

Join our team of experts today and help us make tomorrow's world a safer place! Not sure if your experience perfectly aligns with the role? Studies have shown that some people are less likely to apply to jobs unless they meet every single qualification and every single preferred qualification of a job posting. At Allegion, we are dedicated to building a diverse, inclusive, and authentic workplace. So, if you’re excited about this role but your past experience doesn’t align perfectly with every item in the job description, we encourage you to apply anyway. You may be just the right candidate for this role. 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.