Job Title: Senior SQL Developer
Program: Information Technology
Employment Type: [X] Salary [ ] Hourly (exempt – this position is not eligible for over-time)
[ ] Part-time [X] Full-time
[ ] Temporary [X] Regular
Reports to: Chief Information Officer
Direct Reports to this position: N/A
Salary Range: $90,000 - $100,000
Location:Remote
Is this position in the Bargaining Unit? [X] Yes [ ] No
Job Classification: Database Designer/Analyst, Senior
*Because this position is in the Bargaining Unit, some fees may be required depending on where the candidate lives as a condition of employment.
How to apply: Please apply online by completing our application and submitting a cover letter and resume. The position will remain open until filled. The desired start date is 2/2/2026. Only applicants selected for interviews will be contacted. No telephone calls, please.
ABOUT THE CENTER
The Center for Biological Diversity, a national 501(c)(3) non-profit organization, believes the welfare of human beings is deeply linked to nature — to the existence of a vast diversity of wild animals, plants and people. Because diversity has intrinsic value, and because its loss impoverishes society, we work to secure a future for all species, great and small, hovering on the brink of extinction. We do so through science, law, activism and creative media, with a focus on protecting the lands, waters and climate that humans, other species and all communities need to survive and thrive.
We want those who come after us to inherit a world where the wild is still alive.
POSITION SUMMARY
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.
ESSENTIAL JOB DUTIES AND 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
ESSENTIAL QUALIFICATIONS AND SKILLS
- 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
WORKING CONDITIONS
This job operates in a casual office or home office environment. This role routinely uses standard office equipment such as computers, phones and mobile communications devices.
This is a full-time US-based remote position. Typical hours of work and days are Monday through Friday, 8:30 a.m. to 5 p.m. in a US time zone. Extended hours and weekends may be required to meet Center needs.
Limited travel to offices and meetings as needed.
PHYSICAL REQUIREMENTS
The ideal candidate must be able to complete all physical requirements of this job with or without a reasonable accommodation.
This is not a complete description of all workplace conditions, and conditions are subject to change per the Organization’s discretion.
Cognitive
Ability to process and analyze information: [ ] Rarely [ ] Occasionally [X] Frequently
Exchange accurate information: [ ] Rarely [ ] Occasionally [X] Frequently
Communicate and express oneself with others: [ ] Rarely [ ] Occasionally [X] Frequently
Interaction with other colleagues: [ ] Rarely [ ] Occasionally [X] Frequently
Interaction with the public/co-collaborators: [ ] Rarely [X] Occasionally [ ] Frequently
Physical
Reading (ingest data): [ ] Rarely [ ] Occasionally [X] Frequently
Working on a computer: [ ] Rarely [ ] Occasionally [X] Frequently
Typing: [ ] Rarely [ ] Occasionally [X] Frequently
Writing by hand: [ ] Rarely [X] Occasionally [ ] Frequently
Sitting: [ ] Rarely [ ] Occasionally [X] Frequently
Walking: [ ] Rarely [X] Occasionally [ ] Frequently
Standing: [ ] Rarely [X] Occasionally [ ] Frequently
Lift/Carry 0-25 lbs: [X] Rarely [ ] Occasionally [ ] Frequently
Lift/Carry 25-75 lbs: [X] Rarely [ ] Occasionally [ ] Frequently
Climbing up or down stairs: [ ] Rarely [X] Occasionally [ ] Frequently
Bending: [X] Rarely [ ] Occasionally [ ] Frequently
Squatting: [X] Rarely [ ] Occasionally [ ] Frequently
Reaching overhead: [X] Rarely [ ] Occasionally [ ] Frequently
Repetitive motions: [ ] Rarely [ ] Occasionally [X] Frequently
Ability to drive: [ ] Rarely [X] Occasionally [ ] Frequently
Location Conditions
In person required (versus remote work): [ ] Rarely [X] Occasionally [ ] Frequently
Travel required: [ ] Rarely [X] Occasionally [ ] Frequently
Night or weekend work: [ ] Rarely [X] Occasionally [ ] Frequently
Other? _________________ [ ] Rarely [ ] Occasionally [ ] Frequently
BENEFITS (Subject to change—see Handbook for more details)
For regular staff working 30+ hours a week
- 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.
For all regular staff
- 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.
JEDAI STATEMENT
The Center for Biological Diversity deeply values, and is committed to sustaining and promoting, both biological and cultural diversity. We welcome, embrace and respect diversity of people, identities and cultures. We are committed to fostering an organizational culture of diversity and inclusion. The Center believes staff and board diversity is critical to saving life on Earth.
We are an equal opportunity employer.
The Center complies with all federal and local laws regarding work authorization for new hires. We welcome and encourage anyone interested to apply to any of our open positions. Everyone, regardless of current work authorization, will be considered.
Exempt Classification: Exempt
Applicable Exemption: Administrative
- Reasoning behind this classification: High degree of discretion and work is predominantly intellectual in nature and varied in character. Work is directly related to general business operations of the Center.
