Bilingual Etl Specialist

2 weeks ago


Montroyal, Canada Reelcruit Full time

**Job Overview**:
**Responsibilities**:
**Data Extraction**:

- Develop and implement efficient strategies for extracting data from diverse sources, including databases, APIs, flat files, and other structured/unstructured formats.
- Utilize Python and SQL to create scripts and queries for extracting relevant data

**Data Transformation**:

- Design and implement robust data transformation processes to clean, enrich and structure data according to business requirements.
- Use Python for data manipulation and transformation tasks, ensuring data quality and consistency.
- Collaborate with stakeholders to understand data transformation needs and implement solutions accordingly.

**Data Loading**:

- Develop and maintain ETL workflows to load transformed data into target systems, databases or data warehouses.
- Optimize loading processes to achieve maximum efficiency and minimize data latency.
- Ensure data integrity during the loading phase and implement error-handling mechanisms.

**Integration with BI Tools**:

- Integrate ETL processes with Power BI and Tableau to facilitate data visualization and reporting.
- Collaborate with business analysts and data scientists to create meaningful dashboards and reports based on the extracted and transformed data.

**Documentation and Reporting**:

- Document ETL processes, workflows, and data mappings for reference and future enhancements.
- Generate regular reports on ETL job status, performance metrics and data quality.

**Requirements**:

- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as an ETL Specialist with a focus on Python, SQL, Power BI and Tableau.
- Strong proficiency in Python scripting and SQL query optimization.
- Experience in designing and implementing ETL processes for complex data scenarios.
- Familiarity with data modeling and database design concepts.
- Knowledge of best practices for data quality, data governance, and data security.
- Excellent communication and collaboration skills to work effectively with cross-functional teams.

**Salary**: $80,000.00-$90,000.00 per year

**Benefits**:

- Company pension
- Dental care
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- RRSP match
- Vision care
- Wellness program

Schedule:

- Monday to Friday

Application question(s):

- The salary for this role is between 80-90k, is that acceptable to you?

**Experience**:

- SQL: 3 years (required)
- Tableau: 3 years (required)
- Power BI: 3 years (required)
- Python: 3 years (required)

**Language**:

- Bilingual (required)

Ability to Commute:

- Mont-royal, QC H3R 3L5 (required)

Work Location: In person



  • Mont-royal, Canada Clearit Customs Brokers Inc. Full time

    **Key Responsibilities**: - Answer all customer queries through our Online platform/phone lines and allocate accordingly to Customs Team - Prepare, analyze and finalize quotes to customers - managing receivables - manage incoming referral requests **What we are looking for**: - Highly organized individual with strong attention to detail - Ability to...


  • Mont-royal, Canada Cluster Pos Full time

    Cluster POS is a leading provider of innovative point-of-sale (POS) hardware and software solutions tailored to the needs of businesses across various industries. With a focus on delivering seamless and efficient transactions, we empower our clients to elevate their customer experience and drive operational excellence. As we continue to expand our presence...


  • Mont-royal, Canada Groupe Marcelle Full time

    Located in Montreal, Quebec, the Canadian company Groupe Marcelle is a leader in the cosmetics industry. With the highest standards of quality and excellence, Groupe Marcelle develops, manufactures, and distributes care and makeup products and accessories with a portfolio of four brands: Marcelle, Watier, Annabelle and CW Beggs and Sons. At Groupe Marcelle...


  • Mont-royal, Canada PSB Boisjoli LLP Full time

    _**Aperçu du cabinet**_ Situé à Montréal et comptant une équipe de plus de 250 personnes, PSB Boisjoli est l’un des plus importants cabinets comptables du Québec. Le cabinet favorise une approche fondée sur le soutien mutuel et l’esprit de collaboration entre les associés et les membres des équipes. Il offre également des salaires et des...


  • Mont-Saint-Hilaire, Canada BBA Full time

    **Type of position**: Regular **Your future role on our team** We’re seeking a dynamic Procurement Specialist who has leadership skills. You must feel comfortable working in a consulting environment to meet the growing needs of our collaborators and clients. **With us, you’ll get the opportunity to...** - Be constantly aware of project needs and the...

  • Procurement Specialist

    14 hours ago


    Mont-Saint-Hilaire, Canada BBA Full time

    **Type of position**: Regular **Your future role on our team** We’re seeking a dynamic Procurement Specialist who has leadership skills. You must feel comfortable working in a consulting environment to meet the growing needs of our collaborators and clients. **With us, you’ll get the opportunity to...** - Be constantly aware of project needs and the...


  • Mont-Saint-Hilaire, Canada BBA Consultants Full time

    Type of position: Regular Your future role on our team We’re seeking a dynamic Procurement Specialist who has leadership skills. You must feel comfortable working in a consulting environment to meet the growing needs of our collaborators and clients. With us, you’ll get the opportunity to... Be constantly aware of project needs and the...


  • Mont-Saint-Hilaire, Canada BBA inc. Full time

    Type of position: RegularLooking to advance your career with us?Join BBA to be part of a team of talented individuals who are passionate about success and driven to exceed expectations in delivering the best to our clients. You'll also have the opportunity to work on challenging and rewarding projects, guiding and supporting colleagues who share a commitment...


  • Mont-Saint-Hilaire, Quebec, Canada BBA inc. Full time

    Type of position: TraineeYour future role on our teamWithin the Digital Power Systems group, you'll join a multidisciplinary team composed of electrical, automation and telecommunications specialists. Equipped with a lab and test equipment, the group is centred around executing digitalization and modernization projects in the control, protection and...


  • Mont-Saint-Hilaire, Canada BBA inc. Full time

    Type of position: TraineeYour future role on our teamWithin the Digital Power Systems group, you'll join a multidisciplinary team composed of electrical, automation and telecommunications specialists. Equipped with a lab and test equipment, the group is centred around executing digitalization and modernization projects in the control, protection and...

  • General Bba Template

    13 hours ago


    Mont-Saint-Hilaire, Canada BBA inc. Full time

    **Type of position**: Regular Your future role on our team Help prepare plans, specifications and reports; Design power line and substation structures; Perform other technical functions to support project deliver; Assist with site inspections and surveys; Help plan, organize and assess work; Help prepare estimates, bills of quantities, schedules, budgets,...


  • Mont-Saint-Hilaire, Canada BBA Full time

    **Type of position**: Regular You’ll be part of our team specialized in electrical apparatus installation. You’ll work with experts and be exposed to a variety of situations to develop your technical skills in designing electrical rooms, cable racks and substations for various industrial clients. Your role as Installation Technician will be to...


  • Mont-Saint-Hilaire, Canada BBA Full time

    Working for BBA means being part of a team of talented people who have the passion to succeed and the drive to excel in order to provide first-class service to clients. Recognized for its extensive field experience and cutting-edge expertise, BBA has been delivering a comprehensive range of consulting engineering services for 40 years, from studies and...


  • Mont-Saint-Hilaire, Canada BBA inc. Full time

    **Type of position**: Regular Your future role on our team You’ll contribute to projects involving renewable energy, mining industries as well as plant services in the pulp and paper and data centre sectors. You’ll work jointly with our engineers, technicians and designers and will take care of layouts for our various projects. With us, you’ll get...


  • Mont-Saint-Hilaire, Canada BBA inc. Full time

    **Type of position**: Regular An overview of your future role at BBA Enter various supplier invoices into the accounting software and ensure the firm’s various projects and expense categories are properly charged. Reconcile and enter transactions made using the firm’s credit cards. Verify and process expense reports. Obtain approval of invoices and...


  • Mont-Saint-Hilaire, Canada BBA Full time

    **Type of position**: Regular **Your future role on our team** You’ll contribute to projects involving renewable energy, mining industries as well as plant services in the pulp and paper and data centre sectors. You’ll work jointly with our engineers, technicians and designers and will take care of layouts for our various projects. **With us, you’ll...


  • Mont-Saint-Hilaire, Canada BBA Consultants Full time

    Type of position: Trainee Your future role on our team Within the Digital Power Systems group, you’ll join a multidisciplinary team composed of electrical, automation and telecommunications specialists. Equipped with a lab and test equipment, the group is centred around executing digitalization and modernization projects in the control, protection...


  • Mont-Saint-Hilaire, Canada BBA Full time

    **Type of position**: Trainee **An overview of your future role at BBA** Our team is spread out across Canada, mainly in our Mont-Saint-Hilaire (head office), Toronto and Edmonton offices. Our multidisciplinary team is comprised of specialized engineers, technicians and support staff and includes professionals from junior to expert levels. Heavy industry...


  • Mont-Saint-Hilaire, Canada BBA Full time

    **Type of position**: Regular **An overview of your future role at BBA** As a member of the Finance and Accounting department, you’ll be required to: - Process purchase order requests. - Create purchase orders in the enterprise resource planning (ERP) software and send them to suppliers. - Ensure the firm’s various projects are properly charged. -...


  • Mont-Saint-Hilaire, Canada BBA Full time

    **Type of position**: Regular **Your future role on our team** As a drafter, you will be contributing to projects related to mining processes, mechanics, industrial piping and plant systems (water, steam, compressed air). You will participate in preparing various types of drawings, such as fluid flow diagrams (PFDs), piping and instrumentation diagrams...