Continental Technology Solutions, Inc Logo

Continental Technology Solutions, Inc

BI Solution Architect

Posted 7 Days Ago
Be an Early Applicant
In-Office
Montréal, QC, CAN
Expert/Leader
In-Office
Montréal, QC, CAN
Expert/Leader
Design, architect and implement end-to-end BI and data warehouse solutions. Lead requirements gathering, data modeling, ETL integration, report design and tool selection. Provide technical leadership, create BI roadmaps, develop proofs-of-concept, present solutions to customers, and recommend standards to optimize DW/DB performance.
The summary above was generated by AI
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 optimization to reach a true end-to-end solution.

Job Description

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.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Similar Jobs

7 Days Ago
In-Office
Montréal, QC, CAN
Expert/Leader
Expert/Leader
Artificial Intelligence • Cloud • Information Technology • Professional Services
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.
Top Skills: Big DataData WarehouseDaxETLHighchartMdxOlapOltpPerformancepoint ServerPower ViewQlikviewSharepointSsasSsisSsrsT-SqlTableauTabular Modeling
3 Hours Ago
Remote or Hybrid
Canada
Senior level
Senior level
Financial Services
Advise payments business on regulatory and policy requirements, design and assess compliance controls, support risk assessments, manage incidents and remediation, prepare for regulatory examinations, produce governance materials, and deliver training to ensure payments operations meet Canadian regulatory expectations.
7 Hours Ago
Remote or Hybrid
CA
Senior level
Senior level
eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Lead pricing modeling and experimentation to optimize margin, conversion, and retention. Build elasticity and willingness-to-pay models, design A/B and bandit experiments, develop pricing automation (DealBot) and monitoring for AI-driven rate recommendations, own ETL/analysis/visualization, and partner with Finance, Risk, Product, and GTM teams to operationalize pricing intelligence.
Top Skills: Agentic AiLlmsLookerNumpyPandasPythonRRag SystemsSnowflakeSQLTableau

What you need to know about the Montreal Tech Scene

With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.

Key Facts About Montreal Tech

  • Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
  • Major Tech Employers: SAP, Google, Microsoft, Cisco
  • Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
  • Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
  • Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
  • Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account