Logo
Creative Solutions Services, LLC

Data Modeler - BI Analytics - Onsite (Full Time)

Creative Solutions Services, LLC, Chicago, Illinois, United States, 60290


Minimum 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. 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 and maintaining Data Modeling artifacts like files, repositories, definitions, mappings, Data Dictionary, etc. Extensive experience with Business Requirements Analysis and Data Analysis using SQL scripts and 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. Experience with Data Vault Modeling. A Bachelor’s Degree in Computer Science, Engineering, Math, or other related STEM discipline.

#J-18808-Ljbffr