Data Engineer

IT And Software Development National Capital Region

Key Responsibilities

Lead the design, development, and maintenance of robust data pipelines and workflows.
Write and optimize complex SQL queries, stored procedures, and views for performance and scalability.
Oversee and manage the operational aspects of data stores.
Drive data optimization, performance tuning, and integrity checks.
Manage cloud-based SQL Server (Azure Managed Instance) environments.
Lead the migration of data and systems from SQL Server to Snowflake.
Work with Datalake environments and support data ingestion and transformation processes.
Collaborate with cross-functional teams including data analysts, developers, and business stakeholders.
Provide technical leadership, code reviews, and mentorship to junior team members.

Qualifications

Strong SQL expertise including stored procedures, views, and performance tuning.
Experience in Azure Cloud, particularly with SQL Server Managed Instances.
Hands-on experience with Snowflake and cloud-based data migration.
Familiarity with Datalake architectures and concepts.
Experience with SSIS and/or Crystal Reports is a plus.
Strong problem-solving skills and attention to detail.
Excellent communication and leadership skills.