Remote Senior Data Warehouse Engineer: SQL & ETL

Ironside; Boston (MA); Remote; USD 130,000 - 160,000; Full time

Benefits offered by this job

Competitive merit-based compensation

Incentivized development program

Professional training and certifications

Access to a high-profile professional network

Job summary

A leading consulting firm is seeking a Senior Database Engineer in Boston, MA. This role involves designing and implementing SQL databases, building ETL/ELT pipelines, and optimizing existing systems. Candidates should have over 5 years of experience in data modeling and SQL, with proficiency in modern ETL tools. The position offers competitive compensation and opportunities for professional growth in a fast-paced, client-facing environment.

Qualifications

• 5+ years of experience in data modeling & managing data assets.
• 3+ years of experience building and maintaining robust ETL/ELT pipelines.
• Expertise in SQL scripting and writing complex queries.

Responsibilities

• Design and implement SQL data warehouse models.
• Perform performance optimization on data warehouse implementations.
• Provide strategic guidance on data warehousing best practices.

Skills

Data modeling

SQL scripting

ETL/ELT pipelines

Analytical skills

SQL performance optimization

Tools

Snowflake

Redshift

Netezza

Databricks

AWS Glue

Informatica

Azure Synapse

Informatica

Job description

A leading consulting firm is seeking a Senior Database Engineer in Boston, MA. This role involves designing and implementing SQL databases, building ETL/ELT pipelines, and optimizing existing systems. Candidates should have over 5 years of experience in data modeling and SQL, with proficiency in modern ETL tools. The position offers competitive compensation and opportunities for professional growth in a fast-paced, client-facing environment.