*This role is open to remote based candidates based in Canada with a preference for PST/EST*

We’re looking for a Data Analyst to join our team and be part of our next stage of growth. As our Data Analyst, your top priority is design and development and maintenance of SQL scripts to support migration of Client’s legacy data to Salesforce. This role directly supports our professional services, customers’ success and product teams. The Data Analyst is focused on how to make our customers' lives easier during initial system migration, operational upgrades and support situations.

Who we are

At Traction Rec, community is at the heart of everything we do. We empower nonprofit organizations like YMCAs, Jewish Community Centers (JCCs), and Boys & Girls Clubs of America (BGCA) to strengthen their communities through great technology built on the Salesforce platform. By enabling these organizations to deliver their services more efficiently, we help them focus on creating meaningful connections and driving positive change where it matters most.

We believe that business is a powerful force for good. As part of this belief, we’ve committed to the Pledge 1% for the Planet, dedicating 1% of our time, product, profit, or equity to supporting environmental and community causes. This commitment reflects our dedication to creating a positive impact that extends beyond technology.

Our passion for community and innovation has earned us recognition, including:

• Salesforce Nonprofit Sales Partner of the Year and ISV Partner of the Year
• Globe & Mail's Top Growing Companies of 2024
• Deloitte's Technology Fast 50 winner
• Deloitte's Technology Fast 500 winner

At Traction Rec, we live our values: Community, Authenticity, Impact, Fun, and Growth. As a Living Wage Certified employer in British Columbia, we are dedicated to supporting not just the communities we serve but also the people who make it all happen—our team.

If you’re passionate about making a difference and want to join a company that puts community first, we’d love to have you on this journey with us. Together, let’s create stronger, healthier, and more connected communities.

Skills:
Traction Rec’rs come from a variety of backgrounds, and we are eager to find people that are from diverse backgrounds. For this role, you might have:

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience with data modeling, and building ETL pipelines.
• Experience delivering solutions on the Azure platform is an asset
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Experience executing analysis on legacy data sources and communicating directly with business stakeholders to identify data issues, implement business rules, execute data cleanup tasks or transformations
• Strong analytic skills related to working with unstructured datasets.
• A successful history of manipulating, processing and extracting value from large disconnected datasets.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Strong communication for working with internal and external stakeholders
• Bonus points if:
  • You’ve worked in nonprofit, community centers.
  • You've worked in the Salesforce ecosystem.
  • You’re a results oriented person who likes to roll up their sleeves to get things done.
  • You’re energized by a fast-paced environment.
  • You’re confined only by your imagination, not your job description.

What You Will Be Doing:

• Analyzing external/legacy system data structures (Relational data model) and developing data migration/integrations with Salesforce
• Recommend ways to improve data reliability, efficiency and quality.
• Identify, design, and implement internal process improvements
• Work and communicate directly with our customers to understand their data and help them understand it too
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Build and maintain reusable data tools for professional services data migration
• Custom script development, data migration or manipulation to support customer success or professional services teams
• Support customer success team data needs during new product releases or upgrades
• Propose and maintain data solution strategies and roadmaps

Compensation

At Traction Rec, we are committed to a fair, market-based and equitable compensation structure. Our market data is refreshed on an annual basis to reflect the most current market conditions.

The starting salary band for this role is $85,000-$90,000. Starting salaries will vary within this range based on experience, skill level, and internal equity related to the role.

Please note that the range details above reflect the base pay only and does not include our competitive bonus program and benefits that we offer.

If you’re interested, so are we! Send your resume our way, and let’s chat.

At Traction Rec, we believe that diversity and inclusion are essential to our success. We are committed to building a team that reflects the diversity of the communities we serve, and we actively seek and welcome candidates from all backgrounds. Our hiring process is designed to be fair, welcoming, and respectful to all candidates, regardless of race, ethnicity, religion, gender, sexual orientation, age, ability, or any other characteristic protected by law. We believe that diversity brings unique perspectives and experiences that can enhance our team and drive innovation, and we are committed to providing equal opportunity and support to all candidates. We encourage everyone to bring their authentic selves to the interview process and join us in building a diverse and inclusive culture at Traction Rec.

Don’t meet every single requirement? Studies have shown that women and marginalized groups are less likely to apply to jobs unless they meet every single qualification. If you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Please note that employment is contingent on the successful completion of background and reference checks.