Talent.com
No longer accepting applications
Data Engineer

Data Engineer

LeverageTek Staffing SolutionsGreater Ottawa Metropolitan Area, Canada
23 days ago
Job description

Data EngineerLocation : Ottawa, ONWork Type : Full-timeLeverageTek is actively seeking a Data Engineer for a 2-year term role with its Ottawa-based customerWork LocationThe successful candidate will be required to work 2x / week on-site at the customer headquarters in Ottawa, ONSecurity RequirementMust be eligible for Enhanced Reliability security clearanceKey TasksUnder the direction of Senior Manager, Data and Analytics Architecture , the Data Engineer will be responsible for the following : Implement an end-to-end analytics solution using Microsoft Fabric to ingest data from various sourcesCreate semantic modelsEnable dashboard / visualization creation for the business teamAssist the data management team in implementing data governance frameworks, policies, and controlsDesign and implement data pipelines in Microsoft Fabric, including source mapping and documentationCreate and optimize semantic models including defining business entities, relationships, and security requirementsImplement data governance policies including classification, sensitivity, access controls, and quality validation through Microsoft Purview integrationSet up development, testing, and production environmentsCreate comprehensive technical documentation covering configurations, data models and business rulesKey Qualifications5+ years experience in application development, data analysis, database designExperience with Microsoft data platforms (Azure Synapse, Azure Data Factory, Power BI, SSIS) Knowledge and experience with Microsoft FabricQualificationsUniversity degree or College diploma in Business Administration, Computer Science, Computer Engineering, Information Technology or relatedDatabase platform, data modeling, data quality frameworkEnd-to-end data pipeline development and optimizationArchitecture implementationPower BI semantic model development (Advanced DAX, Star schema) Multi-platform data integrationTechnical documentationApplying policies, procedures, and regulationsClient focus, organizational knowledge, communication, innovation,Cross-functional team collaboration, teamwork and leadershipAssetsMS Fabric, Azure Synapse, Data Factory, Power BI, PowerShell, Azure Data LakeT-SQL, Spark SQL, Python / PySpark, DAX, Power Query (M)Version control (Git) & DevOps CI / CDLakehouse and Medallion Architecture Star schema & Data vaultSQL server, Azure SQLOracle databaseDataverseData quality frameworks and Metadata management ETL / ELT pipeline design and implementation Basic security implementation (RLS) Microsoft Fabric Analytics Engineer certification Business intelligence visualization BenefitsHealth Benefits : Drug coverage, healthcare spending account, virtual care (telemedicine), Employee and Family Assistance Program, mental health support, travel insurance, dental, vision, life insurance, disability insurance and accidental death and dismemberment coverage.Work Life Balance : A wide range of paid / unpaid leave, including paid vacation, family related leave and personal days.Retirement Planning : A Group Savings PlanLearning and Development : Payment of professional association memberships, online learning opportunities including a LinkedIn Learning subscription and second language training.Perks : Discounts through CF One Member AppreciationAbout LeverageTek Staffing SolutionsFounded in 2003, LeverageTek provides end-to-end, cross-functional staffing solutions throughout North America. We are a trusted partner to leading private and public sector organizations and experts in talent solutions that create optimal business outcomes.Don’t let our name fool you. Our roots are in technology, but we are also a proven leader in accounting and finance, sales and marketing, human resources, supply chain, and legal talent acquisition. We offer contract and permanent staffing, executive search, talent mapping, management consultancy, and contractor payroll management. LeverageTek is an equal opportunity employer. We offer a welcoming and inclusive environment in service to one another, our customers, the candidates we represent, and the diverse communities we call home. We do all of this with kindness, empathy, and respect for each other. LeverageTek is committed to employment equity and creating a diverse and inclusive workplace. We welcome applications from all qualified individuals regardless of race, religion, gender, national origin, age, disability, and marital status.Accessibility accommodations are available upon request