BI Solution Architect

Posted Yesterday
Be an Early Applicant
Montréal, QC, CAN
In-Office
Expert/Leader
Artificial Intelligence • Cloud • Information Technology • Professional Services
The Role
Design, architect and implement end-to-end BI solutions including OLTP/OLAP, ETL, data modeling, integration and reporting. Lead requirements gathering, propose BI strategy/roadmap, recommend tools, build proofs-of-concept, optimize DW performance, and support customer presentations and technical proposals.
Summary Generated by Built In
Company Description

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 optimisation to reach a true end-to-end solution.

Job Description

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.

Skills Required

  • 10+ years overall experience implementing end-to-end BI projects
  • T-SQL programming experience
  • Hands-on SSIS experience
  • Hands-on SSAS experience (including tabular modeling)
  • Experience with DAX and MDX
  • Hands-on SSRS (Reporting Services) experience
  • Experience with reporting tools (HighChart, QlikView, Tableau) — 1+ years
  • Experience with PerformancePoint Server and Power View
  • Experience integrating BI with SharePoint
  • Extensive ETL experience from various source systems
  • Data modeling and data integration experience for data warehouse applications
  • Excellent communication and team management skills
  • Strong problem solving skills and proactive attitude
  • Exposure to Big Data related technologies
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
350 Employees

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.

Similar Jobs

Continental Technology Solutions, Inc Logo Continental Technology Solutions, Inc

Architect

Artificial Intelligence • Cloud • Information Technology • Professional Services
In-Office
Montréal, QC, CAN
350 Employees

2K Logo 2K

Design Director

Gaming • Information Technology • Mobile • Software • Esports
Remote or Hybrid
Québec, QC, CAN
4200 Employees

DraftKings Logo DraftKings

Software Engineer

Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Remote or Hybrid
Canada
6400 Employees

Square Logo Square

GTM Strategy & Operations - Global Account Management

eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Remote or Hybrid
8 Locations
12000 Employees
103K-194K Annually

Similar Companies Hiring

Legora Thumbnail
Artificial Intelligence • Legal Tech • Software
Chicago, Illinois
700 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account