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.