Data Engineer (Remote)

Firmex is a global software-as-a-service provider with corporate headquarters in Toronto, Canada. The company’s Firmex VDR service is the world’s most trusted virtual data room, having been used by over 140,000 companies worldwide to share confidential documents for due diligence, litigation and compliance. We also are a remote-first organization, however you have the flexibility to work in the office if you wish.
Firmex is looking to hire a Data Engineer for our Information Management & Analytics program. We are looking for a smart, hardworking individual to design and build processes to move data within our FBI DW (Firmex Business Intelligence Data Warehouse). FBI DW is a key strategic system that provides insight to all of Firmex’s departments for customer and product decision making.

Core Duties of a Data Engineer are:

• Data Requirements Gathering: Work with internal business and technology staff to accurately gather and interpret requirements and specifications to determine appropriate data models and data specifications
• Data Modeling & Data Specifications: 
• Work with various team members to design/document, architect, and build the appropriate S3, Staging, and Redshift tables to support various reporting and analytics projects
• Collect and document the transformation rules in a source to target matrix 
• Build & Support Data Pipelines in AWS environment:  Build the code required for extraction, transformation, and loading of data from a wide variety of data sources using Python, APIs, Airflow, and AWS Service(s) such as EC2, S3, RDS, Redshift, and Glue
• AWS Data & Analytics Infrastructure Support: Configure and maintain the AWS Data & Analytics Infrastructure. (i.e., Data Opps: Support of AWS services EC2, S3, RDS, Redshift, Glue, Airflow, and Tableau on AWS)

What you'll need to be successful here:

• Strong experience in creating & maintaining data pipelines and ETL/ELT processes
• Strong experience coding in Python & SQL (creating reusable Python scripts, SQL stored procedures/scripts, APIs, functions, etc.)
• Experience with AWS stack (SQS, Glue, S3, Lambda, Airflow, RDS, Redshift)
• Experience in building logical and physical design of data lakes, relational databases and data warehouses such as Snowflake/Redshift
• Experience in configuration and maintenance of AWS Data & Analytics Infrastructure is an asset (i.e. knowledge of CF templates)
• Experience with BI Tool(s) such as Tableau & Looker is an asset 
• Good organizational, time management, and prioritization skills
• Strong analytical skills and detail oriented
• Highly flexible with solid interpersonal skills 
• Ability to learn new technologies quickly
• Strong initiative and self-directed

*Note: This is a summary of the duties that are essential to this role and is not an exhaustive list. Firmex reserves the right to add or amend duties as necessary. 
At Firmex, we’re successful because we care about our clients, and our team members share our core values of humour, success, respect and collaboration. We know that success is derived from motivated people who take pride in building a business that makes a difference. 
Firmex is an equal-opportunity employer strongly committed to diversity and inclusion within the workplace.
Firmex welcomes and encourages applications from people with disabilities and can make accommodations on request for candidates throughout all aspects of the hiring process