BI Architect / Data Modeler

  • Next Gen Cyber LLC
  • Sullivan, Cotter and Associates, Inc. - Minneapolis, MN
  • Apr 29, 2018
Full time Systems Architecture Systems Requirements Planning Test and Evaluation Systems Development Knowledge Management

Job Description

This position is ideal for the candidate that demonstrates strong data modeling experience, solid analytical capabilities, experience with data management, automation and technology, and a desire to assist health care organizations, as they navigate the complexities of health care reform.


  • Define, communicate, influence and maintain the long-term strategic data management architecture for the firm and their clients
  • Work in projects, closely with technical architects, database developers, business analyst, product managers to optimal design for new products and tools
  • Define and develop data standards, procedures, guidelines, policies and lifecycles that meet the firms and clients strategic information requirements
  • Develop and interpret key performance indicators to measure the effectiveness of data management processes
  • Lead or consult on new technology evaluations that evolve the firm or their client’s ability to transform data into information and insight
  • Develop and refine business and technical requirements to identify and document detailed data requirements, definitions, data lineage and relevant business rules
  • Analyze requirements and transform them into corresponding conceptual, logical and physical data models.
  • Data warehouse design
  • Perform development and maintenance work on data models, data dictionaries or other artifacts to maintain currency with corporate standards, integration with Enterprise Data Architecture and company goals
  • Ensure that all artifacts be developed according to industry standards and procedures
  • Conduct data modeling sessions with business users and technical staff
  • Provide work direction and guidance to other BI members on the team


  • Bachelor’s degree
  • Minimum of 8 years’ experience as a solid BI data modeler/architect
  • Significant experience and knowledge of BI tools (such as, Tableau, Business Objects and Oracle)
  • Strong experience in data warehousing design
  • Solid understanding of ETL architectures
  • Must have developed and enforced data standards in a previous experience. Should have strong writing skills to prepare metadata and data dictionary and publish for the firm’s use
  • Strong background in developing complex SQL inquiries
  • Perform user story refinement by working with business
  • Demonstrates analytical and problem solving skills, particularly as it relates to data modeling and enterprise data architecture
  • Experience designing for enterprise use in a dynamic environment
  • Ability to quickly learn and comprehend existing complex system infrastructures
  • Ability to resolve design challenges, architectural issues and design conflicts
  • Experience in working on products that are Software As A Service (SAAS)
  • Experience in the healthcare industry would be a benefit
  • Consulting background also beneficial


  • Self-starter with demonstrated ability to successfully assist with project deliverables in a very driven and changing organization
  • Demonstrates strong critical thinking skills in the ability to apply analytical and proactive thinking in a logical, coherent, and consistent approach to ensure robust, appropriate client solutions
  • Demonstrates a high level of flexibility, adaptability, and the ability to work under tight deadlines or changing needs
  • Demonstrates confidence and ability to work independently as well as in a team structure
  • Demonstrates a strong collaboration orientation with associates within the team and business associates outside of the team
  • Demonstrates a strong level of intellectual curiosity, seeking to understand how the business works

Job Type: Full-time

Required education:

  • Bachelor's

Required experience:

  • Kimball Methodology: 2 years
  • Business Intelligence: 8 years
  • Data Modeling: 4 years