Business Intelligence Architect

We are looking for BI Architect to join our team and will be responsible for the analysis design development and maintenance of business intelligence (BI) solutions for customers in the enterprise across multiple business lines and technical platforms. Provides production support for users of internally developed BI technologies both inside and outside the enterprise to enhance BI architecture design and development. Assess existing data sources and translate into new BI Solutions and tools which support the mission vision and values of the organization.

Job Duties and Responsibilities:

Designs develops implements and supports highly complex BI applications of strategic or functional importance for an enterprise audience including: integration with data sources; highly automated data refresh processes; bestinclass data visualizations dashboards and reports that communicate critical insights to drive decision making; testing methodology and criteria to ensure data/information quality; delivery of training and demos to business users.

With minimal direction develops standards policies and procedures for the form structure and attributes of the BI tools and systems. Assist with creation of a robust sustainable and scalable Risk Intelligence BI architecture that supports requirements and provides for expansion

Design and implement conceptual and logical models for the data warehouse or data mart (data structure storage and integration). Lead the database analysis design and build efforts.

Develops enterprise standards and best practices to ensure compatibility scalability and integration with other data platforms

Identifies researches and resolves highly complex technical problems associated with production BI applications

Researches new technology and develops business cases to support enterprise wide BI solutions

Leads technical project team and responsibilities using project management standards and methodologies. Develops project management artifacts and documentation.

Define capture and document metadata and rules associated with ETL processes Develop and test ETL processes

Develops solutions to difficult technical problems encountered as part of system implementation upgrades or support issues

Utilizes datamining skills and business knowledge to convert raw data into solutions that provide clear and concise insights into the health of the business

Perform research to advance the science and technology of intelligent machines

Perform research that enables learning the semantics of data (images video text audio and other modalities)

Work with end users business analysts technical team and developers to define the data requirements and data structure for BI solutions

Makes recommendations to improve operational processes relative to efficiency and effectiveness; provides input and organizational context to major architectural designs to ensure consistency maintainability and flexibility with respect to overall system.

Qualifications:

The position requires a bachelors degree with 8 years of experience in data warehouse/BI intelligence architecture design and development. Significant experience as BI/DW architect on several BI/DW initiatives / projects.

Experience in BI development using the Microsoft Power BI platform

Excellent understanding of Microsoft Power platform (Power Apps Power Automate Power BI) and other Microsoft BI platforms (SSRS SSAS etc.)

Ability to specify and document data warehouse and data mart requirements

Ability to provide critical architectural input including evaluating proposing and selecting appropriate design alternatives which meet functional requirements

Strong experience with ETL tools such as SSIS and SAS as well as familiarity with standard data extract deduping cleansing integration and aggregation techniques and best practices

Experience in sourcing data from disparate systems with a good understanding of their Data Models and ETL procedures

Deliver visualizations for use on mobile devices

SQL query writing data manipulation data cleansing and database design principles.

Data visualization technologies such as Tableau QlikView Cognos etc.

SQL Server and Microsoft Office (Excel Access VBA)

Report Writing Dashboard Development ETL Development

Possesses a strong aptitude/passion for creative problem solving when dealing with ambiguity

Strong project management skills with high attention to detail on data and a strong focus on meeting deliverables with time limitations must have ability to multitask and prioritize

The ability to facilitate prototyping sessions with a variety of end users and stakeholders

Strong technical background with relational and dimensional modeling skills Ability to manage projects end to end

Must have proven leadership skills supported by excellent analytical communication and presentation skills

Person Specification

Works collaboratively as a senior member of the Business Intelligence & Reporting team. Designs architects develops and maintains business intelligence (BI) data warehousing (DW) reporting systems and other business applications. Acts as a project lead / architect on multiteam projects and uses advanced expertlevel skill set to design architect develop test troubleshoot and support BI and reportingrelated projects and associated solutions/applications. Serves as mentor to others learning essential and advanced BI and/or reportingrelated skills.

#hiring #BIArchitecht #jobsincanada