Role description: (Please include a brief outline of the impact this role will have, including overview of customer industry and projects, access to cutting-edge technology etc.)
•The data modeler plays a crucial role in designing, developing, and maintaining data models to support efficient data management and analytics within the organization.
•This role is essential in optimizing data architecture, translating business initiatives into robust data models, and enhancing data integrity, availability, and performance.
•The data modeler is responsible for developing conceptual, logical, and physical data models.
Key responsibilities:
●Design, create, and implement logical and physical data models for both IT and business solutions to capture the structure, relationships, and constraints of relevant datasets
●Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions
●Effectively collaborate and communicate with various stakeholders to understand data and business requirements and translate them into data models
●Create entity-relationship diagrams (ERDs), data flow diagrams, and other visualization tools to represent data models
●Collaborate with database administrators and software engineers to implement and maintain data models in databases, data warehouses, and data lakes
●Develop data modeling best practices, and use these standards to identify and resolve data modeling issues and conflicts
●Conduct performance tuning and optimization of data models for efficient data access and retrieval
●Incorporate core data management competencies, including data governance, data security and data quality.
Key skills/knowledge/experience:
•At least five years of experience in data modeling, database design, or related field
•Hands-on relational, dimensional, and analytical project experience using RDBMS, NoSQL data platform technologies, and ETL
•Expert knowledge of data modeling concepts, methodologies, and best practices
•Proficiency in data modeling tools such as Erwin or ER/Studio
•Knowledge of relational databases and database design principles
•Familiarity with dimensional modeling and data warehousing concepts
•Strong SQL skills for data querying, manipulation, and optimization, and knowledge of other data science languages, including JavaScript, Python, and R
•Ability to collaborate with cross-functional teams and stakeholders to gather requirements and align on data models
•Excellent analytical and problem-solving skills to identify and resolve data modeling issues
•Strong communication and documentation skills to effectively convey complex data modeling concepts to technical and business stakeholders.
Good to Have
•Domain knowledge. Understanding of the water industry.
Person specification: I.e., negotiating, client facing, communication, assertive, team leading/team member skills, supportive.
•Collaborate with customers and stakeholders.
•Grow your career, while being exposed to new technologies.
•Lead projects and inspire both colleagues and stakeholders.
•Mentor junior employees using your expertise