Senior Databricks Data Engineer

49 Solutions is seeking Senior Databricks Data Engineers to design, develop and operationalize secure, scalable data pipelines and data products for Government of Canada environments using Databricks, Lakeflow, Delta Lake, Spark, Python and SQL. Responsibilities • Design, build and maintain enterprise data pipelines using Databricks. • Build ingestion and transformation processes using Lakeflow, Lakeflow Connect, Jobs and Auto Loader. • Develop batch and streaming solutions with Apache Spark and PySpark. • Implement raw, cleaned and curated layers using Lakehouse and medallion patterns. • Develop and optimize Delta Lake tables and enterprise data products. • Connect Databricks with cloud, enterprise and on-premises sources. • Modernize legacy ETL/ELT pipelines and data warehouse workloads. • Implement data quality, validation, reconciliation, monitoring and Unity Catalog controls. • Develop reusable engineering patterns and participate in CI/CD and automated deployments. • Support testing, migration, production deployment, runbooks and client knowledge transfer. Requirements Mandatory Qualifications • A minimum of 10 years of professional experience working in the IT industry or performing IT-related roles. • A valid and active Government of Canada Reliability, Secret or Top Secret security clearance. • Significant experience in data engineering, ETL/ELT or data integration. • Demonstrated hands-on Databricks experience. • Strong Python, SQL, Apache Spark and/or PySpark experience. • Experience designing enterprise pipelines and cloud-based data platforms, preferably Azure. • Experience with data quality, troubleshooting and performance optimization. • Experience with Git and modern software development practices. Technical Skills • Databricks • Lakeflow • Delta Lake • Unity Catalog • Apache Spark / PySpark • Python • SQL • ETL/ELT • Batch and streaming processing • Medallion architecture • Azure data services • Git and CI/CD Assets • Lakeflow Connect and Auto Loader • Terraform or Databricks Asset Bundles • Azure DevOps or GitHub • Microsoft Purview • On-premises source integration • Migration from SAS, Synapse, DataStage, DB2, Oracle, SQL Server, Teradata or Netezza • Government of Canada delivery experience • Bilingualism in English and French Certifications Target Certification • Databricks Certified Data Engineer Professional. Candidates who do not currently hold the target certification may still be considered based on their experience. Candidates are not expected to obtain the certification immediately while 49 Solutions is building its prospective team. If a specific certification becomes required for an opportunity, candidates must be willing to obtain it at their own expense before being submitted for that opportunity. Additional Asset Certifications • Databricks EDW/ETL migration training • Databricks Unity Catalog or data governance training • Relevant Microsoft Azure data certifications • Additional advanced Databricks certifications Security Requirement Candidates must hold a valid and active Government of Canada Reliability, Secret or Top Secret security clearance. Location Ottawa, Ontario, Canada. Engagements may be remote, hybrid, or performed at a Government of Canada location. Candidates located in Toronto or Montreal are also encouraged to apply, provided they are willing and able to travel to Ottawa for onsite meetings approximately once per month, as required. Work arrangements will depend on the client, project and security requirements.