Data Engineer

About Loopio and Role Overview

Join Loopio's Data Engineering team dedicated to revolutionizing the RFP response process into a fast and seamless experience. The team focuses on developing innovative data-driven solutions across the platform to empower internal teams and customers alike. This position offers an exciting opportunity to contribute to a growing group of skilled professionals committed to solving practical challenges and enabling data-driven decision-making.

Key Responsibilities

• Design, develop, and scale data platforms and ETL pipelines with a focus on business growth and data reliability.
• Advance the use of data throughout the organization by serving as a data expert.
• Create sophisticated automation tools for data orchestration, testing, monitoring, and operations.
• Integrate multiple data sources—including clickstream, relational, and unstructured data—into the company's data lake.
• Build and maintain a feature store to support analytics and modeling.
• Collaborate with data scientists to develop predictive models for both product features and internal business teams.
• Engage with cross-functional stakeholders to identify data requirements and deliver solutions that enhance products and facilitate data-driven strategies.
• Develop scalable data pipelines utilizing Databricks and AWS technologies such as Redshift, S3, and RDS.
• Maintain Loopio’s data warehouse (Redshift) and data lake (Databricks Delta Lake).
• Manage workflow orchestration using various pipeline frameworks and tools.

Required Qualifications and Skills

• Strong expertise in database concepts including data modeling, advanced SQL, and query optimization.
• Quick learner able to convert data into actionable business insights.
• Proficiency in Python preferred, or other languages such as Scala or Java, for data manipulation tasks.
• Hands-on experience with multiple AWS services including RDS, S3, Redshift, Glue, Quicksight, Athena, and ECS.
• Knowledge of relational (RDS/Aurora) and NoSQL databases (Redis, DynamoDB, Neptune, etc.).
• Experience with ETL processes and data warehousing techniques such as Inmon, Kimball, or Data Vault.
• Familiarity with massively parallel processing (MPP) frameworks like Apache Spark and Flink.
• Experience with CI/CD pipelines and orchestration tools such as Jenkins, Databricks Jobs, and Airflow.
• Skill in leveraging data visualization and BI platforms like Quicksight, Tableau, or Sisense.
• Experience working with clickstream data tools (e.g., Amplitude, Pendo).
• Comfortable working in fast-paced, agile software development environments.
• Proven ability to build and maintain large-scale production systems.
• Strong communication and teamwork skills with a capacity to lead, mentor, and innovate.
• Minimum of three years of experience in data engineering or a related position.
• Ability to clearly communicate technical strategies, challenges, and solutions.

Preferred Additional Skills

• Experience with container orchestration technologies such as Docker, ECS, and Kubernetes.
• Familiarity with BI as a Service (PaaS/SaaS) solutions.
• Knowledge of Natural Language Processing (NLP) techniques.
• Exposure to AI-supported software development lifecycle practices.
• Experience with graph databases and engines like Neo4J, Neptune, or GraphFrames.

Work Culture and Location

• Loopio is a remote-first company with major hubs primarily in Canada (British Columbia and Ontario), the UK, and India.
• Employees can enjoy flexible working arrangements including options for coworking spaces located in Downtown Toronto and central Vancouver.
• Team collaboration happens virtually across global locations with structured core hours and emphasis on asynchronous teamwork.

Employee Experience and Benefits

• Regular, supportive one-on-one meetings and ongoing feedback are a priority for professional growth.
• Dedicated resources for professional skills development including a mastery allowance for further learning.
• Comprehensive health and wellness coverage available from day one.
• Remote setup support including a MacBook, monthly subsidies for phone and internet, and office arrangement budgets.
• Engaging company culture with frequent virtual events such as townhalls, AMAs, and employee resource groups for networking and learning.
• Recognition as an award-winning workplace that values impactful contributions.

Equal Opportunity and Recruitment Practices

Loopio is deeply committed to diversity, equity, and inclusion, encouraging applications from candidates of all backgrounds. Candidates are urged to apply even if they do not meet all criteria, especially those from underrepresented groups. The recruitment process incorporates AI tools for administrative tasks but ensures all hiring decisions are made by humans and candidates are asked to submit their own original work, particularly in interviews and assignments.

Compensation

The estimated salary range for this position is between CA$103,500 and CA$140,000.