DATA MODELER SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 03, 2024 - The Data Modeler's expertise in CI/CD tools and GIT/Bitbucket integration, complemented by a profound ability to drive technical standards and architectural data patterns across diverse teams. The position demonstrates deep proficiency with Oracle and NoSQL databases like MongoDB, underpinned by a strong foundation in data modeling, security, and privacy standards. Skilled in leading stakeholder sessions to establish data rules and mentoring teams within high-volume enterprise systems, particularly in the retail sector.

Essential Hard and Soft Skills for a Standout Data Modeler Resume
  • Data Modeling
  • SQL
  • Database Design
  • ETL Processes
  • Data Warehousing
  • NoSQL Databases
  • Data Architecture
  • Dimensional Modeling
  • Metadata Management
  • Data Governance
  • Problem Solving
  • Analytical Thinking
  • Attention to Detail
  • Communication
  • Collaboration
  • Adaptability
  • Time Management
  • Critical Thinking
  • Creativity
  • Leadership

Summary of Data Modeler Knowledge and Qualifications on Resume

1. BS in Data Science with 5 years of Experience

  • Ability to accomplish multiple tasks within the agreed-upon timeframes through effective prioritization of duties and functions in a fast-paced environment.
  • Strong track record of building and maintaining solid relationships with internal and external customers and vendors.
  • Able to work independently to complete tasks and respond to department requests and to collaborate with others to utilize resources and knowledge to identify high-quality solutions.
  • Ability to work with functional groups and different levels of employees throughout the organization to effectively and professionally achieve results.
  • Ability to relate business problems to the underlying data and link to solutions to solve those business problems.
  • Ability to identify and improve communication to bring conflict within the team into the open and facilitate resolution. 
  • Ability to share credit for team accomplishment. 
  • Ability to monitor individual and team effectiveness and recommend improvement to facilitate collaboration. 
  • Ability to develop data model prototypes and full model structure
  • Ability to analyze models and develop intuitive result presentations
  • Ability to create transparent model documentation including commenting code and sources for all parameters
  • Experience with system dynamics or agent-based modeling and the development of model interfaces (e.g., to support decision-making)

2. BA in Business Analytics with 4 years of Experience

  • Ability to grow and develop a diverse engineering team by providing technical and professional guidance.
  • Ability to solve complex engineering problems and lead system design and development activities.
  • Understand business processes, a bigger picture, and core ideas behind the developed software.
  • Advocate and advance toward cutting-edge engineering practices.
  • Ability to apply Agile development best practices and ceremonies.
  • Experience with working in the Agile development methodologies, collaborating with business and technology teams located globally.
  • Actively contribute and participate in sprint grooming and planning discussions, daily stand-ups, and Agile ceremonies
  • Experience in working with various teams and stakeholders across geography and time zone
  • Understand and translate business needs into data models supporting strategic solutions.
  • Experience in working with the Application Development team to implement data strategies, build data flows and develop conceptual data models.

3. BS in Computer Science with 5 years of Experience

  • Experience in the Design and Development of AWS cloud data solutions including cloud database, data storage and data warehouse
  • Ability to lead in the creation, development, implementation, configuration, maintenance and support of data models for databases, data marts and data warehouses
  • Deep knowledge of Google Cloud Services like Google Cloud Dataflow, Google Cloud Scheduler, Google Composer, BigQuery
  • Extensive experience in database, data storage and data warehouse designing
  • Deep knowledge of fault tolerance and disaster recovery of cloud data
  • Experience with DevOps and Agile team 
  • Strong written and oral communication skills
  • Data Modelling experience with hands-on knowledge on PL/SQL code
  • Ability to debug data model issues, configuration tuning, code review, performance tuning
  • Experience with PL/SQL code performance analysis & optimization
  • Experience in Database migration and upgrade activities, support & coordination

4. BA in Statistics with 4 years of Experience

  • Familiarity with key technologies and concepts, NO SQL, SQL, RDBMS & Hadoop.
  • Candidate with experience in Analytics and big data architecture.
  • Knowledge of products in Banking and Financial Services.
  • Ability to write clear documentation of procedures, and ability to write specifications for data models to be developed.
  • Detail-oriented and able to follow clear methodologies for troubleshooting and development.
  • Expert knowledge (at least one) in any of the financial service data models like FIBO, BIAN, IBM-BDW, FSLDM etc
  • Expert knowledge of the Erwin data modeler tool
  • Expert in Data Analysis and Data Profiling.
  • Efficient in prioritizing work and multi-tasking
  • Experience in developing and applying conceptual and logical data models (3NF).
  • Experience in using at least one data modeling tool – ideally ER/Studio or Erwin.
  • Knowledge of both SQL and NoSQL databases

5. BS in Mathematics with 8 years of Experience

  • Experience with CICD Tools and GIT/Bitbucket integration
  • Experience in driving technical standards, architectural and data patterns across multiple teams.
  • Experience and strong proficiency with databases, modern system architectures, and data patterns.
  • Solid understanding of data modeling, data lineage, data security/confidentiality/privacy and related data standards.
  • Experience with Oracle 11g,12c,19c
  • Knowledge of NoSQL databases  (e.g. MongoDB) 
  • Ability to educate and influence program stakeholders regarding program goals, objectives and approaches.
  • Ability to organize applicable department timelines and follow up with internal and external customer needs.
  • Experience and proficiency in enterprise data modeling for large, high-volume systems
  • Ability to lead sessions with stakeholders to determine data rules and review data models
  • Extensive architecture and design experience with complex applications, preferably in the retail industry, for Relational and NoSQL databases
  • Experience working with API Management and Service Oriented Architecture (SOA)
  • Ability to coach and mentor less experienced members of a Data Architecture team

6. BA in Economics with 5 years of Experience

  • Experience in producing and managing a Data warehouse modeling plan entailing dimensional modeling such as star schemas, facts, and slowly changing dimensions.
  • Experience with database development experience (stored procedures, functions, materialized views, change data management etc) with large-scale MPP data warehouses such as Teradata, Greenplum, Netezza, Vertica or a variation.
  • Experience in developing, validating, publishing and maintaining conceptual, logical and physical data models and supporting documentation.
  • Experience in working with Business Analysts, Data Architects, Software Developers and Database Architects to achieve project objectives.
  • Experience in solving analytical problems using quantitative approaches.
  • Experience with advanced SQL and other programming languages (Python).
  • Experience with ETL tools and techniques, Informatica, Datastage, SSIS etc. 
  • Basic knowledge in Data presentation tools
  • Understanding of fundamental design principles behind a scalable application and data design.
  • Strong Exposure to IT Project Lifecycle.
  • Life Science Domain experience.
  • Ability to interpret and communicate technical information into business language.

7. BS in Information Systems with 6 years of Experience

  • Expert knowledge of various Data modeling techniques such as OLTP (normalized), ODS, EDW (dimensional)
  • Experience with ER Studio, Erwin or similar tools
  • Knowledge of Industry Data Models
  • Expertise in Oracle (Temporal Data Management features knowledge is nice to have)
  • Working knowledge in the creation of data infrastructure - such as views, stored procedures, ETL usage, real-time/streaming data integration
  • Experience in system/business/data analysis related to data migration and data integration projects
  • Experience with enterprise data management, governance, and BI/reporting tools
  • Knowledge of the development of data models compliant with non-functional enterprise requirements, such as security and performance guidelines
  • Deep understanding of data flow diagrams, system architecture diagrams, functional and system analysis
  • Understanding and hands-on experience of the Data Architecture, Data Quality, and Data Profiling concepts
  • Experience with financial services, retirement, insurance, or medical records industry and knowledge of industry-standard data models (i.e. IBM's Finance model, ACORD)

8. BA in Applied Mathematics with 5 years of Experience

  • Experience in analytical or business intelligence disciplines including data analysis, visualization, integration, modeling, etc.
  • Experience working in cross-functional teams and collaborating with business stakeholders in Retail in support of a departmental and/or multi-departmental analytics initiative.
  • Deep Retail Industry knowledge or previous experience working in the business
  • Strong experience with analytical methods including regression, forecasting, time series, cluster analysis, classification, etc. 
  • Experience with machine learning and AI
  • Strong experience with advanced analytics tools for Object-oriented/object function scripting using languages such as R, Python, Scala, or similar.
  • Strong experience with popular database programming languages including SQL, PL/SQL, etc. for relational databases and on NoSQL/Hadoop oriented databases like MongoDB, Cassandra, etc for nonrelational databases.
  • Strong experience working with popular data discovery, analytics and BI software tools like MicroStrategy, Tableau, PowerBI and others for semantic-layer-based data discovery. 
  • Strong experience in working with data science teams in refining and optimizing data science and machine learning models and algorithms.
  • Basic understanding of popular open-source and commercial data science platforms such as Python, R, KNIME, Alteryx, and others
  • Basic experience in working with data governance, data quality, and data security teams and specifically and privacy and security officers in moving data pipelines into production with appropriate data quality, governance and security standards and certification.
  • Ability to work across multiple deployment environments including cloud, on-premises and hybrid, multiple operating systems and through containerization techniques such as Docker, Kubernetes, AWS Elastic Container Service and others.
  • Adept in agile methodologies and capable of applying DevOps and increasingly DataOps principles to data pipelines to improve the communication, integration, reuse and automation of data flows between data managers and consumers across an organization

9. BS in Software Engineering with 6 years of Experience

  • Understand how an Enterprise Data Warehouse works
  • An intermediate or higher level of SQL querying
  • Experience with Python and Pandas in the context of Data Science
  • Enjoy the bridge between a technical and non-technical audience
  • Able to perform database modeling and mapping (e.g. for Oracle databases)
  • Demonstrate analytical skills
  • Display the strong interpersonal skills necessary to interact effectively with all levels of management
  • Knowledge of the financial industry
  • An intermediate level of testing and validating data
  • Leadership and influential skills to develop consensus across onsite/offshore consultants.
  • Overall technical competence to deliver data management solutions that adhere to Voya standards and excellent presentation skills
  • Problem-solving attitude, eagerness to learn new tools and technologies, and proactive approach to daily activities
  • Appreciation and understanding of the financial services industry in order to make sound business decisions.

10. BA in Operations Research with 10 years of Experience

  • Strong RDBMS and/or Big Data implementation experience.
  • Data Modelling using Erwin or ERStudio
  • Experience with information architecture concepts (Common Information Model/Canonical Data Model, Enterprise Information Management, Metadata Management, Data Governance, and Master Data Management).
  • Knowledge of and experience applying data and object modeling techniques and best practices.
  • Experience working with and supporting ETL and Front-End development teams.
  • Familiarity with tuning and performance optimization techniques.
  • SDLC experience for large-scale and complex projects within Finance.
  • Excellent written and oral communication skills, including the use of Excel for the presentation of data and mappings.
  • Past experience in IBM BDW implementations a strong plus
  • Related Data modeling experience with Big Data environments such as Hadoop/Hive, MongoDB, and HBase
  • Experience building component-based XML or JSON structures to support a Service-Oriented Architecture (SOA).

11. BS in Management Information Systems with 9 years of Experience

  • Experience in data modeling or data architecture in transactional and operational reporting and analytical (EDW, Data Lake, NoSQL) solutions.
  • Experience in LDM / PDM and using Erwin tool.
  • Experience with capacity planning, database scripting and package deployment
  • Good knowledge of data replication methodology.
  • Good knowledge of data warehouse, data mart and Data Lake
  • Experience with AWS and cloud-based databases and data warehouses.
  • Knowledge of UML modeling standards, XML transformation, XML validation schemas (XSD) is a plus
  • Experience working with BI tools for data visualization like Tableau, Cognos, and Business Objects is a plus
  • Strong knowledge of Data Warehousing concepts, top-down, bottom-up, common dimensions, EDW Bus Matrix
  • Experience working with business users
  • Able to produce Conceptual, Logical & Dimensional models
  • Experience in property management and/or construction

12. BA in Computational Mathematics with 7 years of Experience

  • Experience with using a 3rd NF approach and data modeling tools, including Erwin
  • Experience in working with data management concepts and activities including industry best practices for data sourcing, key data elements, and data quality
  • Experience with developing and maintaining logical and physical data models and data dictionaries
  • Experience with developing standardized data vocabularies across large organizations and multiple business units and data issue identification, analysis, and remediation
  • Ability to work within standardized and non-standardized processes to accomplish assigned tasks
  • Ability to create and maintain data flows and documents using tools that include Visio, as necessary
  • Experience with working in agile environments
  • Experience with design, development, and support for digital transformation and data modernization efforts
  • Experience with using Informatica product suites, including Enterprise Data Catalog (EDC) and AXON
  • Ability to work in a team environment and independently on assigned tasks
  • Excellent oral and written communication skills, including facilitating information discovery sessions with business leaders to extract all appropriate terminology and context and focusing on accuracy, consistency, and standardized terminology

13. BS in Artificial Intelligence with 4 years of Experience

  • Expertise in data and processes related to the large-scale retailer (global and transversal vision)
  • Have project management experience and a first experience in corporate data governance
  • Highly skilled in relational databases and structured query language (SQL) such as Teradata, MSSQL, Oracle
  • Experience in data modeling of both SQL and NoSQL databases, database design, normalization, data de-structuring, flattening processes, etc.
  • Experience with non-relational database systems and JavaScript-like programming languages (JSON, CSV, MongoDB, Elasticsearch are preferred).
  • Experience with big data tools like Hive, Sqoop, Presto, Hudi, DBeaver, SQL Studio, Teradata Studio, Erwin, and others
  • Great skills for understanding and explaining to others abstract concepts
  • Ability to express ideas clearly and concisely, using technical and non-technical language.
  • Experience implementing BI projects and data warehouse.
  • Have expertise in the modeling of business objects (OLAP and related)

14. BA in Information Technology with 5 years of Experience

  • Experience in Banking, Mortgage/ secured models, work experience in statistical models built for either Basel II or III or IFRS9
  • Conducts analysis and structures business problems into analytical tasks
  • Problem-solving - open-ended and methodology driven
  • Experience in working with multiple client stakeholders, managing client communication
  • Have SAS, SQL, VBA
  • Good to have- R, Python
  • Experience with ERWIN or ER Studio (one of these is 100% and recent too)
  • Experience with Informatica for moving Metadata in/out of various repositories
  • Modeling experience should cover both transactional as well as dimensional modeling
  • Experience with DBA, Database Developer, Migration/Mapping expert, etc. 
  • Experience working in a senior data management/modeling/governance position
  • Data Management/Data Governance/Data Quality experience
  • Strong stakeholder engagement/Excellent communication
Relevant Information
Senior Data Business Analyst Skills, Experience, and Job Requirements
Data and Applied Scientist Skills, Experience, and Job Requirements
Data Integrity Analyst Skills, Experience, and Job Requirements
Data and Reporting Analyst Skills, Experience, and Job Requirements