Lead Data Analyst / Power BI

Who We Are

tsworks Canada, Inc is a technology products and services company based out of Ontario, Canada. We are a subsidiary of The Software Works, Inc, USA.

Our mission is to adopt, challenge and set the best practices in Information Technology. At tsworks Canada Inc, we value our employees, take pride in providing best value in customer engagements, and make every effort to be transparent, responsible, and prompt in our commitments.

About This Role

tsworks Canada, Inc is seeking driven and motivated Lead Data Analyst to join its Digital Services Team. You will get hands-on experience with projects employing industry-leading technologies.

This position will be a contract to perm, reporting to the Senior Manager and work type will be hybrid with a 2-3 days per week, on-site, in our clients’ locations in Vancouver, BC.

This would initially be focused on the operational readiness and maintenance of existing applications and would transition into a build and maintenance role in the long run.

• Position : Lead Data Analyst
• Experience : - 10+ Years of hands-on experience in Information Technology
• 5+ years of experience designing and executing data solutions in Business Intelligence.
• Location : Vancouver, BC

What skills do we expect from you on Power BI

• Extensive hands-on Power BI visual dashboards, applications, KPI (key performance indicators) scorecards, DAX functions.
• Experience with performance tuning Power BI datasets and reports with Direct and Import mode, Aggregations, Filter Contexts, Partitioning, Row Level Security etc.
• Experience managing and optimizing Power BI Capacities, using Advanced Restful APIs

What skills do we expect from you in Data and Analytics

• Experience on cloud data ecosystems AWS (Amazon Web Services) Redshift, Azure Synapse, Snowflake or Data Bricks
• Experience writing and tuning performance on complex SQL queries.
• Experience with Star / Snowflake data models
• Experience providing solutions on Retail or Finance data domains.
• Ability to articulate, create, and maintain technical and non-technical documentation.

In This Role, You Will

• Design and build data applications on public cloud environments (AWS, Azure, GCP) and / or hybrid cloud using a well architected framework.
• Leveraging expertise in data analysis, visualization, and business intelligence to provide valuable insights and support data-driven decision-making within the organization.
• Lead a team of data analysts to execute the data strategy and maintain the ecosystem.
• Regular evaluation of changes in the data industry and adopt the best practices in terms of technology, governance, security, and compliance.
• Optimize cloud data infrastructure costs.
• Respond to technical issues in a professional and timely manner.
• Develop Power BI visual dashboards, KPI scorecards, and reports utilizing Microsoft technology stack.
• Leverage modern Power BI to extract and manipulate data from a variety of diverse sources.
• Write complex DAX functions in Power BI and Power Pivot.
• Present alternative ways for internal customers to visualize and consume data.
• Understand business questions / pain points and alleviate with supporting data.
• Ensure data accuracy, consistency, and adherence to data governance policies. Conduct data quality checks and implement measures to maintain data integrity.
• Research advanced analytic / visualization capabilities to improve customer understanding of data insights.
• Collaborate cross-functionally at various levels and diplomatically influence stakeholders.
• Demonstrate excellent analytical, problem-solving, and decision-making skills.
• Demonstrate the ability to multi-task, deal effectively with ambiguity, change in business requirements, and self-prioritize under pressure.
• Debug data issues and deliver quality results under tight timelines.

Preferences

• Bachelor's degree in computer science, computer engineering, information technology, or relevant field.
• Experience in Azure Data Factory or other ETL (Extraction, Transformation, Loading) tools solutioning and development
• Experience working in an agile setting.
• Being self-driven, naturally curious, and able to adapt to a fast-paced work environment.
• Public cloud certifications.
• Excellent Communication Skills
Il y a 21 heures