Data Modeler - BI Analytics - Onsite (Full Time)

The Dignify Solutions, LLC

Chicago (IL)

On-site

USD 100,000 - 120,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Modeler - BI Analytics & Data Warehouse (Onsite)
Data Modeler - BI Analytics & Data Warehouse (Onsite)

The Dignify Solutions, LLC • Chicago (IL)

On-site
USD 100,000 - 120,000
Data Modeler (Remote)
Data Modeler (Remote)

Cedent • United States

Remote
USD 55,104 - 82,656
Health Insurance
Dental Insurance
Vision Insurance
BI Data Modeler Engineer
BI Data Modeler Engineer

Request Technology, LLC • Chicago (IL)

Hybrid
USD 110,000 - 140,000
Data Modeling BI Engineer
Data Modeling BI Engineer

Request Technology, LLC • Houston (TX)

On-site
USD 120,000 - 150,000
Bonus eligible
Senior Data Modeler
Senior Data Modeler

Globenet Consulting Corp • Bellevue (WA)

Hybrid
USD 100,000 - 130,000
Competitive salary
Opportunity for advancement
Training & development
+1
Data Modeler
Data Modeler

Cambay • Reston (VA)

On-site
USD 90,000 - 110,000
Senior Data Engineer
Senior Data Engineer

Harnham • Phoenix (AZ)

On-site
USD 140,000 - 150,000
Medical insurance
Vision insurance
Data Warehouse Data Modeler
Data Warehouse Data Modeler

JPS Tech Solutions • Iowa

On-site
USD 120,000 - 170,000
Business Intelligence Data Modeler Engineer
Business Intelligence Data Modeler Engineer

SCIGON • Chicago (IL)

On-site
USD 116,000 - 144,000
Healthcare benefits
Paid time off
Retirement plan
+1
Manager - Data Engineering
Manager - Data Engineering

Mphasis • New York (NY)

On-site
USD 85,000 - 165,000