Consulting/Principal Software Engineer

Responsibilities

• Design and build database schemas, tables, indexes, and constraints while ensuring efficient data modeling across both OLTP and OLAP environments
• Write, troubleshoot, and optimize complex SQL queries using joins, subqueries, CTEs, and window functions to improve performance and reliability
• Perform hands-on database programming by developing and maintaining stored procedures, triggers, and functions, with strong ownership of transaction management and concurrency control
• Implement and enhance Java-based data access layers using JDBC and ORM frameworks such as Hibernate or JPA to ensure efficient and scalable database interaction
• Build and support ETL pipelines, handling data extraction, transformation, migration, and batch processing for large datasets
• Write and maintain Bash or shell scripts to automate database operations, including backups, job scheduling (cron), data processing, and monitoring within Linux or Unix environments
• Perform hands-on data analysis, validation, and reporting to ensure data accuracy and support business needs

Requirements

• 8+ years of experience in software engineering with a strong database focus
• Expertise in relational databases (MySQL preferred) and data modeling
• Advanced proficiency in SQL development and performance tuning
• Strong experience with Java, JDBC, and ORM frameworks (Hibernate/JPA)
• Proven experience diagnosing and resolving complex production issues
• Solid understanding of transaction management, concurrency, and system performance
• Hands-on experience with Unix/Linux environments and shell scripting

Benefits

We are delighted to offer the following benefits:

• Health Benefits: Comprehensive, multi-carrier program for medical, dental and vision benefits
• Retail Benefits: 401(k) with match and an Employee Share Purchase Plan
• Wellbeing: Wellness platform with incentives, Headspace app subscription, Employee Assistance and Time-off Programs
• Short-and-Long Term Disability, Life and Accidental Death Insurance, Critical Illness, and Hospital Indemnity
• Family Benefits, including bonding and family care leaves, adoption and surrogacy benefits
• Health Savings, Health Care, Dependent Care and Commuter Spending Accounts

Pay

The U.S. National Base Pay Range for this role is $115,400 - $192,300. Geographic differentials may apply in some locations to better reflect local market rates.