*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.