Job Closed
This listing is no longer active.
The Center for Biological Diversity is a national nonprofit organization that protects the resources needed for a variety of species to survive. As an equal opp
Senior SQL Developer
Location
California
Posted
140 days ago
Salary
$90K - $100K / year
Seniority
Senior
Job Description
Senior SQL Developer
Center for Biological Diversity
• Designing, developing, and maintaining enterprise reporting solutions and data infrastructure • Ensuring the stability, reliability, and optimal performance of the database environment • Building scalable data warehouses, implementing automated reporting frameworks, and optimizing query performance for large-scale operations • Translating reporting requirements into robust technical solutions • Maintaining data quality standards and creating self-service analytics capabilities that enable data-driven decision-making across the organization • Documenting data flows and transformation logic • Creating automated reporting solutions and dashboards for business stakeholders • Establishing standardized reporting frameworks and templates • Researching and prototyping AI-driven solutions for report automation, anomaly detection, and predictive analytics • Implementing data validation and quality checks across systems • Monitoring and ensuring data consistency and accuracy • Supporting data governance initiatives • Collaborating with stakeholders to gather, refine, and document reporting requirements • Performing other job-related duties as assigned
Job 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
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.
- 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.
Related Guides
Related Job Pages
More Software Engineer Jobs
Integration Developer
AvettaAvetta is an information technology (IT) consulting and services company that specializes in providing supply chain risk management and compliance solutions. As
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description We are looking for an Integration Developer to join our team. This role will be focused on the Boomi platform and will be responsible for leading the design, development, and support of enterprise-grade integrations across internal systems, third-party platforms, and cloud services. Additionally, the role is hands-on with ownership of integration architecture, standards, ensuring seamless data flow, efficient communication across systems, and optimal performance of enterprise applications. You will collaborate with DevOps engineers, business analysts, and internal/external partners to deliver robust integration solutions that support business operations and digital transformation goals. Essential Duties and Responsibilities - Design, develop, deploy, and support complex integrations using Boomi AtomSphere. - Lead integration architecture decisions and best practices. - Configure and manage Boomi Atoms, Molecules, Atom Clouds, and APIs. - Build and maintain REST and SOAP APIs and enterprise integrations. - Implement robust error handling, logging, monitoring, and alerting. - Troubleshoot complex integration and performance issues. - Mentor junior developers and conduct design/code reviews. - Ensuring integrations comply with security, data privacy, and governance standards. Qualifications - Knowledge of JSON, XML, SQL, and scripting languages such as Python or Groovy for data transformation and workflow automation. Requirements - 5 years of integration development experience with deep Boomi expertise. - Bachelor’s or Master’s Degree in Data Engineering, Computer Science, or related field. - Certifications in Boomi (Boomi Architect and/or Professional Integration Developer). Benefits - Health, dental, and vision insurance. - 401(k). - PTO. Salary Information The salary range for this position is $99,000 - $115,000 USD per year, with a potential bonus. Company Description Avetta’s SaaS platform connects the world’s leading organizations with qualified suppliers, contractors, and vendors. We bring unmatched visibility to companies through cloud-based technology and human insights to improve supply chain risk and compliance. As a result, we foster sustainable growth for businesses and their supply chains globally. Our SaaS subscription-based software is used by 85k+ active customers in over 100 countries spanning a diverse set of industries.
Senior SCADA Developer
Terabase EnergyA solar technology company whose mission is to reduce the cost and increase the scalability of large-scale solar.
• Lead the development and ongoing enhancement of the Terabase SCADA system. • Maintain design requirements and guidelines for Terabase Standard Ignition offerings. • Develop and implement new features and improvements to our standard SCADA solutions. • Manage the Ignition development environment across multiple projects, both on-premises and cloud-based. • Develop and maintain multiple SCADA templates that meet key customer requirements. • Design non-standard solutions for project execution to implement. • Configure historians for effective data collection, storage, and retrieval. • Create standards for I/O configuration to ensure proper data flow and system integration. • Review customer requirements and identify deviations from standard offerings, ensuring alignment with customer expectations. • Work with project teams to deploy various SCADA applications on a per project scope. • Implement DevOps methodologies using Bitbucket. • Automate deployment processes to improve efficiency and reliability. • Manage source code repositories and version control. • Ensure continuous integration and continuous deployment (CI/CD) pipelines are established and maintained. • Collaborate with Business Development and project engineers to ensure customer requirements are met. • Participate in SCADA design reviews with customers up to Factory Acceptance Testing (FAT). • Develop historical data best practices and incorporate lessons learned from projects into templates and design documents. • Engage with customers to understand their needs and translate them into actionable project requirements. • Provide regular updates to management on SCADA product development progress, risks, and issues. • Coordinate efforts with other product owners to ensure the delivered products meet customer and industry specifications. • Foster strong relationships with internal and external stakeholders to facilitate project success.
• Collaborate with cross-functional teams including business analysts and stakeholders to understand requirements and implement integration solutions. • Analyze, design, and develop MuleSoft applications using Anypoint Studio that satisfy business requirements and adhere to best practices. • Perform unit testing and debugging to ensure reliability and performance of integration solutions. • Manage, deploy, and monitor MuleSoft applications in CloudHub, Sandbox, and Production. • Create and maintain appropriate documentation. • Troubleshoot and resolve technical issues that arise during development or post-deployment phases. • Stay updated with the latest MuleSoft and related technology trends. • Support existing EDI integration solution. • Support existing Salesforce integration solution. • Support new integration opportunities and solutions.
• Play a contributing role in delivering enterprise-grade mobile solutions using React Native • Collaborate closely with designers, Product Owners, and client-side engineering teams • Contribute to technical and architectural decisions, particularly in shared ownership or client-integrated environments • Participate in estimation, prioritization, and delivery planning to support on-time, on-budget execution • Uphold high standards for code quality, performance, accessibility, and maintainability • Communicate progress, risks, and trade-offs clearly and proactively with both internal teams and client stakeholders • Leverage modern AI-powered and agentic developer tools (e.g., Claude Code, Devin, GitHub Copilot, Codex) to improve velocity, quality, and creativity in problem-solving. • Evaluate when and how to apply AI-assisted development responsibly, balancing efficiency with sound engineering judgment. • Explore opportunities to integrate automation and AI into workflows (e.g., test generation, scaffolding, documentation, debugging assistance, architecture exploration). • Contribute to shaping Orium’s internal adoption of AI for software development and share learnings with the team.
