Senior SQL Developer (Hybrid - Flexible Options)

Broadridge Financial Solutions, Inc.
Boston, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 145K

Job location

Remote
Boston, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Data analysis
Business Intelligence
Big Data
Cloud Computing
Code Review
Information Systems
Databases
Information Engineering
Data Integrity
ETL
Data Systems
Data Warehousing
Relational Databases
Database Design
Database Development
Database Schema
Database Security
DevOps
Dimensional Modeling
Document-Oriented Databases
Identity and Access Management
Python
PostgreSQL
Microsoft SQL Server
MySQL
Oracle Applications
Performance Tuning
Query Optimization
Power BI
DataOps
SQL Stored Procedures
SQL Databases
Tableau
Data Processing
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Snowflake
Database Optimization
Database Performance
GIT
Database Migration
Data Lake
Information Technology
Amazon Web Services (AWS)
Tools for Reporting
Cloudwatch
Looker Analytics
Software Version Control
Data Pipelines
Redshift

Job description

We are seeking a highly skilled Senior SQL Developer with strong expertise in Amazon Redshift and other major database technologies to join our data team. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining complex SQL solutions that support business intelligence, analytics, and operational reporting needs. This role requires deep experience in database development, performance tuning, data modeling, and ETL processes. Experience with AWS cloud technologies and working knowledge of Python are strong pluses., * Design, develop, test, and maintain complex SQL queries, stored procedures, views, and database objects.

  • Build and optimize scalable data solutions in Amazon Redshift for analytics and reporting.
  • Develop and support ETL/ELT processes for loading, transforming, and validating large datasets.
  • Analyze and improve database performance through query tuning, indexing strategies, and schema optimization.
  • Work with cross-functional teams including data engineers, analysts, BI developers, and business stakeholders to gather requirements and deliver data solutions.
  • Design and maintain logical and physical data models to support business needs.
  • Ensure data integrity, accuracy, security, and compliance across database platforms.
  • Troubleshoot production issues, perform root cause analysis, and implement long-term solutions.
  • Support database migration and modernization initiatives, including cloud-based data warehouse solutions.
  • Document database designs, processes, standards, and best practices.
  • Mentor junior developers and contribute to SQL development standards and code reviews.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Engineering, or related field, or equivalent practical experience.
  • 5+ years of experience in SQL development, database programming, or data engineering roles.
  • Strong hands-on experience with Amazon Redshift.
  • Advanced proficiency in writing and optimizing complex SQL queries.
  • Experience with one or more major relational database technologies such as:
  • PostgreSQL
  • Microsoft SQL Server
  • Oracle
  • MySQL
  • Snowflake or other enterprise data warehouse platforms
  • Solid understanding of database design, normalization, dimensional modeling, and performance tuning.
  • Experience building and maintaining ETL/ELT pipelines.
  • Strong problem-solving skills and attention to detail.
  • Excellent communication and collaboration skills.

Preferred Qualifications

  • Experience with AWS cloud technologies, such as:
  • S3
  • AWS Glue
  • Lambda
  • RDS
  • EC2
  • IAM
  • CloudWatch
  • Knowledge of Python for scripting, automation, or data processing.
  • Experience with BI/reporting tools such as Tableau, Power BI, or Looker.
  • Familiarity with data lake, data warehouse, and modern cloud analytics architectures.
  • Experience with version control systems such as Git.
  • Understanding of DevOps/DataOps practices and CI/CD pipelines.

Technical Skills

  • Expert SQL development and query optimization
  • Amazon Redshift administration and development
  • Data modeling and warehousing concepts
  • ETL/ELT design and implementation
  • Performance tuning and troubleshooting
  • AWS cloud services
  • Python scripting
  • Database security and access management

"Broadridge considers various factors when evaluating a candidate's final salary including, but not limited to, relevant experience, skills, and education."

About the company

We are dedicated to fostering a collaborative, engaging, and inclusive environment and are committed to providing a workplace that empowers associates to be authentic and bring their best to work. We believe that associates do their best when they feel safe, understood, and valued, and we work diligently and collaboratively to ensure Broadridge is a company-and ultimately a community-that recognizes and celebrates everyone's unique perspective.

Apply for this position