Careerlink Login
Back to Search New Search

Senior Microsoft Solutions Architect

Catch Intelligence Omaha, NE

Job Description

We are looking for a senior data warehouse architect  to lead our Microsoft BI/Data warehouse projects as the lead solution architect and data modeler, which includes facilitating interview sessions with business and technical users, reviewing source system layouts and schemas, analyzing the business and technical requirements and creating data models to meet our client’s business needs. This individual must be a strong data architect (modeler) and be focused on assessing our client’s environment and requirements and design the Microsoft Data Warehouse architecture in conformance to Microsoft BI best practices and support a full lifecycle Data Warehouse implementation.  The design will involve conceptual, logical and physical data modeling, with a strong emphasis on the Kimball Dimensional Modeling methodology. Previous experience with Agile methodology is highly desirable.

Essential Duties and Responsibilities:

  • Conduct client assessment engagements to flush out requirements, points of pain, gaps and other business and technical input that will support recommendations and a future state Microsoft Azure BI Architecture
  • Lead activities around data analysis, data profiling, data extraction (validation and transformation rules) and integration with data from multiple disparate sources into a robust and scalable data model. Provide means for ensuring data quality and integrity. This position will work closely with clients and end-users to examine existing processes and develop automated solutions, including specifying program and data flow
  • Design and deliver a solutions architecture based on the Microsoft BI technology stack, specifically:
    • Microsoft SQL Server architecture and development
    • Experience with DAX development
    • Prior experience designing and building SSAS cubes using DAX and MDX
    • SSIS, TSQL, or other ETL tools
    • PowerQuery
    • PowerBI
    • Azure
    • Power BI on Premise
  • Work with Business users and Business Analysts to gather requirements in different forms including: interviews, facilitated sessions and documented data structures
  • Act as technical lead to assess client’s current state environment and offer estimates and recommendations for improvement
  • Provide Data Warehouse and Business Intelligence subject matter expertise and leadership, including leadership to the project team, including Business Analysts, ETL and BI report developers. This position will have direct responsibility of managing the implementation team
  • Provide data analysis and data modeling expertise, especially with the Kimball Dimensional Modeling approach leveraging Microsoft technologies such as SSAS, MDX and DAX.
  • Transform Business requirements into functional Data Warehouse design requirements, including the data warehouse data model (logical and physical)
  • Ensure common application architectural framework across different subject areas and conformance with best practices.  Proven experience in designing and deploying conformed dimensions is a must
  • Consult with key individuals across multiple projects regarding the usage and application of Business Intelligence and Data Warehousing architectural standards
  • Develop logical and physical data models from business requirements
  • Provide input and architectural guidance for ETL architecture and processes
  • Implement data quality and data governance processes
  • Evaluate, recommend and  implement Business Intelligence Tools to meet technical and business requirements


To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

  • Strong knowledge and hands on experience developing data warehouse data models, including relational and dimensional modeling, with strong, proven track record of developing Kimball Dimensional models
  • Previous experience with SQL Server 2014/2016 is a required
  • Hands on experience with SSAS (MDX and/or DAAX), T-SQL and SSIS is required
  • Detail oriented with excellent organization and analytical skills
  • Ability to prioritize work and meet deadlines
  • Ability to establish and maintain effective working relationships with clients, project team members, supervisors, and employees from other departments.
  • Bachelor’s degree in computer science, information system, computer engineering or equivalent working experience is required
  • 8+ years hands on working experience in data modeling,  focused on the Kimball Dimensional modeling methodology, including  5+ years’ experience as a lead  Data Warehouse Architect
  • 3+ years’ experience in implementing BI tools

Job Details

Date Posted December 3, 2019
Date Closes January 2, 2020
Located In Omaha, NE
Job Type Full-time Employee
Shift Custom
Start Date 2019-09-09
SOC Category 15-1051.00 Computer Systems Analysts
Zipcode 68154
Name Maranna Bentley

This job offers the following benefits

  • 401(k) Retirement Savings Plan
  • Flexible Spending Accounts
  • Dental
  • Life Insurance
  • Long-Term Disability
  • Medical
  • Prescription Drug Plan
  • Short-Term Disability
  • Vision
  • Bereavement Pay
  • Cafeteria / Food
  • Casual Dress
  • Employee Referral Program
  • Flexible Hours
  • Holiday Party
  • Paid Holidays
  • Paid Vacations
  • Merit Increases
  • Productivity Rewards

This job requires the following skills

  • Business Intelligence / Reporting
  • Microsoft Business Intelligence
  • CA ERwin Data Modeler
  • Data Warehouse
  • Oracle SQL Developer Data Modeler

This job is related other jobs in these career categories

Course(s) relevant to the skills listed for this position

At a Glance
Enjoy these benefits
  • 401(k) Retirement Savings Plan
  • Flexible Spending Accounts
  • Dental
  • Life Insurance
  • Long-Term Disability
  • And More ...