Senior Data Engineer - Analytics

RevSpring; Boston (MA); On-site; USD 140,000 - 190,000; Full time

Job summary

RevSpring seeks a Senior Data Engineer - Analytics to design and manage data pipelines feeding BigQuery and Redshift data stores. The role emphasizes data integrity, scalable architectures, and collaboration with product and engineering teams.

You will own the data stack, implement ETL with Python/SQL, and build analytic semantic layers with Looker/PowerBI/Tableau, while leveraging AI tools to boost developer productivity.

Qualifications

• Experience designing data pipelines to ingest information from various systems into data warehouses.
• Proven track record owning data integrity end-to-end from source to consumption.
• Experience with ETL tools and languages (Python, SQL, Airflow, DBT).
• Experience creating analytic semantic layers and dashboards (Looker/PowerBI/Tableau).
• Ability to leverage AI tools to boost developer productivity.
• Experience with Postgres, BigQuery, Redshift and cloud platforms (AWS/Azure/GCP).
• Experience in developing large-scale data models and complex pipelines.

Responsibilities

• Design and own data pipelines to feed BigQuery/Redshift data warehouses.
• Own code quality, refactoring, and evolving architecture.
• Actively code to unblock technical and cross-team challenges.
• Participate in architecture reviews and documentation for multiple products.
• Communicate with stakeholders about the product and roadmap.
• Provide feedback and participate in pair programming.

Skills

Data pipelines

Data integrity

AI tooling

Problem solving

Education

BS Degree

Tools

BigQuery

Redshift

Postgres

Python

SQL

Airflow

DBT

S3

Airbyte

Confluent

Looker

PowerBI

Tableau

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.

RevSpring does not discriminate against any group in hiring or employment practices.

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.