Microsoft Data and Analytics Consultant

  • Full Time
  • Toronto
  • 100 - 125

Alithya



As a global community of trusted advisors, we create cutting-edge technological solutions to overcome today’s challenges and anticipate tomorrow’s needs. It all starts with the collaboration of a diverse team of passionate intrapreneurs, each driven to make a difference. Together, we challenge the status quo and push each other to new heights.

Ready to make a significant impact on mission-critical projects and shape the future through digital transformation and strategic consulting? Take your ambitions to the next level and discover your next exciting challenge with us!


Your role, your impact

As a Microsoft data and analytics consultant, you will be responsible for helping our clients achieve business success by making data understandable and actionable. In this multifaceted client-facing role, you will help define processes to meet business goals, lead data design and integration efforts, and play a key role in developing advanced data and analytical solutions.

  1. Participate in requirements gathering sessions;
  2. Identify and implement KPIs, measures, dimensions, and other key business drivers;
  3. Analyze client operations and applications;
  4. Review objectives, key business metrics and enterprise reporting requirements with clients;
  5. Evaluate current systems and help define the architecture and ETL strategies for data warehousing;
  6. Make data accessible through various reporting applications (e.g., Fabric).

Keys to your success

Bachelor’s degree in science;


Experience architecting, designing and developing data integration (ETL) solutions (primarily using Microsoft technologies), as well as with reporting and analytics solutions;

Experience with transactional and/or dimensional conceptual and logical data modelling, for both traditional relational data warehouse and modern data lake house architectures;


Strong experience with database technologies: T-SQL, DAX, PySpark, Microsoft Fabric, SQL Server, Azure Data Lake, Azure Synapse, or other cloud data service providers;

Strong experience with data integration: SSIS, Azure Data Factory, Databricks, or other enterprise ETL tools;


Strong experience with reporting or analytics tools: Fabric/Power BI, SSAS, SSRS, Excel;

Excellent presentation, communication, leadership and client development skills to effectively present information to C-level management, public groups and/or boards of directors;


Experience with master data management, metadata management, data governance, data strategies and assessments, data modelling;

Experience with big data, data lake, column-oriented datastores, and other on-premises and cloud-based advanced data technologies;


Experience with Dynamics AX/D365 Finance and Operations;

Experience with TimeXtender and Jet Data Manager, or other data warehouse automation tools;


Knowledge of manufacturing and supply chain processes and use of ERP data sources.

Our offer

  • Balance that works for you: Work-life balance helps us stay at our best. We offer flexible work options, and with our Unlimited Vacation Plan, you can rest and recharge when you need it most.
  • Rewarding achievements every step of the way: Your contributions matter. From day one, our total rewards package offers a comprehensive compensation plan, including short- and long-term incentive programs.
  • Your well-being matters: Our benefits are designed with optimal health and wellness in mind. You’ll have access to 24/7 virtual healthcare, as well as an extensive wellness portal that provides tools and resources to support your physical, mental, emotional and financial well-being.
  • Continuous growth and learning: When you join Alithya, you’re joining a team committed to investing in your development. Refining your expertise is essential in a rapidly evolving industry, and we support your continuous growth every step of the way. Through partnerships with world-renowned education leaders, we provide access to thousands of top-rated online courses and certifications. With exclusive leadership programs designed to empower you to lead your teams with confidence and deliver impactful outcomes, and with a tuition reimbursement program for external training, we set you up for success to thrive and achieve your ambitions.
  • Ownership with opportunity: Our people drive our success. Through our Employee Share Purchase Plan with matched contributions, you become a stakeholder, sharing in our growth and directly benefiting from our collective achievements.

Our authenticity is our strength

The diversity of our backgrounds, experiences, thoughts and insights is our competitive advantage. We foster a collaborative environment rooted in our core values of respect, well-being, passion, trust, integrity and creativity. For us, diversity, equity and inclusion aren’t just buzzwords; they’re essential drivers of innovation and excellence, and powerful catalysts for inspiration and evolutionary ideas. The empowerment of our people is fundamental to being the trusted advisor to our clients. Join us in embracing our authenticity and in leveraging our unique perspectives to collectively build the future we all envision.



An inclusive path to success


Fostering an environment where you can thrive starts with ensuring an accessible recruitment process. If you require any accommodations, we welcome you to contact us. For more information, please visit our accessibility page at https://www.alithya.com/en/accessibility.


#J-18808-Ljbffr

To apply, please visit the following URL: