Sr. IT Analyst - Data Engineering

As a member of the Global Data & Analytics Team at Allegion, you will play a crucial role in designing and implementing scalable data architecture solutions on Azure. Your main responsibilities will include: - **Design and Architecture:** Developing scalable data architecture solutions on Azure that meet high availability, disaster recovery, and security standards. - **Data Integration and ETL:** Creating and managing ETL processes using tools like Azure Data Factory and Azure Databricks to integrate data from diverse sources. - **Collaboration and Requirement Analysis:** Engaging with global data team members and stakeholders to understand requirements and translate them into effective ELT designs. - **Data Querying and Modeling:** Utilizing T-SQL to query data from multiple sources and create semantic models for reporting purposes. - **Dashboard Development:** Implementing top-notch PowerBI dashboards for data analysis and decision-making support. - **Data Governance and Quality:** Establishing data governance and quality processes to ensure data integrity and compliance. - **Agile Practices:** Implementing agile methodologies to document repeatable processes for efficient delivery. - **Coordination and Accuracy:** Collaborating with source-system and IT teams to ensure data consistency and accuracy. - **Support and Maintenance:** Providing ongoing support for global data assets and solutions. - **Documentation:** Creating and maintaining comprehensive documentation for all data solutions, processes, and best practices. To succeed in this role, you will need: - 8+ years of experience in Data Analytics and Engineering. - Bachelor's degree in information technology. - Technical Expertise: Proficiency in designing data solutions on Microsoft Azure, including Azure Synapse Analytics and Azure Data Factory. - ETL and Data Tools: Experience with ETL processes and SQL Server Databases. - Data Modeling and Analytics: Knowledge of data modeling techniques and experience in creating analytics measures. - PowerBI Expertise: Experience in developing data assets and dashboards in PowerBI or Microsoft Fabric. - Collaboration and Communication: Strong teamwork skills for effective collaboration with cross-functional teams. - Problem-Solving Skills: Ability to diagnose and resolve data-related issues. - Agility and Adaptability: Flexibility and adaptability in executing projects with an agile approach. - Time Management: Highly organized with good time management skills. - Leadership and Mentorship: Capable of leading projects and mentoring junior team members. - Industry Knowledge: Stay updated with the latest Azure technologies and industry trends. Join Allegion in their mission to create a safer and more secure world.,