Logo
The Dignify Solutions LLC

Data Modeler - BI Analytics - Onsite (Full Time)

The Dignify Solutions LLC, Chicago, Illinois, United States, 60290


5+ Years of Data Modeling ExperienceProven 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 tools like: Tableu/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 is 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 od 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