Associate Analytics Engineer

Allegion Canada Inc.; Carmel (IN); Hybrid; USD 65,000 - 85,000; Full time

Benefits offered by this job

Health, dental, and vision insurance

401(k) with 6% company match

Tuition reimbursement

Unlimited PTO

Perks at Work discounts

Community involvement opportunities

CliftonStrengths coaching

Job summary

Allegion is seeking an Associate Analytics Engineer to help design and maintain data models and analytics pipelines supporting enterprise reporting. The role involves collaborating across teams to implement Lakehouse schemas, develop T-SQL and Spark/SQL transformations, and build Power BI dashboards for self-service analytics.

The ideal candidate has 0–2 years in analytics or BI, basic Power BI and DAX skills, and a foundational understanding of data modeling.

Qualifications

• 0–2 years of analytics/BI experience; internships or coursework count.
• Basic Power BI experience, building datasets and reports; familiarity with DAX.
• Working knowledge of T-SQL and data transformations.
• Foundational understanding of star schema or dimensional data modeling.
• Willingness to follow templates, governance, and workflows.
• Strong communication and curiosity to learn new tools.
• Organized, analytical, and collaborative team player.
• Bachelor’s degree in a related field or equivalent coursework.

Responsibilities

• Assist in implementing Lakehouse schemas and semantic dataset layers powering reporting and analytics.
• Build and maintain T-SQL and Spark/SQL data transformations to produce curated, analytics-ready tables.
• Develop and maintain enterprise-grade Power BI dashboards and reports enabling self-service analytics.
• Create DAX measures and time-intelligence calculations to support KPIs.
• Support and maintain global data assets, ensuring accuracy and performance.
• 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.

Skills

Power BI

DAX

T-SQL

Data modeling

Communication

Team collaboration

Education

Bachelor's degree in related field

Tools

Power BI

SQL

Job description

Associate Analytics Engineer

Creating Peace of Mind by Pioneering Safety and Security. Allegion helps 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.

Hybrid work model: Combination of in‑person collaboration and remote flexibility. Details vary based on team needs.

What You Will Do

• Assist in implementing Lakehouse schemas and semantic dataset layers that power core reporting and analytics across Allegion – applying 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

• 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, and able 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, offering professional development, work‑life balance, and a culture that promotes safety, innovation, and collaboration.

What You’ll Get from Us

• Health, dental, and vision insurance coverage.
• 401(k) plan with 6% company match and no vesting period.
• Tuition reimbursement.
• Unlimited PTO.
• Employee discounts through Perks at Work.
• Community involvement opportunities.
• CliftonStrengths testing and coaching.

Qualified candidates must be legally authorized to be employed in the United States; no visa sponsorship is provided.

Allegion is an equal opportunity and affirmative action employer. We are committed to building and maintaining a diverse and inclusive workplace.