Senior Database Engineer

Ironside Group•Lexington, MA

22h•Remote

About The Position

Ironside Group is seeking a Database Engineer to join our team. In this role, you will support clients across a variety of industries by designing and implementing analytics-focused SQL databases and building efficient ETL/ELT pipelines. You’ll have the opportunity to work on diverse projects, often taking on multiple roles throughout the project lifecycle. This is a dynamic position ideal for someone who thrives in a client-facing, fast-paced environment and enjoys solving complex data challenges.

Requirements

5+ years of experience in data modelling & managing data assets and working with Snowflake, Redshift, Netezza, and Databricks for data storage, processing, and analytics use cases.
3+ years of practical experience building and maintaining robust ETL/ELT pipelines for structured and semi-structured data using modern tools like Glue, DBT, Informatica, SSIS and best practices.
Expertise in SQL scripting, writing complex and efficient queries, building complex and performant stored procedures in SQL.
Expert knowledge in procedure languages – T-SQL and PL-SQL.
Ability to understand and analyze data assets as part of reporting analytics.

Nice To Haves

AWS platform experience & certification is a plus.
Experience working in data migration projects is desirable.
Snowflake or equivalent database certification is a plus.
Experience working with Azure Synapse / Data Factory is a plus.
Subject matter expertise in Insurance or Financial Services (Asset Management, Hedge Funds, Banking) is a plus.

Responsibilities

Designing and implementing detailed SQL data warehouse models and data mappings for clients.
Perform performance optimization and tuning on new and/or existing data warehouse implementations.
Provide strategic and tactical guidance with respect to data warehousing best practices and attention to quality documentation within large and mid-market organizations.
Create and manage data models and schema designs to support reporting, operational systems, and downstream analytics.
Develop and maintain expertise in advanced and/or emerging data warehouse and analytical information technologies such as cloud data warehousing and ETL/ELT, modern data platforms and data lakes.
Provide detailed documentation, end-user training, and knowledge-transfer services to customers.
Partner with data analysts, data scientists, and business users to deliver reliable, well-documented data assets.