BI Architect

Role Description

The business intelligence (BI) and data warehouse (DW) Solution 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.

Essential Functions:

• Formulates and recommends standards for achieving maximum performance and efficiency of the DW ecosystem.
• 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 the DW manager to ensure prioritization of corporate and departmental objectives and projects.
• Champion data quality, integrity and reliability throughout the department by designing and promoting best practices.
• Provide assistance to DW team members with issues needing technical expertise or complex systems and/or programming knowledge. Provide on-the-job training for new or less experienced team members.
• Provide technical training to external team members to foster stronger cross-departmental relations.

Qualifications

• Experience delivering business intelligence solutions
• 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 as strong presentation and collaboration skills and can communicate all aspects of the job requirements including the creation of formal documentation
• Database Technology: SQL Server, Netezza, Hadoop, Cloudera
• ETL Technology: SSIS, DataStage, Talend, CRON scripting, Perl
• BI Technology: SSRS, SSAS, Tableau, MicroStrategy
• Proficient in time series analysis, clustering, decision trees and neural networks
• Strong problem solving, time management and organizational skills

Requirements

• Bachelor's Degree in related field or equivalent experience
• 3-5 years of professional experience as a BI Architect working on progressively complex Information Management projects
• GitLab, Jenkins, Control-M experience required
• Strong documentation skills required
• Agile methodology experience required
• Prior FB/Health care experience highly preferred
• Experience with OLAP cube configurations preferred