Senior Engineer II - PowerBI

Location: Canada

State/Province/City: British Columbia

City: Vancouver

Business Unit: Store Support Centre (SSC)

Description & Requirements

who we are
lululemon is an innovative performance apparel company for yoga, running, training, and other athletic pursuits. Setting the bar in technical fabrics and functional design, we create transformational products and experiences that support people in moving, growing, connecting, and being well. We owe our success to our innovative product, emphasis on stores, commitment to our people, and the incredible connections we make in every community we're in. As a company, we focus on creating positive change to build a healthier, thriving future. In particular, that includes creating an equitable, inclusive and growth-focused environment for our people.

about this team


The Senior Engineer II will be part of the Data Analytics team building real-time enterprise-level platform reporting solutions using Fabric Power BI from multiple sources such as Snowflake, Azure, AWS, JIRA, ServiceNow, etc. The ideal candidate will analyze data across multiple systems and work closely with the platform engineering team to build the optimal end-to-end BI solution using the full stack of Azure data services to satisfy business needs. In addition to these responsibilities, the candidate will ensure robust governance and security operations within the Fabric. The candidate will also be working with the platform administration team to configure security settings in line with organizational policies. The role involves working with cross-functional technology teams to analyze and build semantic data models, create reports and dashboards, manage data, evaluate results, and strategically display insights using visualization tools, DAX queries, charts, and relationships.


a day in the life 

As a Senior Engineer II, you will work as the technical leader for the product(s) your team delivers. You will be counted on as a leader in your technology space, as you contribute to all areas of development and operations (pre-production to production). As a Senior Engineer II, you will dedicate a fair amount of time to the planning and discovery of tools and practices inside your given area of expertise. You will apply that knowledge by working closely with Staff Engineers to promote platform level change. Senior Engineer IIs, take production readiness and performance personally and help drive continuous improvement. You will be part of a day-to-day production release team and may perform on-call support functions as needed. You will be considered the technical owner of the production system(s) you work on and focus on how your product(s) are delivered and how to optimize them for efficiency, security and reliability.


  • Main contributor for product roadmaps and reliability strategy
  • Conduct research to aid in product development and tools selection
  • Provide an escalation point and participate in on-call support rotations
  • Actively monitor key metrics, reports on trends, and make improvement recommendations
  • Facilitate an Engineering Community of Practice for your product(s)
  • Contribute to engineering automation, management or development of production level systems
  • Review product roadmaps and guide intake acceptance for a set of production systems
  • Own reliability for a defined set of production systems
  • Own the delivery lifecycle for a defined set of production systems
  • Co-ordinate with multiple data source teams in building Power BI dashboards adhering to industry standards, policies, and best practices. 
  • Fabric Power BI administrative tasks such as configuring workspace, capacity management etc.
  • Mentor Junior resources and drive end to end design, implementation and delivery of engineering components.
  • Collaborate with cross-functional teams – business stakeholders, engineers, program management, project management, etc. - to produce the best solutions possible.
  • Anticipate system/application challenges and propose solutions for the same.
  • Contribute to story sizing and work estimates for implementation, validation, delivery and documentation.
  • Reviewing the technical architecture and ensuring the design follows the organization tech landscape and standards.


qualifications

  • BS in Computer Science or related
  • 5+ years of experience as a Power BI developer in BI space is needed
  • Experience working with Snowflake & Azure technologies is a must
  • Working experience of scripting, data science and analytics (SQL, Python, PowerShell, JavaScript) is needed
  • 2+ Years of performance tuning and optimization, bottleneck problems analysis, and technical troubleshooting in a sometimes, ambiguous environment
  • 2+ Years working with Azure cloud-based systems
  • Experience working with cloud-based systems - Azure & Snowflake data warehouses will be an add
  • Experience with Azure SQL Services will be an add
  • Experience with reporting layer Fabric Power BI is necessary 
  • Experience with optimizing Semantic Models using various tools like DAX Studio, Tabular Editor, Performance Analyzer and monitoring the Capacity utilization is required.
  • Working experience in designing data pipelines, table structures, and SQL queries is desirable
  • Experience working with large volume data; retail experience strongly desired
  • Working knowledge of CI/CD DevOps Process and Implementation.
  • Working knowledge of building data integrity checks as part of delivery of applications
  • Technical expertise to build code that is performant as well as secure.
  • Technical knowledge on infrastructure creation using Terraform is desirable
  • Technical depth and vision to perform POC’s and evaluate different technologies


must haves
  • Acknowledge the presence of choice in every moment and take personal responsibility for your life.
  • Possess an entrepreneurial spirit and continuously innovate to achieve great results. 
  • Communicate with honesty and kindness and create the space for others to do the same. 
  • Lead with courage, knowing the possibility of greatness is bigger than the fear of failure. 
  • Foster connection by putting people first and building trusting relationships. 
  • Integrate fun and joy as a way of being and working, aka doesn’t take yourself too seriously.

Additional Notes
Authorization to work in Canada is required for this role. 

Compensation and Benefits Package 
lululemon’s compensation offerings are grounded in a pay-for-performance philosophy that recognizes exceptional individual and team performance. The typical hiring range for this position is from $144,400 - $177,500 annually; the base pay offered is based on market location and may vary depending on job-related knowledge, skills, experience, and internal equity. As part of our total rewards offering, permanent employees in this position may be eligible for our competitive annual bonus program, subject to program eligibility requirements.   

At lululemon, investing in our people is a top priority. We believe that when life works, work works. We strive to be the place where inclusive leaders come to develop and enable all to be well. Recognizing our teams for their performance and dedication, other components of our total rewards offerings include support of career development, wellbeing, and personal growth:
  • Extended health and dental benefits, and mental health plans 
  • Paid time off 
  • Savings and retirement plan matching 
  • Generous employee discount 
  • Fitness & yoga classes 
  • Parenthood top-up 
  • Extensive catalog of development course offerings 
  • People networks, mentorship programs, and leadership series (to name a few) 
Note: The incentive programs, benefits, and perks have certain eligibility requirements. The Company reserves the right to alter these incentive programs, benefits, and perks in whole or in part at any time without advance notice.

workplace arrangement

This role is classified as In-Person under our SSC Workplace Policy:


In-Person 

In-person collaboration and connection is important to our culture. Work is performed onsite, minimum 4 days per week.


#LI-Onsite
#LI-SS1