Sr. Analyst- Data Transformation & Visualization

Title: Sr. Analyst- Data Transformation & Visualization

Location: Toronto, ON (Need to visit 3 days onsite)

Job Type: Contract

Job Details:

Responsibilities:

1. Lead the technical migration of business rules currently embedded within Power BI (DAX, Power Query) and Domo platforms (Magic ETL) into SQL, ensuring our business logic remains portable and optimized.

2. Recommend changes to data schemas and dataflows to better align with new ETL processes.

3. Manage and enhance data visualizations on platforms such as Domo or Power BI, downstream of dataflow improvements.

4. Actively participate in the team's sprint process and collaborate with key reporting stakeholders.

Project Focus:

The contractor will primarily focus on migrating business logic to SQL with storage and execution of this code in Databricks. In addition, the role will involve migrating front-end reporting from one platform to another (e.g., Power BI to Domo).

Qualifications:

• 7-8 years of experience with data transformation, particularly in large and complex organizations.

• Expertise in Power BI DAX, Power Query, and SQL is essential.

• Strong experience in managing data visualizations in platforms such as Domo or Power BI.

• Experience with media or exposure to the industry is a plus.

Location & Flexibility:

The position is located in Toronto. The contractor will be expected to work in-office 3-5 days a week.

Expected Deliverables:

• Successful migration of complex data transformation steps from Power BI or Domo into SQL (via Databricks), for multiple existing reporting solutions.

• Migration of front-end reporting solutions from one platform to another, based on requirements/roadmap.

If interested, you can apply or send resume at [email protected]