Continental Technology Solutions is Our consulting and managed services deliver the resources and capabilities required to assess,design, build and manage an agile, flexible IT environment. You'll work with one dedicated team from strategy and assessment through design, implementation, management and optimization to reach a true end-to-end solution.
BI Solution Architect
Montreal, QC
Fulltime/ Permanent Position
10+ years’ experience in Architecting, designing, implementing, managing , solution and supporting OLTP, OLAP , Database, ETL & Analysis & Reporting system(s).
Responsibilities:
• Assessment of business requirements, collection and identification of technical specifications, and the subsequent development of technology solutions that require development to be viable.
• Data Modeling, Data Integration & designing of reports.
• Extensive experience in ETL from various source systems.
• Formulates and recommends standards for achieving maximum performance and efficiency of the DB/DW ecosystem.
• Able to develop/implementing complex data models for data warehouse applications
• Able to recommend tools in various areas like integration, reporting and analytics.
• Extensive experience in Requirement gathering, Functional and technical analysis at onsite and offshore in BI solutions in Customer support domain
• Able to design BI strategy/Roadmap, solution, resolve technical issues, Support for Technical solution in Proposals, developing Proof of Concept on new BI areas, Customer Presentations on MS BI capabilities, & solution demonstrations.
• Involved in overall enterprise data architecture and conceptual data model
• Formulates and recommends standards for achieving maximum performance and efficiency of the DW ecosystem
Qualifications:
• 10+ years of overall experience implementing end to end BI projects including T-SQL programming, SSIS, SSAS, tabular modeling, DAX,MDX & Reporting services
• 1+ years of experience in reporting tool e.g. HighChart, Qlikview, Tableau
• Hands on experience on SSIS, SSAS & SSRS, Performance Point server, Power view, Qlikview, Tableau and HighChart with SharePoint
• Excellent communication & team management skills
• Strong problem solving skills & proactive attitude
• Exposure to Big Data related technologies would be an added advantage.
All your information will be kept confidential according to EEO guidelines.
Skills Required
- 10+ years implementing end-to-end BI projects including T-SQL programming, SSIS, SSAS, tabular modeling, DAX, MDX and SSRS
- 10+ years architecting, designing, implementing and managing OLTP, OLAP, databases, ETL, analysis and reporting systems
- Experience in data modeling and data integration for data warehouse applications
- Extensive ETL experience from various source systems
- 1+ years experience with reporting tools such as Highcharts, QlikView, Tableau
- Hands-on experience with PerformancePoint Server, Power View and SharePoint
- Requirement gathering, functional and technical analysis (onsite and offshore) in BI solutions
- Ability to design BI strategy/roadmap, produce POCs, deliver customer presentations and solution demonstrations
- Excellent communication and team management skills
- Strong problem solving skills and proactive attitude
- Exposure to Big Data related technologies
What We Do
Continental Technology Solutions is an Information Technology and Professional Services company headquartered in Houston, USA, with global offices in the UK, Canada, Australia, Singapore, Hong Kong, and India. The company specializes in AI, cloud technology, and Product Lifecycle Management (PLM), providing innovative business solutions and staffing services to a client list that includes mid-sized to Fortune 500 companies worldwide.
