BI Data Modeler

Salary: Open + Bonus

Location: Chicago, IL

Hybrid: 3 days on-site, 2 days remote

*We are unable to provide sponsorship for this role*

Qualifications

• Bachelors degree
• 5+ years' experience in data modelling concepts and techniques, ETL and data warehousing
• Experience working with relational and dimensional data models, and in developing complex queries using Transact SQL and other data query/reporting tools.
• Strong knowledge of relational database management systems (RDBMS) such as Microsoft SQL Server and Azure Synapse.
• Experience building, managing, and optimizing data flows using ETL or ELT techniques in support of the data model buildout.
• Erwin for data modelling
• Transact-SQL query using tools like SSMS
• ETL Tools - Talend and/or ADF preferred.
• Experience with version control systems like Git.
• Familiarity with BI and reporting tools like Microsoft Power BI, Qlik Sense and Tableau.
• Proficiency in Scripting languages like Python or programming languages like Java or C# is a plus.

Responsibilities

• Work with business resources to identify business needs then design and develop conceptual, logical, and physical data models for the needs and support data analysis and reporting.
• Define and create ETL processes for data extraction, transformation, and loading into the data warehouse or BI platform.
• Implement data quality checks and validation rules to ensure data accuracy and consistency.
• Continuously monitor and optimize data models and database performance for efficient data retrieval and reporting.
• Maintain comprehensive documentation of data models, schemas, and related processes.