BI Architect

BI Architect

Job Description:

The business intelligence (BI) Architect will focus on delivering the vision of the department through process, development and lifecycle. They will work directly with stakeholders and team members to define, design and deliver actionable insights while working with ETL developers and BI developers in an agile environment.


Primary Job Duties:

Formulates and recommends standards for achieving maximum performance and efficiency of the EDW ecosystem.

* Lead the deployment of the new BI tools and processes.

Participates in the planning for retirement of systems programs, and migration of systems infrastructure.

Develop business cases and ROI for department to get buy-in from senior management.

Interview stakeholders and develop BI roadmap for success given project prioritization and budget.

Evangelize self-service BI and visual discovery while helping to change Excel based culture.

Work closely with DW manager to ensure prioritization of corporate and departmental objectives and projects.

* Work closely with the Business Analyst and User community to develop new dashboards and meeting service level and responsiveness goals.

Champion data quality, integrity and reliability throughout the department by designing and promoting best practices. 


Required Skill Set:

5+ years of experience delivering business intelligence solutions

5+ years of experience with OLTP and OLAP database models

Good analytical and problem solving skills

Fluent in relational database concepts and flat file processing concepts

Must be knowledgeable in software development lifecycles/methodologies i.e. agile

Has strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentation

Strong problem solving, time management and organizational skills

Bachelor’s Degree in related field or equivalent experience


Preferred Skill Set:

• Database Technology: Snowflake, Redshift, SQL Server,

• ETL Technology: Talend, CRON scripting, SSIS,

• BI Technology: Tableau, SSRS, SSAS, MicroStrategy

• Master’s Degree Computer Science or Statistics