Lead ETL Engineer - remote

SimplyAnalytics
Posted 2 years ago
We Work Remotely
SimplyAnalytics is a powerful spatial analytics and data visualization application used by thousands of business, marketing, and social science researchers in the United States and Canada. It comes pre-packaged with 200,000+ data variables and allows our users to create maps, charts, tabular reports, and crosstabs. We are passionate about creating outstanding software, and we believe in test driven development, continuous integration, and code review.

As a smaller company, each of our developers has an important role to play - at SimplyAnalytics, you are not just another cog in the wheel, you are an integral member of our team. You will be working on valuable features and making key decisions that impact the direction of the application and the satisfaction of our users. In addition, we provide an excellent work-life balance, with 100% remote work, 20 personal days off, flexible work hours, a collaborative work environment, and quarterly “professional development days” to explore and share your interests with the rest of the team. 

We're looking for a Lead ETL Engineer to process datasets, manage our existing data workflows, develop and maintain ETL pipelines, conduct data related QA, and supervise a small team of ETL developers. You will be creating and maintaining production-quality in-house tools within a large shared code base, and the data you curate will be used by thousands of university students, researchers, and marketing professionals.

The ideal candidate is a self-starter, has a high level of attention to detail, is comfortable asking questions, enjoys working with talented colleagues, and has an interest in analytics and data visualization. 

This is a 100% remote position, our developers can live and work anywhere in Canada or the United States. We will also consider exceptional candidates from other countries in the Americas. This is a full-time salaried position.

Responsibilities:
  • Design, develop, and test ETL related tools and features
  • Process datasets through our ETL pipeline
  • Write high-quality, clean, scalable, maintainable code (e.g., PEP 8, PEP 484)
  • Contribute ideas for new features or improvements to existing features
  • Assist colleagues through code-review, collaboration, and troubleshooting
  • Supervise a team of ETL developers

Required:
  • 5+ years of professional software development work experience
  • 3+ years of experience working with large PHP or Python codebases
  • Comfortable using Linux CLI
  • Data warehousing experience with PostgreSQL
  • Advanced relational database and data manipulation skills
  • Experience with data orchestration platforms (e.g., Dagster, Airflow, or Prefect)
  • Ability to maintain our full data processing stack in PHP and Python
  • Experience using AWS services