Business Intelligence Apr 27, 2021 Developer. Business Intelligence, Field Services Req Id: 287674 At Bell, we do more than build world-class networks, develop innovative services and create original multiplatform media content – we advance how Canadians connect with each other and the world. If you’re ready to bring game-changing ideas to life and join a community that values, professional growth and employee wellness, we want you on the Bell team. Bell’s Field Services team is proud to be the face of the Bell brand, performing the best installation and repair services and maintaining Bell’s network for our residential and business customers. Job Duties/ Accountabilities: Design functional requirements, program SQL database objects and data transformation "ETL" in a Microsoft SQL Server environment Work closely with Business Analyst to implement end-to-end database solutions Analyze the solution taking into consideration the infrastructure in place, opportunities and information security Optimize database programming to avoid bottlenecks and implement a data archiving strategy Reuse the team’s common libraries, programming standards and apply best practices Provide estimate, work breakdown structure (WBS) and progress on projects Creation of user guides and participate in the improvement of production applications Post-deployment application support and identify problems, find solutions and apply fixes Manage a development team Critical Qualifications/ Competencies: Strong experience of at least 5 years in SQL query, DDL creation, T-SQL programming (procedure, function …) and ETL in Microsoft SQL Server 2012 or more recent Strong experience in objects database modeling and relational models Experience with SSIS, SSAS and SQL Agent Scheduler tools Experience in a transactional (OLTP) and analytical (OLAP) database environment Experience with Git or Team Foundation Experience with Microsoft Office Word, Excel and PowerPoint Good communication, teamwork, documentation and organizational skills Bilingual (French and English) Preferred Qualifications/Competencies: Experience with DevOps practice Experience with the SAS platform: DIS,SAS Base programming and the SAS Enterprise Guide tool Bilingualism is an asset (English and French); adequate knowledge of French is required for positions in Quebec. Additional Information: Position Type: Management Job Status: Regular – Full Time Job Location: Canada : Quebec : Montreal Application Deadline: 05/11/2021 Please apply directly online to be considered for this role. Applications through email will not be accepted. At Bell, we donât just accept difference – we celebrate it. Weâre committed to fostering an inclusive, equitable, and accessible workplace where every team member feels valued, respected, and supported, and has the opportunity to reach their full potential. We welcome and encourage applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. For a confidential inquiry, simply email your recruiter directly or email@example.com to make arrangements. If you have questions regarding accessible employment at Bell please email our Diversity & Inclusion Team at firstname.lastname@example.org. Created: Canada, QC, Montreal Bell, one of Canada’s Top 100 Employers.