Senior Data Engineer - Analytics

RXinsider LTD.; Boston (MA); On-site; USD 120,000 - 170,000; Full time

Job summary

RevSpring is seeking a Senior Data Engineer - Analytics in Boston to design scalable data pipelines feeding BigQuery or Redshift data warehouses. You will own the codebase, refactor when needed, and collaborate with cross-functional teams to meet product roadmaps and deliver AI-enhanced analytics.

The role requires experience building ETL pipelines with Python, SQL, Airflow, DBT, plus BI dashboards with Looker/PowerBI/Tableau.

Qualifications

• Ability to approach complex data challenges systematically and deliver end-to-end data pipelines.
• Experience owning data integrity and ensuring reliable, timely data from source to consumption.
• Experience creating ETL pipelines using Python, SQL, Airflow, DBT, with cloud storage (S3) and integration tools (Airbyte, Confluent).
• Experience building analytic semantic layers and BI dashboards (Looker, PowerBI, Tableau).
• Experience with Postgres, BigQuery, Redshift; cloud platforms AWS/Azure/GCP.

Responsibilities

• Collaborate across teams to design data pipelines ingesting data into BigQuery or Redshift.
• Own codebase, identify gaps, refactor, and keep design modern.
• Code to unblock technical challenges and meet product roadmaps.
• Contribute to architecture decisions, documentation, and governance of data products.
• Communicate with stakeholders and participate in pair programming.

Skills

Data modeling

Data pipeline design

AI-assisted development

Python

SQL

Airflow

DBT

S3

Airbyte

Confluent

BigQuery

Redshift

Postgres

AWS

Azure

GCP

Looker

PowerBI

Tableau

Education

BS Degree in Computer Science or related field

Tools

Python

SQL

Airflow

DBT

S3

Airbyte

Confluent

Looker

PowerBI

Tableau

Postgres

BigQuery

Redshift

AWS

Azure

GCP

Job description

Job Title: Senior Data Engineer - Analytics

Essential Functions

• Collaborate with other internal teams to design data pipelines to ingest information from various systems to our BigQuery or Redshift data warehouse
• Take ownership of the codebase, identifying gaps, areas for improvement, refactoring where needed, and keeping the design fresh and modern
• Actively code to unblock technical and communication challenges as necessary to ensure teams meet product roadmaps and close those gaps.
• Participate in architecture review decisions, designs, and documentation that will govern the direction of the team, the codebase, and multiple products over a several month timeframe
• Communicate effectively with stakeholders (upper management, engineering manager, product manager, and peers) regarding the product you are responsible for
• Provide feedback and participate in pair programming exercises.

Success In This Role

• Team delivers reliable, scalable, high performing customer facing analytic services within analytic SLAs
• Team consistently delivers committed business initiatives and coordinates with other stakeholders to roll out products with analytic insights.
• Business teams and Customers are empowered with AI assisted insights without dependency on engineering
• Consistently deliver high quality code that is easily maintained and scaled. Your work is reliable and your team members and stakeholders fully trust you to execute your responsibilities with minimal oversight
• Contribute to the team culture where innovation, autonomy, and accountability thrive

Minimum Requirements

Specific Job Skills

• Ability to approach complex, ambiguous data challenges systematically. You can diagnose the problem, come up with a plan to address it, and see that plan through.
• Experience owning data integrity, ensuring that data is reliable, timely, and traceable from source to consumption
• Experience creating and maintaining Extract, Transform, and Load (ETL) Pipelines and using modern ETL tools such as Python, SQL, Airflow, DBT, S3, Airbyte, Confluent.
• Experience creating and maintaining analytic semantic layers and business intelligence dashboard such as Looker, PowerBI, Tableau, etc.
• Experience owning data integrity, ensuring that data is reliable, timely, and traceable from source to consumption
• Proficiency in leveraging AI agents and other AI tools to significantly enhance developer productivity.
• Experience working with database and data warehouse technologies such as Postgres, Bigquery, and Redshift.
• Experience with cloud services such as AWS, Azure, GCP.
• Experience in developing large scale data models and complex data pipelines.

Preferred Skills

• Preferred: Experience in working with large slow changing dimension data models
• Preferred: Experience in the US healthcare system, in particular with data systems and EHRs such as Epic, Cerner or Athenahealth.

Education: BS Degree or equilivent work experience

Experience: Five years experience developing data platforms using Python, SQL

Supervision: N/A

Certifications: N/A

Language Skills

Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures or governmental regulations. Ability to write reports, business correspondence and procedure manuals. Ability to effectively present information and respond to questions from a variety of both internal and external sources.

Physical Capabilities: Standard categories

The physical capabilities described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

RevSpring is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Note

This Job Description may not describe all of the job responsibilities and standards assigned to this position. The duties may change from time to time. RevSpring does not discriminate against any group in hiring or employment practices. Nothing in this job description constitutes a contract for employment.