Summary
Qualifications:
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
- Advanced experience with Excel, including using complex formulas, pivot tables, and custom data models to format and validate data sets
- Experience with data modeling, and building ETL pipelines is an asset
Location: Canada
Job Type: 2-month Contract (Remote)
Salary: $5,000-$7,000 per month
*This role is open to remote based candidates based in Canada with a preference for PST/EST. Additionally, due to this being an urgent to fill position, recruitment will have very fast turnaround.*
We’re looking for a Data Analyst to join our team as a temporary contractor to support customer go lives. As a Data Analyst, your top priority is execution of data migrations (primarily through SQL Server or Salesforce API tools) of customer’s legacy data to Salesforce.
Who we are:
Traction Rec empowers customers with great technology. Built on the Salesforce platform, we enable YMCA’s, Jewish Community Centers (JCC’s), and Boys & Girls Clubs of America (BGCA) to deliver their services and achieve their missions. At the heart of Traction Rec is our desire to support non-profit community centers and the amazing good they do.
Traction Rec has been recognized by Salesforce as Nonprofit Sales Partner of the Year and ISV Partner of the Year. Traction Rec takes pride in the development of product and services, and building strong relationships with partners and customers.
At our core, we love community. We are looking for people who want to join an active group of engaged individuals who see business as more than just a vehicle to make money. We care about our people, wider community, and planet. We welcome you to experience a vibrant personal and professional journey by joining our diverse team.
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.
- Advanced experience with Excel, including using complex formulas, pivot tables, and custom data models to format and validate data sets
- Experience with data modeling, and building ETL pipelines is an asset
- Experience delivering solutions in Microsoft SQL Server or 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.
- 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
What You Will Be Doing:
- Running data migrations for clients using existing technical procedures and scripts using both MSSQL Server processes and Salesforce Data Loading Tools
- Support project teams both during testing and go live phases
- Validate incoming data from customers, recommending ways to improve data reliability, efficiency, and quality.
- Support customers with post go live data updates as required
- Propose and maintain data solution strategies and roadmaps
Term & Compensation
This is a short term contract position until the end of November 2024, with the following compensation details:
- Monthly rate: $5,000-$7,000, prorated based on your start date and dependent on experience, skill level, and internal equity to a comparable role.
- Benefits: As a contractor, this role is not eligible for any benefits we offer, such as health insurance, paid time off, or our bonus program.
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.
Please note that employment is contingent on the successful completion of a background check.
