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.
