Data Warehouse Operations Manager - SQL Server
Overview
The EveryAction platform is built by some of the leading experts in the Nonprofit technology space and provides an integrated communication and fundraising platform to nonprofits of all sizes. At EveryAction, we stand behind our progressive values with a commitment to our employees to provide a safe, equitable, and highly effective environment that better reflects the world we want to build.
Where we are at:
It was recently announced that EveryAction is combining with CyberGrants and Social Solutions to create the second-largest and fastest-growing social good software company in the world.
How we're growing bigger, better, stronger:
Our number one goal remains the same as ever: keeping our shared culture of being mission-minded and passionately committed to propel social good. Bringing three like-minded companies together was deliberate - we all provide individual solutions that help social impact; but combined we're creating a mammoth opportunity to accelerate change.
We are actively recruiting across roles in the US and beyond.
Currently we are a remote workforce and have equipped our teams with the technology to stay connected to each other and as close to our customers as possible.
Responsibilities & Requirements
The Data Warehouse Operations Manager will lead the technical implementation, expansion, and maintenance of our cross-business unit data warehouse. They will work with other technical leaders to drive decisions on the makeup of the technology stack and data governance policies. The Data Warehouse Operations Manager will work closely with the Data Science team and other stakeholders to prioritize projects and allow for effective usage of the warehouse.
The Data Warehouse Operations Manager will also manage a team of Data Engineers responsible for designing data models and building ETL processes that feed into and out of the data warehouse.
Responsibilities
- Design and implement Data Warehouse and ETL systems
- Design and implement scalable data pipelines for both internal and external data sets
- Collaborate with internal departments to prioritize projects and deliverables
- Manage a team of Data Engineers responsible for ETL processes
Crucial Skills/Experience - A good candidate will have all of these:
- Prior managerial experience, preferably in an Agile environment
- 5+ years of experience with RDBMS platforms, at least one of SQL Server, Oracle, PostgreSQL, MySQL.
- 3+ years of experience with one or more cloud-hosted data stores (Azure SQL Hyperscale, Synapse Analytics, Snowflake, Redshift, Databricks), preferably in Azure.
- Experience utilizing third-party ETL tools (FiveTran, Qlik Replicate, DBT)
- Strong understanding of data warehousing principles and practices
- Experience implementing data governance policies, specifically with regards to sensitive data such as PII
- Excellent SQL skills
- Experience managing semi-structured data
Additional Skills/Experience - A great candidate will have several of these
- Experience with Azure Data Platform technologies
- Understanding of Azure AD and RBAC
- Experience with Powershell, Python, or other scripting languages
- Experience with PowerBI or other business intelligence tools such as Looker or Tableau
About Us
Our Culture:
Our team is made up of industry experts and advocates who are 100% committed to supporting the doers of social good. We are currently undergoing an effort to create the vision and values that embody our collective organization and embrace the individuals who make up our community.
Some of our comprehensive and competitive benefits include:
- Generous PTO policy
- Equity for ALL regular, full-time employees from individual contributors to management - share in our success!
- Up to 15 paid company holidays including some commemorating social justice events and self-care
- Paid volunteer time
- Resources for savings and investments
- Paid parental leave
- Health, vision, dental, and life insurance with additional access to health and wellness programs.
- Opportunities to learn, develop, network, and connect
- When we can-company-sponsored events and swag!!
Job Tags
#LI-JV1 #LI-Remote