Address
Form of workJob Description
***We are unable to sponsor for this permanent full-time role***
***Position is bonus eligible***
Prestigious Global Firm is currently seeking a SQL BI Data Modeler with strong Azure and ETL experience. Candidate is responsible for creating and managing data models that support the Firm’s business intelligence and reporting needs. This role involves working closely with business analysts, data engineers, and other stakeholders to design/optimize data structures and flows that facilitate efficient data analysis and reporting. The BI Data Modeler has both technical and business-facing skills that allows driving solutions from a functional and technical perspective. The Data Modeler is well versed with industry best practices for creating, deploying, and managing data models for the Enterprise Data Warehouse, Data Marts, Data Cubes etc.
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 the 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, trouble shooting and analysis.
- Identify and execute on new process improvement opportunities.
- Work in a highly agile development environment.
- Develop a strong understanding of the business and its systems to support the firm's strategic objectives.
- Maintain up-to-date awareness of current and future directions of business industry and associated technologies.
Qualifications:
- The candidate must have a BA/BS in computer science, related field, or equivalent experience with 5+ years’ experience in data modeling concepts and techniques, ETL and data warehousing. The ideal candidate must have good judgment, problem-solving, oral, written, and interpersonal communication skills, as well as the ability to work in a fast-paced environment and build positive working relationships. In addition, candidates must be self-motivated, organized, and able to multi-task and effectively prioritize competing demands, along with:
- Data Modelling skills (e.g., using Erwin to create and manage Logical/physical data models) and expertise in modeling 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).
- Legal or professional services industry experience that demonstrates ability to work in dynamic, fast-paced company / firm working across multiple business areas (desired).
- 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).
- Ability to quickly understand business issues and data challenges of the organization.
- Self-starter, team-player and will be expected to manage and complete their tasks in a fast-paced results driven environment.
Technologies/Software:
- Erwin for data modeling.
- 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.
