Join Firmex as a Data Engineer

Firmex, a global software-as-a-service leader headquartered in Toronto, Canada, is offering an exciting opportunity to join our team. Known worldwide for our trusted Firmex VDR service, we have facilitated the secure sharing of confidential documents for due diligence, litigation, and compliance for over 140,000 companies. We are looking for a Data Engineer to contribute to our Information Management & Analytics program.

About the Role

As a Data Engineer at Firmex, you will be instrumental in designing and building data processes within our Firmex Business Intelligence Data Warehouse (FBI DW). The FBI DW is crucial for providing insights that drive customer and product decision making across all departments at Firmex.

Key Responsibilities

Data Requirements Gathering

Collaborate with internal business and technology teams to gather and interpret requirements, ensuring accurate data models and specifications.

Data Modeling & Data Specifications

Work with team members to design, document, and build S3, Staging, and Redshift tables to support reporting and analytics projects. Document transformation rules in a source-to-target matrix.

Building & Supporting Data Pipelines in AWS Environment

Develop code for extraction, transformation, and loading of data from various sources using Python, APIs, Airflow, and AWS services (EC2, S3, RDS, Redshift, Glue).

AWS Data & Analytics Infrastructure Support

Configure and maintain AWS Data & Analytics Infrastructure, supporting EC2, S3, RDS, Redshift, Glue, Airflow, and Tableau on AWS.

Required Skills & Experience

• Strong experience in creating and maintaining data pipelines and ETL/ELT processes using Python, SQL, and Apache Airflow
• Proficient in Python and SQL programming (reusable Python scripts, SQL stored procedures/scripts, APIs, functions)
• Experience with AWS stack (SQS, Glue, S3, Lambda, Apache Airflow, RDS, Redshift)
• Ability to design and build data lakes, relational databases, and data warehouses like Snowflake/Redshift
• Knowledge of configuring and maintaining AWS Data & Analytics Infrastructure (e.g., CloudFormation templates)
• Strong interpersonal and analytical skills with an eye for detail
• Experience with BI tools like Tableau and Looker is an asset
• Demonstrated ability to quickly learn new technologies
• Excellent time management, initiative, and self-direction

Note: The "Core Duties" summary encompasses essential responsibilities and is not exhaustive. Firmex may update duties as necessary.

Join Our Inclusive Team

Firmex prides itself on fostering an equitable, diverse, and inclusive environment guided by core values of respect and collaboration. We encourage applications from BIPOC, LGBTQIA2S+, women, individuals with disabilities, internationally trained professionals, and historically disenfranchised groups. We are committed to providing accommodations or adjustments as needed throughout the interview process and beyond.

Company Name: Firmex

Job Title: Data Engineer (10-Month Contract)