Senior SQL Developer

Center for Biological Diversity

5d•$90,000 - $100,000•Remote

About The Position

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. This role requires deep expertise in SQL Server and Python to build scalable data warehouses, implement automated reporting frameworks, and optimize query performance for large-scale operations. Working closely with business stakeholders, the Senior SQL Developer translates reporting requirements into robust technical solutions, maintains data quality standards, and creates self-service analytics capabilities that enable data-driven decision-making across the organization.

Requirements

Bachelor's degree in computer science or related field or equivalent experience
10 years of professional SQL development experience
Minimum 3 years direct experience with MS SQL Server
5 years of experience creating Python scripts for managing data in SQL Server
3+ years of ETL design and development
Experience building and maintaining data warehouses
Experience in business process analysis and requirements gathering
Experience working directly with business stakeholders
Strong expertise in data warehouse design and dimensional modeling
Advanced SQL skills including complex queries, stored procedures, and performance tuning
Strong proficiency with SQL variations across SQL Server, MySQL, Oracle, and Azure databases
Experience with T-SQL, data transformation logic, and query optimization
Proficiency with reporting tools (Power BI, Tableau, or SQL Server Reporting Services)
Working knowledge of HTML, CSS, and JavaScript for data presentation solutions
Understanding of database design principles and normalization
Excellent analytical and organizational skills
Ability to understand user requirements with a problem-solving attitude
Excellent verbal and written communication and documentation skills
Ability to work both independently and in a team environment
Ability to work 40+ hours per week

Responsibilities

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
Perform other job-related duties as assigned

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.
Relaxed work atmosphere and dress code.