Data Engineer

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 30 brands, 12,000+ employees globally and products sold in 130 countries, we specialize in security around the doorway and beyond. Additionally, in 2024 we were awarded the Gallup Exceptional Workplace Award, which recognizes the most engaged workplace cultures in the world.
Allegion is looking for a passionate Data Engineer to work as part of a highly engaged small team within a global organization of 12,000+ employees, representing 30+ brands (including Schlage, Von Duprin and LCN) focused on safety, security and access management. You'll work on solutions that will enable seamless access and help keep you and your loved ones safe and secure where they work, live and thrive.
This position functions within Allegion's Global Data & Analytics Team. This role is strategically designed to support existing Data Warehouse & Lakehouse initiatives of the Data Engineering Team. This role will be responsible for collaborating with the entire Global Data & Analytics Team, designing, and rolling out technical solutions in alignment with Team Architecture Best Practices.

What You Will Do

• Collaborate with Global Data Team Members to review requirements & translate to ELT design and implementation.
• Understand Extract Transform and Load technical approaches and designs.
• Understand the agile approach, leveraging best practices and implementing/documenting repeatable processes.
• Coordinate with all source-system, and IT teams to ensure integration points are managed and involved.
• Perform technical validation of extracted data.
• Follow Allegion code management processes and utilize specified tools.
• Support & Maintain Allegion's Global Data Assets

What You Need To Succeed

• Ability to execute and deliver to milestones.
• 2- 4 Years' experience in Data & Analytics.
• Be self-motivated and highly organized with good time management skills.
• Execute and deliver with agile / iterative approach.
• Work well in teams that may be globally co-located.
• Flexibility and adaptability in responsibilities as required.
• Experience working with Azure Synapse Analytics, Azure Data Factory, or Extract-Transform-Load Tool equivalent.
• Experience working with SQL Server Databases.
• Bachelor's Degree in a related field OR Technical Certification equivalent.

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

What You'll Get From Us
Health, dental and vision insurance coverage, helping you "be safe, be healthy"

Unlimited Paid Time Off

A commitment to your future with a 401K plan, which currently offers a 6% company match and no vesting period

Health Savings Accounts – Tax-advantaged savings