Data Warehouse Operations Manager - SQL Server

Sorry, this job was removed at 11:31 a.m. (EST) on Friday, July 8, 2022
Find out who’s hiring remotely
See all Remote jobs
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • C#Languages
    • JavascriptLanguages
    • PHPLanguages
    • ReactLibraries
    • ReduxLibraries
    • ASP.NETFrameworks
    • Node.jsFrameworks
    • ZendFrameworks
    • TrustRadiusAnalytics
    • AsanaManagement
    • ConfluenceManagement
    • SmartsheetManagement
    • WordpressCMS
    • ZapierCMS
    • SalesforceCRM
    • DrawloopCRM
    • TenfoldCRM
    • DocuSignCRM
    • OutreachCRM
    • MarketoLead Gen
    • BizibleLead Gen
    • TableauLead Gen

Location

Boston , MA

What are DO NOT USE - Bonterra Perks + Benefits

Culture
Volunteer in local community
Receive up to 8 paid hours per quarter to volunteer with a non-profit organization of your choice.
Partners with nonprofits
Open door policy
Open office floor plan
Flexible work schedule
Bonterra employees are encouraged to work with their manager to establish a schedule that works both for them and for the business.
Remote work program
All employees will work from home will be until June 1st, 2021. Optional/reservable work from office is available.
Diversity
Dedicated diversity and inclusion staff
Highly diverse management team
Mandated unconscious bias training
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
The Dependent Care FSA allows you to set aside up to $5,000 per plan year to cover expenses such as day care, after-school programs, and mroe so you and your spouse can work or go to school.
Disability insurance
Our benefits include short and long-term disability, as well as $50K of coverage provided by the company for employees.
Dental insurance
We pay 100% of medical insurance for employees. Dental and vision is free for employees and family. We offer an HSA match for employees and family.
Vision insurance
We pay 100% of medical insurance for employees. Dental and vision is free for employees and family. We offer an HSA match for employees and family.
Health insurance
We pay 100% of medical insurance for employees. Dental and vision is free for employees and family. We offer an HSA match for employees and family.
Life insurance
Our benefits include short and long-term disability, as well as $50K of coverage provided by the company for employees.
Pet insurance
Wellness programs
Our Wise and Well program offers monthly events incorporating physical, intellectual, emotion, financial and social well-being – like chair massages, financial planning workshops, and happy hours.
Mental health benefits
Financial & Retirement
401(K)
We offer a 401K match to help our employees invest in their future retirement.
401(K) matching
Social Solutions' 401(K) retirement plan matches 50% of an employee's contributions up to 3% of their annual base salary.
Performance bonus
Many individual contributor roles at Social Solutions are eligible for an annual performance bonus. Bonuses are based on a percentage of the employee's salary and are paid during performance reviews.
Charitable contribution matching
Child Care & Parental Leave Benefits
Generous parental leave
We recognize the importance of bonding with a new baby, so new parents receive paid off for both birthing and non-birthing leave.
Family medical leave
Bonterra will provide up to 12 weeks of unpaid, job protected leave to eligible employees for a variety of reasons.
Vacation & Time Off Benefits
Unlimited vacation policy
Paid volunteer time
Bonterra provides each employee with 8 hours of paid volunteer time per quarter. Employees are encouraged to volunteer with an organization of their choice.
Paid holidays
Paid sick days
Bonterra employees are able to take paid sick days as a part of our Flexible PTO policy.
Office Perks
Company-sponsored outings
Bonterra has an annual summer party and a holiday party for all employees and a guest. Past parties have included a casino night, a shrimp boil, and of course eating BBQ.
Company-sponsored happy hours
We work hard and we play hard. Bonterra hosts happy hours once per month either in our office break room or at a local bar.
Onsite office parking
We recognize that Austin isn't known for it's public transportation, so we have on-site parking for all employees.
Recreational clubs
Bonterra offers a variety of groups for employees to join that range from sports leagues to breakfast clubs and book clubs.
Home-office stipend for remote employees
Onsite gym
Professional Development Benefits
Job training & conferences
We offer a 2-Day New Hire Orientation, monthly professional development training, a High Potential program that accelerates growth of our top talent, and the LEAD program which is offered to managers.
Tuition reimbursement
Bonterra offers $1,500 per year toward role related graduate and undergraduate programs or $500 per year for continued education courses.
Promote from within
Continuing education stipend

More Jobs at DO NOT USE - Bonterra

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about DO NOT USE - BonterraFind similar jobs like this