Data Modeler - BI Analytics - Onsite (Full Time)

The Dignify Solutions, LLC; Chicago (IL); On-site; USD 100,000 - 120,000; Full time

Job summary

A technology solutions provider is seeking a Data Modeler specializing in BI Analytics for an onsite full-time position. The ideal candidate will have over 5 years of data modeling experience, expertise with BI reporting tools, and proficiency in database technologies. Strong communication and analytical skills are essential for success in this mid-senior level role, which involves creating complex logical and physical data models.

Qualifications

• 5+ years of data modeling experience required.
• Experience with BI reporting tools and data warehouse methodologies.
• Excellent communication skills and self-starter mentality.

Skills

Data Modeling Experience

BI Reporting tools expertise

Ralph Kimball Style of Modeling

ER Studio or Erwin Data Modeling tool

Business Requirements Analysis

Data Warehousing Methodologies

Cloud technologies

Relational database knowledge

Verbal and written communication

Self-Starter mindset

Education

Bachelor’s Degree in Computer Science or related field

Tools

SQL

Excel

Snowflake

Azure

AWS

GCP

Job description

Data Modeler - BI Analytics - Onsite (Full Time)

Base pay range

$100,000.00/yr - $120,000.00/yr

This range is provided by The Dignify Solutions, LLC. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Overview

Data Modeler - BI Analytics - Onsite (Full Time).

Qualifications

• 5+ Years of Data Modeling Experience
• Proven track record of delivering complex Logical and Physical Data Models with expertise in delivering Physical Data Models.
• Extensive experience with at least one BI Reporting tool like Tableau/Looker/Cognos/MicroStrategy/Power BI etc.
• Expertise in Ralph Kimball Style of Modeling: Dimensional, Multidimensional, Star, Galaxy and Snowflake Schema.
• Extensive experience with either ER Studio or Erwin Data Modeling tool.
• Extensive experience in versioning, maintaining Data Modeling Artifacts like files, repositories, Definitions, Mappings, Data Dictionary etc.
• Extensive experience with Business Requirements Analysis and Data Analysis using SQL scripts, Excel techniques.
• Must be passionate about being up to date with current industry trends and experimenting/learning new technologies.
• Demonstrate deep knowledge of different Data Warehousing Methodologies, techniques and best practices.
• Deep knowledge of at least one relational database: Oracle/SQL Server/Teradata. Performance tuning, Partitioning, Indexing of Physical Database Objects.
• Excellent verbal and written communication skills to work with: Team Leads, Project Managers, ETL Team, Business Analysts, Data Analysts, DBAs etc. Self-Starter with a research problem solving mindset.
• Experience with cloud technologies like Snowflake, Azure, AWS, GCP etc.
• Experience with Data Vault Modeling. A Bachelor’s Degree in Computer Science, Engineering, Math, or other related STEM discipline

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Other

Industries

• IT Services and IT Consulting