BUSINESS INTELLIGENCE ARCHITECT JOB DESCRIPTION

A Business Intelligence Architect owns the semantic layer between raw enterprise data and the dashboards executives act on. Most BI teams run on dozens of ERP, CRM, and cloud data sources feeding a single warehouse; the Architect decides how those feeds are modeled, governed, and published so every downstream report tells the same story. That ownership spans dimensional data modeling, ETL governance, and the federated standards that keep self-service analytics from fragmenting into departmental silos.

As the Business Intelligence Architect, you translate enterprise data complexity into governed, scalable reporting solutions that power strategic decisions across business units. You operate within a data or analytics engineering team, defining the architectural standards that BI developers, data engineers, and business stakeholders rely on to deliver consistent, trustworthy insights.

Career Impact: Owning the full BI architecture stack - from dimensional modeling to semantic-layer governance - builds the kind of cross-functional technical authority that advances careers from Architect to Principal or Head of Data.

Business Impact: The data models and ETL pipelines you architect determine whether business stakeholders can trust the KPI dashboards and OKR reports they use to allocate budget and headcount each quarter.

Growth Opportunity: Hands-on exposure to cloud-native data platforms and federated governance positions you to step into Data Platform Lead or Enterprise Data Architect roles as organizations expand their analytics programs.

• Design and maintain conceptual, logical, and physical data models supporting enterprise data warehouse and data mart initiatives.
• Architect ETL pipelines and data integration processes that move, cleanse, and transform data from ERP, CRM, and disparate source systems into the reporting layer.
• Define and enforce BI architectural standards, governance policies, and best practices across development, testing, and production environments.
• Develop and publish dashboards, KPI scorecards, and self-service reporting solutions that translate complex data into actionable business insights.
• Lead requirements-gathering sessions with business and technical stakeholders to translate analytical needs into detailed BI solution specifications.
• Review and govern code, data models, and report objects contributed by BI developers to maintain quality, performance, and security compliance.
• Build and maintain architecture roadmaps covering a one-to-three-year horizon for data warehouse evolution and analytical platform capabilities.
• Partner with data engineers and database administrators to optimize query performance, data lineage, and metadata documentation across the BI ecosystem.

• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent work experience.
• 5 or more years of business intelligence architecture experience, with demonstrated ownership of enterprise data warehouse design and delivery.
• Proven competency in dimensional and relational data modeling, including star schema, snowflake, and Kimball or Inmon methodologies.
• Strong working knowledge of ETL design, development, and governance, including data lineage, transformation rules, and error handling.
• Demonstrated ability to write and optimize complex SQL queries, stored procedures, and views against large relational databases.
• Experience gathering and translating business requirements into BI solution specifications in cross-functional stakeholder environments.
• Ability to communicate architectural decisions, tradeoffs, and roadmaps to both technical teams and non-technical business audiences.
• Familiarity with data governance principles including metadata management, data quality frameworks, and access control standards.

• Experience implementing master data management programs or enterprise data governance structures with defined data ownership accountability.
• Proficiency with cloud data platform services covering data lake, data warehouse, and transformation orchestration capabilities.
• Exposure to advanced analytics methods including predictive modeling, machine learning pipelines, or IoT data integration within a BI architecture context.
• Relevant professional certification in a major BI platform or data architecture discipline.

• Dashboard data freshness rate, measuring whether scheduled ETL loads meet agreed SLA windows.
• ETL pipeline error rate per release cycle, tracking how cleanly new data loads reach the reporting layer without failures.
• Report and model reuse ratio, reflecting how consistently published semantic objects are adopted rather than duplicated by downstream teams.
• Data governance coverage percentage, measuring the share of critical data assets with documented lineage, owners, and quality rules.
• Time from requirements sign-off to dashboard production deployment, tracking architectural delivery speed on new BI initiatives.
• Typical tools: Data modeling platforms (commonly erwin or dbt); BI visualization (commonly Power BI or Tableau); ETL and integration (commonly SSIS, Azure Data Factory, or ODI).

• Base Salary Range: $130,000 – $175,000 per year, depending on experience and location
• Bonus: Annual performance bonus, typically 8–15% of base salary
• Equity: RSUs or stock options offered at many mid-to-large technology and enterprise employers
• Health Benefits: Medical, dental, and vision coverage; employer contribution varies by company
• PTO: 15–25 days annually, plus public holidays; policies vary by employer
• Common Perks: Remote or hybrid flexibility, professional development budget, conference attendance, and 401(k) matching

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

Background check completion is a condition of employment for this role; offers are contingent on satisfactory results. All applicants are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations are available to qualified individuals with disabilities throughout the application and employment process. Candidates must be authorized to work in the United States.

The Business Intelligence Architect owns the end-to-end health of back-end data and front-end BI solutions, designing architecture and development best practices while driving proof-of-concept initiatives for new analytics capabilities. Reporting to technical leadership and working closely with business analysts and data scientists, this role delivers a well-governed data environment that connects reliable data sources to actionable visualisations across the organisation.

Key Responsibilities

• Improve and maintain the overall system health of back-end data and front-end business intelligence solutions through design and implementation of best practices in architecture, development processes, and system monitoring.
• Conduct regular research and produce summaries of data and analytics market trends to support thought leadership in business intelligence and analytics capabilities.
• Work closely with business analysts and data scientists to connect data sources and visualise data in Power BI or other visualization software.
• Drive innovation by supporting proof-of-concept initiatives for new business intelligence capabilities, including hands-on implementation of new technologies and development activities.
• Govern code, reports, and objects across all development activities to minimize negative impact on front-end business intelligence tools, environments, and users.
• Assist the team with new data collection practices, data governance rules, and maintenance to ensure data is usable for building models and creating visualizations.
• Apply a full understanding of database architecture and ETL concepts as they relate to predictive modelling and data visualization.

Required Qualifications

• 3+ years of technical architecture experience with front-end BI and analytics tools, including multi-tool approaches.
• Experience with multi-location user bases.
• Experience with ERP software, including MS Dynamics and Oracle NetSuite.
• Experience with MS Azure database structures, data lakes, and Databricks.
• 2+ years of experience with advanced analytics and ETL tools and techniques, including RStudio and Data Ladder.
• Solid knowledge of analytics tools, including Google Analytics, Power BI, Adobe Omniture, SQL, and RStudio.

Embedded within the data and analytics function, the Business Intelligence Architect develops and maintains data models and ETL scripts that form the foundation for accurate, timely reporting across the institution. Working closely with faculty, staff, and technical teams, this role leads new development and implementation projects for campus-wide dashboards and Tableau visualisations, enabling data-driven decision-making at every level of the organisation.

Core Functions

• Develop and maintain existing and new data models that form the foundation for accurate and timely reporting.
• Create ETL scripts to move data from source systems into the business intelligence reporting environment.
• Develop and maintain appropriate processing schedules.
• Troubleshoot load errors and system failures.
• Perform data validation and sanitation to ensure the quality, accuracy, and relevance of the BI architecture.
• Participate in the planning and implementation of migrations from outdated to new data systems and tools.
• Stay current with emerging tools and approaches in the field through ongoing professional development.
• Recommend new strategies based on best practices.
• Research and develop solutions to integrate existing data sources into a comprehensive reporting solution.
• Gather user requirements and develop solutions for campus-wide dashboards and reports based on reporting standards.
• Provide training for users in one-on-one and group settings.
• Develop documentation and data dictionaries for users.
• Research exemplary dashboard models from other institutions and recommend adaptations for local use.
• Lead new development, enhancement, release, upgrade, and implementation projects, including developing and maintaining project plans, managing issues, and communicating with management and project participants.
• Lead project management on sub-projects within an overall project.
• Coordinate task assignment and completion with staff members.
• Coordinate technical testing to ensure end-to-end testing across interdependent groups.

Qualifications & Experience

• Bachelor's degree in Computer Science, Computer Information Systems, Information Systems, or a related field.
• Five years of experience in business intelligence, preferably in a higher education environment.
• Knowledge of data warehouse and business intelligence tools and best practices.
• Demonstrated competence in relational databases and structured programming design, including the ability to write and edit SQL queries.
• Experience in dimensional data modelling.
• Experience with data visualization tools, including Tableau.
• Working knowledge of Oracle RDBMS and Oracle Data Integrator as an ETL tool.
• Experience with data analysis and programming languages, including R and Python.
• Experience with PeopleSoft tables and data.
• Software release and system change management experience.
• Ability to apply technical judgment independently to achieve desired results.
• Ability to independently apply various learning techniques to adapt new knowledge and skills in changing situations.
• Demonstrated reflective listening skills, with the ability to interpret and identify needs and requirements to develop successful solutions.
• Ability to plan and work on shared projects to achieve established objectives.
• Advanced experience with PC tools, including word processing, diagramming, and spreadsheet applications.

Reporting to senior technology leadership, the Business Intelligence Architect leads the end-to-end design of BI and data analytics solutions, overseeing frequent delivery and support of all production services while creating architecture strategy and roadmaps across a one-to-three-year timeframe. Partnering with internal customers, external partner organisations, and key stakeholders, this role ensures that data meets required levels of quality, latency, and detail to fulfil customer needs while upholding data protection and security commitments.

Primary Duties

• Lead the design of end-to-end architecture for business intelligence and data and analytics solutions, and oversee the frequent delivery and support of all production services using these platforms.
• Create and develop architecture strategy and methodology to enable repeatable and standardised business intelligence and data warehousing architecture for a range of data and analytics products and services over a one-to-three-year timeframe.
• Lead proof-of-concept efforts for new architecture solutions to establish the effectiveness of requirements and accelerate the conversion of data into business insights.
• Create appropriate solutions and processes to govern architecture change, ensuring changes are applied consistently and to an agreed quality, and reducing the risk of changes that could compromise quality or security.
• Create and maintain medium- to long-term solution strategies and roadmaps for data and analytics systems, ensuring the solution evolves in line with the overall strategy and continues to deliver required business capabilities.
• Make recommendations on technological investments across the data and analytics portfolio based on roadmaps and agreed strategy.
• Ensure quality assurance of all team outputs, establish standards, and develop team capability through training and knowledge sharing.
• Analyse the current technology environment to detect critical deficiencies and recommend best-practice solutions for data and analytics and other relevant areas.
• Promote architecture work to internal customers, external partner organisations, and key stakeholders, and serve as an authoritative point of contact.

Skills & Qualifications

• Graduate-level degree in a relevant technology or computer science subject, or an equivalent technical qualification with sound on-the-job experience in the platform specialism.
• Full and detailed working knowledge of data warehousing methodologies, data modelling, and big data approaches, including star schema structure and design, and the application of Kimball and Inmon data warehouse design methodologies.
• Detailed knowledge of all components of data warehousing development, including ETL, testing, and reporting front-end solutions.
• Expert solution architecture skills in architecting business intelligence solutions across software, infrastructure, and networks, including cloud environments.
• Experience designing large, multi-tier business intelligence applications deployed across multiple machines, incorporating non-functional requirements such as reliability, scalability, performance, and resilience.
• Knowledge of national and international legislation applicable to government and public sector IT, including data protection, EU procurement directives, and freedom of information requirements.
• Broad knowledge of planning and project management tools and techniques.
• Proven ability to take loosely defined requirements and build a high-level architecture, refine it as information is discovered, and produce architecture roadmaps based on analysis of complex systems.
• Ability to ensure mapping and traceability between business and technical requirements and subsystem and interface specifications.
• Proven experience architecting business intelligence solutions within an agile development process.
• In-depth knowledge of security principles and best practices, including PCI-DSS 1.2 compliance.

Sitting at the intersection of data governance and business intelligence, the Business Intelligence Architect serves as the business sponsor for master data management needs and builds reporting capabilities through data visualisation systems that translate operational results into dynamic graphical views. Operating across geographically dispersed teams and collaborating with IT, data owners, and business process improvement stakeholders, this role delivers actionable insights and self-sustainable reporting practices that support enterprise-wide performance management.

Duties

• Serve as the business sponsor for master data management needs, covering systems, databases, analysis tools, integration, and quality control.
• Establish a data governance program with identified data owners, defined responsibilities, and automated checks and balances.
• Ensure business reporting needs are met by providing the required source data for acquisition, data sets, and BI storage solutions in collaboration with IT.
• Identify data integrity issues, troubleshoot root causes, and develop capabilities to cleanse and control data.
• Support IT and database administrators with defining data model structures and simplifying complexity.
• Document and maintain Entity Relationship Diagrams and Data Flow Diagrams.
• Define and maintain the roadmap of technical data reporting solutions, and establish performance reporting standards aligned across departments.
• Build reporting capabilities via data visualisation systems with appropriate cost-benefit analysis, and translate business and operational results into standard graphical views that enable users to adjust outputs dynamically.
• Continuously adjust data visualisation solutions to support changing business needs, and develop and deliver reporting training and materials, including one-on-one coaching and small group training.
• Query, scrub, and model data to gain deeper insight into relationships and trends, and analyse business processes to determine value-add performance measures, KPIs, metrics, and dashboards.
• Interpret and identify actionable insights from performance reporting results, and recommend business process improvements based on findings.
• Understand technical problems and solutions in relation to the current and future business environment, and provide thought leadership on business intelligence.
• Establish credibility through effective stakeholder management, and enhance alignment between data owners, business process improvement, and IT to foster self-sustainable reporting practices.

Requirements

• Bachelor's degree or equivalent education and experience.
• 7 years of experience in business intelligence and data management.
• Experience in project management, including virtual leadership with the ability to drive results, provide feedback and direction, and manage relationships with leaders and team members in a geographically dispersed team environment.
• Experience with large data sets, including implementation and use of data management software such as AWS, Cloudera, Google Cloud, and Microsoft platforms.
• Statistics and analytics, including descriptive, diagnostic, and predictive methods.
• Data visualisation using MS Power BI, Tableau, Qlik, and Business Objects.
• Knowledge of Lean Six Sigma methodology, Agile development, and continuous improvement practices.
• Experience implementing and supporting SharePoint, including governance and distributed use models.
• Strong analytical skills with close attention to detail and accuracy.
• Effective listening and communication skills across all levels, including executives, to gather and synthesise reporting requirements and reach consensus on standards.

A key member of the data and analytics team, the Business Intelligence Architect designs subject areas, data models, and automated visualisations to support the overall organisational strategy while steering the organisation toward report and analytics standardisation leveraging Oracle Cloud. Collaborating across management and cross-functional business partners, this role delivers efficient, on-time changes to autonomous data warehouse structures and ensures business and information needs are prioritised to drive sound, data-driven decisions.

Functions

• Interview cross-functional business partners to understand data and analytical needs for strategic initiatives.
• Design subject areas, data models, and automated visualisations to support the overall organisational strategy.
• Work alongside management to develop overall business intelligence architecture, steering the organisation towards report and analytics standardisation leveraging Oracle Cloud.
• Perform all functional duties to ensure efficient and on-time delivery of autonomous data warehouse data structure changes, including designing database changes, data flow changes, and assessing downstream impacts within reporting and analytics.
• Work closely with management to prioritise business and information needs.

Experience & Qualifications

• Bachelor's degree in Mathematics, Computer Science, Analytics, Engineering, Information Science, or a related field.
• Master's degree in Mathematics, Computer Science, Analytics, Engineering, Information Science, or a related field.
• 5 years of directly related work experience, including 3 years in data analytics and 3 years in data visualisation.
• 1 year of experience in predictive modelling, project management, consulting, Oracle Cloud Business Intelligence, and Oracle Data Integrator, respectively.
• Experience with statistical analysis and business intelligence using Oracle Cloud technologies, including ODI, OAC, RPD, OTBI, and BIP.
• Proficiency at the master's level in Microsoft Office products, including Excel, PowerPoint, Word, and Access, as well as SQL and PL/SQL.
• Familiarity with the software development lifecycle and project management lifecycle.
• Familiarity with database design and architecture, and experience as a data-driven decision maker with the ability to achieve goals using available resources.
• Strong analytical skills and problem-solving capabilities, with the ability to deliver results in a fast-changing, technology-driven environment.

Delivering a well-governed data ecosystem depends on the Business Intelligence Architect, who designs, develops, and supports highly complex BI applications of strategic importance, including Power BI architecture, data warehouses, and data marts with Conceptual, Logical, and Physical Data Models. Based within a data-focused organisation and overseeing data quality through validation, cleansing, and ETL methods, this role executes a roadmap of business-focused BI initiatives that maximises performance and efficiency across the enterprise data environment.

Accountabilities

• Design, develop, implement, and support highly complex BI applications of strategic or functional importance, including integration with data sources, automated data refresh processes, and best-in-class data visualisations, dashboards, and reports.
• Architect data warehouses and data marts, including the design and development of Conceptual, Logical, and Physical Data Models.
• Execute a roadmap of business-focused BI initiatives with a clear understanding of all deliverables and associated deadlines.
• Design and develop Power BI architecture and dashboards.
• Develop and maintain data management standards and documentation of current data sources, raw data, data marts, transformations, and report specifications.
• Oversee data quality, including validation, cleansing, scrubbing, and ETL methods.
• Formulate and recommend standards for achieving maximum performance and efficiency of the data ecosystem.
• Participate in data integration, BI, and enterprise information management programmes by rationalising data processing to support reuse.
• Ensure best possible performance and quality in ETL packages, stored procedures, and SQL.

Technical Qualifications

• Bachelor's degree in Computer Science or a related field.
• 12+ years of experience in data warehouse and business intelligence architecture, design, and development, including significant experience as a BI and data warehouse architect across multiple initiatives.
• Experience with Master Data Management, Data Governance, and Enterprise Information Management.
• Data security experience at both macro and micro levels, including platform, row-level, and encryption approaches.
• Expert knowledge of Azure tools and services centred around data and analytics, including Data Lake, Data Factory, Azure Databricks, and Azure SQL.
• Excellent understanding of Microsoft Power BI and other Microsoft BI platforms, including SSRS, SSAS, and SSIS.
• Experience designing and building complete ETL processes, moving and transforming data across ODS, staging, and data warehousing environments.

As the Business Intelligence Architect, this role serves as steward, architect, and thought leader on all matters related to BI and the data warehouse, defining and promoting architectural guidelines, standards, and governing mechanisms while developing dashboards, KPI scorecards, and visualisations using enterprise BI tools. The broader data organisation relies on this work to modernise analytical capabilities, support engineers in defining semantic-layer data requirements, and build a data-driven culture that advances strategic goals across business and technical stakeholders.

Activities

• Serve as steward, architect, advisor, and thought leader on all matters related to BI and data warehousing.
• Define, implement, and promote BI architectural guidelines, standards, best practices, governing mechanisms, key processes, controls, and supporting tools.
• Work with business and technical stakeholders to design, develop, deploy, and support analytics on the BI platform.
• Develop dashboards, visualisations, goals, and ad-hoc reports.
• Apply analytical insights to help increase business and team effectiveness against key strategic goals.
• Work with business and technical stakeholders to define requirements for new projects and enhancements to existing solutions.
• Support the modernisation of analytical capabilities and the development of a data-driven culture by staying current with new features, demonstrating capabilities, and developing proof-of-concept initiatives.
• Connect data sources, import data, and transform data for business intelligence.
• Develop tabular and multidimensional models compatible with data warehouse standards.
• Develop visual reports, KPI scorecards, and dashboards using BI tools.
• Support data engineers in defining data and modelling requirements at the semantic layer.

Position Requirements

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Master's degree with 8 years of experience; or a PhD with 5 years of experience.
• Minimum of 12 years of related experience.
• 5+ years of experience in a role requiring the application of modelling and analytical skills, including building data management and business intelligence automation.
• 5+ years of experience working with enterprise data architectures, including Data Lakehouse, Master Data Management, Data Quality, Data Analytics and BI, Data Enrichment, Data Integration and ETL, Security, and Governance.
• Experience with data visualisation tools, including Tableau and Power BI.
• Experience with SQL, database development, and query optimisation.
• Experience working with structured and unstructured data from a variety of ERP, CRM, and other data sources.
• Excellent communication skills, with the ability to discuss requirements effectively with stakeholders and internal teams.

Business Intelligence Architect leads and mentors BI developers and designers while acting as client liaison to understand business requirements and design comprehensive solutions covering effort, time, cost, risks, and assumptions. Success in the position means delivering enterprise reports, ad-hoc analysis, and Power BI dashboards that meet defined requirements, while supporting practice leadership on workforce planning, recruitment, and the management of project requests with appropriate documentation.

Operational Focus

• Lead and mentor BI developers and designers.
• Act as client liaison to understand business requirements and design overall solutions, including effort, time, cost, risks, and assumptions.
• Provide technical support for the maintenance and development of reports and dashboards in Power BI.
• Manage requests and components of larger projects with appropriate documentation and status reports.
• Develop enterprise reports and ad-hoc analysis based on defined requirements in Power BI.
• Work with practice leadership on workforce planning, managing job descriptions, conducting interviews, and making recruitment decisions.

Knowledge Skills & Abilities

• Bachelor's degree in Computer Science, Computer Engineering, or a closely related field.
• Experience with Python, including the pandas library, and Java.
• Experience providing governance for Power BI estates.
• Hands-on knowledge of SOA, PKI, web services, and Enterprise Service Bus technologies.
• Knowledge of testing tools and techniques, and the ability to execute test scripts to test performance.
• Knowledge of best practices for Power BI configuration, report development, and publishing.
• Knowledge of database administration, repository management, and data warehousing practices, including proficiency with facts, dimensions, and various schemas.
• Strong knowledge of database back-end systems, including SQL Server 2008 R2 and 2012.
• Familiarity with data sharing platforms, including open data platforms.
• Ability to write complex SQL statements using SQL and T-SQL, and experience working with complex SQL variations such as PL/SQL.

The Business Intelligence Architect produces well-architected Power BI, Tableau, and Microsoft SQL Server solutions, reviewing business problems and translating stakeholder requirements into effective reporting solutions that include semantic models, managed SSRS reports, and row-level security. Working closely with business analysts and stakeholders across the organisation, this role ensures reports and dashboards are evaluated, tuned, and maintained to the highest performance standard while managing defect reports, change requests, and technical documentation.

Key Deliverables

• Review business problems and architect appropriate solutions for Power BI, Tableau, and Microsoft SQL Server stacks, including application security, row-level security, and scheduled automation.
• Design, implement, and maintain Power BI reports, Tableau dashboards, semantic models, and managed SSRS reports.
• Evaluate and tune reports and dashboards for optimal performance.
• Work closely with business analysts and business stakeholders to gather requirements and translate them into effective reporting solutions.
• Evaluate and prioritise defect reports and change requests.
• Create and update requirements, process, design, and technical documentation.

Professional Experience

• Bachelor's or Associate's degree in Computer Science, Information Technology, or equivalent experience.
• 5 years of experience with BI technology, preferably Power BI.
• 5 years of business analysis experience.
• Data warehouse design and build experience.
• Data transformation and cleansing experience.
• Strong SQL and PL/SQL knowledge and experience.
• Ability to work independently on software design, software development, testing, and deployment.
• Excellent meeting facilitation, organisational, and communication skills, with the ability to interact effectively with all levels of the organisation.
• Strong problem-solving and analytical skills with a high level of accuracy and attention to detail.
• Strong commitment to achieving deadlines, with the ability to work flexible hours as needed to complete projects.

Embedded within the Global Credit Risk, Seller Risk, and Collections Risk Intelligence team, the Business Intelligence Architect develops and manages Operational Data Stores, Enterprise Data Warehouses, and BI technologies that serve as the foundational connection between data sources and business intelligence teams. Working closely with analytic teams, technical architects, end users, and developers, this role advances the design and deployment of scalable BI architecture that fulfils current and long-term data volume, governance, and growth requirements.

Areas of Ownership

• Assist with the creation of a robust, sustainable, and scalable BI architecture that supports current requirements and provides for future expansion.
• Work with end users, business analysts, technical architects, and developers to define data requirements and data structures for BI solutions.
• Design and implement conceptual and logical models for the data warehouse or data mart, covering data structure, storage, and integration.
• Lead database analysis, design, and build efforts.
• Evolve data models to meet new and changing business requirements and growth.
• Design data lineage and map source system data to data warehouse models.
• Develop and test ETL processes, and define, capture, and document associated metadata and rules.
• Ensure database designs fulfil requirements, including data volume, frequency, and long-term BI growth requirements.
• Collaborate with other architects to ensure all components meet defined objectives and performance goals.
• Participate in validation, data quality management, and governance reviews.
• Implement approved technologies aligned with technical design standards, business plans, and long-term strategy, and deliver technical alternative documents and architectural designs that meet business requirements.
• Analyse complex system and technical issues, develop solutions to difficult technical problems, and make recommendations to improve operational processes relative to efficiency and effectiveness.

Education & Experience

• Bachelor's degree with 5+ years of experience in Information Technology or BI-related fields, with progressively increased levels of responsibility and data modelling expertise, including a strong understanding of data sources, relational and dimensional modelling, and effective uses of business data.
• Experience with connecting to and sourcing data from multiple disparate data sources, including Teradata, SAP BW, Oracle, SQL, and Hadoop.
• Strong experience with ETL tools, including SSIS and SAS, as well as familiarity with standard data extract, de-duplication, cleansing, integration, and aggregation techniques and best practices.
• Knowledge of formal database architecture and design.
• Experience in developing or architecting data supporting credit and risk products or portfolios is preferred.
• Prior experience working with consumer and SMB lending or credit card banking data domains is preferred.
• Strong project management skills, with high attention to detail on data, a focus on meeting deliverables within time constraints, and the ability to multitask and prioritise.
• Ability to use effective facilitation skills to elicit requirements from a diverse range of stakeholders and groups, and to facilitate prototyping sessions with end users.

Reporting to the Enterprise Data Analytics team leadership, the Business Intelligence Architect develops and implements analytical solutions that support key business initiatives across a complex data landscape, including metadata modelling, bi-temporal data models, and complex integrated data sets from disparate sources. Partnering with peer organisations, business users, and developers, this role produces BI architecture that enables interoperability across enterprise data assets and drives the delivery of technical solutions using business intelligence, predictive analytics, and machine learning strategies.

Role Responsibilities

• Lead business intelligence solution architecture, design, development, implementation, and administration across a complex data landscape.
• Build and maintain schema objects and an abstraction layer on top of various enterprise data assets.
• Partner with peer organisations to design normalised and dimensional data models, implement metadata solutions, and develop bi-temporal data models to ensure interoperability with BI solutions.
• Perform metadata modelling and develop complex integrated data sets from disparate data sources using expert SQL utilisation and BI object optimisation.
• Perform detailed documentation of design, development, testing, and deployment activities.
• Conduct troubleshooting, analysis, and enhancement development based on reported issues.
• Write complex SQL queries and stored procedures for report or dashboard development.
• Contribute to and apply standards and governance of business intelligence processes.
• Customise applications using SDK, API, JavaScript, HTML, and CSS, including work with REST, XML, JSON, and HTTP.
• Provide technical support for reports and analysis as needed.

Background & Experience

• Bachelor's degree or equivalent in Information Technology, Computer Science, CIS, Engineering, or Mathematics.
• 8+ years of BI architect or senior BI developer experience with increasing responsibilities, implementing medium- and large-scale projects, business intelligence solutions, and data modelling.
• 6+ years of experience with ETL solutions, relational databases, columnar databases, time series databases, BI platforms, big data technology, metadata, lineage, quality modelling, sanitisation, analytics, and reporting.
• 4+ years of direct work experience with MicroStrategy, with Certified MSTR Architect designation preferred.
• 10+ years of professional experience preferred.
• 2+ years of web development experience using REST API services, Java and JavaScript frameworks including React, Angular, and Node.js, HTML, Python, and D3 web integration preferred.
• Experience with VPN, SSO, and EMM protocols.
• Ability to work with large amounts of data, independently and collaboratively, and to manage multiple tasks under the Agile methodology.
• Strong written and verbal communication skills.
• Entrepreneurial mindset with strong financial awareness and personal integrity.

Sitting at the intersection of business requirements and data technology, the Business Intelligence Architect coordinates interaction between business users, the analytics team, and IT to translate complex reporting requirements into functional specifications and design analytics solutions incorporating data security, drill-down capabilities, and flexible data hierarchies. Operating across a retail enterprise and collaborating with development teams to validate logical data models and finalise technical specifications, this role shapes the analytical capabilities that convert raw data into actionable information and drive success across the organisation.

Job Functions

• Coordinate interaction and communication between business users, the analytics team, and IT.
• Work with business users to translate complex reporting requirements into functional specifications for reporting solutions.
• Work with development teams to finalise functional and technical design specifications, build solutions that meet those specifications, and validate all the way to production.
• Coordinate assignments of internal resources.
• Design and develop analytics incorporating data security, drill-down, drill-throughs, and flexible data hierarchies.
• Validate data relationships, mapping, definitions, and the accuracy of logical data models.
• Understand the usage, nuances, and architecture of the Cognos framework, security model, and reporting capabilities.
• Understand the capabilities of existing ETL tools that can be leveraged.
• Manage a project list while handling interruptions in a timely and effective manner.

Minimum Qualifications

• 5 years of internal IT experience.
• Experience with client interviews and requirements gathering.
• Logical and physical data modelling experience.
• A retail or economics background is preferred.
• Self-motivated individual with strong interpersonal skills.
• Ability to work well under pressure and independently.
• Ability to grasp new ideas quickly in a dynamic and diverse environment.
• Strong problem-solving skills with knowledge of web-based applications and business analysis skills.