Lead Business Intelligence Developer (SQL)
Waterloo, ON, CA Richmond Hill, ON, CA Mississauga, ON, CA
OPENTEXT - THE INFORMATION COMPANY
As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management.
Life at Opentext: #LI-Remote
At OpenText and in IT, we believe in every employee having meaningful, purposeful work. By joining our team, you will join a community of supportive and collaborative peers focused on innovation, teamwork, and driving successful outcomes. You’ll be expected to bring with you an ideation and “Yes, if” mindset. And, as you build your network and demonstrate your professional excellence, you will have the opportunity to forge your own career path and professional growth.
Overview #INDOT
OpenText is looking for Lead BI Developer with a passion for data to join the Business Intelligence team. You will assist in the design of BI solutions using the Microsoft BI stack including SQL Server, SSAS, SSIS and SSRS. Your primary focus will be managing development through the SDLC.
Responsibilities
- Development of Data Flows and Column Mapping (Source to Warehouse)
- Development of Data Models (Physical and Logical)
- Development of Functional Specifications
- Development and execution of test plans
- Technical Specification and Code reviews
Must Have
-
- Post-secondary university, college or equivalent experience
- 8+ years of T-SQL, SSIS and SSAS development (2012, 2017, 2019)
- Data Modelling and design skills
- Dimensional Modelling skills
- Experience with Logical and Physical Data Modelling
- Excel Skills
- PowerPoint Skills
- Team player with positive attitude
- Detail conscious, Problem solver & Innovative thinker
- Good communication skills – written and verbal.
- Good interpersonal & presentation skills
Nice to Have
-
- Familiarity with any of the data models of SAP Simple Finance, SAP BW, SalesForce, FrontRange ITSM, Changepoint, Siebel CRM, OpenAir or Service Now
OpenText's efforts to build an inclusive work environment go beyond simply complying with applicable laws. Our Employment Equity and Diversity Policy provides direction on maintaining a working environment that is inclusive of everyone, regardless of culture, national origin, race, color, gender, gender identification, sexual orientation, family status, age, veteran status, disability, religion, or other basis protected by applicable laws. Should you require accommodations during the selection process, please contact accommodationrequests@opentext.com.
Subject to applicable laws and regulations, OpenText’s global vaccination policy requires all employees to be fully vaccinated against COVID-19 to enter an OpenText office. Accommodations may be available for specific roles.