BI Data Modeler

Posted on Feb 7, 2024 by Request Technology
Chicago, IL, 60601
IT
Immediate Start
$140k - $150k Annual
Full-Time

*Hybrid, 3 days onsite, 2 days remote*

*We are unable to sponsor as this is a permanent Full time role*

A prestigious company is looking for a BI Data Modeler. This Modeler will focus on creating and managing data models that will support the companies Business Intelligence and reporting needs. This person will design/optimize data structures and flows to help data analysis and reporting. Technology experience needed: T-SQL, Talend/ADF, Erwin, SSMS, ETL, Python, Tableau, Qlik Sense, and Azure.

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.
  • Apply knowledge of the data in company ecosystem in internal consultations with IT and business staff who want to use this data in reporting and analytics.
  • Implement data security measures and access controls to protect sensitive data.
  • Ensure compliance with data governance and data management best practices.
  • Apply strong skills and experience with SQL and other means to develop data queries for ad hoc reporting, data profiling, validation, troubleshooting and analysis.
  • Work in a highly agile development environment.

Qualifications & Requirements

  • The candidate must have a BA/BS in computer science, related field, or equivalent experience with 5+ years' experience in data modelling concepts and techniques, ETL and data warehousing.
  • Datamodelling skills (eg, using Erwin to create and manage Logical/physical data models) and expertise in modelling OLAP marts, cubes etc., and understanding on data grain, slowly changing dimensions (SCDs), snowflake/star schemas, row/object level security designs etc. (required).
  • Experience working with relational and dimensional data models, and in developing complex queries using Transact SQL and other data query/reporting tools (required).
  • Knowledge of database design techniques and advanced SQL skills preferably on the SQL Server platform and/or Azure Synapse Data Marts (required).
  • Experience building, managing and optimizing data flows using ETL or ELT techniques in support of the data model buildout (required).
  • The ideal candidate has tactical experience with data warehouse implementations and data mart design.
  • Be able to understand and work with disparate data sources (required).

Technologies/Software:

  • Erwin for data modelling
  • Transact-SQL query using tools like SSMS
  • ETL Tools - Talend and/or ADF preferred.
  • Strong knowledge of relational database management systems (RDBMS) such as Microsoft SQL Server and Azure Synapse.
  • 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.
  • Microsoft office toolset (Microsoft Outlook, Word, PowerPoint, Excel) and other software as part of standard firm Windows desktop/laptop.

Reference: 2712907291

https://jobs.careeraddict.com/post/87836466

This Job Vacancy has Expired!

BI Data Modeler

Posted on Feb 7, 2024 by Request Technology

Chicago, IL, 60601
IT
Immediate Start
$140k - $150k Annual
Full-Time

*Hybrid, 3 days onsite, 2 days remote*

*We are unable to sponsor as this is a permanent Full time role*

A prestigious company is looking for a BI Data Modeler. This Modeler will focus on creating and managing data models that will support the companies Business Intelligence and reporting needs. This person will design/optimize data structures and flows to help data analysis and reporting. Technology experience needed: T-SQL, Talend/ADF, Erwin, SSMS, ETL, Python, Tableau, Qlik Sense, and Azure.

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.
  • Apply knowledge of the data in company ecosystem in internal consultations with IT and business staff who want to use this data in reporting and analytics.
  • Implement data security measures and access controls to protect sensitive data.
  • Ensure compliance with data governance and data management best practices.
  • Apply strong skills and experience with SQL and other means to develop data queries for ad hoc reporting, data profiling, validation, troubleshooting and analysis.
  • Work in a highly agile development environment.

Qualifications & Requirements

  • The candidate must have a BA/BS in computer science, related field, or equivalent experience with 5+ years' experience in data modelling concepts and techniques, ETL and data warehousing.
  • Datamodelling skills (eg, using Erwin to create and manage Logical/physical data models) and expertise in modelling OLAP marts, cubes etc., and understanding on data grain, slowly changing dimensions (SCDs), snowflake/star schemas, row/object level security designs etc. (required).
  • Experience working with relational and dimensional data models, and in developing complex queries using Transact SQL and other data query/reporting tools (required).
  • Knowledge of database design techniques and advanced SQL skills preferably on the SQL Server platform and/or Azure Synapse Data Marts (required).
  • Experience building, managing and optimizing data flows using ETL or ELT techniques in support of the data model buildout (required).
  • The ideal candidate has tactical experience with data warehouse implementations and data mart design.
  • Be able to understand and work with disparate data sources (required).

Technologies/Software:

  • Erwin for data modelling
  • Transact-SQL query using tools like SSMS
  • ETL Tools - Talend and/or ADF preferred.
  • Strong knowledge of relational database management systems (RDBMS) such as Microsoft SQL Server and Azure Synapse.
  • 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.
  • Microsoft office toolset (Microsoft Outlook, Word, PowerPoint, Excel) and other software as part of standard firm Windows desktop/laptop.

Reference: 2712907291

CareerAddict

Alert me to jobs like this:

Amplify your job search:

CV/résumé help

Increase interview chances with our downloads and specialist services.

CV Help

Expert career advice

Increase interview chances with our downloads and specialist services.

Visit Blog

Job compatibility

Increase interview chances with our downloads and specialist services.

Start Test