Develop, optimize, and maintain complex SQL Server queries, stored procedures, and functions in production environments.
Perform regular database tuning, troubleshooting, and query optimization, prioritizing stability and performance for reporting infrastructure.
Develop Python scripts to extract data from various sources and load it into our environment.
Monitor existing ETL/ELT processes to ensure data is flowing correctly and resolve any pipeline failures promptly.
Design, develop, and maintain SSRS reports and Power BI dashboards to meet stakeholder requirements.
Ensure data models are optimized for performance and usability.
Provide tier-2/3 support for BI tools and environments, including issue triage and resolution.
Partner with business stakeholders to document data requirements and ensure solutions align with operational and strategic goals.
Implement data validation, auditing, and reconciliation processes to ensure the integrity of reporting outputs.
Support governance initiatives for consistent and accurate data across platforms.

Requirements

Bachelor's degree in computer science, Information Systems, Mathematics or related field (or equivalent work experience).
5+ years of experience as a BI Developer, Database Developer, or similar role.
2+ years of experience supporting production-grade Python ETL processes.
Strong proficiency with SQL Server (including stored procedures, functions, triggers, and performance tuning).
Proven experience with SSRS and Power BI, including DAX and Power Query.
Experience supporting production environments and snapshot reporting databases.
Strong analytical and problem-solving skills with attention to detail.
Excellent communication and documentation skills to interface with technical and non-technical stakeholders.

Benefits

Self-Managed PTO: Time off is yours to plan and use as you need it
Affordable Health Insurance: 80% employer-paid premiums for medical and dental for team members; 50% covered for eligible partners, spouses and dependents
Parental Leave: Generous paid leave benefits for maternity, paternity and adoption to enjoy time with your growing family
Flex Spending Accounts: Benefit from pre-tax savings for out-of-pocket healthcare or dependent/daycare costs
Additional Insurance: Company paid life insurance and short- and long-term disability
401k +5% Match: Contribute to your financial future and receive a 5% company match with immediate vesting upon eligibility
Fashion Discount: Enjoy a 30% discount on all EVEREVE product when you shop in our stores
Culture of Purpose: Experience a culture of purpose rooted in our HEART Values – Humility, Empathy, Authenticity, Relationship and Tenacity

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQL Serverstored proceduresfunctionsquery optimizationPythonETLSSRSPower BIDAXPower Query

Soft Skills

analytical skillsproblem-solving skillsattention to detailcommunication skillsdocumentation skills