Share this Job

Analyst, Data Architecture & Insights

Apply now »

Date: Jul 27, 2022

Location: Toronto, ON, CA, M6K 3H7 Ottawa, ON, CA, K1P 5G3 Oakville, ON, CA, L6M 2W1

Company: Softchoice

Why you’ll love Softchoice:

We are a software-focused IT solutions and services provider that equips organizations to be agile and innovative, and for their people to be engaged, connected, and creative at work. That means moving them to the cloud, helping them build the workplace of tomorrow, and enabling them to make smarter decisions about their technology. By doing these things we help them create success for their customers and their people. 

We stand proudly for our people and support their success through career development and advancement. We are recognized and respected for our culture of inclusion and belonging, continuously striving to do what’s good for our people and communities. 

The impact you will have:


Our GTM Operations, Insights and Analytics team is looking for a talented, curious, and motivated Data Architecture and Insights Analyst to enhance our company’s data infrastructure to guide our business transformation and growth. This role will play a significant part in transforming and maintaining data infrastructure to enhance business intelligence and data analytics for our partner programs across the GTM organization. This will role will be seen by others as a key strategic asset and a driver of innovation and performance across the organization.


Our ideal candidate loves to constantly dig into “the why” and is not afraid to challenge the status quo and ask the difficult questions. In this role you will be reporting to a Supervisor, Marketing Science and execute sophisticated ETL processes for various data sources, ensure data quality and governance and provide insights - through Power BI reporting for programs, enablement, and process improvement across all areas of the GTM organization. The candidate will be expected to define ETL processes, implement and test ETL code, maintain data quality through governance and provide insights via BI reporting.


What you will do:


  • Understand business objectives and processes that will be enabled and/or enhanced by different data solution
  • Analyze business requirements to identify data source(s) and required data columns, gain functional understanding of the data, and analyze the data for feasibility of use to ensure high-quality solutions and presentable data
  • Create and manage data-related artifacts such as data flow diagrams and source-to-target mappings as part of requirements definition and analysis
  • Lead discussions with internal stakeholders and external partners to deploy new initiatives
  • Development of Python code to ingest data from various sources into the enterprise data lake
  • Develop and ensure completeness of Data Governance artifacts and documentation required to deliver solutions.
  • Recommend solutions utilizing data that drive actionable business opportunities/insights and meet business goals/objectives.
  • Accountable for Critical Data Elements, data quality and completeness.
  • Identify and interpret trends and patterns in complex data sets. Analyze data, make recommendations that are actionable and ultimately help drive better business decisions.
  • Assimilate and analyze information from a variety of sources; make recommendations and present information in an easily absorbed and understandable manner.
  • Query customer data, perform analysis, and present findings through clear and innovative visualizations using Power BI.
  • Develop and maintain robust and user-friendly Power BI reports and dashboards for partner program and campaign performances
  • Hands on test automation experience with Database, Phython and ETL Testing

What you'll bring to the table:


  • You are creative and find tackling new problems highly engaging
  • You are an independent, self-driven individual with a highly responsible nature
  • You are proactive in seeking solutions to unique and complex problems
  • You are methodical, organized, with high attention to detail
  • You are an energetic and proactive learner
  • You have strong interpersonal skills and are a team player
  • University degree in Business, Marketing, Information Technology, or related field preferred
  • Minimum 2 years of related experience

Not sure if you qualify? Think about applying anyway:

We understand that not everyone brings 100% of the skills and experience for the role.

At Softchoice, we offer opportunities to a diverse group including those with a variety of workplace experiences and backgrounds.  Whether you are new to corporate tech, returning to work after a gap in employment, or looking to transition and take the next step in your career, we are excited to learn more about you and encourage you to apply.  

Why people love working here:


  • We offer hybrid and remote working opportunities.

  • Comprehensive benefits from day one of employment.

  • We offer meaningful work and opportunities for career growth.

  • Our team members have 2 paid volunteer days per year to give back to a cause of their choice.

  • We offer an opportunity to build and grow a career in the technology industry.

  • Recognized as a Best Workplace in Canada by the Great Place to Work Institute for 17 consecutive years.

  • Softchoice has been certified as a Great Place to Work in the United States for several years.

  • We have also been recognized as a Best Workplace for Women, Best Workplace for Inclusion, Best Workplace for Giving Back and Best Place to Work for LGBTQ+ Equality.

  • We have raised over $3 million through Softchoice Cares, our grassroots fundraising organization.  

Inclusion & Equal opportunity employment:

We are an equal opportunity employer committed to diversity, inclusion & belonging. People seeking employment at Softchoice are considered without regard to any protected category including but not limited to, race, color, religion, national origin, age, sex, marital status, ancestry, disability, veteran status, gender identity, or sexual orientation.

Require accommodation? We are ready to help:

We are proud to provide interview & employment accommodation during the recruitment and hiring process. If you require any accommodation to apply or interview for a position, please reach out directly to We are committed to working with you to best meet your needs.

Our commitment to your experience:

We are committed to the safety of all applicants and team members. With that in mind, we have implemented digital interviewing for everyone. We understand that you may need to interview with distractions around you (such as children or furry friends) and we will be doing the same.

Before you start with us, we will conduct a criminal record check, verify your education, and check your references.

When you join Softchoice, we will onboard you remotely. Don't worry. It's quick, simple and you'll be connected with your new team in no time.


Job Requisition ID: 4262