Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.

A

Data Engineer

alimentiv-2 · 30+ days ago

London, Ontario

Negotiable

Full-time

Continue

By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.

The Data Engineer will build and operationalize data necessary for enterprise data and analytics initiatives. This role will build, manage and optimize data architecture and pipelines in accordance with industry standard practices and using industry standard tools, and will move these data pipelines effectively into production for data and analytics use cases across the organization. The incumbent will ensure compliance with data governance and data security requirements while creating, improving and operationalizing these integrated and reusable data pipelines and analytical models that will support and promote self-service analytics. Will occasionally provide support to end users on the use of data visualization solutions. Responsible for maintaining and making recommendations to enhance technology as the needs of our client’s change.

Data & Analytics

Design, build and maintain data pipelines (i.e. data flow from data sources to integration to consumption for specific use cases).
Develop data models (conceptual, logical and/or physical) as required.
Manage metadata using data preparation, integration and AI-enabled tools and techniques.
Drive automation in data integration. Recommend and lead the implementation techniques and architectures to automate the most-common, repeatable and tedious data preparation and integration tasks partially or completely to minimize manual and error-prone processes.
In collaboration with functional leaders, identify the company’s inefficiencies, inaccuracies, missed opportunities, other issues and report on the recommended improvements to the executive team.
Provide technical leadership for Azure platform by directing and prioritizing the work of others on the team related to Athena.
Act as a subject matter expert for the Azure platform.

Stakeholder Engagement

Assist cross-functional groups, Business analysts, and other stakeholders to gather, define and refine their data requirements for various initiatives.
Propose appropriate (and innovative) data ingestion, preparation, integration and operationalization techniques in optimally addressing stakeholder requirements.
Assess ways to further leverage existing systems and recommend methods for streamlining data flow and data integration.
While identifying and evaluating new projects or requests for enhancements, work with the functional leader to determine the project cost, timeline, goals and feasibility and then support the project through completion.

Data Compliance & Governance

Work with corporate leadership to manage and promote compliance with the corporate data strategy
Collaborate with data stewards or appropriate stakeholders to develop policies to ensure the responsible use of data by users and consumers.
Lead the development and maintenance of documentation and the data catalog for Alimentiv data assets.
Promote the available data and analytics capabilities and expertise to business unit leaders and educate them in leveraging these capabilities in achieving their business goals.
Ensure data or software solutions continue to meet customer needs by capturing changes in requirements and making corresponding updates to existing software or data analytics.

Qualifications

A minumum of a Bachelor's Degree + 4-6 years of related experience.
Core Technical Skills:

Microsoft SQL Server:

5+ years of experience in SQL Server (2008/2012/2016) development and administration.
Proficient in writing complex queries, stored procedures, and optimizing performance.
Experience with database backup, recovery, replication, and performance tuning.

Azure Data Platform:

Strong experience with Azure services including Azure SQL Database (PaaS) and Azure SQL VM (IaaS).
Hands-on experience in migrating on-premises databases to Azure.

ETL Tools:

Proficient with Azure Data Factory (ADF) for orchestrating data pipelines.
Experience with other ETL tools like Matillion, including error handling, logging, and monitoring.

Azure Synapse Analytics:

Experience with building and optimizing data warehouses in Azure Synapse.
Proficient in performance tuning, data partitioning, and loading large data sets.

Power BI:

Experience in developing reports and dashboards using Power BI for business analytics.

Additional Technical Skills

System Administration:

Proficient in managing Windows Servers (2016/2012/2008) in a production environment.
Experience in SAN network environments and RAID configuration.

Scripting:

Experience with scripting languages such as PowerShell, Bash, and Python for automation and configuration management.

Database Monitoring & Tools:

Experience with monitoring tools like Redgate, Idera Diagnostic Manager, SolarWinds for SQL Server performance monitoring and troubleshooting.
Expertise in using SQL Server Profiler, SSMS, and SQL Sentry.

Migration Experience

Cloud Migrations:
Experience in cloud migration projects, specifically migrating databases from on-premises environments to Azure.
Familiarity with DevOps procedures for cloud architecture in both AWS and Azure environments.

Data Management & Reporting

SSIS and Data Warehousing:

Ø Experience in designing, developing, and deploying SSIS packages in data warehouse environments.

Ø Performance tuning in SSIS packages using Row Transformations and involved in error handling and logging.

Reporting:

Ø Developed custom SQL Server Reporting Services (SSRS) reports for monitoring job performance.

Ø Experience in creating interactive reports and dashboards using Power BI.

Health Sector-Specific Requirements

Regulatory Compliance:
Understanding of health sector regulations and compliance standards such as HIPAA for data security and privacy.
Data Sensitivity:

Ø Experience working with highly sensitive and protected health information (PHI) in a secure cloud environment.

Behavioral and Situational Competencies

Problem-Solving and Troubleshooting:

Ø Demonstrated experience in identifying and resolving performance bottlenecks in SQL and Azure environments.

Ø Expertise in troubleshooting complex issues and implementing solutions in high-pressure scenarios.

Collaboration and Teamwork:

Ø Proven ability to collaborate with DevOps, data engineering, and development teams in a fast-paced, cross-functional environment.

Ø Experience working with business stakeholders to gather requirements and translate them into technical solutions.

Project Management and Leadership:

Ø Experience in leading small-to-medium-sized database migration or cloud infrastructure projects.

Ø Ability to manage timelines, deliverables, and resource allocation for Azure migration projects.

Certifications (Preferred)

Microsoft Certified: Azure Data Engineer Associate
Microsoft Certified: Azure Fundamentals
Microsoft Certified: SQL Server Specialist

•

Last updated on Oct 15, 2024

About the company

A

alimentiv-2

More jobs at alimentiv-2

Analyzing

Clinical Operations Lead

New South Wales

·

30+ days ago

Clinical Operations Lead

·

30+ days ago

Medical Writer

Toronto, Ontario

·

30+ days ago

Sr. Business Analyst

Toronto, Ontario

·

30+ days ago

Sr. Business Analyst$49k+

Atlanta, Georgia

·

30+ days ago

More jobs like this

Analyzing

Data Engineer

urbanlogiq

Vancouver, British Columbia

·

30+ days ago

Full Stack Blockchain Developer

ND

NDAX · Cryptocurrency exchange platform

Calgary, Alberta

·

30+ days ago

WEB - Analyste QA intermédiaire / Intermediate QA analyst (Star Citizen)

turbulent

Remote

·

30+ days ago

Software Engineer - DevOps

7

7647

Vancouver, British Columbia

·

30+ days ago

Conseiller en architecture d'integration applicatif

T

tehora

Remote

·

30+ days ago

UI/UX Designer

S

simms

Toronto, Ontario

·

30+ days ago

Data Engineer

T

two95-international-inc-3

Remote

·

30+ days ago

Blockchain Architect

D

dhjdnwh4qm62pb5vm2o4tbd72ej7oa01f47beu0d9d984ckrwi58r2ocg36n82t5

Vancouver, British Columbia

·

30+ days ago

BIZTALK DEVELOPER

3

3djdnw5yqdh8wl3frr5t6561tvvokq01affwpxt3lcutzo4f8yt1aeiy3msk02or

British Columbia

·

30+ days ago

Sr Backend Software Engineer

B

b6jdnwcpcemgg8el3r9winlpunj8hc038b1vkhowrzxn9gitznreodi38t7rirkp

Mississauga, Ontario

·

30+ days ago

For job seekers

Job searchSearch millions of jobs

LaunchpadNew

Resume to business

Cover Letter StudioGenerate a cover letter

Add to ChatGPTFind and discuss jobs

For employers and recruiters

Resume ScreenerOrganize and rank candidates

Talent PipelinePre-order

Source top talent

Promote a jobReach more candidates

For everyone

Referral programEarn 30% commission

Get mobile appBrowse anywhere

Jobs API

Become a partner

Developed by Blake and Linh in the US and Vietnam.

We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord

Changelog

🚀 LaunchpadNov 27

Create a site and sell services based on your resume.

🔥 Job search dashboardNov 13

Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.

🫡 Cover letter instructionsSep 27

New Studio settings give you control over AI output.

✨ Cover Letter StudioAug 9

Automatically generate cover letters for any job.

🎯 Suggested filtersAug 6

Copilot suggests additional filters above the results.

⚡️ Quick applicationsAug 2

Apply to jobs using info from your resume. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.

🧠 Job AnalysisJul 12

Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.