Business Intelligence Architect

Job Title : Business Intelligence Architect

Location : Ontario, Canada- (REMOTE)

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; best-in-class 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 data-mining 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 bachelor's 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, de-duping, 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 multi-team projects and uses advanced, expert-level skill set to design, architect, develop, test, troubleshoot, and support BI and reporting-related projects and associated solutions / applications. Serves as mentor to others learning essential and advanced BI and / or reporting-related skills.

https : / / www.linkedin.com / company / trispoke-managed-services-pvt-ltd /

And above link for more jobs.

jobsearch #jobhunt #jobseeker #jobopening #jobopportunities #nowhiring #hiring