The Data Modeler manages the flow of information between departments through the use of relational databases. Develops data models to meet the needs of the organization’s information systems. Being a Data Modeler stays informed of the ways the organization uses its data. Maintains data integrity by working to eliminate redundancy. In addition, Data Modeler requires a bachelor’s degree. Typically reports to a manager. Being a Data Modeler gains exposure to some of the complex tasks within the job function. Occasionally directed in several aspects of the work. Working as a Data Modeler typically requires 2 to 4 years of related experience.
Data Modeler Job Description Template
Our company is looking for a Data Modeler to join our team.
Responsibilities:
- Model documentation and recommendations;
- Communicate with key stakeholders to facilitate discussions about data modeling;
- Develop DDLs for physical implementation and views;
- Data mapping and data discovery;
- Analyze source system data using profiling tools;
- Translates and transforms business requirements into data models (conceptual, logical and physical);
- Track technical debt in the data design and recommend approaches to minimize and reduce technical debt;
- Synchronize models with physical implementations;
- Adhere to existing naming and design standards as well as recommend new standards;
- Design data models in data modeling tools (e.g. ERWin);
- Produce data model documentation using ER/Studio at various levels including story, subject area, and full data model;
- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks;
- Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models;
- Lead and/or participate in data model reviews with various stakeholders;
- Evaluates database and data and develop the data model appropriately.
Requirements:
- Minimum of 1 year experience in modeling in a Snowflake and Talend solution environment;
- Minimum of 5 yearsu2fff experience with Logical Design demonstrated with large scale, multiple business solutions across divisions or enterprise;
- Minimum of 5 years prior experience as a data analyst a nd data modeler;
- Document target state end-end data flows and representations;
- Ability to create and maintain conceptual data models, high complexity logical and physical data models;
- Experience with SQL;
- Bachelor’s degree;
- Scaled Agile Framework (SAFe);
- ER/Studio;
- Strong analytical skills;
- Ability to translate business requirements to technical requirements;
- Financial Services experience a plus;
- Comfortable working in ambiguity;
- Experience as Data Modeler on OLTP relational and data warehouse projects;
- Understanding of emerging technologies, and their associated impact on enterprise environments.