Senior Data Engineer

 Posted a day ago
     
5-10 years experience
Apply Now

Please mention DailyRemote when applying

AI Summary

Design and maintain stored procedures, SSRS reports, and a customer-facing Postgres data mart. Lead the migration from legacy Go ETL to a modern Snowflake and dbt pipeline while serving as a technical expert for enterprise clients.

Responsibilities

  • Design, optimize, and maintain stored procedures and SSRS reports across the ClubReady reporting environment
  • Own the customer-facing Postgres data mart product serving enterprise clients
  • Co-own migrating from the legacy Go ETL to the new Fivetran → Snowflake → dbt → Postgres pipeline, partnering with the central data team
  • Serve as technical domain expert for assisting data mart customers
  • Triage and resolve customer-reported data discrepancies
  • Author Azure DevOps work items, review pull requests, and operate inside two-week sprints
  • Maintain the internal data dictionary and the external data documentation
  • Tune queries and indexes against very large tables (multi-billion-row scale) where wrong choices have real customer-visible cost
  • Join customer calls directly with enterprise account managers and customer-side data analysts to scope and deliver work

Requirements

  • 5+ years of data engineering or BI development experience with deep T-SQL and SQL Server in a transactional, customer-facing environment
  • Bachelor's degree in Computer Science, Information Systems, Engineering, or related field — or equivalent professional experience
  • Production experience with at least one analytics warehouse stack (Snowflake, BigQuery, or Redshift) and modern ELT tooling (dbt, Fivetran, Airbyte, or similar)
  • Strong query performance instincts: indexing strategy, execution plans, statistics, partitioning, and rewrite patterns for legacy procs
  • Proficiency in SQL and at least one scripting language (Python preferred)
  • Experience with SSRS or another enterprise reporting platform
  • Demonstrated ability to operate as a senior IC: own scope end-to-end without close supervision
  • Excellent written and verbal communication
  • Comfort working directly with external customers and stakeholders (finance teams, account managers, customer-side analysts)

Ideal Candidate Traits

  • Customer-Facing: Comfortable being the technical face of BI to enterprise customers, finance teams, and account managers who don't read SQL
  • Senior IC Mindset: Owns scope end-to-end — writes their own work items, pushes their own PRs, defends their own estimates
  • Performance-Instinctive: Reads execution plans, indexes, and statistics fluently; debugs why a 5-second proc went to 5 minutes without flailing
  • Pragmatic: Comfortable maintaining legacy systems while migrating to new ones; doesn't insist on rebuilds when the runway doesn't support it
  • Accountable/Responsible: Takes initiative on a small team where the customer surface is much larger than the engineering headcount


Preferred Qualifications

Ideal candidates possess:

  • Experience supporting a multi-tenant data product (per-customer schemas, row-level security, tenant onboarding workflows)
  • Postgres at production scale
  • Experience within the boutique fitness industry
  • Go experience for maintaining the legacy custom ETL during the sunset period
  • Familiarity with Azure DevOps for source control and work tracking
  • Exposure to AI-assisted analytics work (Snowflake Cortex, Claude, embedded LLM reporting)
  • Track record of mentoring or growing more junior engineers


Ready to apply?

To start your application, please submit your resume, and we will be in touch as soon as we can.


Got questions? You can email us at talentsupport@xplortechnologies.com.


Similar Jobs

See all Remote Software Development jobs →

Personalize your Remote Job Search in 3 Easy Steps!

Discover remote opportunities in Data Engineer

Answer easy questions

Answer easy questions

200,000+ jobs across 15+ categories

Get your best job matches

Get your best job matches

Only hand-screened, legit jobs

Find a remote job faster

Find a remote job faster

No ads, scams, or junk

I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!

Sarah J. — Sarah J. · Marketing Manager ★★★★★ Verified