Job Summary
Senior Database/BI Developer (54330057)
Location: Etobicoke, ON Category: Content/Document Management
Job Type: Direct Hire Reference: CA_EN_6_17450_54330057
Posted: November 30,2016 Salary: N/A

Print image email image
Apply Now

 
 
 
Modis, on behalf of our client is looking for a Senior Database/BI Developer
 
Senior Database/BI Developer (54330057)
 
Permanent Position
Location: Toronto, ON
 
Responsibilities:
 
• Work closely with BI and other reporting/analytical groups to determine data and reporting requirements
• Document new datamart model/framework and implement process around the use of datamarts
• Design and develop complex datamarts and stored procedures in a Microsoft SQL environment
• Develop and implement an efficient daily and monthly load log process including notifications of failures and successful load completions
• Proactively perform database monitoring and work closely with Database Administrators to optimize database performance
• Work closely with Enterprise Data Integrations (EDI) team to determine and maintain data warehouse growth
• Perform extensive analysis of database entities, relationships and attributes to determine efficient design solutions while meeting business needs
• Develop, implement, and maintain change control for modifications to databases, procedures and SSIS packages
• Identify inefficiencies in current load processes and recommend/implement resolutions
• Support team members with testing initiatives to ensure and maintain data integrity including accuracy and completeness
• Work closely with developers to identify resolve complex technical issues
 
Required Qualifications/Experience
 
• Bachelor’s Degree in Information Technology/Computer Science or a related field
• 3+ years of experience in database design, development and implementation, with significant experience in designing in a large SQL environment
• Strong knowledge of SQL Server Experience with normalized and de-normalized data, dimensional modeling techniques, Star & Snowflake schemas and slowly changing dimensions
• Extensive knowledge of MS SQL Server 2005/2008/2012/2014 (tables, triggers, functions, unions, joins, complex queries and stored procedures)
• Strong experience in the physical and logical design of database architecture
• Fluent in English (reading, writing, and verbal)
• Ability to successfully influence effective solutions
• Ability to follow and enforce change management processes within production environments
• Comfortable in a fast-paced environment, working across multiple projects simultaneously
• Demonstrated interest and ability to work on new, innovative, cutting edge technologies
 
Please note that Candidates must be legally eligible to work in Canada. Your resume will not be forwarded to any of our clients without your explicit permission. We thank all applicants, but only suitable applicants with the above qualifications clearly identified in their resumes will be contacted. Modis Canada is an Equal Opportunity Employer.
 
 
We’re at the center of exceptional IT connections. Every day, Modis connects premier IT professionals to great opportunities at leading companies. Put our connections to work for you!
 




Print image email image
Apply Now
alt