BI SOLUTION ARCHITECT JOB DESCRIPTION

A BI Solution Architect owns the data architecture decisions that determine whether an organization's reporting infrastructure stays reliable or becomes a bottleneck that costs analyst teams hours of rework per sprint. The role translates business requirements into data models, ETL pipelines, and visualization frameworks that serve Finance, Sales, and Operations stakeholders across cloud and on-premises environments. Most BI Architects in this space hold direct accountability for technology roadmaps that span multi-year platform modernization efforts. That combination of hands-on delivery authority and enterprise-wide planning scope sets this seat apart from adjacent analytical roles.

As the BI Solution Architect, you define the technical and functional architecture of enterprise data and analytics platforms, converting stakeholder reporting needs into scalable, governed solutions that support data-driven decisions across the organization. You operate within a cross-functional engineering team, partnering with product owners, delivery leads, and senior leadership to align the architecture roadmap with business direction.

Career Impact: Owning an enterprise-wide BI roadmap builds a track record in dimensional modeling, cloud data warehouse governance, and Agile delivery that senior technical leadership roles in data engineering require.

Business Impact: When the architecture you design performs well, Finance and Sales teams get trustworthy, real-time reporting instead of reconciling conflicting figures from disconnected data sources.

Growth Opportunity: The breadth of this role, from proof-of-concept prototyping through production deployment and ongoing platform governance, accelerates movement into Director of Data Architecture or VP of Analytics positions.

• Define and maintain the enterprise BI architecture, including data models, ETL standards, and platform governance policies.
• Lead solution architecture delivery on assigned programs, capturing scope, trade-offs, and rationale in clear architectural artifacts.
• Partner with Finance, Sales, and Operations stakeholders to translate reporting requirements into technical data structures and visualization frameworks.
• Own the technology roadmap for the BI and data warehouse environment, aligning platform priorities with multi-year business objectives.
• Conduct design reviews of proposed and existing architectures to ensure production readiness, scalability, and standards compliance.
• Drive adoption of best practices across delivery teams through internal guidelines, documentation, and hands-on technical advisory.
• Evaluate and validate vendor solutions through proof-of-concept testing before integration into the production environment.
• Mentor BI developers in data modeling, ETL design, and deployment standards to raise capability across the team.

• Bachelor's degree in Computer Science, Information Systems, or Engineering, or equivalent work experience.
• 5 or more years of BI solution architecture experience, with demonstrated ownership of enterprise data warehouse design and delivery.
• Proficiency in dimensional and relational data modeling, including star schema, Data Vault, and columnar store design.
• Experience designing and implementing cloud-based data warehouse environments and hybrid on-premises and cloud platforms.
• Competency in ETL and data integration design, including transformation logic, pipeline orchestration, and data quality validation.
• Strong ability to develop and communicate multi-year technical roadmaps to both engineering teams and non-technical senior stakeholders.
• Experience implementing CI/CD practices, version control, and automated testing within BI and data platform delivery.
• Demonstrated knowledge of Agile and DevOps delivery methodologies applied to data and analytics programs.

• Experience leading BI architecture in Finance, Accounting, or Sales domain environments where data governance and auditability are primary constraints.
• Familiarity with cloud identity and access management frameworks, including role-based access control design for analytics platforms.
• Exposure to unstructured data processing technologies and their integration patterns within governed enterprise data environments.
• Prior experience in technology consulting or pre-sales architecture roles, with the ability to produce statements of work and solution proposals.

• Architecture artifacts delivered per program, measured against stakeholder sign-off rate and revision cycles.
• Data model adoption rate, tracking the percentage of reporting built on governed, centrally maintained structures versus ad hoc queries.
• Platform availability percentage for the production BI environment, reflecting infrastructure reliability under the architect's ownership.
• Proof-of-concept completion time, measuring how quickly candidate solutions are evaluated and a recommendation is produced.
• Roadmap milestone adherence rate, comparing planned versus actual delivery of platform modernization milestones across quarters.
• Typical tools: BI and Visualization platforms (commonly Power BI or Tableau); cloud data warehouse platforms (commonly Snowflake or Redshift); ETL orchestration tools (commonly Azure Data Factory or SSIS).

• Base Salary Range: $130,000 to $175,000 annually depending on experience and location.
• Bonus: 10 to 15 percent annual performance bonus, common in enterprise technology environments.
• Equity: RSUs or stock options offered at larger technology firms and publicly traded employers.
• Health Benefits: Medical, dental, and vision coverage, typically employer-subsidized for employee and dependents.
• PTO: 15 to 20 days annually, plus federal holidays and sick leave.
• Common Perks: Remote or hybrid work options, conference and certification budget, home office stipend.

Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.

Reasonable accommodations are available to applicants with disabilities throughout the hiring process and in the workplace upon request. All qualified applicants are considered for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other characteristic protected under applicable federal, state, or local law. Employment in this role is contingent on successful completion of a background check. Candidates must be authorized to work in the United States without sponsorship unless otherwise stated in the offer.

The BI Solution Architect owns the end-to-end technical infrastructure strategy, ensuring systems remain documented, adaptable, and aligned with business pace while developing a future engineering roadmap alongside senior leadership. Collaborating with virtual teams across time zones, the role delivers hands-on support across projects and steers technological innovation to enable richer data, analytics, and insights across the organization.

Key Responsibilities

• Ensure reliable technical systems infrastructure that is well documented, adaptable, and ready for change in line with the pace of the business.
• Develop a detailed roadmap and strategy for future engineering infrastructure in collaboration with senior leadership.
• Gain deep understanding of existing technical infrastructure and own it entirely.
• Support projects and initiatives hands-on, contributing technical experience where team members lack certain skills.
• Initiate and steer technological innovation across the organization.
• Define how data will be stored, consumed, integrated, and managed within data platforms.
• Collaborate with virtual teams across different time zones to deliver solutions.

Required Qualifications

• Demonstrate 8+ years of technical initiative in areas relevant to this role.
• Experience in Finance, Accounting, Sales, or Marketing domains and understanding of their specific needs.
• Deep understanding of the Power BI ecosystem, including DAX, PowerQuery (M), Dataflows, and Azure Analysis Services.
• Proficiency in C#/.NET Core and PowerShell for scripting and automation.
• Practical experience with Azure Data, Storage, Analytics, Compute resources, and Azure deployment technologies.
• Experience managing on-premises Windows Server machines and SQL Server databases, both on-premises and cloud.
• Understanding of cloud identity systems including Azure AD and OAuth 2.0/OpenID Connect.
• Experience implementing CI/CD pipelines, DevOps practices, and automated testing.
• Strong communication skills to convey complex ideas clearly to non-technical stakeholders.

As a BI Solution Architect, you'll be part of a team of smart, highly skilled engineers and architects who are proud to partner with some of the world's leading retailers on challenging, cutting-edge, Innovative and data driven solutions - all powered by our exceptional technology and people. Embedded within a co-located agile team in Toronto, the BI Solution Architect defines and promotes BI, web, and data architecture strategy across Qlik, Sisense, Snowflake, and cloud-native technologies. Working closely with R and D, Data, and Tech Analytics teams, the role drives solution design and technical roadmaps that deliver analytical outcomes for retail clients worldwide.

Core Functions

• Define, develop, and promote BI, web, and data architecture strategy to achieve analytical solutions and strategic information management goals.
• Lead design, development, and implementation of solution architecture including BI standards, architecture patterns, and data models.
• Lead solution architecture efforts supporting key analytics innovations involving multiple internal and external stakeholders.
• Ensure solution architecture aligns with product vision roadmaps and broader architecture principles across functional teams.
• Define how data will be stored, consumed, integrated, and managed within data platforms and application products.
• Research new technologies, create architectural roadmaps, and define development standards for new products and enhanced solutions.
• Provide advice on designing and implementing optimal BI technical architecture and security frameworks.

Qualifications and Experience

• 5+ years of experience leading complex BI and data architecture projects with large data sets.
• Expertise with multiple modern BI tools including Qlik, Sisense, Tableau, and Power BI.
• Expertise with SaaS development and deployment, with cloud experience preferred.
• Expertise in SQL and proficiency in dimensional and relational database design using Snowflake, Redshift, and Teradata.
• Expertise in developing and communicating technical roadmaps and leading development teams in technical adoption.
• Exposure to modern web development technologies including Java, .NET, Node.js, JavaScript, Angular, REST APIs, and microservices.
• Expertise in Lean and Agile software development methodologies including Kanban and Scrum.
• Degree in Computer Science, Engineering, or Information Systems, or equivalent experience.

BI Solution Architect is responsible for the assessment of business requirements; collection and identification of functional and technical specifications; and the subsequent development of BI solutions that require development to be viable. Reporting to regional IT leadership, the BI Solution Architect drives APAC manufacturing data analytics and visualization initiatives, leading cross-functional teams of business, IT, and partner professionals to design and deliver competitive analytical products. Partnering with clients to translate business problems into innovative solutions, the role accelerates data-driven decision making in production environments.

Primary Duties

• Drive APAC manufacturing data analytics and visualization initiatives and products.
• Support definition, development, and implementation of new regional analytical products.
• Engage with clients to understand business problems and propose innovative solutions.
• Lead a diverse network of professionals across business, IT, and partner teams to design competitive solutions.
• Ensure analytical products generate insights to accelerate data-driven culture and decision making in production.
• Ensure all products consider business value, usability, and feasibility.
• Build strong client relationships by demonstrating deep BI and analytics expertise.

Skills and Qualifications

• Minimum 5 to 7 years of experience in Business Intelligence and Data Warehousing domain with strong knowledge of theory and methodology.
• Proven technical capability with deep expertise in mainstream BI and Data Warehousing technologies.
• Experience working in agile environments leading the full lifecycle of analytical products from development to user adoption.
• High analytical drive with demonstrated ability to achieve stretched goals in a fast-paced environment.
• Excellent problem-solving and analysis skills combined with solid business judgment.
• Strong written and oral communication skills in both Chinese and English.

Act as a technical liaison between stakeholders, delivery teams, and support teams to ensure technical alignment of priorities, vision, and execution. Sitting at the intersection of architecture and hands-on delivery, the BI Solution Architect owns the technology roadmap and aligns it with overall business direction while directly contributing to technical implementation alongside product owners and developers. Operating across vendor management, proof of concept initiatives, and internal guideline development, the role shapes a quality-driven engineering culture through research-backed decisions and clear articulation of trade-offs.

Duties

• Work with vendors to select, test, and implement solutions ensuring they meet requirements.
• Conduct proof of concept in the lab and trials.
• Own a technology roadmap and align it with overall business direction.
• Directly contribute to hands-on technical delivery alongside product owners and developers providing design leadership and strategic advisory.
• Drive the team to adopt best practices, implement internal guidelines, and maintain a quality-driven approach.
• Collaborate with teams to present potential technical solutions, clearly articulating feasibility, benefits, and trade-offs.
• Identify and recommend areas for improvement through design sessions, proof of concept initiatives, and process improvement decisions.

Experience and Qualifications

• Bachelor's or advanced degree in Computer Science or closely related subject.
• 4+ years of experience in software development and architecture.
• 2+ years of experience building Java or Python data engineering and data science projects.
• 2+ years of big data expertise including Hadoop.
• Experience setting up containerized environments using Kubernetes and Docker.
• Solid knowledge of cloud-based and microservices architecture.
• Expertise in SQL, NoSQL, and other query languages.
• Knowledge of Linux, Unix, and scripting.
• Strong leadership, team-building, and collaboration skills with demonstrated ability to articulate decisions with research and clear rationale.

A key member of the IT architecture function, the BI Solution Architect embeds within business teams to identify opportunities to apply IT solutions to data insight challenges and leads end-to-end design, development, and testing of BI solutions using modern engineering techniques including automated testing and continuous deployment. Collaborating across Data Analytics, Master Data Management, and IT Infrastructure teams, the role delivers production-standard systems that maximize business value from enterprise-wide data platforms.

Functions

• Embed within business teams to identify opportunities to apply IT solutions to data insight challenges and help business teams understand how technology can help them do more with their data.
• Work directly with business stakeholders to formulate, analyze, and manage an agreed backlog of opportunities.
• Work collaboratively and iteratively with business stakeholders to design, develop, and test BI solutions.
• Design advanced conceptual, logical, and physical data models, repositories, dashboards, and reports within a complete functional and technical architecture.
• Take ownership of architecture of any systems developed and choose appropriate technology stacks.
• Collaborate with organizational efforts around Data Analytics and Master Data Management.
• Work with the IT Infrastructure team to deploy solutions sustainably.
• Deliver robust, production-standard systems using modern software engineering techniques including automated testing, continuous integration, and automated deployment.

Technical Qualifications

• 5 to 10 years of relevant working experience as a BI solution architect.
• Experience designing and implementing enterprise-wide data platforms.
• Experience leading data conversations and developing business concepts.
• Exceptionally strong relational and dimensional modeling skills in relational database technologies, with SQL Server preferred.
• Knowledge of analytical querying using SSAS cubes or columnar data stores.
• Experience with visualization tools such as Tableau, Power BI, and Excel.
• Experience with ETL tools such as SSIS, Alteryx, and Azure Data Factory.
• Understanding of unstructured data stores and processing technologies such as MongoDB, Hadoop, and Spark.
• Experience with PaaS services leveraging cloud elasticity, with Azure preferred.

Trusted data and analytics outcomes for the APAC region depend on the BI Solution Architect, who partners with business stakeholders to translate reporting and insight needs into data requirements, visualization layers, and database architecture while owning the regional platform release schedule and features backlog. Based within the Global Data and Analytics organization and working alongside internal and external delivery teams, the role guides modernization of the data and analytics landscape through pragmatic, solution-oriented recommendations.

Accountabilities

• Partner with business stakeholders to understand reporting and insight needs, and translate these into business requirements.
• Lead the design of data requirements, data structures, and visualization layers to meet business needs.
• Lead database analysis, design, and build efforts in partnership with internal and external teams.
• Guide development and modernization of the data and analytics landscape in line with the Global Data and Analytics strategy.
• Own and drive high-level regional Data and Analytics platform release schedules across delivery teams.
• Own and maintain prioritization of features and requirements backlog for the APAC Data and Analytics platform.
• Provide analysis and recommendations on optimization of the data and analytics stack.

Background and Experience

• Bachelor's or master's degree in Computer Science or related field, or equivalent work experience.
• 5 years of professional experience in IT projects with a focus on Data and Analytics.
• Experience designing and implementing data warehouses in cloud-based environments.
• Deep understanding of data warehouse design concepts and technical platforms.
• Strong expertise in integrating and migrating data warehouse platforms.
• Experience in data transformation and ETL tools such as SAP Business Objects Data Services, SQL, Databricks, and Matillion.
• Experience in Agile and DevOps methodologies is an advantage.
• Solution-oriented mindset with strong communication skills and high attention to detail.

As the BI Solution Architect, this role defines and builds BI architecture encompassing technical and functional design, performs ETL software development, and maintains the data warehouse to ensure technical capacity and long-term viability. The logistics and supply chain team relies on this work to translate complex business needs into documented, governed BI solutions that support testing, deployment, and ongoing maintenance of applications.

Key Deliverables

• Help define and build the BI architecture including technical and functional design.
• Perform software developments and ETL, building data marts and tabular models.
• Support testing, deployment, and maintenance of applications and software.
• Document solutions and define data governance policies.
• Maintain the data warehouse, ensure technical capacity, and provide incident and change support.

Education and Experience

• Bachelor's or master's degree in IT or business.
• Experience with SSAS Tabular Models, DAX, SSIS, and SQL.
• Knowledge of databases and related infrastructures.
• Strong analytical mindset with ability to switch between broad view and detail level.
• Broad logistics expertise with knowledge of different supply chain fields.
• Strong communication skills in English, with Dutch preferred.

Reporting to the BI Manager, the BI Solution Architect elaborates and implements BI and Data Warehousing strategy, architecture and solutions to support informational business requirements. BI Solution Architect shapes end-to-end BI architecture across all Data Warehouse components, mentoring BI Developers, overseeing ETL and data model implementation, and maintaining technology roadmaps that meet IT service level agreements. The work directly supports compliance with Enterprise Architecture and security standards while promoting BI capabilities across the McGill community in collaboration with the Enterprise Architecture group.

Leadership Responsibilities

• Elaborate end-to-end BI architecture for all components of the BI and Data Warehouse environments.
• Transform business requirements into BI solutions.
• Provide in-depth expertise in technical design, development, testing, and deployment, and mentor BI Developers in best practices.
• Oversee implementation of data models, ETLs, and metadata definitions as well as ongoing maintenance and support.
• Ensure compliance with Enterprise Architecture, ITS, and security standards and methodologies.
• Deliver and maintain technology roadmaps that provide robust solutions meeting requirements and IT service level agreements.
• Promote BI capabilities to the wider organization and stay current on related technologies.

Minimum Qualifications

• Minimum 3 years of experience as a BI architect including data modeling in SQL Server Data Warehouse environments.
• Expertise with the Microsoft BI stack both on-premises and cloud.
• Expertise using ETL tools with deep understanding of ETL concepts, standards, and best practices.
• Experience in developing Enterprise Data Warehouse and Business Intelligence solutions.
• Experience with Oracle databases, performance optimization, and SQL tuning.
• Knowledge of relational and star schema modeling, with Data Vault as an asset.
• Experience with Version Control Systems, Continuous Integration, and Continuous Deployment.
• Knowledge of Software Delivery Life Cycle approaches including Agile, DevOps, and ITIL.
• Excellent verbal and written communication skills in English and French.

Company is looking for a BI Solutions Architect to join our Business Technology Data and Analytics Team to help drive scalable data and analytics solutions that create trusted data sets and reporting across our business users. The BI Solution Architect delivers scalable LookML models and unified metric visualizations that create trusted, consistent data sets across a growing analytics team. Collaborating across Data Engineering, vendor partnerships, and internal business units, the role builds the governance standards, SLAs, and access control frameworks that underpin organization-wide data confidence.

Role Responsibilities

• Provide architectural guidance and technology recommendations supporting development and implementation of data initiatives across multiple complex projects.
• Build scalable and consistent LookML models flexible enough to accommodate existing and new analytics users and projects.
• Develop standard development guidelines to create a unified user experience across the platform.
• Design, build, and automate key business metrics into unified visualizations to tell a story.
• Develop and publish usage patterns, define SLAs, establish guidelines, ensure proactive monitoring, and track adoption.
• Develop processes and standards that build trust with data and provide consistent metrics across the organization.
• Manage vendor relationships to understand and influence product roadmaps and collaborate with broader user communities.

Professional Experience

• 8 years of experience with a bachelor's degree, or 6 years with a master's degree, working with modern analytics tools such as Looker, Tableau, or similar, with LookML experience required.
• Bachelor's degree with emphasis on quantitative coursework in Information Systems, Computer Science, Data Science, or a related area.
• Experience working with Data Engineering teams with advanced SQL expertise.
• Proficiency in Python and experience with BI tool access control and approval workflows.
• Knowledge of cloud tools including Salesforce, AWS, Snowflake, and Google Cloud.
• Hands-on experience in Looker administration including security configuration and role-based access controls.
• Strong organizational and collaboration skills with proven ability to lead small technology projects.

The BI Solution Architect produces high-quality architectural artifacts and manages solution architecture delivery on assigned projects across the BIS platform, capturing business process, support, time, and cost dimensions while aligning with Sony Interactive Entertainment's broader enterprise architecture standards. Working closely with architects and engineering teams across BIS, DSO, and wider SIE, the role develops and socializes architecture patterns, builds supplier partnerships, and advances the architecture practice through improved ways of working.

Strategic Responsibilities

• Manage and deliver solution architecture on assigned projects, capturing impact on the BIS platform and services and providing leadership across business process, support, time, and cost dimensions.
• Deliver high-quality architectural artifacts clearly explaining solutions, decisions, and rationale, ensuring they are accessible to all target stakeholders.
• Develop, maintain, and socialize architecture standards, patterns, and policies across the BIS department and wider enterprise.
• Contribute to the effectiveness of the architecture practice by developing improved ways of working and sharing best practices across Sony Interactive Entertainment.
• Work with suppliers to understand their future vision and build partnerships that deliver the best outcomes for the enterprise.
• Build strong working relationships with architects and engineering teams across BIS, DSO, and wider SIE.

Knowledge Skills and Abilities

• Proven hands-on experience as a solution architect on major programs, with recent experience on BI solutions involving ETL, data warehouse, data lakes, and reporting applications.
• Proven ability to deliver flexible, reliable, supportable, and cost-effective packaged and bespoke solutions.
• Demonstrable knowledge of solution architecture governance through principles, policies, views, viewpoints, and building blocks.
• Demonstrable knowledge of the IT and BI marketplace and trends within end-user organizations including media, marketing, and retail businesses.
• Demonstrable knowledge of Agile methods for delivering BI.
• Ability to communicate complex technical issues to diverse audiences from technologists to senior stakeholders.
• Ability to build rapport and influence through collaborative leadership.

Reporting to senior architecture leadership, the BI Solution Architect creates solution architectures meeting operational requirements including scalability, security, reliability, and manageability across both on-premises and cloud environments, serving as technical expert and point of contact for BI domain-specific solutions. Partnering with distributed project teams, the role conducts R and D efforts, expert design reviews, and SDLC-phase participation to ensure production-ready, standards-compliant technology solutions.

Engineering Responsibilities

• Bring architectural and engineering concepts to design solution architectures meeting operational requirements such as scalability, maintainability, security, reliability, extensibility, flexibility, availability, and manageability.
• Organize and lead research and development efforts including proofs of concept and prototypes as BI architect and subject matter expert.
• Participate in various SDLC phases to ensure proposed technical and solution architectures align with approved technology standards and architectural requirements.
• Conduct expert technical and design reviews of existing, legacy, and new solution architectures built by the project team.
• Ensure technology solutions are production-ready, meet defined specifications, and can be maintained via production support methodologies.
• Serve as technical expert and point of contact for BI domain-specific solutions.

Technical Qualifications

• 12+ years of experience in designing and developing data solutions both on-premises and in cloud.
• Deep knowledge of one or more databases including PostgreSQL, Oracle, MS SQL Server, Sybase, and DB2.
• Good familiarity with Aurora, DynamoDB, and Redshift.
• Knowledge of AWS Data Platform stack including Data Lake, Kinesis, Lambda, S3, Redshift, and QuickSight.
• Experience with Snowflake in AWS or Azure environments and ELT/ETL experience loading data into Snowflake.
• Prior experience in technology consulting roles with experience providing technical guidance to distributed teams.
• Ability to create clear, detailed, and concise documentation including architecture diagrams, presentations, and design documents.
• Excellent English communication skills.

Our client is looking for a BI Solutions Architect to join their team to assess the current state of the environment, determine how to configure SSRS with Active Directory, how SSRS will fit into the technical infrastructure, and how it will be implemented and interface with Active Directory. The BI Solution Architect refines client BI strategy and roadmaps by analyzing requirements, delivering technical proposals, proofs of concept, and statements of work based on Microsoft's Reporting Suite including SSRS, SSAS, and SSIS. Serving as a trusted technical advisor to prospects and clients, the role builds and maintains strong relationships with technical leadership within Microsoft and the broader marketplace.

Day-to-Day Responsibilities

• Provide pre-sales technical support and analyze client requirements and current capabilities.
• Ensure technical solutions accomplish client objectives and that requirements are met through project delivery.
• Make technical proposals, solution presentations, and proofs of concept, and prepare statements of work both in-person and remotely.
• Serve as a trusted technical advisor to prospects and clients.
• Understand client requirements to build a BI strategy and roadmap.
• Partner with customers to understand their needs and propose specific solutions based on Microsoft's Reporting Suite including SSRS, SSAS, and SSIS.
• Build and maintain strong relationships with technical leadership within Microsoft and in the broader marketplace.

Position Requirements

• Expertise in SSRS, SSAS, Cognos, and SQL.
• Experience with solution design, gathering requirements, and transforming them into actionable steps.
• Ability to build strong relationships with technical leadership and maintain them within Microsoft and related technology communities.
• Experience with whiteboarding, writing statements of work, and architecting proposed systems.
• Excellent written and verbal communication skills.