Associate Analytics Engineer

allegion; Carmel (IN); Hybrid; USD 55,000 - 80,000; Full time

Benefits offered by this job

Health, dental and vision insurance

401(k) plan with 6% company match

Tuition Reimbursement

Unlimited PTO

Employee discounts through Perks at We

Community involvement and volunteering

CliftonStrengths coaching

Job summary

Allegion is seeking an Associate Analytics Engineer to join the Global Data & Analytics Team in a hybrid work model. The role is entry-level, supporting how analytics are embedded into business and IT workflows, with guidance from senior team members.

The position emphasizes building analytics-ready data, dashboards, and reports, while collaborating across the analytics organization to deliver scalable solutions.

Qualifications

• 0–2 years’ experience in Analytics, BI, Data Analysis, or related roles; internships or coursework count.
• Basic experience with Power BI, including building simple datasets and reports.
• Working knowledge of T-SQL and foundational data transformations.
• Bachelor’s degree in a related field or equivalent coursework / certification.

Responsibilities

• Assist in implementing Lakehouse schemas and semantic dataset layers for core reporting and analytics across Allegion.
• Build and maintain data transformations in the Data Lakehouse to produce curated, analytics-ready tables.
• Develop and maintain enterprise-grade Power BI dashboards and reports for self-service analytics.
• Create DAX measures and time-intelligence calculations to support KPIs.
• Support and maintain global data assets and data lineage documentation.
• 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.

Education

Bachelor’s degree in related field

Tools

Power BI

T-SQL

Spark/SQL

DAX

Job description

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 the 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.

At Allegion, we are driven by a bold vision of redefining safety while empowering our employees to thrive. This role offers the benefits of 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. 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.

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 the 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 count.
• 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.

What You’ll Get from Us:

• Health, dental and vision insurance coverage.
• A 401(k) plan with 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.
• Opportunities to leverage your unique strengths through CliftonStrengths testing and coaching.

Allegion is an equal opportunity and affirmative action employer.