Data Engineer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
What You'll Do
- Develop ETL pipelines using Python to extract data from APIs, Excel files, databases, and other source systems
- Load and manage data in SQL Server databases
- Develop and optimize stored procedures, views, functions, and SQL queries
- Implement data transformation, validation, and business rules within SQL Server
- Create and maintain Tableau dashboards, reports, and visualizations
- Ensure data quality, integrity, and performance across the data pipeline
- Collaborate with business stakeholders to gather requirements and deliver reporting solutions
- Support production deployments, troubleshooting, and ongoing enhancements
- Strong Python development experience with a focus on ETL pipeline development
- Solid SQL Server skills including stored procedures, views, functions, and query optimization
- Hands-on experience with Tableau for dashboard development and reporting
- Experience integrating data from REST APIs, Excel, CSV, and other source systems
- Strong understanding of data transformation, validation, and analytics reporting
- Good communication and stakeholder engagement skills
- Eligibility for a mandatory background check
- Experience in banking or financial services data environments
- Familiarity with data governance and data quality frameworks
- Prior experience supporting production data pipelines in a regulated environment
More about this job
Responsibilities
Develop and maintain Python-based ETL pipelines that integrate data from APIs, Excel files, databases, and other sources, and manage and optimize data solutions in SQL Server. Build Tableau dashboards and reporting solutions, ensure data quality and pipeline performance, and support stakeholders, production deployments, troubleshooting, and ongoing enhancements.
Requirements
The role requires strong Python ETL development skills, solid SQL Server expertise, and hands-on Tableau dashboard and reporting experience. Candidates should be experienced integrating data from varied sources and applying data transformation and validation, communicate effectively with stakeholders, and be eligible for a mandatory background check.
Skills
- Python
- SQL Server
- ETL Pipeline Development
- Tableau
- Stored Procedures
- Views
- Functions
- SQL Query Optimization
- REST API Integration
- Data Transformation
- Data Validation
- Data Quality
- Data Integrity
- Reporting
- Stakeholder Engagement
- Production Support
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Finance & Accounting
Keywords
- Python
- SQL Server
- ETL
- Tableau
- Stored Procedures
- Views
- Functions
- SQL Query Optimization
- REST APIs
- Excel
- CSV
- Data Integration
- Data Transformation
- Data Validation
- Business Rules
- Data Quality
- Data Integrity
- Analytics Reporting
- Dashboards
- Data Pipelines
- Production Deployments
- Stakeholder Requirements
- Banking
- Financial Services
- Data Governance
- Regulated Environment
- Background Check