Senior Data Modeler/Architect
Datasource Consulting, LLC - Denver, CO

This job posting is no longer available on Indeed. Find similar jobs:Senior Data Modeler Architect jobs - Datasource Consulting jobs

Datasource Consulting is a premier leader in the enterprise information management and business intelligence space. We specialize in delivering Lean, innovative, end-to-end solutions that leverage and express the full value of data. We employ the best and brightest experts in the industry with a focus on areas such as data integration, data architecture, data virtualization, data modeling, data quality, data governance, reporting & analytics, and BI program management. Datasource not only remains close to the latest technology and industry trends, but we also help move the needle with thought leadership in areas such as BI in the Cloud, Agile BI, and Big Data.

Senior level Data Architect with strong data modeling for full-time or contract. First class working environment at a company recognized as a leader in BI/DW space.

Job Description

  • Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical and physical data models based on those needs
  • Responsible for leading the architectural development of Project/Metadata and reporting framework
  • Experience with Dimensional, Canonical, Rational, Logical and Physical data modeling
  • Develops long term portal roadmap and architectures, designs and builds the portal framework per the roadmap
  • Works with Business Analysts to document analytic requirements and translates into technical solutions
  • Assists in ETL design, development, optimization, and support
  • Coordinates with Project Managers and participates in project planning
  • Works with business partners to review prototypes and develop iterative revisions
  • Leads coordination of the QA test process and migration of objects through the change control process
  • Oversees and performs troubleshooting and provides resolutions to reporting issues


  • Minimum of 10 years of experience designing large scale data models for data warehouse environments
  • Diverse experience with database technologies including MPP appliances (Teradata, Netezza, Exadata, etc.)
  • Strong experience with large data sets ( >50TB)
  • 10 years of Data Warehouse experience including demonstrated strong Logical, Canonical, Rational, Dimensional and Physical Data Modeling skills
  • Knowledge and appreciation of business concepts and requirements
  • Ability to apply policies and procedures to solve every day and/or complex company issues
  • Ability to gather business requirements, perform analysis and establish/recommend a data integration architecture
  • Ability to work in a team environment
  • Extensive background in database systems along with a strong knowledge of SQL
  • Excellent communication and documentation skills
  • Experience with agile/scrum is valuable
  • Experience with data modeling and data virtualization tools
  • Ability to exercise initiative, problem-solving and decision-making skills
  • Proven ability to work creatively and analytically in a teamwork-oriented environment
  • Superior interpersonal and communication skills, including the ability to be both directive and collaborative
  • A minimum of a Bachelor’s degree or comparable job-related experience is required
  • Ability to travel 25%