BI Data Modeler

Posted on Jan 30, 2024 by Request Technology
New York, NY, 10001
IT
Immediate Start
Annual Salary
Full-Time

BI Data Modeler

Salary: Open + Bonus

Location: Chicago, IL/Houston, TX/Dallas, TX/Austin, TX/Miami, FL/NY, NY/San Fransisco, CA

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.

Reference: 2708688154

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

This Job Vacancy has Expired!

BI Data Modeler

Posted on Jan 30, 2024 by Request Technology

New York, NY, 10001
IT
Immediate Start
Annual Salary
Full-Time

BI Data Modeler

Salary: Open + Bonus

Location: Chicago, IL/Houston, TX/Dallas, TX/Austin, TX/Miami, FL/NY, NY/San Fransisco, CA

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.

Reference: 2708688154

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