Business Intelligence Architect

BI Architect

Location: Madison, WI

Description:

?? Responsible for leading the design and support of enterprise wide business intelligence applications and architecture.

?? Develop and evaluate application or architecture alternatives that solve the needs of the business area or agency, including API, data lake, and cloud architectures.

?? Study, develop, recommend, and support business intelligence development tools, standards, policies and procedures, and methodologies.

?? Works with enterprise wide business and IT senior management to understand and prioritize data and information requirements.

?? Solves complex technical problems.

?? Creates testing methodology and criteria for a modernized analytics platform.

?? Develops standards, policies, and procedures for the form, structure, and attributes of the modernized business intelligence tools and systems.

?? Researches new technology and develops business cases to support enterprise wide business intelligence solutions.

?? Leads technical team to develop proof of concepts for modernized architecture

?? Ability to communicate directly with IT senior management and program area stakeholders to review information about new or changed business intelligence tools, potential new technical advances, and impact on program areas.

?? Expectation is to be able to independently create and facilitate presentations, including fielding questions.

?? Bachelor's or Master's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.

?? Typically has 7 to 10 years of experience with large and complex database management systems, business intelligence tools and systems.

Must Have

Years of Experience

Administration - Project Management

Demonstrated experience in the design and utilization of performance measures and reports

Expertise in implementation of large complicated models and processes

General Competencies

Excellent organization, analytical, and communication skills

??

Information Technology - Applications

Ability to develop and implement quality assurance processes and procedures including test/use cases

Information Technology - Architecture

Experience with Azure Data Warehouse, AWS RedShift, GCF Bigquery, Cloudera/Horton Works, IBM Netezza

Physical and Logical Data Architecture Analysis and Design

Information Technology - Databases

Data Warehouse - Experience in data warehouse design and development

Leading database design reviews and enforcing standards

Information Technology - Design

Familiarity and knowledge with best practices in information architecture

Knowledge of Kimball data warehouse design principals

Information Technology - Languages/Tools

Experience with big data techniques and advanced analytics platforms (Hadoop, etc)

Nice to Have

Information Technology - Databases

Informatica