Data Integration Specialist Ii

**Company Biography1**:
As one of the fastest growing cities in Alberta, the City of Airdrie is a recognized leader in building a vibrant and sustainable community through innovation.

At the City of Airdrie, incredible opportunities happen every day in a flexible work environment that is tailored to each department. Our inclusive culture and values create a workplace where we welcome aspiring, driven and creative individuals to help us accomplish our business and community goals. We are supportive of one another, and we have fun while we serve our community. We are passionate about improving the lives of our residents through care and respect; that is the foundation of our organization. At the City of Airdrie, we learn, grow and accomplish great things together. We’re proud to foster a workplace culture built on dedication, teamwork, and genuine care. Our commitment to creating a positive environment is reflected in our employee feedback from the 2025 Employee Engagement Survey, with 92.8% of employees saying they enjoy their work, and 92.6% feeling equipped with the resources they need to stay safe on the job.

If you have a passion for building a better community and are ready to join the excitement, we’d love to hear from you

**The Opportunity**:
Primary responsibilities include:

- Design and implement scalable data architectures across on-premises SQL Server and Microsoft Fabric environments, ensuring alignment with enterprise standards and future-state strategies.
- Lead the development and maintenance of comprehensive documentation, such as data flow diagrams, entity relationship diagrams (ERDs), data dictionaries, and system architecture blueprints.
- Establish and enforce data standards and best practices, such as naming conventions, version control, deployment procedures, and data modeling guidelines.
- Architect and optimize data pipelines and lakehouse solutions using Microsoft Fabric components (e.g., Dataflows, Data Factory, Spark), enabling efficient ingestion, transformation, and modeling of structured and unstructured data.
- Oversee master data management (MDM) and entity resolution initiatives, defining governance frameworks, validation rules, and integration strategies to ensure consistency and integrity of core datasets.
- Collaborate with business stakeholders and data stewards to design semantic models and dimensional structures that support enterprise reporting and analytics.
- Provide guidance and support to junior team members providing guidance on technical design, documentation standards, and troubleshooting methodologies.
- Conduct architecture and solution reviews, ensuring data engineering solutions are well-documented, maintainable, and aligned with organizational goals.
- Monitor and enhance performance of data workloads, proactively identifying bottlenecks and implementing improvements to ensure reliability and scalability.
- Automate and optimize data engineering workflows, including deployment pipelines, monitoring frameworks, and data quality validation.
- Ensure compliance with IT change management, data protection, and disaster recovery policies, maintain detailed records and audit-ready documentation.
- Contribute to strategic planning and roadmap development for data services, evaluating emerging technologies and recommending improvements to the City's data ecosystem.

**You Bring**:

- Completion of a post-secondary degree in Information Technology, Computer Science, Data Management, or a closely related discipline is required; a master’s degree in a related field is considered an asset.
- Required Certifications:

- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Fabric Data Engineer Associate
- Certifications that are considered assets:

- ITIL Foundation (v4)
- Microsoft Certified: Azure Data Fundamentals
- Microsoft Certified: Azure Database Administrator Associate
- Certified Data Management Professional (CDMP)
- Microsoft Certified: Security, Compliance, and Identity Fundamentals
- Microsoft Certified: Azure Solutions Architect Expert
- Cloud Platform Expertise
- Hands-on experience with Azure data services (Synapse, Data Lake, Azure SQL) and Microsoft Fabric
- Skilled in real-time analytics (KQL/Eventstreams), Notebooks, and API integration
- Strong understanding of data quality, metadata management (Azure Purview), and CI/CD practices
- Core Data Engineering & Pipeline Design
- 3+ years designing pipelines with Microsoft Fabric (Dataflows, Lakehouses, Spark, Data Factory)
- Proficient in Python for entity resolution and MDM using tools like Zingg
- Experienced in semantic modeling, ERDs, and Power BI enhancements (DAX, Power Query)
- Foundational Database & Infrastructure Experience
- 8+ years supporting enterprise data platforms; 5+ years in senior SQL Server roles
- Expertise in SSIS, SSRS, T-SQL, performance tuning, and hybrid architecture
- Skilled in security, access control, diagnostics, and automated maintenance
- Addition