Data Modeler Job Description
Data modeler
provides SQL programming, with detailed direction, in the execution of data analysis that will contribute to the final project deliverables.
Data Modeler Duties & Responsibilities
To write an effective data modeler job description, begin by listing detailed duties, responsibilities and expectations. We have included data modeler job description templates that you can modify and use.
Sample responsibilities for this position include:
Maintain knowledge of data processing trends and innovations in programming languages, development environments, and database capabilities
Drive metadata capture through data modeling application
Lead requirements gathering meetings with application teams, Database Administrators, and/or business partners to understand business needs
Develop and design the conceptual and logical data model for RDARR using Sybase PowerDesigner data modeling software
Contribute and participate in discussions with implementation of metadata tools for RDARR (business glossary, data lineage)
Provide technical support to the Underwriting and Modeling teams on topics, such as efficient data warehousing, manipulation of extremely large client datasets, general task automation and interfacing with the industry standard catastrophe modeling software
Working with the Internal IT Developers to design and standardize exposure and risk reports and add value by integrating them with in-house corporate systems
Create appropriate documentation as part of work assignments, such as program code, flowcharts and technical requirements
Perform design implementation and support of Enterprise Data Management (EDM) and data structures within all layers of Enterprise Data Warehouse (EDW) environment
Drive design of data structures
Data Modeler Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Modeler
List any licenses or certifications required by the position: ITIL, AWS, SDLC, PMI, DAMA, HANA, CSM, PMP, CE, II
Education for Data Modeler
Typically a job would require a certain level of education.
Employers hiring for the data modeler job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Information Systems, Mathematics, Business, Technical, Information Technology, Science, Computer Engineering
Skills for Data Modeler
Desired skills for data modeler include:
SQL
Application
Programming languages
GEOINT TCPED
R
ABI concepts and methods
Excel
MS Project
Project Management with the ability to drive projects to successful completion
Banking processes and products
Desired experience for data modeler includes:
1+ years of experience in finance, data analysis and business analyses
Advanced degree preferred, Bachelor’s degree required in Economics, Finance, Mathematics, or other quantitative discipline
Experience extracting data from various databases and analyzing large data sets for conversion into useful business information
The business data modeler must have 3-5 years of experience working on data modeling complex financial instruments, party, agreement and other business concepts in an investment bank
End-to-end data model development and entity-relationship design from data preparation to the build, validation and calibration of BI data models
Experience using data modeling tools such as PowerDesigner or Erwin
Data Modeler Examples
1
Data Modeler Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of data modeler. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data modeler
- Create Conceptual/Logical/Physical Models for EDW staging, data integration, analytics, and reporting
- Lead creation of Enterprise view (integration) of data
- Lead model management and version control of data models
- Facilitate creation/migration of data objects (DDL) across Development/Quality Assurance/Production
- Reverse-engineer source system structures for EDW sourcing/landing
- Maintain repository and exchange of metadata using EDW-based tools (Teradata, Informatica, Cognos)
- Establish Standards, Guidelines, and Best Practices around data modeling initiatives
- Publish and communicate models to IT and User Teams
- Develop data movement requirements/technical specifications across EDW layers
- Create and optimize data structures for reporting and data integration
Qualifications for data modeler
- Experience with FI Standard Data Models such as Teradata FS-LDM, IFX
- Experience consolidating multiple data models to an industry data model
- Strong background in Data Warehousing and Business Intelligence environment working with large data sets
- Facilitate requirements and modeling sessions including user interview, document analysis, workshops
- Ensure strategy of data conversion is consistent with defined controls and procedures established data standards
- Contribute with DBAs to the creation physical database designs
2
Data Modeler Job Description
Job Description Example
Our growing company is hiring for a data modeler. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data modeler
- Supporting the CCFA (common cash flow application) and LFM (loss forecast model)
- Participate in requirements definition, analysis, and design of EDW solutions
- Partner directly with BI reporting developers to assist with framework modeling, troubleshooting development performance, simplifying complex reporting requirements, and developing optimum solutions in accordance with Enterprise data standards
- Investigate data quality issues to determine root causes, resolve data issues and recommend process changes
- You will be working with Business Partners, IT Partners, Vendors and your Project Team to deliver data that translates business needs into business intelligence reports
- You will work closely with the Project Manager, Development Consultant, Architect, Business Systems Analysts and Developers to define a data model that supports a broad array of business needs in a divisionally consistent model
- You will create data specifications and support the development team in the creation of reports to ensure that the output meets the requirements of the solution
- As we grow you will work closely with project teams to define solutions and provide analysis in support of correspondence management needs
- Provides senior level data modeling services, including updating and building logical database models for regularly scheduled releases, including those for new databases with large numbers of users and interfaces
- Reviews data models with lead to assess the impact of the new model on the enterprise model
Qualifications for data modeler
- Participate in data definition and data management reviews
- Design, create and document best practice logical and physical data models for operational analytical data models
- Ensure optimal performance by adding required database objects (indexes)
- Excellent oral and written communication skills, ability to interact with the business users other technical teams
- 7 - 10 years experience in data modeling, data warehousing, data mining, data entity analysis, conceptual, logical and physical model development in relational data base environments
- Solid understanding of transaction and information systems, data warehouses, data marts, ODS, MDM methodologies and life cycles ETL and MDM technologies
3
Data Modeler Job Description
Job Description Example
Our company is looking for a data modeler. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data modeler
- Creates and writes documentation, including procedures
- 5+ years with strong experience with modeling in a Data Warehousing and BI context (star schemas, BI modeling issues such as slowly changing dimensions)
- Provide ad-hoc analyses/queries/reports from a wide variety of BI tools including MicroStrategy, Oracle data-mart tables
- Supports analysis of adherence of data to business rules and compliance with laws and regulations
- Collaborate in meetings with product owners to understand the functional requirements
- Pull data from databases on different platforms
- Update Technical Design documents
- Collaborate with Enterprise Architects to establish, and enforce data principles, standards and best practices
- Iteratively refine the existing enterprise conceptual data model where required
- Develop data quality cleansing rules for data elements within scope
Qualifications for data modeler
- Self-starter who solves complex technology and operational problems/issues with little to no guidance from senior management
- Will collaborate with data mappers, business analysts, ETL developers, and other team members as needed in order to provide the appropriate logical and physical database designs
- Will be able to demonstrate experience using data modeling tools such as Power Designer (preferable), Erwin, or equivalent
- Will have familiarity with Financial Industry Standard Data Models, such as Teradata FS-LDM or equivalent
- Experience in credit card industry, financial services, and financial risk reporting will be a definite asset to the position
- Must be able to demonstrate strong attention to detail
4
Data Modeler Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of data modeler. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for data modeler
- Architect overall master data hub for data elements that are used by multiple IT systems
- Designing data extracts, ad hoc queries, and other BI solutions
- Working with business stakeholders to gather requirements and ensuring result validity
- Working with the Analytics Team to ensure appropriate data is captured
- Develop conceptual, logical, and physical data models for the business intelligence efforts
- Be responsible for leading and facilitating communication with business customers, IT staff, and other stakeholders, incorporating business requirements into data model design
- Translate technical aspects of data modeling (facts, dimensions, "snowflaking", ) into language that non-technical users can understand
- Make recommendations on data maintenance tactics for slowly changing dimensions, data roll-off / archival planning
- Work with DBAs to coordinate instantiation of tables and other relevant database objects
- Design models optimized for both storage (warehouse) and query / retrieval (end user marts)
Qualifications for data modeler
- Minimum five years’ experience of Investment industry data modeling
- Advanced degree in Computer Science, Engineering, Mathematics, Statistics, Finance, or related quantitative field or equivalent
- Experience with GIS mapping software (Map Object, ArcGIS, MapInfo )
- Related experience in Property Insurance or Reinsurance sector and catastrophe modeling
- Experience using graph DBs and triple stores such as Virtuoso, Jena, Sesame, AllegroGraph is a plus
- Familiarity with semantic rules such as SPIN, OWL ontologies, and Reasoners is a plus
5
Data Modeler Job Description
Job Description Example
Our innovative and growing company is hiring for a data modeler. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for data modeler
- Responsible for progressing and maintaining the official description of the data
- Responsible for reverse engineering of existing databases
- Reverse engineer source system data structures for model sourcing
- Develop advanced analytical models, including optimization and other prescriptive analytical tools
- Lead and support efforts to integrate data from multiple databases
- Lead and support efforts to build and automate data flows from source data
- Lead and support development of automated data connections from multiple data sources into a prescriptive planning software platform, including designing required data integration/manipulation processes and queries
- Analyzing user requirements, procedures and problems
- Working with Enterprise Models, working on building mortgage loan performance models, and integrating the models to forecast cash flows and compute analytics
- Building models such as loan performance models, call models, interest rate models, micro-economic models
Qualifications for data modeler
- Familiarity knowledge of Unix is a plus
- Previous experience in the finance industry is a plus
- Willingness and ability to learn new concepts and technologies quickly
- Experience using data modeling tools - , ErWin
- Expert modeling tool development experience in CASE tools, including Erwin and PowerDesigner
- You have the ability to translate system requirements into a logical data model