Request Technology Looking for BI Data Modeler at New York 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.