Data Engineer

Loopio Inc.; United States; Remote; USD 110,000 - 165,000; Full time

Benefits offered by this job

Health benefits

Remote work setup

MacBook provided

Home office stipend

Learning budget

Job summary

Loopio is seeking an experienced Data Engineer to build and support data pipelines and analytics. You will partner with ML Engineers and Data Scientists to enable data-driven decision making and embed data solutions in Loopio’s platform.

You’ll lead data integration across clickstream, relational and unstructured data, while advancing a scalable data lake and warehouse using Databricks and AWS tools, fostering collaboration with product and RevOps teams.

Qualifications

• Build and support data pipelines with scalable data platforms and ETL workflows.
• Promote data-driven decisions across the org via data expertise.
• Partner with ML Engineers and Data Scientists to enable analytics and modeling.
• Experience with Databricks, AWS Redshift, S3, RDS and BI tools.
• StrongSQL, Python, and data warehousing knowledge.
• Ability to work in a fast-growing agile environment.

Responsibilities

• Build, evolve and scale data platforms and ETL pipelines.
• Integrate diverse data sources into the data lake and warehouse.
• Develop and maintain a feature store for analytics and modeling.
• Collaborate with stakeholders to align data needs with business goals.
• Create predictive models with data scientists to drive insights.
• Orchestrate pipelines with Airflow and Databricks Jobs.
• Ensure data reliability, quality, and governance across systems.

Skills

SQL

Python

ETL

Data Modeling

Big Data

Cloud Architecture

Data Lakes

Collaboration

Mentorship

Education

Bachelor's degree in CS/Engineering

Tools

Databricks

Airflow

Jenkins

Redshift

S3

RDS

Quicksight

Tableau

Job description

Take your career to new heights with Loopio!

Loopio’s Data Engineering Team works together on a mission to transform the RFP response process into a rapid and seamless experience. Our team works across all platform portfolio features and delivers innovative solutions where it matters the most for our customers.

We are looking for an experienced Data Engineer to build and support the delivery of data pipelines, used for analytics both internally by Loopio’s teams, embedded within the Loopio platform for our customers. Our perfect candidate has deep technical skills and is comfortable working in an evolving technology infrastructure. This is a unique opportunity to join a growing team of creative and passionate individuals committed to solving real world problems. You will empower engineers, product, and data scientists with tools that enable and streamline data-driven decision making, analysis, and feature development.

You will partner closely with ML Engineers, Architects and Data Scientists, Product Managers, and other business stakeholders to help us take Loopio’s data value to the next level.

Note: This is an existing vacancy on the team

What You’ll Be Doing

• Be responsible for building, evolving and scaling data platforms and ETL pipelines, with an eye towards growth of our business and reliability of our data
• Promote data-driven decision making across the organization through data expertise
• Build advanced automation tooling for data orchestration, evaluation, testing, monitoring, administration, and data operations
• Integrate various data sources into our Datalake, including clickstream, relational, and unstructured data
• Developing and maintaining a feature store for use in analytics & modeling
• Partner with data scientists to create predictive models to help drive insights and decisions, both in Loopio’s product and internal teams (RevOps, Marketing, CX)
• Work closely with stakeholders within and across teams to understand the data needs of the business and produce processes that enable a better product and support data-driven decision-making
• Build scalable data pipelines using Databricks, and AWS (Redshift, S3, RDS), and other cloud technologies
• Build and support Loopio’s data warehouse (Redshift) and data lake (Databricks deltalake)
• Orchestrate pipelines using workflow frameworks / tooling

What You’ll Bring to the Team

• Strong understanding of database concepts, modeling, SQL, query optimization
• Ability to learn fast and translate data into actionable business results
• Experience in either Python (preferrably), or other common programming language (Scala, Java) for data manipulation purposes
• Hands-on experience with the AWS services (RDS, S3, Redshift, Glue, Quicksight, Athena, ECS)
• Strong understanding of relational databases (RDS/Aurora) and NoSQL engines (Redis/DynamoDB/Neptune/etc).
• Experience with ETL & Data warehousing, building Inmon/Kimball/Data Vault models
• Experience with MPP frameworks such as Spark / Flink
• Experience with CI/CD tools (Jenkins) and pipeline orchestration tools (Databricks Jobs, Airflow)
• Experience working with data visualization and BI platforms (Quicksight, Tableau, Sisense, etc)
• Experience working with Clickstream data (Amplitude, Pendo, etc)
• Experience in a high growth agile software development environment
• Experience building and supporting large-scale systems in a production environment
• Strong communication, collaboration, and analytical skills
• Demonstrated ability to work with a high degree of ambiguity, and leadership within a team (mentorship, ownership, innovation)
• 3+ years experience in a data engineering or a similar role
• Ability to clearly communicate technical roadmap, challenges, and mitigation

Bonus Qualifications

• Experience with container orchestration (leveraging tools like Docker, ECS, Kubernetes)
• Experience working with BI PaaS / SaaS solutions
• Experience with Natural Language Processing techniques
• Experience in AI-augmented SDLC
• Experience with graph-like data and corresponding data engines (Neo4J, Neptune, GraphFrames)

Where You’ll Work

• Loopio is a remote-first workplace because we recognize the advantages of working flexibly. We are HQ’d in Canada, with established hub regions around the world from which we hire.
• Our employees (or Loopers, as we call ourselves!) live and work in Canada (British Columbia and Ontario), London, and India (specifically in Gujarat, Maharashtra, and Bengaluru).
• The majority of our team is based in ON and BC, which means these employees live and work remotely within a 300km radius of Toronto (within Ontario) and Vancouver (Within BC).
• We offer flexible co-working locations available to Loopers in ON and BC. Those based in ON have the option of working out of our convenient co-working space located in the heart of Downtown Toronto and a 12-minute walk from Union Station. BC Loopers have the option to work centrally in Vancouver. It is whatever works best for you!
• You’ll collaborate with your teams virtually across the UK, India, and North America (we’re just a Zoom call and Slack message away!) with core sync hours and focus time for headsdown work during the workday
• We encourage asynchronous collaboration to effectively work as a global #OneTeam!

Why You’ll Working at Loopio

• Your manager supports your development by providing ongoing feedback and regular 1-on-1s, we leverage Lattice for our 1:1s and performance conversations
• You will have the opportunity to elevate your craft and the opportunity to explore your creativity, with a dedicated professional mastery allowance for more learning support! We encourage experimentation and innovative thinking to drive business impact.
• We offer a wide range of health and wellness benefits to support your physical and mental well-being, starting day 1 with Loopio.
• We’ll set you up to work remotely with a MacBook laptop, a monthly phone and internet subsidy, and a work-from-home budget to help get your home office all set up.
• You’ll be joining a supportive culture that has thoughtfully built out opportunities for connections in a remote first environment.
• Participate in townhalls, AMA (Ask-Me-Anything), and company celebrations to celebrate the big wins and milestones as #oneteam!
• Our four Employee Resource Groups offer opportunities for employees to learn and connect year-round.
• You’ll be a part of an award-winning workplace with an opportunity to make a big impact on the business.

Whether or not your experience checks off all the boxes on a job posting, we still encourage you to apply to ensure that your application receives a review from our team. We understand that a resume can only showcase so much during the applicant stage, so we’ve created prompts in the application for you to share more about yourself. If you’ve made a career transition (or a few!), you’re self taught in a new role, or you have skills/experience you’d like to highlight, we want to hear more about what you could bring to the table.

AI in Recruitment At Loopio, we leverage artificial intelligence (AI) technology to enhance our recruitment process. These tools assist with tasks such as resume screening, drafting preliminary job descriptions, generating initial interview questions, transcription and occasionally sourcing prospective candidates. However, AI is never used to make final hiring decisions; our use of AI serves to support repetitive and administrative tasks in order to streamline our hiring and recruitment workflows. We are committed to the responsible use of AI in our hiring practices, prioritizing both an improved candidate experience and operational efficiency. Our standardized hiring practices remain focused on reducing biases, with all key hiring decisions solely made by our team. We continuously review and refine our hiring practices to align with industry best practices and evolving legal guidelines

AI Usage in Interviews The Loopio interview process is designed to help we better understand your professional experiences, as well as your unique perspective and approach to delivery and collaboration. To ensure a fair and accurate assessment, we expect candidates to refrain from using AI-generated content to produce responses to our interview questions during the live interview, as our goal is to evaluate your own knowledge and problem-solving abilities - not those of an AI assistant. If AI-generated responses are identified during the interview, Loopio reserves the right to disqualify candidates from the interview process.

For specific roles that include a take-home assignment, our AI Interviewee Policy allows the use of AI for initial support; however, the final submission must be a true reflection of your personal insights, skills and decision-making.

Loopio is an equal opportunity employer that is deeply committed to building equitable workplaces that are diverse and inclusive. We actively encourage candidates from all backgrounds and lifestyles to consider us as a future employer. Please contact a member of our Talent Experience team ([e-mail]) should you require accommodations at any point during our virtual interview processes.