Bonterra
We help the people who make social good possible drive more impact for more people, in less time.
Remote

Senior Business Data Analyst

Sorry, this job was removed at 4:59 p.m. (CST) on Wednesday, August 4, 2021
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.

a

Social Solutions provides a comprehensive and secure operations platform for social service organizations through its products, Apricot and ETO.  Our goal is to provide the industry’s best technology and data solutions to measure and impact social change, enabling communities to drive greater impact together.

 

We are located in Canada, United States, Australia, New Zealand and the United Kingdom.

 

At Social Solutions, we are committed to our mission and values — creating opportunities for lasting positive impact.  We strive to combine an impact-obsessed, inclusive culture with the ability to truly make the world a better place — every single day. When you work for Social Solutions, you’ll be working on software solutions that help make a real difference in the lives of people doing great work in communities all over the globe, while enjoying our company culture of innovation, collaboration, and commitment to community. If you’re inspired by the possibility of accelerating lasting social change through technology, then Social Solutions may be the place for you.

 

We are seeking a Senior Business Data Analyst (1 year contract) who wants to help deliver on our mission to be a key enabler of social impact for organizations working to improve the lives of individuals, families, and communities around the world.

 

What You’ll Do

As Senior Business Data Analyst, reporting to the Manager of Tailored Services, you will work with Social Solution’s clients and internal teams to develop common reporting data sets for our market sectors as well as custom client reports.  You will tailor solutions to meet these needs, often working on multiple projects simultaneously - translating business process requests into workable solutions. In this role you will:

 

  • Be the subject matter expert in the database schema.
  • Query databases, creating custom views and functions to facilitate updating and designing reports and creating data visualizations and/or data exports in multiple formats.
  • You gather and document requirements and provide informed quotes for estimated effort.
  • You write SQL queries and create visual representations of data in third party tools such as Excel, Tableau, and XML.
  • Familiarity with ETL processes using various data formats such as CSV, JSON and HL7.
  • You lead customer meetings, communicating to both technical and non-technical personnel
  • You build relationships and communicate with our customers regarding process and change requests, understanding the business issues and data challenges of their organization and industry.
  • You liaise with project and business leaders to interpret analytical requirements.
  • Document current and future standard operating procedures

 

This position is contract, full-time, and located in our Waterloo, Ontario headquarters.

Responsibilities & Requirements

Who You Are

  • You possess at least five (5) years progressive experience in the field of reporting and data analysis.
  • You are able to learn new applications swiftly, independently, and with confidence.
  • You will use technical and analytical expertise and proven knowledge of specialized reporting tools to gather, examine, interpret, evaluate and report on data stored in various database structures.
  • You have a breadth of knowledge and experience with relational databases, including modeling table relationships and writing and executing SQL queries to join, retrieve and analyze data from multiple database tables.
  • You have exceptional interpersonal skills and outstanding written and verbal communication abilities.
  • You are able to succeed in a dynamic, driven environment, trail-blazing creative solutions to complex challenges.
  • You have experience creating dashboard reports in Tableau (a Tableau certification is preferred).
  • You have expert knowledge of Microsoft Excel (macros, v-lookups and pivot tables).
  • You have an Undergraduate University Degree or equivalent experience in Mathematics, Computer Science, Data Science or Programming
  • Experience in business analysis and project leadership experience an asset.

About Social Solutions Global

Why We’re Awesome

 

Recently named one of Built In Austin’s Best Places to Work for in Austin. At Social Solutions, we’re mission focused and results oriented! We’re a diverse team of innovators, creatives, and digital architects that come together to help organizations transform lives. Our clients affect countless lives every day. That’s why we go above and beyond to provide tools to get the job done. We help non-profits get to the heart of their data so they can maximize their efforts to be more impactful. In essence, we help those that are changing the world.

 

What You’ll Get

  • Amazing coworkers
  • Company sponsored events and happy hours
  • Career advancement opportunities and more!

To ensure candidate and employee health, Social Solutions is conducting the interview process remotely via Zoom for the foreseeable future. Thank you in advance for your cooperation!

 

In order fulfill Social Solutions’ mission to “help people transform lives,” we seek to build teams that leverage diverse perspectives to create an innovative and welcoming environment.  

 

To that end, we make employment decisions based on qualifications, merit, and business need. Social Solutions does not discriminate on the basis of age, race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability.

See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

What are 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
To enhance our work hard, play hard culture we offer a Flexible PTO policy which means that employees are able to take as many days off as they need, provided they have pre-approval from their manager
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
Social Solutions offers all employees 9 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
Our building, Braker Point, is currently building an 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 Bonterra

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