Senior SQL Developer

The Senior SQL Developer is responsible for designing, developing, and maintaining enterprise reporting solutions and data infrastructure while ensuring the stability, reliability, and optimal performance of the database environment.

Requirements

• Design and implement data models and schemas optimized for reporting performance
• Maintain data warehouse structures supporting reporting needs
• Develop and maintain complex SQL queries and stored procedures for enterprise reporting processes
• Optimize query performance for large-scale reporting systems
• Design, develop, and optimize ETL/ELT processes using SQL and Python
• Create and maintain data pipelines from multiple source systems
• Manage complex data integrations across disparate systems
• Document data flows and transformation logic
• Create automated reporting solutions and dashboards for business stakeholders
• Establish standardized reporting frameworks and templates
• Create self-service reporting capabilities for business users
• Research and prototype AI-driven solutions for report automation, anomaly detection, and predictive analytics
• Implement data validation and quality checks across systems
• Monitor and ensure data consistency and accuracy
• Document data standards, definitions, and data lineage
• Support data governance initiatives
• Collaborate with stakeholders to gather, refine, and document reporting requirements
• Collaborate with other team members and staff

Benefits

• Fully paid medical premiums for staff, and greatly discounted for families.
• Fully paid dental and vision premiums for staff and their families.
• Generous employer contribution to HSA and HRA's.
• Lifestyle Spending Account (LSA) provided for reimbursement of eligible wellness expenses.
• Center paid premiums for Short Term and Long-Term Disability provided for all staff.
• Center paid premiums for Basic Life Insurance for all staff.
• Discounted premiums for pet discount program.
• 403(b) plan with employer match and increasing employer paid contributions.
• Generous time off policies, including 13 paid holidays per year and 5 “personal” days awarded each year.
• Vacation accrual starts at a rate of 15 days annually, but it may be higher commensurate with experience, and paid sick days accrue at a rate of 10 days per year.
• Center Paid Time Off for parental leave, personal leave, caretaker leave and even pet caretaker leave.
• After 5 years of service, all employees receive a 12-week paid sabbatical.