Data Modeler Resume Samples

The Guide To Resume Tailoring

Guide the recruiter to the conclusion that you are the best candidate for the data modeler job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.

Craft your perfect resume by picking job responsibilities written by professional recruiters

Pick from the thousands of curated job responsibilities used by the leading companies

Tailor your resume & cover letter with wording that best fits for each job you apply

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

CHOOSE THE BEST TEMPLATE - Choose from 15 Leading Templates. No need to think about design details.

USE PRE-WRITTEN BULLET POINTS - Select from thousands of pre-written bullet points.

SAVE YOUR DOCUMENTS IN PDF FILES - Instantly download in PDF format or share a custom link.

Create a Resume in Minutes

S Schroeder

Sadye

Schroeder

87235 White Valley

Chicago

+1 (555) 136 6014

87235 White Valley

Chicago

Phone

p +1 (555) 136 6014

Experience Experience

Dallas, TX

Data Modeler

Dallas, TX

Hartmann and Sons

Dallas, TX

Data Modeler

Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models
Work with the development team to implement data strategies, build data flows and develop data models
Provide SAP HANA modeling and Analytics expertise in the development of new solutions as well as the improvement of existing solutions
Work with the lead to establish standards around flexibility of the data model to ensure deviations are within established guard rails
Work with development, application and other data architects to provide an overall solution approach
Identify and recommend process improvements that significantly reduce workloads or improve quality for his/her assigned areas of responsibility
Provides technical assistance and mentoring to staff for developing conceptual and logical database designs and the physical database

Detroit, MI

Lead Data Modeler

Detroit, MI

Jenkins LLC

Detroit, MI

Lead Data Modeler

Assist service developers in adding new data concepts to their services,
Establish standards around flexibility of the data model to ensure deviations are within established guard rails
Performs data analyzes and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using ERWIN and MB MDR
Assist service developers in finding relevant content in the existing reference models,
Assist with defining data model development methodologies, principles, standards, and governance considering People and Process optimization aspects
Five or more years of enterprise level data design and development
Provide technical support to a review team that approves those additions, and

present

Philadelphia, PA

Senior Data Modeler

Philadelphia, PA

Hickle-Lind

present

Philadelphia, PA

Senior Data Modeler

present

Develops and approves strategies for continuous improvement in data management
Provide guidance and leadership to perform analysis and provide solutions
Assists with coordination of database changes within context of overall configuration management process
Identifying, recommending and implementing emerging Modeling and IT trends, developments, tools and improvements/solutions
Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs
Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques including Inmon or Kimball
Collaborates with cross-functional team in support of business case development and identifying modeling method(s) to provide business solutions

Education Education

Bachelor’s Degree in Computer Science

Drexel University

Bachelor’s Degree in Computer Science

Skills Skills

Strong applied knowledge of software development efforts through implementation including good design, documentation and supportability practices
Strong interpersonal skills; strong written and verbal communications skills; experience with remote or virtual teams
Strong work ethics, driven, dependable, and responsible
Willingness and ability to learn quickly new Big Data and Cloud Analytics solutions
Strong organizational skills with attention to detail
Excellent analytical and problem-solving ability
Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal BI-Temporal models, etc.)
Detail oriented with strong organizational and analytical skills
Strong analytical skills and writing skills, to include solid experience in writing functional and technical specification
Strong people skills including the ability to effectively and concisely communicate orally and in writing across all levels of the organization

Create a Resume in Minutes

15 Data Modeler resume templates

Read our complete resume writing guides

Data Modeler Resume Examples & Samples

Work with the Card Data Warehouseteam to develop, enhance and maintain its systems
Participate in the analysis and design of system solutions to meet business needs
Ensure data quality, data understanding within supported areas
Demonstrated expertise in logical and physical data modeling (ER and Dimensional)
3-5 years experience in developing data-marts, operational and analytical environments
3-5yearsusing Data Modeling tools: ERwin
Knowledge of software project lifecycle
Experience with change management procedures
Experience with Data Governance
Excellent communication, both written and verbal
Experience with large scale Data Warehousing environments
Experience with Teradata
Strong analytical skills and writing skills, to include solid experience in writing functional and technical specification

Data Modeler Resume Examples & Samples

Ability to work in a fast paced environment
3-5 years demonstrated expertise in logical and physical data modeling (ER)
3-5 years of experience in developing operational environments
3-5 years demonstrated proficiency using Data Modeling tools such as: ERwin
3-5 years working experience of large scale computing environment
3 years of working experience in ANSI standard SQL a must
3 years of experience with change management procedures and SDLC is a must
3 years of experience with deployment of database changes
3 years of demonstrated ability to investigate and learn new technologies and products is preferred
3 years of experience with Oracle
Strong verbal and written communication, with an ability to present and discuss technical information in a way that establishes rapport, persuades others, and gains understanding
Ability to exercise independent judgment and creative problem-solving techniques in a highly complex environment using technology and/or integrating diverse user systems

GIW Data Modeler Resume Examples & Samples

5+ years experience in data modeling (preferably on large scale DWH)
Experience with analytical and operational data Store modeling
Experience with physical data model deployments, script development
Experience with dimensional data modeling at an enterprise level
Expert level experience in ERWin 4.x (or above)
Familiarity with Kimball and Inmon methodologies
Expert experience and working knowledge of Oracle (10g or above preferred)
5+ years of experience with SQL, SQL tuning
Experience with tools including TOAD, SQL Developer
Experience with UNIX Shell scripting
Experience with BI tools (Business Objects, Microstrategy)
Experience with source control tools (i.e. Clearcase)
Experience with PL/SQL
Familiarity with real time vs. batch systems

Data Modeler Resume Examples & Samples

Minimum five years of experience in the design and building of data models
Minimum five years of experience in relational database design & tuning, use of tools to diagnose database performance issues, create reporting index strategies and improve database designs based on SQL execution
Minimum five years of experience in gathering database mapping requirements and creating mapping documentation in detail preferably using ERwin
Knowledge of data architecture concepts such as data cubes and OLAP multidimensional systems, data marts, data mining systems, operational data stores, data warehouses, staging databases and data servicing layers
Skilled in data base design in a large data base environment (1 TB )
Experience with Microsoft SQL Server 2008 R2 or higher
Familiarity with the procedures and issues of implementing ETL routines
Should have experience with an ETL tool, preferably Microsoft SSIS
Familiarity with Ab Initio is a plus
Experience with SQL create/modify/test scripts to test data model and confirm viability against report specifications
Strong communication skills and the ability to work with customers to understand business requirements

Senior Data Modeler Resume Examples & Samples

Develop, enhance and maintain customer lifetime value scoring assessment
Develop customer insights through statistical modeling, segmentation, quantitative analyses, and customer profiling
Effectively communicate results to executives
Perform advanced statistical analysis and modeling to solve complex business problems
Utilizes predictive analytics to develop insights, opportunities, and effectiveness of marketing initiatives
Develop, enhance and maintain customer lifetime value
Collaborates with cross-functional team in support of business case development and identifying modeling method(s) to provide business solutions
5-8 years experience required
MS degree in math, statistics, computer science or related field
Prior experience utilizing SAS, SPSS, SQL, or similar large database application is desired
Exceptional analytic, strategic, and problem-solving skills
Exposure to digital analytics tools a plus (Adobe Omniture, Google Analytics)
Passion for data analysis and modeling, with strong analytical and SQL skills

Data Modeler Resume Examples & Samples

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. Financial services organization experience highly preferred
Overall financial services industry knowledge with specific functional expertise ideal
Demonstrated ability to build, maintain and navigate the organization using formal / informal networking skills
Hands on experience with end to end data modelling skills, source to target maping techniques, data flow diagrams using EA Erwin Diagrams, Enterprise Architect and Vizio Diagram, etc
Strong understanding of database concepts & semantic modeling
Experience in doing current state data model assessments/target data models and gap analysis
Has understanding of strategic roadmaps, process & technology solutions
Good facilitation skills and experience in managing stakeholder requirements / design sessions
Familiarity and experience with financial services business and governance models
Strong understanding and hands on application of any data architecture and coordinate hand-off of data model design to IT for physical design and build
Strong ability to problem solve (by means of logical thinking, deductive reasoning) critical issues and business problems
Strong analytical skills are required to synthesize data and story board
Demonstrated ability in conveying results of analysis into business language
Assist Reference Data Production team in implementation and integration of data models in day-to-day production activities
Define / maintain CDU Data Dictionary/Business Glossary
CDU LDM “Source to target mapping” and business rules to support ETL design by I.T
CDU LDM Data flow diagram and business rules to support CDU process design ( TPM)
Coordinate data governance aspect of CDU LDM with IB Ref Data Governance team and CDU Process Architect team
Contribute in strategy and roadmap discussions with the Change delivery teams
Typically qualifications would include an undergraduate or postgraduate degree in Science, Business Administration, Engineering or a related field
LI-SA2* *LI-SA2* *LI-SA2* *LI-SA2* *LI-SA2* *LI-SA2* *LI-SA2*

Data Modeler Resume Examples & Samples

Work with Analysts and Subject Matter Experts to identify and understand customer requirements for creation/modification of corporate Data Warehouse, departmental Data Marts and application specific Operational Data Stores
Develop logical and physical data models including star schemas, snowflake schemas, and highly normalized data models
Understand the nature of the data in various source systems and mapped to a single consolidated data warehouse model (source to target mappings)
Enhance process for capturing and maintaining metadata from all data warehousing components
Assist database developers and administrators with the translation of the logical model into a workable physical model. Participate in or lead data quality and data standardization initiatives. Assist in the development of Extraction, Transformation and Loading (ETL) programs
Be responsible for or be a contributor to documentation artifacts including functional requirements documents, design documents and data management plans
Minimum five years of experience in relational database design & tuning. Use of tools to diagnose database performance issues, create reporting index strategies, and improve database designs based on SQL execution
Minimum five years of experience in gathering database mapping requirements, creating mapping documentation in detail, preferably using ERwin
Knowledge of data architecture concepts such as data cubes and OLAP multi-dimensional systems, data marts, data mining systems, operational data stores, data warehouses, staging databases and data servicing layers
Skilled in data base design in a large data base environment (1 TB+)
Familiarity with the procedures and issues of implementing ETL routines. Should have experience with an ETL tool, preferably Microsoft SSIS. Familiarity with Ab Initio is a plus
Strong communications skills and the ability to work with customers to understand business requirements

Data Modeler / Developer Resume Examples & Samples

Key participant in creating and implementing a data management/governance framework for JPMIS
Execute data delivery projects as an individual contributor
Develop and plan required data sourcing and transformation projects in response to business needs. Contribute to the design, build and maintenance of the IntelliStor repository and other data assets as they are developed
Effectively partner with the Data Insights team to drive usage and improvement of the IntelliStor repository
Create and enforce guidelines to ensure consistency, quality and completeness of all JPMIS data assets
4+ years of working in large and medium project teams, as a contributing member in self-directed roles
Deep experience across the full range of database and business intelligence tools (SQL, Tableau, Spotfire, SAS, R and other data science toolsets)
Detail oriented and a commitment to innovation
Experience with industry leading Analytical, Data Processing and Business Intelligence tools and techniques for application in a Big Data environment
Ability to present complex information in an understandable and compelling manner
Strong working knowledge of Java and Python
Knowledge of Big Data technologies (e.g., Hadoop, GreenPlum) is preferred
Knowledge of machine learning and predictive analytics is a plus

Data Modeler Resume Examples & Samples

Experience with data modeling and database design
Experience with data profiling
Thorough knowledge of SQL and Transact-SQL scripting
Extensive experience developing stored procedures, functions, views, and triggers
Experience with SQL Server Data Transformation Services and SQL Server Integration Services, including use of variables, and configuration files
Proficiency with MS office product suite, especially MS Excel
Knowledge of the Canadian securities industry is required and experience with trading systems and derivative instruments is preferred
A self-starter with strong ability to prioritize and meet deadlines
A quick learner to understand technical as well as business requirements
A strong interest to work in capital market electronic trading
Strong desire to improve his/her technical and business skill set and knowledge base
Ability to work on multiple initiatives at the same time
Interpersonal skills with an ability to communicate effectively and easily
Technical design experience
Technical business analysis skills

Data Modeler Resume Examples & Samples

1-3 years demonstrated expertise in logical and physical data modeling (ER)
1-3 years of experience in developing operational environments
1-3 years demonstrated proficiency using Data Modeling tools such as: ERwin
1-3 years working experience of large scale computing environment

Data Modeler Resume Examples & Samples

2+ years of employment history in the Financial Services industry and a corresponding history of data models delivered is essential
Knowledge of both OLTP 3NF modeling and Kimball-style dimensional modeling is desirable
Familiarity with SDLC
A track record of using Erwin or experience with other data modeling tools
Excellent problem solving skills and technical reasoning
Awareness of other modeling techniques such as UML
Familiarity with reference data at the global and local level
Assist with the definition and documentation of current state and future state Information Architecture models

CIB Tech-logical Data Modeler, VP-brooklyn Resume Examples & Samples

Reviewing and elaborating stakeholder requirements
Designing data models in a collaborative manner, and in line with the firm’s defined Information Architecture and Fortress Architecture principles
Directly support the implementation of data base and message designs through close collaboration with physical data modelers and developers
Working in an Agile environment
Excellent core data modeling experience and skills, including dimensional modeling and OLTP database design
Excellent Information Architecture knowledge and experience, including business vocabularies, meta data management and reference data strategies for a large enterprise
Deep understanding of Information Architecture principles pertaining to real-time, asynchronous message-driven architectures
Good experience with both OLTP, Data Mart and asynchronous messaging applications
Deep familiarity with at least one recognized modeling tool (e.g., MagicDraw or ERWin)
Good proficiency with SQL, and its appropriate use in 3-tier architectures and Business Intelligence settings
Good understanding of modern relational data base capabilities (e.g., Oracle or SQL Server)
General knowledge of the wholesale Finance Industry
Business knowledge of cash management in a money center bank
Physical data modeling expertise
Implementing OLTP databases and Data Marts with Oracle RAC and Exadata
MQ Series asynchronous messaging design patterns
Industry message standards: FPML, SWIFT, etc

Data Modeler Resume Examples & Samples

At least 5 – 8 years software development experience required in Data Warehouse environment
At least 5 – 8 years of experience with ER and Dimensional Data modeling, Erwin
At least 3 - 5 years of Teradata or any MPP environment is a preference
At least 3 – 5 years in Financial domain is a preference
Excellent Knowledge of Conceptual, Logical and Physical modeling in Data warehouse environment that supports large scale DW implementations based on industry data modeling
Experience in creating large Dimensional modeling leveraging confirmed dimensions and facts for large data warehouse implementations
Experience on BDW – Banking data model from IBM a plus
Experience in physical implementation in a MPP platform like Teradata a plus
Experience in creating source to target mapping and experience in providing data model overview to stakeholders
Experience with data model training a plus
High level of personal commitment to each task, a can do attitude and a drive to deliver
Strong communication skills to be able to communicate at all levels (business and IT)
Ability to gather and understand requirements
The candidate should have a proactive approach to problem solving
Good analysis skills in order to aid in trouble shooting and problem solving
Bachelor's degree in Engineering, Computer Science, or Information Technology. Master's degree in Finance, Computer Science, or Information Technology a plus
Minimum of 5 to 8 years of work experience in creating data models (Conceptual, Logical and Physical data model) using Erwin or similar data modeling tool
5 - 8 years experience in mid to large scale Data warehouse
Knowledge of various data modeling concepts and methodologies
Understands what is the SDLC lifecycle and the significance of each of the phases of Waterfall model
Knows about the processes to be followed in the project, Follows the defined processes in the projects
Experience with CVS, SUBVERSION similar source code versioning tools
Solid design, coding, testing and debugging skills
Excellent interpersonal relationship and communication / presentation skills; build relationship with business and participate in “sit-with” session to gain Business Knowledge
Troubleshoot systems production/performance issues under tight deadlines
Requirements management and Research and evaluate alternative solutions and make recommendations
Establish auditing procedures to ensure data integrity
Responsible for on-time delivery of high-quality code
Support QA phase by tracking and assigning defects to development team; work with QA leads to schedule fixes and builds and enable QA to be successful
Participate in the definition of Operational Data Stores and data marts that perform well and meet the client expectations. Works with other team members, including DBA's, ETL developers, Technical Architects, QA and Business Analysts

Data Modeler Resume Examples & Samples

Review source systems and business publications to document data requirements and integrate them into the logical data model
Develop and design new consolidated logical and physical data models and assist in developing a transition plan from existing data models (where applicable)
Document existing data flows by inspection of DTS and SSIS packages and document data and scheduling interdependencies
Participate in the redesign of data flows, adapting existing processes to the new consolidated data models
Develop/redesign SSIS packages, stored procedures, functions, triggers, and SQL Server jobs with emphasis on modularity, performance, and dependability
Assist in standardizing data management procedures
Work with a team of database developers to produce high quality designs and implementations

Data Modeler Resume Examples & Samples

Strong data management skills
Strong Data Modeling
Should have managed/participated in complete project life cycle
CFA

Data Modeler Enterprise Kyc Technology Resume Examples & Samples

Own the enterprise-level Data Architecture for KYC data serving as the authoritative reference for implementation of KYC applications and common services (conceptual & logical models; metadata management
Develop organization and versioning scheme across compliance requirements, logical data model, KYC system implementations and client records
Work with compliance to simplify and streamline the management of KYC requirements
Work with LOB Technology areas and CIS to develop standard mappings to CIS data model
Work with senior architecture and business analysis resources across LOBs and ES to define strategy, standards and business processes for shared KYC data
Work on current to target state roadmap
Develop a governance process for KYC data
Support global KYC projects (e.g., risk scoring, periodic reviews, holistic view, global due diligence, etc.)
Participate and/or lead cross-LOB Design Council sessions
Provide data architecture oversight
Excellent knowledge of Client Reference Data and its use/impact in the enterprise
KYC experience at equivalent large bank/broker dealers
Knowledge of Master Data Management
Ability to identify patterns, concepts, abstractions
Hands-on experience with data modeling tools (object-oriented and relational)
Experience in large, complex, cross lob technology initiatives
Detail oriented and strategic thinker
Ability to collaborate and build strong partnerships across business, technology and operations as well as across regions and lines of business
BS/MS in Computer Science or equivalent
10 to 15 years minimum in technology preferably with a financial services firm

Senior Data Modeler Resume Examples & Samples

Experience in implementing data model governance process
Understanding of data governance functions
Exposure to Data Maturity Model
Solid understanding of products/services in Financial Services industry
Proven expertise in data modeling and data mining
Knowledge of Software development life-cycle
Excellent understanding of data representation and modeling including XML and related technologies
Logical data modeling experience is desired

Senior Data Modeler Resume Examples & Samples

Provide guidance and leadership to perform analysis and provide solutions
Rethink and influence strategy and roadmap for building scalable data solutions and scalable data warehouse environment
Create and maintain data architecture, data management conventions and standards, naming and metadata standards
Develop and maintain conceptual, physical and logical data models
Lead data optimization and clean-up projects
Lead capacity planning exercises and help project teams to estimate the cost
Lead Semantic layer Data Model development to support BI tools (Tableau, MicroStrategy, SAS)
Act as the in-house Subject Matter Expert (SME) on issues of data architecture
Provide technical leadership related to data modeling, data management, integration and warehousing, storage and business intelligence
Develops and approves strategies for continuous improvement in data management
B.S. or MS degree in Computer Science, business or related discipline, or equivalent experience
Over 5 years of experience in Business Intelligence and Data Warehouse design, conceptual, logical and physical data modeling
Over 5 years of experience as an Enterprise level Data Architect with a large organization dealing with large set of data
Over 5 years of experience physical tuning of databases I.E Indexes, partitions, Compressions etc on a MPP architecture based RDBMS
Solid understanding of both Inmon and Kimball models and approaches to data warehouse
Expertise and knowledge in data management, business intelligence, master data management, and data services architectural frameworks
Good understanding of OLAP tools such as Microstrategy, SAS, and Tableau and experience with multi-dimensional modeling
Solid experience with Data Modeling tools such as ERWIN 9, Power Designer, and Data Model Driven approach

Data Modeler Resume Examples & Samples

Development of medium to difficult SAS software modules to meet customer specifications 35%
Process customer input files; parsing and re-formatting to match vendor / product requirements 25%
Process vendor / product return files; parsing and re-formatting to meet customer specifications 20%
Generate statistical reports for QC and administrative reporting / billing purposes 10%
Participate in team meetings to discuss best practices / processes and administrative processes 5%
Participate in technical/professional training 5%
Experience in C, C++, SAS, SQL required
Individual must possess excellent written and oral communication skills
The individual must present a professional image and work well with all levels within the organization
Excellent analytical skills are essential

Data Modeler / Developer Resume Examples & Samples

Design and build asset class data model to support regulatory reporting function of a bank
Establish data modeling naming standards, abbreviations, guidelines and best practices
Drive the data model review process and solicit users’ feedback
Counsel with Subject Matter Experts on specifics topics in order to accurately capture existing business rules/principles
Analyze legacy applications, including both data content and a structure and review source code to derive necessary information
Propose new database architecture, support data migration from an existing Legacy system to a new structure
Educate internal and external team members on data modeling techniques, database design methodologies
Develop innovative DB solutions based on business requirements and technical challenges
Ensure to complete and deliver all assigned tasks on time with quality
Need to multitask working simultaneously on more than 1 task at any given time
Ensure timely and accurate communication with project staff throughout the life cycle of the project
Research and apply new technologies and best practices for development and deployment process improvements
6–8 years of industry experience with at least 2 years of investment banking
Familiar with regulatory reporting processes with strong understanding of trading, accounting, back office operations and MIS
Experience in designing enterprise scale conceptual, logical and physical data model
Passion for data exploration and data discovery is critical for this role
Familiarity with ER data modeling techniques, as well as star schema; understanding of OLAP vs. OLTP database design principals
Experience in database performance tuning, optimization and maintenance
Adept at writing efficient Structured Query Language (SQL) using various SQL-development software packages including Oracle PL/SQL
Strong knowledge on build (Ant/Maven), continuous integration (Jenkins), code quality analysis (SonarQube) and unit and integration testing (JUnit)
Experience of working on end to end data warehouse projects will be considered added advantage
Ability to work with a sense of urgency and attention to detail; meets deadlines
Strong work ethic; does whatever it takes to get the job done
Demonstrates the ability to handle a multitude of tasks and issues in a fast-paced, rapidly changing environment

Data Modeler Resume Examples & Samples

Candidates must demonstrate knowledge and understanding of advanced database concepts including data modeling, SQL programming skills, data access & data warehouse and operational data stores
Ability to obtain a Public Trust Clearance
Experience with Git or Subversion version control
Experience with Agile SCRUM

Risk Data Modeler Resume Examples & Samples

Define and analyze data requirements needed to support business processes
Lead the development of a risk model tool for target operating model
Understand and translate business needs into data model supporting CTPO End State
Create logical data models using best practices to ensure high data quality
Develop key Risk Metrics and reporting in support of the new model
Assist in enhancing data standards and procedures
Drive completion of a comprehensive Data Dictionary in support of the model
Maintain data integrity by working to eliminate redundancy
Understanding the critical business functions third parties support
Engagement of all stakeholders, both internally and externally
Providing transparency to senior management on data logistics, issues and results
Partner with other workstreams within the CTPO team, with TPMOs and with other corporate stakeholders as needed on critical items as they occur
Ability to work in pressure environment and meet tight deadlines
Expert in use and development of Data Modeling tools
Thorough understanding of Risk and Controls Analytics & Metrics
Knowledge of basic risk frameworks including RCSA processes
3-5 years Business Requirements gathering experience
Familiar with Best practices related to Data Modeling
Excellent Excel and MS Office Skills
Familiarity with other reporting tools such as Cognos and Qlikview
Strong, proactive task-based approach with focus on delivery

Senior Data Modeler Resume Examples & Samples

Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques including Inmon or Kimball
Profile source data and meet regularly with IT partners to develop complete source to target data mappings
Generate DDL from model for RDBMS (Oracle, Teradata)
Investigation data quality issues to determine root causes, resolve any data issues and recommended process change to prevent reoccurrence
Performance tuning of SQL
4-5 years working experience with in a data modeling role
4-5 years working experience with Oracle and Teradata
4-5 years working experience with ERwin Enterprise Data Modeler Suite or comparable data modeling tool experience
Strong understanding of relational databases, querying and building
4-5 years working experience with enterprise data warehouse projects

Data Modeler, Asset Management Resume Examples & Samples

Understand the data requirements including the relevant business transformation rules used to standardize and normalize the data for consistency
Identify the authoritative sources for the data, and conduct data analysis for the universe of Enterprise-wide data that is in-scope
Work with business stakeholders, business analysts, data analysts, systems analysts to translate data requirements into data model design
Develop and design the conceptual and logical data model for complete asset management inventories
Conduct and participate in data model review to validate the data requirements
Ensure data models are designed for flexibility to support future business needs and enhancements
Assist in data profiling and technical analysis as appropriate to validate business transformation rules and development of technical specs
Contribute to development of standards for maintaining the data models
Contribute to the creation of presentation materials relating to data modeling for stakeholder discussions
Support application testing and production implementation as required
Support integration of models and ensure definitions are consistent across the enterprise for share-ability and reusability
Solid understanding of relational data model design, dimensional modeling & data warehousing methodologies
Proven experience in delivering quality data models that have enterprise-wide data coverage in a large transformational program
Experience in usage of metadata and data profiling tools
Proven experience in standard database technology (SQL Server, Oracle, etc.)
Knowledge of big data technology a plus
Experience with an IT asset management tool or CMDB is a plus
Solid critical thinking and analytical skills with the ability to proactively follow up on identified issues and gain resolution.Highly flexible and able to quickly adapt to changing priorities and manage multiple priorities concurrently

Senior Data Modeler Resume Examples & Samples

Develop application technology roadmaps
Guide strategic technology discussions and decisions
Lead efforts to improve process and procedures around software development
Provide technical leadership and guidance to the technology staff
Maintain documentation standards and versioning control
Adherence to security and compliance standards
Contribute to project estimation
Post-deployment support
6 + years industry experience (Mortgage)
Experience with creating and maintaining data definitions, data models (dimensional/snowflake), query optimization and OLAP tools is required as well as familiarity with metadata management, business semantics, and metadata workflow management
Ability to pick up new technologies, solve complex technical problems and multitask between different projects
Must be able to work independently as well as in a team environment
Demonstrated ability to work effectively in a fast-paced, deadline-driving environment
BS or equivalent degree in Computer Science or equivalent field

Data Modeler Resume Examples & Samples

Self-motivated and proactive in leading technology efforts
Develop a thorough understanding of business specifications and produce design and code artifacts that meet the specifications
Manage individual contribution or, potentially, group effort to tight deadlines
Proven Technical Leadership experience
3 + years industry experience (Mortgage)
Hands-on experience on building logical and physical models
3+ years’ experience providing technical leadership over large software development initiatives in blended
Very good command over SQL and workings of relational databases such as Oracle
Solid Architectural and Software life cycle experience for enterprise software
Experience managing onshore/offshore applications development services is a plus
Strong problem solving and analytical capabilities
Must be able to adapt to a rapidly changing environment

Data Modeler Resume Examples & Samples

Understanding of the methodologies that depict the flow of data within and between technology and business functions/operations
Ability to apply strategic data management, transformation, and warehousing principles and techniques
Skilled in data modeling concepts, techniques, and modeling languages
Ability to determine deliverables and approaches to deliver data models at the Enterprise or project level
Ability to design and develop logical and physical data models to meet needs of the organization’s information systems
Ability to maintain data integrity by working to eliminate redundancy
Ability to coordinate data models, dictionaries, and other database documentation across multiple applications
Ability to effectively present and communicate data definitions and relationships using business terms
Experience assessing legacy system data and incorporating into an enterprise view
Experience with defining, implementing, and analyzing metrics and measurement programs
Excellent verbal, interpersonal and written communication skills
Problem solving skills with ability to analyze situations, identify existing or potential problems and recommend solutions
6+ years related experience, including development of data centric applications, OLAP, predictive modeling, business intelligence and data warehouses
Ability to obtain a sensitive security clearance from the Postal Inspection Service

Senior Data Modeler Resume Examples & Samples

Reduce costs and enhance agility through IT portfolio complexity reduction
Mitigate business risk through architecture documentation, standardization and project governance
Support increased business flexibility by promoting pan-enterprise interoperability; and
Increase the speed of business capability enablement through IT-business alignment, technology innovation, and solution design
Solid understanding of transaction and information systems, data warehouses, data marts, ODS, MDM methodologies and life cycles as well as ETL and MDM technologies
Strong working knowledge of ERwin Data Modeler
Familiarity with performance tuning techniques in Teradata, Oracle, SQLServer, and DB2 environments such as partitioning, conditional RI, Bitmap indexes, Mviews, CUBEs, Dimension and fact definitions as well other de-normalization techniques
Knowledge of and experience with leading data management platforms and market data providers
Experience with ETL tools; especially IBM InfoSphere Information Server version 8.1 and higher
High energy and drive. Laser-focused on delivery with strategic-thinking, collaboration, facilitation, negotiation and motivational skills
Able to serve as evangelist of the architectural vision, strategy, and principles
3 to 5 years of experience working with financial services preferably with annuity, insurance, fixed income or mutual funds products
Working knowledge of IBM's Banking and Financial Data Warehouse Industry Models, IBM's Insurance Information Warehouse Models
Excellent planning and execution skills with a proven ability to establish and meet impactful goals and objectives with regard to data integration
Strong skills in normalization and 3NF structures supporting enterprise warehouses and a solid understanding of dimensional modeling
Thought leader who is innovative, entrepreneurial, well respected and actively sought out. Is considered an authority by peers
Courage to push difficult or unpopular perspectives
Self-starter who solves complex technology and operational problems/issues with little to no guidance from senior management. Seeks senior management advice and guidance as needed for critical decisions with broad business exposure and high risk

Senior Data Modeler Resume Examples & Samples

Translate Business Requirements to Conceptual and Logical Data Models (ERDs – Entity relationship Diagrams)
Create Physical Data Models (ERDs), of different types, from Logical Data Models
Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of project requirements, and/or from a Logical Data Model
Mapping of Logical to Physical Data Models and vice versa
Create DDL from Physical Data Models
Work closely with Database Engineering to move DDL to Test and Production environments
Evaluate other Modeler’s logical and/or physical data models for (a) adherence to LDM modeling principles, such as 3NF (b) adherence to CST Standards and Guidelines and (c) a match between business requirements and model content
Participate in model design reviews and testing
Explain/ teach classical Conceptual, Logical and Physical Data Modeling
Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs
Identifying, recommending and implementing emerging Modeling and IT trends, developments, tools and improvements/solutions

Lead Data Modeler Analyst Resume Examples & Samples

Database design and modeling
Maintains strong data governance discipline
Highly effective at facilitating data requirements sessions for complex applications
Leads data requirements, and data modeling sessions
Data quality and integrity analysis
Creates Target State Data Models that accommodate strategies across JPMC. Responsible for coaching and mentoring less experienced team members
5-7 years of experience in developing conceptual, logical and physical database design for OLTP and OLAP systems
3 years of data modeling using Erwin and DB2 required
Solid experience in relational modeling, dimensional modeling, conceptual, logical modeling, physical modeling, star schema, snowflakes schema, ER diagrams, granularity, cardinality and database reengineering
Strong experience on data analysis, business analysis, user requirement gathering, user requirement analysis, gap analysis, gathering metadata data cleansing, data transformations, data relationships, source systems analysis and reporting analysis
Strong Analytical skills and the ability to work through ambiguity to define structure and order

IT Data Specialist / Senior Data Modeler Resume Examples & Samples

The candidate will have the requisite data modelling skills and experience necessary to provide the high quality deliverables
The candidate will develop the Enterprise Logical Data Model (LDM) from a Corporate Conceptual Model (CDM)
The candidate will facilitate Joint Application Design (JAD)sessions with key stakeholders to determine data requirements and translate these requirement into Logical Data Model (LDM) and Physical Data Models (PDM)
The candidate will manage models in and out of the centralized model repository, and documents data model translation decisions
Additionally, the candidate will have the interpersonal skills necessary to interact with data architects, business analysts, data integration specialists, DBAs, project managers, and other IT professionals in order to fulfill a critical part of the TDI IM team
10 yrs + in the Data Warehousing, Business intelligence domain
Proven capabilities in the creation of conceptual, logical, and physical data models as they relate to data warehousing and business intelligence domains
Knowledgeable in both normalized and denormalized data model design and implementation
Able to demonstrate experience using data modeling tools such as Power Designer (preferable), Erwin, or equivalent
Solid experience with Financial Industry Standard Data Models, such as Teradata FS-LDM or equivalent
Good knowledge of the Insurance domain
Ability to create and support a positive work environment that promotes service to the business, quality, innovation and teamwork
Strong leadership skills with the ability to build strong relationships with business partners , vendors and TS teams
Excellent written, verbal and presentation skills in both English and French with ability to communicate clearly within all levels of the organization, as well as with external partners
Tools & Technologies: Power Designer, IBM InfoSphere suite and metadata repository, Hadoop, Oracle, DB2, SQL, SQL Server, SAS, Cognos , Apache Hbase, Apache Hive

Senior Data Modeler Resume Examples & Samples

Work closely with analysts and business users to refine and understand requirements and limitations of source data
Design of message model that meets immediate needs but also provides flexibility for future use in target systems and the wider community
Design of Operational Data Store and Data Life Cycle therein to persist data from the messaging layer
Ensure data standards and best practices are applied
Hands on data design using Embarcadero ER Studio
Minimum five years’ experience of Investment industry data modeling. Other industry modeling experience may be considered
Expert level knowledge of normalisation and data modeling techniques
Advanced understanding of data types used in the fund management industry
Advanced knowledge of Embarcadero ER Studio
Knowledge of messaging technologies and modelling data for such
Knowledge of design and constructs of XML
Experience of SQL Server and Oracle databases
Ability to conduct complex analysis and present data in a meaningful way
Strong organizational skills and detail orientation
Has proven analytical and problem-solving traits
Open minded, flexible, and willing to listen for other people’s opinions
Interpersonal skills necessary to effectively communicate over the phone with a variety of individuals at all technical levels are required

Senior Big Data Modeler Resume Examples & Samples

Design, develop and maintain conceptual, logical and physical data models for Big Data
Bachelor’s in Information Systems or an equivalent experience
5 years experience on developing logical and physical data models; preferably 2 years within a

Enterprise Solutions Data Modeler Resume Examples & Samples

Design, model and implement conceptual model that extends our current tag-based model into a, broadly speaking, semantic model of Bloomberg Data
Coordinate conceptual data models, dictionaries, and other database documentation across multiple applications and across multiple internal customer bases and interests
Act as a liaison between Business, R&D, and Global Data departments
Provide expert guidance and support to global business
Solid understanding of conceptual, logical and Physical data models
Experience of data modeling in UML or Entity-Relationship models
Knowledge of XML schemas and concepts such as XSD, super/sub type, domains, ranges
Working knowledge of at least one semantic modeling language (OWL, RDF, etc.)
Strong project management, analytical and organizational skills
Strong negotiation and communication skills
Demonstrated ability to research problems and develop solutions
Ability to multi-task and work independently, as well as within a team environment
No minimum education. Relevant Bachelor's degree, Master's or Ph.D preferred

Associate Data Modeler Resume Examples & Samples

Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques
Interact with application development, enterprise architecture, technology services, and vendors on a regular basis
Design, document and develop data warehouse implementations
Develop and enforcement data modeling standards
Remain current on database technology trends and upcoming database releases. Provide guidance on database technology direction
Proactively investigate database query log data to find opportunities to improve performance in OLAP and OLTP queries executing against the database
Up to 2 years working experience with in a data warehouse analyst role or implementing data warehouses with relevant experience
Strong Level SQL knowledge
Basic understanding of various data modeling techniques
ERwin or comparable data modeling tool
4 Year BA/BS in Computer Science, MIS or Business Administration

Senior Data Modeler Resume Examples & Samples

10+ years of experience with Data Strategy and Modeling
Experience with data design and strategy for enterprise level technology systems
Awareness of other modeling techniques, UML experience is a plus
Familiarity with reference data at the global and local level is required

Data Modeler Resume Examples & Samples

Oversee, govern and guide data related activity on your projects
Propose and promote best practices in the area of data architecture
Proactively identify and promote improvements and optimizations in the data architecture area
Execute reviews of technical documentation and code reviews, from the point of view of respecting the principles and rules of data architecture
Create Logical Data Models for domain applications
Define and Manage data flows within applications
Define mappings between data feeds and Logical Data Models
Multi-cultural experience, including participation in remote teams in different geographical locations
More than 2 years of experience in designing and working with large scale data models
Knowledge in data architecture
Expert in DB technology; Oracle is a must
DWH experience
Experience in using meta-data tools
Data modelling, data modelling tools (e.g. PowerDesigner)
PL/SQL & stored procedures
Data integrity tools

Data Modeler Resume Examples & Samples

Interact with Data Warehouse team to design, create and verify data models
Ensuring the completeness and comprehensiveness of data structure by integrating the sources for newly identified data points
Ensuring the accuracy of the data points through automated and manual checks
Design, develop, and test SQL scripts to import, modify and enhance data to meet customer requirements
Participate in business requirements and work directly with business units to define and prototype applications/visualization tools
Demonstrating applications/visualization tools to internal users
Communicating with stakeholders to gather requirements for new ideas and report updates
Investigating problems to establish real or hidden causes and solves complex problems with creative solutions
3+ Years of experience with at least one of the following
BI Concepts and Reporting
Data Analysis and SQL
2+ Years of experience in investments related work
MBA, CFA, and/or CAIA
Qlikview / Data Analysis and SQL
Scrum Methodology / JIRA
Web/App Design
Excellent problem solving skills, logical process thinking
Detail oriented with strong organizational and analytical skills

Data Modeler Resume Examples & Samples

To develop data models in support of integrated business reporting and data exchange
To implement data models on our data warehouse
To perform data profiling on source system data to ensure that source system data can be integrated and represented properly in our models
To assist ETL and report developers with best usage of the models
To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues
Bachelors degree in Computer Science, Software Engineering, Information Technology, or related field required
At least 7+ years of experience in data development and solutions
At least 7+ years for SQL experience with the ability to write ad-hoc and complex queries to perform data analysis
Ability to create E-R data models (conceptual, logical and physical)
Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal BI-Temporal models, etc.)
Relevant and substantial work experience with business requirements definition and management (end to end), structured analysis, process design, use case documentation, UML process and use case definition
Understanding of IBM DB2, Informatica, and DB2 stored procedures a plus
Strong understanding of the Financial Services industry and content lifecycle relating to Risk, Regulatory, Audit and Compliance needs
Strong problem solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements and priorities
Overall technical understanding of data warehousing, business intelligence, web and other multi-tiered, distributed applications/systems

Lead Data Modeler Resume Examples & Samples

Performs data analyzes and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using ERWIN and MB MDR
Proficient in multiple business disciplines, functions, and knowledgeable about the business' strategic direction
10 years of experience in developing conceptual, logical and physical database design for OLTP and OLAP systems
Extensive experience in enterprise data warehouse and operational data store architectures
Experienced in data transformation, data mapping from source to target database schemas, data cleansing procedures
Experienced in master data management (MDM) projects and solutions
Strong Communication skills, both verbal and written, is required

Business Intelligence Data Modeler Resume Examples & Samples

Toronto – 100 Wynford Dr, Toronto, ON M3C 4B4
Mississauga – 5099 Creekbank Rd, Mississauga, ON L4W 5N2
Analyze and follow existing data management conventions and standards, naming and metadata standards
Gather reporting requirements through meetings with business users and IT resources
Consult with BI resources, architects, and business analysts
Develop and maintain conceptual, logical, and physical data models
Prepare technical documents for data mappings, data dictionaries, data lineage etc
Implement physical models and responsible for fine tuning and performance tuning
B.Sc. or M.Sc. degree in Computer Science, business or related discipline, or equivalent experience
Over 3 years of experience in Business Intelligence and Data Warehouse design, conceptual, logical and physical data modeling
Advanced proficiency in dimensional modeling and semantic data modeling concepts
Solid Teradata RDBMS and ETL experience with some major ETL Tool
Solid understanding of generic and conventional modeling approaches
A Passion for technologies and data architecture and the ability to effect change
Presentation and Project Management skills

Senior Data Analyst & Data Modeler Resume Examples & Samples

Enforcing Data architecture standards
Defining data dictionary, metadata management and database design
Database and SQL performance tuning
Demonstrable experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, maintaining PHYSICAL data models
Demonstrable experience using data modeling tools - e.g., ErWin
Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc
10+ years any RDBMS experience
Experience with techniques for addressing performance issues and ability to Tune SQL Queries
Expert skills and understanding of advanced data warehouse architectural principles

Data Modeler Analyst Resume Examples & Samples

Participate in the analysis and design of system solutions to meet business and technology needs
Develop logical and physical data models using ERwin
Design & document ETL specifications and meta-data repository
Optimize the utilization of data assets by governing investments via the Enterprise logical data model
3-5 years of Database Management/Administration experience
1-3 years demonstrated proficiency using Data Modeling tools such as: Erwin
Working experience in ANSI standard SQL is a must
Experience in developing operational environments
Experience with change management procedures and SDLC is a must
Experience with deployment of database changes
Demonstrated ability to investigate and learn new technologies and products is preferred
Solid interpersonal, negotiating, and marketing skills to work with users, senior management, and external personnel on significant matters, often requiring coordinated activity across organizational lines

Enterprise Data Modeler Resume Examples & Samples

Design and development of ontology data models (RDF) for dynamic and real-time data ingestion and distribution between various systems
Work with business and IT development teams to design solutions that are consistent within the larger Enterprise architecture
Review design of new projects and data model enhancements to ensure they are compliant with architecture standards, meets the platform capacity and performance needs, and maximize solution re-use
Act as cross-functional subject matter expert and data model evangelist for multiple teams within the organization
Mentor and train junior level resources by assisting to develop their skills and transfer knowledge
5+ years working experience with relational data modeling, including but not limited to toolsets like Erwin, Embarcadero etc
Familiarity with NoSQL concepts and the ability to think outside the relational model is a must
Ability to query, analyze and understand the meaning and content of financial business data in relational databases
Proficiency in semantic web technologies (RDF/OWL/SPARQL) is a huge plus

Business Intelligence Data Modeler Resume Examples & Samples

4+ years of experience in ETL, Business Intelligence, analytics or reporting/data visualization platforms
4+ years of experience in multidimensional data modeling, such as star schemas, snowflakes, denormalized models, handling “slow-changing” dimensions/attributes
4+ years of experience with SQL coding across standard commercial databases

Data Modeler Resume Examples & Samples

BS Degree in a related field
5+ years of experience in data warehousing and data modeling
Must be able to obtain a Public Trust clearance
Able to commute to Falls Church, VA daily

M HIS Solutions Data Modeler Resume Examples & Samples

Design and support of data models using Embarcadero ER Studio
Conduct data profiling and data mapping
Maintain data warehouse architecture and metadata standards
Collaborate with Enterprise Architects (BI, Data, and Technical) on best practices, standards, and strategic planning
Work closely with Business Analysts and Subject Matter Experts to identify key business drivers for the data warehouse using a broad base of skills including facilitation of requirements gathering and mapping data to the logical and physical data models
Perform data analysis and review with the business stakeholders to refine requirements that will be mapped for ETL developers
Maintain an enterprise metadata repository (data dictionary, data mappings, data lineage)
Minimum of one (1)+ years of experience in design, development, modification and testing of multi-terabyte databases designed to support Data Warehousing and BI analytics using dimensional/star-schema based data structures
Minimum of three (3)+ years of experience in writing complex SQL queries for multi-terabyte data warehouses
Minimum of two (2)+ years of experience performing requirements analysis including data flow diagrams, source to target data mappings, and definitions in a Business Intelligence/Data Warehouse environment
One (1)+ years of experience using database modeling tools (ER Studio, Erwin, Power Designer etc.)
Two (2)+ years of experience working in the Healthcare industry
Work as a member of an agile development organization
One (1)+ years of experience utilizing Data Vault 2.0 modeling
One (1)+ years of experience designing multi-terabyte data warehouse databases using RDBMS technologies, such as Microsoft SQL Server, Oracle, or DB2
One (1)+ years of experience modeling operational data stores (ODS)
One (1)+ years modeling for OLAP technology
One (1)+ years of experience with modeling for MicroStrategy or other business Intelligence tools such as Business Objects or Cognos
Experience working in a SaaS BI and Data Warehousing environment
Knowledge of medical claims data including claim, member, provider, clinical, etc
Experience modeling for unstructured data
Experience working with ETL developers, BI architects, and report developers to communicate database designs
Creating design documentation for relational and dimensional data structures
Experience consolidating data from disparate systems is preferred
BI data architecture knowledge in designing, developing, and implementing data warehouse and business intelligence solutions with Microsoft SQL Server and MicroStrategy
Strong problem solving skills to breakdown complex relationships
Must be self-motivated and able to work with minimal supervision

Enterprise Data Modeler Resume Examples & Samples

Develop the LDM, utilizing ERWin and adhere to the data governance standards (i.e. naming conventions)
Work closely with the data governance working groups to determine data rules and holds LDM review sessions with both the governance and data quality teams and any subject matter experts (SME's) from the business as appropriate
Responsible, in conjunction with the Data Governance Domain Lead Manager (with assistance from the data governance working groups), to develop the ontology used to map the organizations global data to the common model in order to enable global reporting
Works closely with the data quality team in understanding data profiling results and mapping physical data layouts to the common model and ensuring that the physical representation of data matches/corresponds to the stated data definition in the LDM
Work closely with other data modelers in Kimberly-Clark, along with the ETL developers, data warehouse architects and any other associates that will use or interface with the common model, especially those associated with the Enterprise Data Warehouse and Data Marts
Data Analysis: The investigation, evaluation, interpretation and classification of data, in order to define and clarify information structures which describe the relationships between real world entities. Such structures facilitate the development of software systems, links between systems or retrieval activities
Data Management: The management of practices and processes to ensure the security, integrity, safety and availability of all forms of data and data structures that make up the organization's information. The management of data and information in all its forms and the analysis of information structure (including logical analysis of taxonomies, data and metadata). The development of innovative ways of managing the information assets of the organization
Information management: The overall governance of how all types of information, structured and unstructured, whether produced internally or externally, are used to support decision-making, business processes and digital services. Encompasses development and promotion of the strategy and policies covering the design of information structures and taxonomies, the setting of policies for the sourcing and maintenance of the data content, and the development of policies, procedures, working practices and training to promote compliance with legislation regulating all aspects of holding, use and disclosure of data
Information security: The selection, design, justification, implementation and operation of controls and management strategies to maintain the security, confidentiality, integrity, availability, accountability and relevant compliance of information systems with legislation, regulation and relevant standards
Information systems coordination: Typically, within a large organization in which the information strategy function is devolved to autonomous units, or within a collaborative enterprise of otherwise independent organizations, the coordination of information strategy matters where the adoption of a common approach (such as shared services) would benefit the organization
3+ year's experience in logical data modeling preferably developing a common data model
Master level experience with ERWin
Experience with CPG Industry logical data model
Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels
Proven experience in navigating complex organizations, creative problem solving, and rational experimentation
Experience and knowledge developing strategic planning, leadership, and organization delivery for "Mater Data Management" across a Global Enterprise
Ability to work in a virtual team which may work across distance (remote), cultures and time zones, in a matrix with multiple reporting lines, and may extend outside the K-C organization including suppliers, partners and customers
Verbal and written fluency in English is mandatory

Data Modeler Resume Examples & Samples

Develop design document for data mapping and data transformation processes
Identify and enforce data standards to ensure consistent and maintainable structures in the data warehouse
Analyze data in source systems to assess data quality
Data Modeling: Level I: 0-2 years experience as a modeler: Level II: 2-5 years experience; Level III: 5+ years experience
3-5 years experience with SQL in Health Care IT
Documenting and analyzing workflow and clinical processes
Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models
Experience in developing, publishing, and maintaining all documentation for data models
Ability to manage and prioritize complex requests and maintain progress towards project goals
Individual contributor that works under limited supervision
Ability to effectively lead a project team

Data Modeler Resume Examples & Samples

3 years' experience
Working with SQL
Working with large database management systems (Teradata, DB2, MSSQL, or Oracle)
2 years' experience
Using data modeling tools (ERWIN or ER Studio)
Working with ERP data (JD Edwards or SAP)
1 year experience
Conducting performance tuning and query optimization through Teradata BTEQ
Working with SAP AFS retail industry solutions
Developing complex performance tuning reports in COGNOS, or similar report tool such as Tableau or Qlik View; and
Deploying and supporting large, complex data warehouse/business intelligence solutions

Data Modeler Manager Resume Examples & Samples

A Data Modeler Is viewed as an expert in IT systems architecture
Undertakes complex projects requiring additional specialized technical knowledge
Makes well-thought-out decisions on complex or ambiguous IT architecture issues
Coordinates with users to determine requirements
Ensures that system improvements are successfully implemented and monitored to increase efficiency
Establishes and communicates common goal and direction for team
Acts as a resource for direction, training and guidance for less experienced staff
Monitors project schedules and costs
Typically requires six to eight years of experience
Partnering with Enterprise Data Architects, Application Development and Operational Data Administration personnel to translate business needs into a data model that will be the basis for a solution that closely aligns with business requirements. Work to be performed includes
Create the logical data model and work closely with the Database Administrator with the translation of the logical model into a workable physical model using a recent version of an appropriate CASE tool
Generation and testing of ddl from CASE tool
Knowledge of database architecture, performance design methodologies, and ability to make and implement physical tuning recommendations
Generation of Data Dictionary from CASE tool
Experience developing logical and Physical data models
Knowledgeable and demonstrated experience in Data models for data warehouses and data marts
Data standards and metadata management
Data modeling methods and tools
Primary role as a Data Modeler/Database Architect for >5 years
Experience in Relational Data Modeling and/or Star Schema/Dimensional Data Modeling
Expert development skills in normalized and de-normalized data model development
Understanding
Experience with one or more DBMS, including Teradata, DB2, Oracle, SQL Server, and other database environments
Proficient in data warehouse / systems development methodologies
Strong development using multiple OLAP cube technologies
Understanding of Data Profiling and Quality tools (preferably IBM DataStage)
Expert modeling tool development experience in one or more CASE tools, including Erwin and PowerDesigner
Expert in data sourcing and data mapping skills
Strong teamwork and interpersonal skills and ability communicate with all management levels
Leads others toward technical accomplishment, collaborative project team efforts and achievement of important project goals
Strong written and oral communication skills, including technical writing
Strong analytical and conceptual skills
Agile methodology experience a plus
Positive, can-do attitude

Data Modeler Resume Examples & Samples

You have worked in IT for at least 3 years with experience as a Developer or you have a Computer Science or Programming Degree with supporting work experience
You have worked on the development of a data model that supports a broadly implemented technology stack
You have the ability to translate system requirements into a logical data model. Bonus points if you have a working knowledge of specific Business Intelligence Reporting Technologies
You love data specification creation, data modeling and database structure and have a track record of successful engagements
You love learning and champion change
You are fun to be around and WOW, can we count on you

Data Modeler Resume Examples & Samples

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. Evaluates completeness and accuracy of data models
Uses a variety of information gathering techniques (e.g., interviews) to gather complex business data requirements from internal business clients and development teams. Analyzes data requirements. Provide conceptual and technical modeling assistance to developers. Validates data models with IT team members and internal clients
Reviews data models with lead to assess the impact of the new model on the enterprise model. Identifies data sources and areas of overlap, and facilitates data sharing
Participates in Inspections, data analysis, and data discovery sessions. Attends operations engineering review (OER) meetings to address data modeling changes to reviewed databases and the enterprise database
Works with senior DBA staff to transform logical database models into physical database designs
Creates and writes documentation, including procedures. Administers document repositories
Collects and maintains meta data
Trains and mentors staff with less experience. Resolves complex issues elevated from staff with less experience
Thoroughly understands and complies with IT policies and procedures, especially those for quality and productivity standards that enable the team to meet established client service levels. Thoroughly understands and complies with Information Security policies and procedures
2-5 years data modeling experience, including experience with business requirements analysis, entity relationship design, and data normalization experience
Strong written and oral communication skills, including interviewing and group facilitation skills
Strong analysis and problem solving skills
Understanding of the financial services industry
Advanced knowledge of the following data modeling practices and concepts
Meta data
Technical standards and deliverables
Relational database implementations
Business requirements analysis
Entity relationship design
Data normalization
Work flows
Advanced knowledge of current versions of the following products
DB/2
ERwin
Lotus Notes
Microsoft Office Suite
Sybase
Advanced knowledge of current versions of the following products, preferred
Microsoft Access
Microsoft Project

Senior Logical Data Modeler / Analyst AIM Resume Examples & Samples

BA/BS degree in related discipline
Minimum of 3 years of experience in logical data modeling and data analysis
Or any combination of education and experience which would provide an equivalent background
Minimum of 5 years of overall information technologies experience preferred
Minimum of 5 to 10 years of logical data modeling and data analysis experience would be ideal
Strong Data Modeling and data analysis skills
Full life cycle experience in Data Management/Architecture
Demonstrated logical and physical modeling experience with large scale, multiple business solutions across divisions or enterprise
Understanding of the methodologies and technologies that depict the flow of data within and between application systems and business functions/operations
Understanding of fundamental concepts and architectural principles of Data Management
Good decision-making capabilities possessing both conceptual and analytical skills
Ability to interact with ETL Architects, Developers, DBDs and DBAs on how the model works and be able to make enhancements based on new and future requirements
Ability to communicate to business users and program sponsors the decisions made in the data model for optimal performance
Able to communicate effectively with all levels in a clear and professional manner, both verbally and written
Demonstrated experience to develop consensus across work teams
Ability to work in a fast-paced environment and comfortable working across multiple teams and business units
The ability to problem-solve, prioritize projects, and multitask
Possess competency in all phases of software development

Standards Data Modeler Resume Examples & Samples

Bachelor’s degree in engineering, or related technical field, or equivalent experience
6+ years of systems engineering, systems integration, or systems development experience
Proficiency in logical data modeling, including developing and/or using UML (Unified Modeling Language) Class Diagrams
Knowledge of Object-based / Oriented Modeling concepts
Experience developing logical data models
Demonstrated ability to work in a multi-contractor / government organization
Demonstrated ability to develop and present effective technical presentations to senior management; must possess strong written and verbal communications skills
2+ years of experience with data standards, data modeling, and metadata management
3-5 years of related experience with NGA or its IC partners
Experience with NSG Application Schema (NAS), NSG Metadata Implementation Specification (NMIS), and/or NSG Metadata Foundation (NMF) implementation / programming
Knowledge of ISO 19100 series standards related to metadata, geography, GML, application and implementation of schemas & schema registries, & OGC exchange
Experience with the policies and practices of the following Standards organizations: ISO, ISO/IEC, INCITS L1, Open Geospatial Consortium (including the North American Forum), NATO and Coalition partner organizations
Knowledge of the following Standards organizations and their policies and procedures: Open Geospatial Consortium, ISO, GWG
Experience with OCL (Object Constraint Language)
Experience using eXensible Markup Language (XML) encoding
Experience with Agile development methods

Data Mart Data Modeler Resume Examples & Samples

Uses relational analysis and dimensional analysis and produces logical and physical data models
Uses Star and Snowflake schemas to deliver data marts
Uses SQL Data Definition Language/SQL Queries with an Oracle RDBMS
Uses data modeling tools such as Erwin
Works individually and in a team, solution-oriented environment
Assists technical teams, developers, ETL, BI, and end users in understanding the data model
Minimum eight (8) years of data modeling experience required
Minimum seven (7) years SQL experience with data definition language and queries required
Minimum seven (7) years of experience with Oracle RDMS required
Minimum seven (7) years of experience working with data modeling tools such as Erwin required
Experience delivering data marts using Star and Snowflake schemas
Experience with data analysis (SQL), data profiling, and data mapping is preferred
Experience leading and coordinating tasks within an enterprise level program is preferred
Experience with managing metadata for the data model is preferred
Experience evaluating existing data models and physical databases for variances and discrepancies is preferred
Experience leveraging and enforcing standards for data naming conventions is preferred

Logical Data Modeler Resume Examples & Samples

Work closely with business and IT subject matter experts and map their requirements into Conceptual and Logical Data Models
Develop and update Logical Data Models to support complex, data-centric envisioning and application release decisions
Identify opportunities to unify disparate but common data concepts across multiple enterprise systems
Work with appropriate business and IT leads to incorporate data modeling and data quality best practices into IT solutions roadmaps

Data Modeler With Nosql Experience Resume Examples & Samples

Participates in coding, testing and debugging new software or significant enhancements to existing software
Analyzes complex technical and/or Level 2 system problems; designs and implements effective solutions
Works with technical staff and business to understand problems with software and develops specifications for improvements and enhancements
Responsible for developing, testing, implementing, troubleshooting and resolving issues related to system performance, ETL applications, and data integrity
Responsible for quality assurance review
Manage scheduling, support, tools and maintenance of integration processes
Interaction and collaboration with other team members, business users, software vendors
Work with business users on trouble tickets and provide remedial solution to the issues
Data Modeling concepts (Advanced Level)
Well versed with Data Modeling platforms like Erwin etc.,
Good knowledge about Database Designing / Administration
Over-All understanding of Database space (Databases, Data Warehouses, Reporting, Analytics)
Open to learn new technologies in-line with organizational needs / direction
NoSQL and MongoDB experience is must

Data Modeler Resume Examples & Samples

Leads requirements gathering sessions with subject area experts to identify and document data requirements, definitions, data dependencies and relevant business rules. Capture detailed data requirements both at the enterprise level and for specific initiatives
Perform development or maintenance work on data models,, data dictionaries, event models, CRUD matrix, or other artifacts to maintain currency with corporate standards, integration with enterprise data architecture and company goals
Conduct or perform data modeling exercises in support of subject areas and/or specific client needs for data, reports, or analyses, with a concern towards reuse of existing data elements, alignment with existing data assets and target enterprise data architecture. Ensure that all artifacts be developed according to SDLC standards and procedures
Confer with business units and technical staff to understand data usage, lineage and attributes
Contribute to initiatives development cycle, providing guidance for the structure, storage and forms in which data are stored, retrieved, and represented
Integrate models and ensure that definitions are consistent, vetted by business and re-useable across the enterprise
Review junior team members’ data models
6+ years of related experience
4+ years of progressive experience to support data warehouses, data mart implementations in Financial Services including data quality, architecture and meta-data management
Demonstrated experience in utilizing best practices and data management tools
Demonstrated ability working with multiple customers and solving complex data problems
Strong knowledge of Finance and Accounting concepts
5+ years of experience in business intelligence tools (Microstrategy, Business Objects, OBIEE, Hyperion Planning and Essbase)
4+ years Business Objects development experience
Must be proficient in SQL
Experience with software development life cycle (SDLC)
Experience with HP Quality Center and IBM Rational DOORS
Experience with Tableau and SpotFire a plus

Data Modeler Resume Examples & Samples

Good understanding of Secondary Mortgage Business and MISMO standards
Solid understanding of Data Management principles, specifically Data Modeling
Experience with large scale data processing scenarios (ODS, Data Warehouse)
Solid understanding of Business Intelligence and Analytics concepts
Solid understanding of Mortgage Backed Securities (MBS)
Good understanding of Fannie Mae Business Architecture (States & Events)
Good understanding of Fannie Mae Enterprise Conceptual Data Model
Knowledge of Data Modeling tools (ER/Studio, Erwin)

Data Modeler Resume Examples & Samples

Extensive experience in Data Modelling; including conceptual, logical and physical
5+ years with strong experience with modeling in a Data Warehousing and BI context (star schemas, BI modeling issues such as slowly changing dimensions, etc.)
Possesses strong hands-on modeling experience of time-series and temporal data and data patterns
5+ years’ experience using the ERWin tool
Expertise in developing SQL scripts to do ETL operations including large, complex SQL statements
Perform deep dive analyses into business requirements to define initiative objective & scope
Consult with the business partners to understand their requirements to proactively provide value added recommendations
Provide ad-hoc analyses/queries/reports from a wide variety of BI tools including MicroStrategy, Oracle data-mart tables, etc
Must be able to extract data from multiple data sources to synthesize information that is actionable and driven by facts
Ensure Data Management & team delivers high quality analytical support throughout the lifecycle of projects and other engagements
Confirm solutions deliver value to stakeholders and adjust as required by running JAD sessions during the requirements gathering and clarification phase
Ensure Solution & Design standards are aligned to organizational strategic objectives and departmental objectives by engaging the technical delivery team and architecture as required during the initiative lifecycle
Manage relationships with stakeholder groups with each interaction
Manage stakeholder expectation
Conduct review sessions with Solution Design and Development resources as required during the SDS & DDD phases
5+ years of experience conducting business analysis in the telecom/wireless industry to derive strong modeling in the Data Warehousing and BI context (star schemas, BI modeling issues such as slowly changing dimensions, etc.)
Extensive experience with business intelligence tools and concepts
Extensive experience consulting with business to translate business requirements into technical specifications, then into reports/dashboards for visualization
3+ years of experience in Oracle databases using complex SQL scripting
Experience with MicroStrategy, Tableau, Cognos or other BI tools
Quick learner with initiative and flexibility to deal with ambiguity
Proven analytical/business intelligence skills
Ability to work with large volume of data, translating business requirements into insightful information used to drive critical business decisions
Strong communication skills with experience working with stakeholders across the organization
Bias towards action oriented, flexible and adaptable
Oracle / SQL / Cognos / Microsoft SQL Server / SAS / MicroStrategy / Tableau
Undergraduate Degree in Business, Mathematics or equivalent experience with exceptional knowledge of business intelligence tools
Prior consulting experience considered an asset
Oracle / SQL / Cognos / Microsoft SQL Server / SAS

Data Modeler Resume Examples & Samples

Maintains and is accountable for the vision of all enterprise data models and multiple parallel product development initiatives
Maintains a strong understanding of the business or function for which the data or product is designed so that data definitions as well as supporting systems, or processes are aligned
Helps define key data standardization / harmonization initiatives that support business drivers and strategic direction
Establishes and maintains data governance, protecting the company’s primary asset (information) in collaboration with the Data Engineering & Management Teams
Drives the overall direction of HLI's information-based data standards and models
Develops and facilitates collaborative software design templates, ensuring that data definitions & interfaces are properly identified, designed/documented and maintained
Supports the Data Architect roles in building and maintaining the enterprise architectural platform that enables change-based growth Collaborates with the Data Services and external teams on business decisions and organization goals as part of the daily SCRUM activities and weekly Storytime / ARB meetings
Communicates and evangelizes technical decisions to non-technical stakeholders, other IT stakeholders and senior management Develops and maintains a customer-focused, agile, and accountable team view
Accountable for and manages adherence to enterprise data models and data design guidelines
Supports the delivery of technology solutions, documentation artifacts and programs
Remains abreast of data standards / technology developments and proactively aligns project goals with strategic business goals Communicates with staff or clients to understand specific product, functional, or non-functional requirements
Collaborates with engineers or software developers to select appropriate design solutions or ensure the compatibility of system components
Assists with the data design activities for end-to-end applications, and other system-related information for internal and external facing solutions
Provides mentoring as a cornerstone of career development for all key contacts and technology team members
Work collaboratively with the Software Engineering and Bio Science Teams to implement commercial clinical grade solutions
Defines best practices and governance principles, while working with business stakeholders to ensure the clinical and corporate solutions meet data delivery and quality SLAs / KPIs
Ensures that critical application and information assets modeled as part of any project are represented in the enterprise Business, Application, Information and Technology architectures (BAIT) and follow the design guidelines and requirements of EA
Experience with Data Modeling Methodologies focused on Data Standardization leveraging Data Terminologies and Ontologies and evolving clinical / genomics standards, such as CDISC, GA4GH, OMOP
A bachelor's or master's degree in computer science, bioinformatics, information systems or other related field; or equivalent work experience
Strong communication and conflict resolution skills to help reconcile the different points of view and requirements that clash during cross-team and cross-organization efforts as part of broader data design efforts
Training in business process improvement and object oriented design / data modeling using various modeling tools such as EA Sparx, Erwin or similar tools
Deep understanding of business processes and the databases they access, and the flow of information between processes
Working knowledge in modern distributed data architectures and data storage techniques including HDFS and other distributed file systems and varying formats such as JSON, Parquet
Working Knowledge of RDBMS (MySQL, PostgreSQL, SQL Server) and NoSQL databases such as HBase, CouchBase, Vertica, MongoDB, Cassandra
Basic understanding of a programming language such as Java/Python/Scala and a shell scripting language and experience using version control tools like git
Experience working with Agile development methodologies and tools (Jira, Confluence)

Next Generation Data Modeler Resume Examples & Samples

Six years of progressive post-baccalaureate experience as a Data Architect or Data Modeler
Strong experience in data architecture standards and best practices and experience coaching other Architects in appropriate methods of data design, including conceptual, logical and physical data models
Strong experience in leading architecture, design and implementation of data architectures and frameworks across: data pipelines, data services, operational data stores, data warehouses, data marts, big data stores, big data analytics and business intelligence platforms
In-depth knowledge of data integration concepts, approaches, and tools and the role of data architecture in successful implementation of data integration strategy
Strong experience with multiple database technologies for relational, unstructured and Big data
Advanced analytical, problem solving, negotiation and organizational skills with demonstrated ability to multi-task, organize, prioritize and meet deadline
Strong written/oral communication and presentation/interpersonal skills
3+ years of experience with Apache Hadoop stack (e.g., MapReduce, Pig, Hive, HBase, Flume)
4+ years of experience with ETL (Extract-Transform-Load) tools (e.g., Informatica, Ab Initio, etc.)
Knowledge of NoSQL platforms (MongoDB, Cassandra, etc.)
Experience with Amazon AWS EC2/S3/RDS/Redshift
Demonstrated ability to provide technical oversight for large complex projects and achieve desired customer satisfaction from inception to deployment
Advanced knowledge of SQL, including the ability to write stored procedures, analytic/windowing functions, and tuning

Data Modeler Resume Examples & Samples

Work with technology teams to analyze data requirements (functional and non-functional) and provide data architectural designs solutions/reviews for business application and technology initiatives
Establish and document guidelines/practices for the team
Identify opportunities to streamline processes with best practices in data provisioning and management
Establish and contribute to Data Dictionaries and Business Data Glossary
Model Data Vault, and Data Marts
Work with development, application and other data architects to provide an overall solution approach
Mentoring and coaching other peers and team members on data issues
Provide input and technical support for the design and development of database systems
Advanced level Data Modeling (5-7 years)
Mustdemonstrate expertise in data analysis and data modeling
Excellent organizational, problem solving and communication skills
Ability to speak with the business to understand their needs and the format/security/availability of the data must be appropriate for the appropriate audience
Communicate the architecture to the organization to allow others to take advantage of data that is available or contribute to the data
Experience participating in development of standards and processes
Experience designing and architecting systems as a member of a design team
Strong verbal communication

Data Modeler Resume Examples & Samples

Work in a team of Professional Services consultants, architects and project managers who implement SAP and Big Data Analytics solutions
Provide SAP HANA modeling and Analytics expertise in the development of new solutions as well as the improvement of existing solutions
Being able to articulate & define analytics solutions being used by supervisory board, executive committees and senior managers
Deliver and lead industry-centric customer projects through providing Big Data Analytics for the desired business metrics
Ability to work as a visualization architect to recommend the best visualization stories for customer’s business KPI’s
Help customers harmonize master data and building data models (in HANA or other relational databases)
Will involve leading or participating in business sessions to identify and document business use cases
Meet clients, analyze their requirements, document and prepare project proposals
Review and contribute to solution knowledge base with specific areas of expertise, Develop and document enterprise knowledge in the form of technical articles, and best practices
Strong work ethics, driven, dependable, and responsible
Willingness and ability to learn quickly new Big Data and Cloud Analytics solutions
Ability to stay on top of technology innovations and eager to continuously learn
Must be a flexible self-starter who can ramp up with new technologies quickly and can adapt to a growing and rapidly evolving environment
Willingness to participate in the sales process as a subject matter expert
Ability to inspire confidence and work with all levels of client and internal staff. Ability to deliver clear, concise presentations to non-technical audience. High energy, clear goal orientation and strong work ethics; “can do” attitude
Ability to manage difficult situations at customer projects
Executive level presence required
Motivated, and able to work effectively under pressure situations
Ability to capture customer requirements and translate them into software specifications
Ability to present complex information in a clear and precise manner; with non-technical audience
Project Management exposure. Ability to manage risks and issues and escalate through proper channels
Master’s or Bachelor’s degree in Business Administration, Computer Science or Information Management
6+ years overall experience in business and technical roles, ideally in analytics
Track record of successfully implementing Analytics projects in challenging environments
Experience in SAP HANA modeling and SQL scripting is required
Experience in SAP BusinessObjects product suite is required
Strong in data warehousing and data modeling concepts

Data Modeler Resume Examples & Samples

Responsible for designing, planning, implementing and administering databases, including security, access, and documentation
Participates in the design, maintenance, enhancement, coding, and administration of relational databases
Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities
Participates in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions
Coordinates testing of designed applications
Provides guidance and work leadership to less experienced analysts, and may have supervisory responsibilities
8-10 years of related database analysis and/or administration experience

Data Modeler Resume Examples & Samples

Engage with Accountable Executives and SMEs across IB Functions, Business and Programs to drive the creation of Data Models for core Data Groups/Entities within the IB. Establish working groups, agree milestones and implement delivery plans for each intersect
Assist with strategic decisions on the frameworks and data modelling structures to be used by Data Modelling Team
Curate various Data Models and establish Working Model. Upload and maintain in central Sparx repository
Operate a robust review and signoff process that ensures Data Models are recognized as authoritative within the IB
Establish lineages between data models, data requirements and business requirements
Design and implement the strategy to govern Data Models in Sparx
Promote education in Data Governance within the IB – design creative training materials and ensure effective dissemination (including in person training events)
Four-year college degree
Experience in Entity – Relationship modelling, Object – Relational modelling, Class modelling
Knowledge of UML modelling, E-R modelling notation
Understands the trade-offs to 3rd Normal Form for Enterprise Modelling
Aware of trade-offs between System models & Enterprise models
In-depth experience of mapping Business Requirements to Data Entities and Attributes
A college degree in analytical or data driven discipline (Engineering, Physical Sciences, Finance, Information Technology)
MBA or other advanced degree
Previous experience working on Database solutions
Previous experience in Data Management consulting roles, Enterprise Data
Extensive experience of Sparx, including customization for enterprise environment, report production, building report templates and custom UI development
Experience using PowerDesigner or similar products
Experience working with colleagues spread across multiple global locations

Data Modeler Resume Examples & Samples

Assist with strategic decisions on the frameworks and data modeling structures to be used by Data Modeling Team
Knowledge of UML modeling, E-R modeling notation
Understands the trade-offs to 3rd Normal Form for Enterprise Modeling

Business Intelligence Data Modeler Resume Examples & Samples

Leads business information modeling for large, complex projects and ensures that project information conforms to corporate information architecture standards
Demonstrates domain knowledge of claims, membership, benefits and providers and clinical healthcare
Collaborates with business clients, IT and Business Intelligence staff, and management to assess information and resource needs, identifies data sourcing, application, and maintenance, determines project impact, and ensures integration across projects
Researches and evaluates alternative solutions and recommends the most efficient and cost-effective data management solutions
Identifies, researches and recommends new methods for supporting information management as it relates to data management
Develops high-level database architectures and ensures that database designs are consistent with KP's information architecture and information management standards as well as industry standards
Works with the Data Warehouse Architect to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas
Eight (8) years of information technology experience including a minimum of four (4) years experience designing, deploying, and maintaining relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence
Extensive experience integrating disparate systems into conformed dimensions
Strong hands-on ERwin data modeling tool experience
Experience with a range of relational database management systems (RDBMS) (Oracle, Teradata, DB2, etc.) and RDBMS tuning
Experience deploying and supporting large, complex data warehouse/business intelligence solutions (full life cycle)
Eight (8) years of information technology experience, preferably in large, complex organizations, including a minimum of four (4) years experience designing, deploying, and maintaining relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence
Prior experience in health care
Secondary degree in business, computer science or health care
Knowledge of data vault and hyper dimensional data modeling techniques

Data Modeler & Functional Architecture Engineer Resume Examples & Samples

Take an important and central role in the development process across departments and phases and act as X-stream CSD’s own subject matter expert
Take ownership and build X-stream CSD’s functional architecture
Design and develop the complex and highly sophisticated data model
In collaboration with Business Analysts, work with the customers for increased business knowledge and understanding in order to provide product specific guidance
Review and provide feedback on business requirements
Provide expertise and recommendations on software design specifications and test scenarios
Work with client base on data migration
You have an agile mindset and enjoy working under constantly changing conditions
You possess a strong drive to achieve results, and always look to exceed the expectations of stakeholders
You are a good team member and able to work efficiently both independently and in collaboration with others
You have a genuine interest in financial domain model and in particular the settlement and corporate action areas
You are an effective communicator as the role will require to liaise with development / business teams and with clients

MDG Data Modeler Resume Examples & Samples

Supports detailed data usage and data meaning analysis to support governance recommendations across various systems (SAP, Team Center, Quantum, Sales Force, etc.)
Supports analysis of adherence of data to business rules and compliance with laws and regulations (e.g. Government requirements and regulations, industry standards, etc.) and Honda Aircraft technical standards (naming, attribute definition, sizing, etc.)
Prepares and reviews additions to and changes to the overall master data model, including the subject areas, entities within subject areas, and attributes within entities
Reviews across subject areas changes to and impacts on the overall master data model
Collaborates with master data business analysts, master data modeling analysts and master data stewards to develop and/or refine the overall master data model
Provides support to technical staff to implement governance master data model recommendations within software and systems
Works with technical resources such as developers and database teams to test and validate master data governance model design and to ensure governance rules are appropriately implemented
Develops and maintains data model policies and standards based on management directives
Supports overall master data governance processes
Uses criteria, specifications, and rules for the definition (i.e. data standards) for the capture, creation, storage and usage of operational and analytic data models. Standards may include, but are not limited to, naming conventions, derivation and transformation rules, specific quality measures, etc
Bachelor’s degree in Business, Mathematics, Accounting, Computer Science or related field; Management may elect to consider years of experience in lieu of a degree
2+ years of directly related work experience is required; 5+ years of directly related work experience is preferred
Previous experience within one or more of the following areas is preferred
Working knowledge of data analysis, data model development, data model design, and some data model architecture along with knowledge of database related technologies (SQL, OLAP, etc.), data model software (such as ERWIN, VISIO, or equivalents)
Proficiency in MS Office (Word, Excel, PowerPoint, Access) and Lotus Notes is required
Ability to make decisions, identify problems, coordinate own resources and options, and implement changes
Ability to effectively communicate throughout all levels within the organization
Ability to present complex master data model ideas and concepts to a wide variety of audiences, both business and technical
Ability to work independently with minimal direction as well as within a team-oriented environment
Ability to work with junior business users as well as to work with highly technical individuals

IT Data Specialist / Data Modeler Resume Examples & Samples

Deliver logical and physical data models consistent with enterprise frameworks, standards and data strategies
Ensure integration of insurance data into the financial services logical models
Collaborate with the senior data modeler, architects, data mappers, business analysts, systems analysts and developers, and other team members as needed in order to provide the appropriate logical and physical database designs
Provide estimates for data modeling activities within projects
Support developers and DBA's responsible for delivering the database in a thorough understanding of the requirements and designs
Assess the technical characteristics of proposals and alternatives considered to optimize data base performance
Work in strategic partnership with development teams, delivery teams and infrastructure teams to continually identify and create opportunities to improve application efficiencies
Ensure understanding, compliance and adherence of TS internal work methods and procedures
Maintain and develop good interpersonal relations and ensure dynamic, constructive and quality communications with various partners and stakeholders
Data modelling, data warehousing, data integration
7 yrs + in the Data Warehousing, Business intelligence domain
Solid experience with Financial Industry Standard Data Models, such as Teradata FS-LDM or equivalent. Experience with Guidewire data models an asset
Ability to facilitate requirements and modeling sessions including user interview, document analysis, workshops etc
Good knowledge of technology platforms and tools supporting the Data management domain (ETL, data modeling, data lineage, relational and non-relational databases, distributed computing of large data sets, storage management, ..)
Highly organized, self-motivated, customer oriented and able to embrace and drive change

Data Modeler Resume Examples & Samples

Work with SMEs, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions
Develop and maintain fully defined Logical and Physical data models for Operational and Analytical environments
Provides technical leadership for data management, design and development
Forward Engineer, implement and maintain database environments
Participate in code reviews to ensure appropriate and efficient use of the database structures
Develop and maintain quality metadata within the data models to be shared with business and other technology teams
Contribute towards development of data standards, data dictionaries, processes, and definitions of project and data requirements in support of strategy and ongoing operational support
8+ years of overall Information systems, services / consulting experience of which the recent 4+ years in data architecture / data modeling
Experience in data analysis, user requirement gathering, user requirement analysis, gap analysis, gathering metadata, data transformations, data relationships, source systems analysis and reporting analysis
Strong data modeling fundamentals including experience with 3rd normal form
Experience with data modeling tools (e.g. Erwin, Sybase Power Designer, EA, etc.) and understanding of IDEF1X
Experience in Forward and Reverse Engineering with Oracle
Excellent SQL skills and demonstrated ability to write complex SQL for purposes of analyzing data and/or evaluating how information needs might be translated into back end database structures
Hand on experience with Oracle and PL/SQL
Wealth management experience is heavily preferred
Experience with unstructured data through the design and development of content management solutions
Additional 3-5 years working in another role within a data warehouse team, such as business/data analyst, quality assurance analyst, ETL developer or BI / information delivery developer
Banking industry data model experience, such as BIAN
Agile experience

Senior Data Modeler Resume Examples & Samples

Performs senior-level responsibilities for the design, development, and implementation of data solutions and enterprise data models that meet business requirements and align with the overall Data Architecture and Enterprise Architecture
Works with various business owners and application development project teams to design and implement data models for NYC DOE systems on a wide variety of platforms
An expert in creating enterprise-level data models that allow business owners, policy makers, and business units to create reports and analyze data that originates from multiple disparate systems
Works with business owners and policy teams to develop large data structures that allow accurate and timely reporting of critical data with respect to student performance
Creates and maintains project documentation, including conceptual, logical, and physical data models
Develops and maintains an excellent business understanding of NYC DOE data, data terminology, and data definitions
Works with NYC DOE’s ESB team, data architects, SQL developers, and reporting teams for the development and implementation of the Enterprise Data Model and strategy development plans for usage by Operational Data Stores, data warehouses, and other data repositories across DOE
Stays current on and evaluates new and emerging technologies and standards for feasibility and implementation at DOE
Creates effective data integration solutions utilizing data expertise and knowledge regarding customers and associated data across DOE to meet the business needs
Creates data models that promote data sharing, data consistency and data reusability across DOE
Leads and manages the review of data quality deliverables of all phases and enhancements
Collaborates with business units and data owners to successfully implement and maintain a DOE enterprise-level business analytics and data warehousing solution
Ensures that operational and analytical data warehouses are able to support all business requirements for business reporting across the organization
Leads the design of data handling and cleansing, and standardization procedures and business transformation rules and logic
Leads and conducts regular data model processes, policies, and vision for purposes of identifying and implementing improvements
Adheres to and enforces all data exchanges and integration standards
Develops guidelines and best practices to ensure standardization and consistency across projects and systems
Contributes to developing transparent and well understood enterprise data governance processes, rules and technologies to support them
Responsible for creating and maintaining documentation of standards, processes, procedures, and other relevant documentation
Provides extensive expertise in enterprise data and information management methods and standards
Works with other data modelers and the SQL development team to identify and promote best practices for data modeling within information areas across the Department of Education, which may include providing oversight for all activities related to data cleansing, data quality and data consolidation using industry standard data modeling methods and processes
Displays demonstrated abilities in communicating the overall customer data models to both technical and business constituencies
Education and/or experience equivalent to "1"or "2"above. College education may be substituted for up to two years of the required experience in "2"above on the basis that 60 semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in "1"or "2"above. However, all candidates must have at least a four-year high school diploma or its educational equivalent and at least one year of satisfactory full-time experience in a project leader capacity or as a major contributor on a complex project

Data Modeler Resume Examples & Samples

The success and timely management of all phases of the project from project initiation to post implementation, effectively managing the end to end project management activities for strategic Data Management deliverables at the offshore location
Manage and deliver across a complex distributed / matrix organizational environment
Candidate will be responsible for managing the development aspects of overall technology release cycle, scope, and quality on time and on budget
Strong technical project management focus, with proven stakeholder management experience at an offshore location
To work with internal delivery leads to effectively manage program requirements and expectations
To create, review and maintain project plans with all relevant parties involved
To proactively monitor overall project progress, resolving risks and issues and initiating corrective action plans as appropriate
To act as the central point of liaison and coordination with all stakeholders throughout the project lifecycle for development activities
To work with internal technologists and project manage the implementation of solutions, ensuring functionality, infrastructure and processes are in place
To manage the development activities of multiple concurrent projects of varying sizes/complexities
Developing and maintaining program plans/milestones and coordinating program activities while tracking accomplishments and results
To actively manage scope changes and the impact to the overall plan
To demonstrate knowledge of the supported/related business area
To report on management of project budgets and report to Seniors of the status of development budgets
To provide regular communication to management and the stakeholders of project status, including risks & issues and mitigations
To provide analytical, technical, business and management expertise to the group
To adhere to and enforce existing PMO and best practice processes including but not limited to tollgate and release management process
Minimum 5+ years Project Management experience ideally within a financial software development environment
People management skills, managing large teams
Experience in Business Intelligence and Information Management
Experience of managing large and complex projects involving multiple stakeholders across different geographical locations
Experience in managing risk and control within a financial software development environment
Knowledge of the financial industry in relation to Treasury & Trade Service business is an advantage
Significant project management experience of applications development or implementation
Extensive IT experience, preferably encompassing analysis and/or development
Experience of working within-in a multi-cultural and remote team structure
Proficient in use of Microsoft Project
Proven influencing and negotiation skills
Ability to manage multiple activities
Ability to identify the critical success factors and risks
Focus and determination
Self-supporting
Maturity and sense of responsibility
Ownership and accountability

Data Modeler Resume Examples & Samples

Work with application development teams in designing new data structures and modifications to existing structures
Review data models and data structures developed by data modeling team and application development teams
Review SQL developed by development teams in terms of standards, best practices and performance impacts
Develop deployment data definition language(DDL) scripts
Perform deployments across all environments
5+ Years Data Modeling(Preferably on Large Scale DWH)
Experience in tuning SQL
Understanding of Logical vs. Physical Modeling
Experience with Analytical and Operational Data Store Modeling
Experience with Dimensional Data Modeling at an enterprise level
Experience with tools including: TOAD, SQL Developer
Experience with Source Control Tools (i.e. Subversion, Clearcase)
Familiarity with Big Data

Data Modeler Resume Examples & Samples

Provide expert data modeling and data validation services that produce flexible, extensible data structure design solutions that support effective business decisions
Mapping of relational entities to use cases or business requirements and assisting in the development of data models
Create and manage an array of data design deliverables including data models, data diagrams, data flows and corresponding data dictionary documentation
Follow standards for database design and overall data architecture to assess data quality and act as a liaison with various technical service teams which include database administrators and platform administrators
Identify opportunities for sharing and utilizing data across boundaries, thus extracting maximum benefit from the data resource
Support analysts in requirements development, research and verification
Participate in full life cycle development to meet project objectives
Participate in the development of software documentation
Analyze business user requirements in order to define data requirements for new analytics, reporting, and data governance
Knowledgeable in concepts around modeling Slowing changing Dimensions and Capturing Transactional History
Strong technical understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data
Deep knowledge of best practices through relevant experience across data-related disciplines and technologies, particularly for enterprise-wide data architectures, data management, data governance and data warehousing
Highly competent with relational database design and structured query language (SQL)
Strong familiarity with data management tools, including enterprise repository tools, data modeling tools, data quality tools, data mapping tools, and data profiling tools
Solid understanding of Business Intelligence and Data Warehouse technologies (e.g.., Informatica Business Objects, Oracle, SQL Server). Hands on experience a plus
Strong aptitude to learn business processes/products and the role of data within the business domain
In-depth experience in managing/operating information solutions
Candidate should have a combination of strong communication/facilitation skills with conceptualization/design skills
Strong applied knowledge of software development efforts through implementation including good design, documentation and supportability practices
Five years' experience managing multiple complex systems with
Demonstrated leadership of multi-discipline, high-performance work teams/groups; and
Demonstrated high competency in execution of multiple large projects
Experience working in a program management office (PMO) using project and portfolio management tools
Candidate should have a minimum of ten years of experience in IT, with at least three years in Deployment, Maintenance and Operations Project Management

Data Modeler Resume Examples & Samples

Effective listener, who can give timely and constructive feedback. Is willing to state opinions assertively and deals constructively with conflict situations. A problem solver as well as willing to comprise for a common effective and efficient solution
Develop and maintain relationships with key business and technology partners
Participate in production on-call rotation, where required
Ensure all code changes are managed according to the company best practices
Identify opportunities for improvement; innovate
Hands on experience with Microsoft SQL database tools
Hands on experience with Data Virtualization technology (RedHat/JBoss, Cisco, Denodo, others)
LI-LOCS VIRTUAL-US

Senior Data Modeler / Analyst Resume Examples & Samples

Designs and builds relational database models and defines data requirements to meet the business requirements
Develops strategies for data acquisitions, archive recovery, and implementation of databases
Develops logical and physical database models
Data lineage and audit controls for data movement life cycle
Writes scripts and commands for data manipulation
Plans and conducts database unit and system tests, monitors results, and takes corrective action
Monitors and resolves database performance, database capacity, data integrity and replication issues
Assures integrity of data, software, and hardware; develops policies and procedures related to development and support of new and ongoing systems
Determines transition strategy from current to new architecture, including integration from current data and information systems
Provides technical consulting to application development teams during application design and development for highly complex or critical projects
Ensures compliance with the organization's database standards
6+ years’ experience with Application development with focus on Data Management
6+ years’ experience with the concepts, philosophies and tools behind the design of applications, information and underlying information technologies
Data analytics and modeling (SAS)
Data Governance Processes and Technologies (IBM)
Data warehouse modeling and Dimensional Modeling (Star Schema Design). I
Involved in creating Logical and Physical data models for Data warehouse and Data Marts of end to end BI/Analytics solutions
Data acquisition and integration, OLAP and data modeling tools (Erwin and Enterprise Architect)
Development and management of data lineage and audit controls for data movement life cycle
Large scale transformational initiatives (Financial Crimes), Data profiling and Data Quality initiatives
Creating a very performance oriented physical data models in Oracle. To take advantage of partitions, indexes and Aggregates
Query Tuning from Reports/Integration perspective to meet performance SLA requirements
Self Service BI programs and creating semantic models for successful adaptions by the business team
Building of Data Discovery Platform using analytic/data technologies SAS, R, Hadoop, Oracle and others
Product and vendor liaison
IT standards, procedures, policy
Experience working in a fast pace IT environment with strong ability to meet tight deadlines
Self-motivated and not afraid to work in ambiguous situations

Data Provisioning Data Modeler Resume Examples & Samples

BS in Computer Science or related IT field, or equivalent work experience required
Experience: 3-5 years development experiences in building large scale data warehouse
Strong data analyses skills and proficient in SQL writing
Ability to translate business requirements into IT requirements
In depth working experience with at least one data base e.g. Oracle
Strong data model capability. Familiarity with Oracle OFSAA is a big plus, but not a prerequisite
Ability to use project management tool such MS Project to help run or coordinate a project
Good experience in financial industry is desirable. Familiarity with investment banking data is a big plus
Experience in data integration (ETL / API)
Knowledge with core ETL development technologies such as Informatics is desirable
Ability to analyse and understand data flows and derives a data architectural solution
Highly motivated and delivery focused
Solution centric mindset and creativity
Shows initiative, autonomy, self-motivated, self-starter
Experience working successfully in a multicultural environment
Excellent communication skills and ability to deal effectively with customers
Proven ability to pick up new technologies independently and quickly

Data Modeler, Associate Resume Examples & Samples

Work with product owners, business analysts and subject matter experts to gather requirements
Identify the set of entities that satisfy the requirements
Create draft models that contain necessary properties to meet business requirements
Build the actual models and create sample documents that conform to the model schemas and show what the data will look like
Collaborate in meetings with product owners to understand the functional requirements; will need to translate those into technical solutions
3+ months- 3 years experience working as a Data Modeler, Business or Data Analyst
Basic technology skills and knowledge including but not limited to: Windows and Linux operational systems, code and text editors, Web browsers
Technology-centric Education from a 4 year college or university in technology I preferred (basic understanding of SDLC/software development/database technology), etc
Exposure to, or basic knowledge of, databases, data modeling (for integration or storage), data warehouses (should understand the basic concepts of how data is stored and communicate this effectively). In depth experience in this space is not required, because the role will be trained in how to create JSON files using various Ellucian tools
Clear communication is a must. Candidate must communicate effectively with senior architects and business analysts, ask questions, and learn quickly
Reading/collecting requirements for software development and collaborating with business analysts and data architects
Multiple types of systems (transactional, reporting, etc.)
Able to express ideas clearly and communicate well with both SMEs and development teams
Ability to deal with complex information, ability to structure effectively, and present the data in simple form and the way it was requested
Basic knowledge of SQL and exposure to databases, data warehouses, big data environment; data analysis, data profiling, data mining
Basic knowledge of DBMS concepts, experience with database and data warehouse design and implementation, reports design and development, data visualization and presentation
Facilitate and gather requirements for new data models and modifications of existing ones
Create mapping between incoming and outgoing data formats
Data warehousing, data profiling, data visualization, data mining, MongoDB, and NoSQL

Data Modeler Resume Examples & Samples

Data modeling and using tools such as ERWin, Power Designer and Visio
Data modeling methodology (ex. Kimball)
Enterprise metadata (managing information assets of organization) and data governance
Work with product development and support staff to document, categorize and classify information used by our various business systems
Create and maintain custom and vendor provided data dictionaries for all business systems
Database and data warehouse design across multiple platforms and computing environments
Support new and existing development projects with logical data and process modeling activities. Provide entity, logical and physical data models
Communicate to leadership within our partner companies to convey the importance and business value of data architecture
Promote information management strategies that drive value to our organization and integrate our business systems
Keep pace with latest trends and technologies related to information management to guide our future business strategies
Participate in data governance processes related to data quality and information management
Assist in product evaluations for technology to support the Enterprise Data Office
An understanding of the staffing or professional services profession a plus
Strong people skills including the ability to effectively and concisely communicate orally and in writing across all levels of the organization
Demonstrated strong analytical skills including the ability to solve problems in a systematic, logical and effective way leveraging defined processes and methods
Ability to collaborate in a team environment and ability to work independently to meet individual and team goals
Ability to handle multiple projects or issues concurrently
Familiar with concepts and strategies of a Service Oriented Architecture (SOA)
Familiar with enterprise ERP and CRM systems such as PeopleSoft and Siebel

Data Modeler Resume Examples & Samples

Pull data from multiple databases across different platforms such as Oracle, SQL Server, Teradata and Hadoop to integrate data and build a Data Lake and analytical datamarts
Works with the Lead Data Architect to determine high level data strategy for the Enterprise Data Warehouse
Creates logical and physical data models for operational applications and all analytic applications
Participates in ETL design and acts as the subject matter expert on source and target data structures
Work with various outside vendors and internal support teams in maintaining and/or enhancing processes and data integrations
Support business by generating ad-hoc analysis, using SQL, for overall business as needed
Perform extensive data quality / data analysis checks to ensure integrity of database for business use
Work with business partners on the full lifecycle of data related projects from requirements analysis and design through development
Maintain and manage scheduling and distribution of reporting
Manage and monitor server processes and jobs for on-premise and cloud environments
Investigate and resolve root cause for complex data issues
Script and automate processes
Diagram and document databases and data flows
Bachelor’s degree in Information Technology, Computer Science
Minimum 4 years’ experience in database development and administration
Experience with data integration and database design, knowledge of Data Warehousing methodologies. Exposure to ETL tools such as Microsoft SSIS
Experience with enterprise reporting tools; Business Objects, Microsoft SQL Reporting Services, Power BI or Tableau preferred
Excellent data interpretation and communication skills; ability to summarize complex findings clearly and concisely, ability to communicate effectively to all levels of management
Strong conceptual/analytical/creative thinker
Strong skills in SQL to analyze, manipulate data, investigate data problems, and develop reports
Familiarity with a programming/scripting language such as Java, .Net, powershell or Python

Data Modeler Resume Examples & Samples

Supports all aspects of maintaining a database environment
Installs and troubleshoots database applications, patches, and updates
Implements mirroring and clustering techniques
Creates, maintains and monitors databases (i.e. Shrink/Manage Transaction Logs, Daily database administration, user accounts)
Analyze sand troubleshoots logs for performance and resource planning purposes
Performs daily database backups, maintenance, monitoring
Owns, tracks and resolves database-related incidents and requests, fulfilling requests and resolving incidents within SLAs
Creates Stored Procedures and Views for use in various front-end applications
Responds to database-related alerts
Assists in the design and use of databases, the global view of databases, and access to the databases
Tunes the databases to maintain optimum performance
Creates conceptual data models based on user requirements
Creates data dictionaries, data flow diagrams and logical data models
Bachelor’s degree in math, computer science or equivalent technical field with 4 years of experience in Data Management arena
Minimum 3-4 years experience in data modeling/database design
Knowledge of DBMS concepts
Proficient in Oracle and/or SQL DBMS
Individuals in this position work in a group or on project teams under deadlines and heavy workloads
Must have good interpersonal skills and the ability to coordinate actions with supervisor and peers

Data Modeler Resume Examples & Samples

Work in a team of Professional Services consultants, architects and project managers who implement SAP and Big Data and Analytics solutions
Provide a good SAP HANA modelling expertise and Analytics guidance in the development of new solutions as well as the improvement of existing solutions
Being able to articulate defined analytics solutions al all levels of the organisation
Deliver industry-centric customer projects through providing analytics for the desired business metrics
Ability to work as a visualisation expert to recommend the best visualisation stories for customer’s business KPI’s
Meet with clients, analyse their requirements, produce requirements documents (technical and functional)
Strong work ethic, driven, dependable, and responsible
Willingness and ability to learn quickly new Big Data and Cloud and Analytics solutions
Willingness to participate in the sales process
Motivated, and able to work effectively under pressure
Ability to present complex information in a clear and precise manner; with technical and non-technical audiences
Master’s or Bachelor’s degree in Business Administration, Computer Science, Information Management or equivalent
3-5 years overall experience in business and technical roles, ideally in SAP analytics
Experience in SAP HANA modelling and SQL scripting is required
Experience in data warehousing and data modelling concepts

Data Modeler Resume Examples & Samples

Work with the Lead Data Architect to determine a high-level data strategy for the Enterprise Data Warehouse
Work with business partners on the full lifecycle of data-related projects from requirements analysis and design through development
Pull data from databases on different platforms (i.e. Oracle, SQL Server, Teradata, Hadoop) to integrate data and build an analytic datamart
Participate in ETL design and act as subject matter expert on source and target data structures
Generate ad-hoc analyses using SQL
Diagram and document data flows and databases
Bachelor’s degree in Information Technology or Computer Science
Minimum 4 years’ experience in database development and administration; Experience with data integration and database design, knowledge of Data Warehousing methodologies. Exposure to ETL tools such as Microsoft SSIS
Strong SQL skills to analyze, manipulate data, investigate data problems, and develop reports
Experience with enterprise reporting tools such as Business Objects, Microsoft SQL Reporting Services, Power BI or Tableau

Data Modeler Resume Examples & Samples

Partner with multiple global MDM and/or application project teams to define data requirements, influence data design to achieve Enterprise and Sector goals
Lead requirements gathering meetings with application teams, Database Administrators, and/or business partners to understand business needs; help define and anticipate business needs
Design and model relational databases in Teradata, Oracle, Sybase, SQL Server, and/or IBM DB2 environments; create data and process solutions for business and systems requirements; convert logical models to physical models and build database in development platform
Perform quality assurance reviews on data models, created by junior members, to ensure requirements have been met and design is optimized for functionality and performance
Update Technical Design documents; create and maintain metadata, including table/column definitions
Support application and functional teams with data identification and analysis
Collaborate with Enterprise Architects to establish, and enforce data principles, standards and best practices; advocate Enterprise data strategies, architecture, and direction
7+ years experience in application development, data design and analysis, or data management/governance
5 years of Data Modeling/Design experience, required
Proficiency with ER/Studio, or other data modeling tools
Demonstrated analytical skills and aptitude
Strong interpersonal skills; strong written and verbal communications skills; experience with remote or virtual teams
Development experience with SQL and UNIX
Experience translating business and application requirements
Knowledge of PepsiCo master data, applications, and Business, a plus
Team player; ability to work well with changing priorities; demonstrated flexibility

Data Modeler Resume Examples & Samples

Conceptual data modeling experience required
Logical data modeling experience (third normal form) required
Physical data modeling experience required
Prior work and familiarity with databases (preferably Oracle or SQL Server) required
ERwin modeling tool experience preferred
Data analysis experience required
Outstanding communication and presence in front of senior level customers required
Workshop and interview experience preferred

Data Modeler / Analyst Resume Examples & Samples

Review and analyze client workforce or operational data
Review, analyze and develop models to report on and/or optimize cost, staffing, performance or operations
Perform performance and cost analysis on client interpret findings
Develop recommendations for improving organizational effectiveness or efficiency based on data review findings or model outputs
Develop reports detailing the analysis of data and next steps for implementing organizational improvements
Proficiency in statistical analysis and data modeling as well as Microsoft Word and Excel
Ability to translate analytical findings into context that non-technical clients can understand
Flexibility and willingness to address client ideas and feedback
Responsiveness to client and project manager requests
Good time and project management skills
Experience with River Logic Enterprise Optimizer or analytical packages a strong plus

Senior Data Modeler Resume Examples & Samples

Perform data research, analysis, conceptual and logical data modeling to validate and document business data artifact with an in-depth understanding of entity relationship design, data normalization & relational modeling techniques
Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems
Identify key business processes and deliver subject specific OLAP data-marts and manage logical and physical data models for data warehouse
Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures
Familiarity with Bill Inmon & Ralph Kimball Data Warehousing methodologies
Work very closely with business analysts, development teams and project managers for requirements and business rules
Support ongoing data modeling efforts for Development, QA, Production environments
Experience with ERWIN or similar data modeling tools
Experience in design and deployment of logical and physical structures preferably Banking Risk Area
Experience in business analysis techniques and data warehouse design techniques
Experience deploying and supporting large, complex data warehouse/business intelligence solutions

Data Modeler Resume Examples & Samples

5+ years of experience using SQL, SSRS, SSAS etc
Professional Billing Epic Clarity Data Model certification
Previous experience working in a Hospital setting
Working knowledge of Sharepoint and Business Intelligence

Data Modeler Resume Examples & Samples

Review current data models to understand the as is environment. Review report design documents to understand where data model structures can address requirements
Work with the key business representatives, data owners, end users, application designers and data architect to model the current data (where models do not already exist) and for the to be system. Create logical and physical data models for as is and proposed or to be system
Create entity-relationship diagrams for relational systems and dimensional diagrams for the Data Warehouse, Data Marts and data cubes
Review, update and validate data model with key business representatives and end users
Work with the technical architect, data architect and database administrator to understand current data storage constraints and define to be needs with growth allocation
Work with data architect to define and create required metadata. Maintain data models continuously as modifications and enhancements are made
Create data model structures to enhance performance of the application by creating aggregation and summarization structures
Minimum of 3 years professional services experience in data modeling and big data technologies
Ability to travel a minimum of 80%, up to 100% where applicable
Experience with a minimum of one of the following technologies: Hadoop/Cassandra/Mongo DB/Couch DB Oracle DB/MS SQLServer, SAP HANA/Oracle Exadata
Minimum of a Bachelor's Degree
Life sciences clients and experience preferred
Strong power point presentation skills
Should be able to work independently with Accenture and client organization
Able to lead teams and able to interface directly in client facing interactions

Business Intelligence Senior Data Modeler Resume Examples & Samples

Apply rigorous data management principles and industry standard development approach to model SE NAM ‘s data assets to build and maintain conceptual, logical, and physical data models
Coordinate with Data Architect & DBAs to define the optimal physical data model
Develop and employ the industry and SE technical standards, procedures, and guidelines used to govern data models
Direct, coach, and guide development teams in applying data modeling techniques and the usage of data modeling and repository tools
Provide architectural expertise in Data warehouse construction and engineering, data source identification and engineering, data modeling, database design, operational flexibility and user self-service capabilities
Support system integration of diverse components and technologies used in the design, construction, testing, deployment and operations of DW & BI solutions
Detail and process oriented with great organizational, collaboration and analytical skills
Advanced communication and interpersonal skills
Advanced Data Modeling for Star Schema design
Use-case analysis
SQL query development for investigation and analysis
Working knowledge of Reporting tools, ETL tools and database technology
Working knowledge of Data Warehousing tools, theory and methodology
Working knowledge of business domains
10-12 years of experience in architectural design of Data Warehouse Data Star Schema modeling
Demonstrated expertise in Data Warehousing and Data management domains

Data Modeler Resume Examples & Samples

BS or equivalent + 2 yrs related experience, or MS + 0 yrs experience
Software design experience desired
C++ programming experience desired

MDM Data Modeler Resume Examples & Samples

Works in conjunction with the Requirements, Architecture, and Development Teams,
Supports new and existing development projects through the completion of logical data and process modeling activities,
Provides entity, logical, and physical data models
Develops, documents, and maintains technical solutions and design artifacts for various MDM system components,
Prepares high quality design documentation, including visual diagrams and processing flows,
Maintains and updates Database Design Documents DDDs

Guidewire Data Modeler Resume Examples & Samples

Bachelors Degree in Computer Science, Computer Engineering, or related field with 6 or more years of data modeling experience
Data Mapping and Data Modeling experience
Experience with Data Warehousing, Data Marts, and BI Design best practices and techniques
Experience with ETL tools such as SAP, Informatica, or SSIS
Bachelor’s Degree in Computer Science, Computer Engineering, or equivalent field preferred
SQL scripting (TSQL or PL/SQL) including query optimization
Guidewire experience
DataHub experience

Data Modeler Resume Examples & Samples

Design and Develop Application Data Models
Design and Develop Reference and “Data Warehouse” Data Models
Ensure the consistent use of Enterprise Reference Data within the application and “Data Warehouse” data models
Develop and deliver long-term strategic goals for data architecture vision. Global and divisional stake holder standards must be met while creating short term tactical solutions to reach the long-term goals mapped out over all data management
Establish processes for governing the identification, collection, and use of corporate metadata as well as create methods for tracking such data for quality, completeness, redundancy, and improvement
Create data capacity planning, life cycle, duration, usage requirements, feasibility studies and other related required tasks
Strategize what the best practices are in relation to data security, backup, disaster recovery, business continuity and archiving. Ensure all strategies are in compliance with enterprise procedures and regulations
Act as liaison to vendors and service providers to select the products or services that best meet company goals and requirements
Select and implement the appropriate tools, software, applications, and systems to support data technology goals. Drive best practice in regards to data warehouse, business intelligence, and reporting technologies
The Data Architect will oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality. Collaborate with project managers, address data related problems in regards to systems integration and compatibility, as well as act as a leader for coaching, training and providing career development to stakeholders
Developing and implementing key components as needed to support global application development and support initiatives
Documenting enterprise data architectures and environments in order to maintain a current and accurate view of global data landscape
Identifying and developing opportunities for data reuse, migration, or retirement
Minimum of Bachelor’s Degree or equivalent degree
Ability to review and provide feedback for complex data models implemented by partners
Proven experience working in an outsource and offshore environment on major delivery programs
Knowledge of all phases of SDLC and full lifecycle implementations
Database Technologies: Acutate, Business Objects, MS Access, PowerMart, SQL, Trillium, Oracle, Sql Server, MySql, Teradata etc
Others – ERWIN, SQL Designer, other data modeling tools

Data Modeler Resume Examples & Samples

Understand and translate business requirements into data models supporting long-term solutions
Work with the development team to implement data strategies, build data flows and develop data models
Create conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
Validate business data objects for accuracy and completeness
Analyze data-related system integration challenges and propose appropriate solutions
Ability to understand and integrate data from multiple systems, domains, and activities into the Operational Data Store model
Guide the development team and others on project limitations and capabilities, performance requirements and interfaces
Ability to communicate to business users the decisions made in the data model for optimal performance
Design and development of data flow and transformations (input and output)
Data standardization and quality
8-10 years of Experience
Expert in dimensional data modeling for building structured data warehouses
Should have implemented at least 2 full projects of large scale
Data warehousing experience with data modeling of a min of 6 yrs
Hands on experience with any modeling tool, Power designer will be an advantage
Deep understanding of business processes (Key Process Chains) in high tech manufacturing business
Exposure to Hadoop will be nice to have
Exposure to ECC and understanding of SAP ECC data models will be a huge plus
Experience with agile or other rapid application development methodologies
Experience with a RDBMS –Microsoft SQL Server, Oracle, DB2, SAP ECC
Experience in an market leading ETL tools (SAP DS, SSIS) and reporting tools (such as BO and Tableau) is a plus
Experience collaborating with global teams
Excellent verbal, written and presentation communications skills, organizational capabilities, and collaborative interpersonal skills

Senior Data Modeler Resume Examples & Samples

Develop and maintain various data subject area data models for Data Warehouse, Operational Data Store and Data Marts
Experience in Building complex, large scale logical data models with Erwin, E/R Studio, or another data modeling tool
Experience in relational and dimensional schemas for Enterprise Data Warehouse
Experience in data modeling (physical and logical), ER diagrams, data dictionary, data mapping
Experience in Data Architecture and database design
Experience with Database technologies (e.g. Oracle)
Compose accurate and complete definitions for entities and attributes
Design and Validate data solutions which are achieved through the application of industry proven architectural principles, standards and governance
Gap analysis
Data Mapping / Data Lineage mapping
5+ years of experience working as an Data Warehouse Data Modeler / Architect
Oracle 11g
Data Movement Architectural Patterns
Thorough understanding of system development life cycles

100

Senior Data Modeler Resume Examples & Samples

8 or more years of experience with database architecture and design solutions
5 or more years of experience with data modeling tools such as Embarcadero ER/Studio or Erwin Data Modeler
Extensive background in data modeling supporting application development and/or data warehouse development
Clear understanding of relational and dimensional models, keys and constraints, normalization and indexes
Experience in creating and maintaining enterprise data dictionary and logical/physical data models
Hands on experience with writing SQL statements and running database queries in support of data analysis
Experience in documenting and writing SOPs
Experience in creating data flows and diagrams using tools like Visio
Excellent organizational skills with the ability to work independently
Experience with SDLC
Experience working in Agile environments
Experience with version control tools such as Rational Clear Case or SVN
Knowledge in Oracle or Sybase database
Knowledge in ETL process or data replication

101

Data Modeler Resume Examples & Samples

5+ years health insurance experience
5+ years experience of data modeling related projects (e.g. data warehousing, migration, data quality, data governance, analytics)
5+ years data analytics tools exposure (e.g. Business Objects, Cognos, SAS, Tableau)
Consulting and development project experience

102

Data Modeler Resume Examples & Samples

Develop Data Models, mapping documentation, ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code
Works independently to develop, configure, code and test programs from specifications
Presents all work in design review and code review sessions to senior team members, and must be able to explain and support decisions made and actions taken
Interfaces with business analysts, project managers and clients to clarify requirements
Assists other team members with their assignments (e.g., onboarding junior team members)
Tests own work and contributes to the development of test plans
Prepares documentation that describes installation and operating procedures, including application user guides, with limited guidance
Can troubleshoot applications problems, with limited support
Required to create or choose an approach or procedure from a variety of complex options for addressing a work task
Has developed an understanding of the technical architecture, application landscape and IT environment, as well as tools used in development, deployment and testing
Understands the structure and processes of the IT organization, including the roles of IT team members and the information and/or resources they may require

103

Data Modeler / Analyst Resume Examples & Samples

5+ years of experience with database design and data modeling
Experience with configuration or version management of data models, including performing ER or studio tool maintenance, as needed
Experience with creating or maintaining data flows and other documents using Visio or equivalent tools
Knowledge of SQL, including running queries against the database for the purposes of data analysis on the Sybase platform
Ability to enforce documented standards and provide guidance to application teams
Ability to manage a SharePoint site and keep the contents updated
Experience with SDLC preferred
Experience with using the Rational suite of products and SVN a plus
Knowledge of Oracle a plus
Ability to work in a team environment and independently on assigned tasks
Possession of excellent documentation and analytical skills

104

Data Modeler, Senior Resume Examples & Samples

3+ years of experience with data modeling tools, including Embarcadero ER, Studio, or Erwin
Experience with data modeling, including supporting application development or data warehouse development and creating data flows and diagrams using tools, such as Visio
Experience with defining and implementing naming standards, abbreviations, guidelines, and best practices
Experience with creating and maintaining an enterprise data dictionary and logical or physical data models
Experience with writing SQL statements and running database queries in support of data analysis
Experience with documenting and writing SOPs
Knowledge of relational and dimensional models, keys and constraints, and normalization and indexes
Experience with working in Agile environments a plus
Knowledge of Oracle or the Sybase database a plus
Knowledge of the ETL process or data replication
Possession of excellent analytical and organizational skills, including working independently

105

S/hana Cds/hana Data Modeler Resume Examples & Samples

Minimum of 2-3 years’ hands-on and deep experience with HANA Enterprise (data architecture, data modeling, information modeling, SQLScript development)
Minimum of 1 year hands-on experience with Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA, as well as deep development knowledge of Basic, Composite, and Consumption Views
Minimum of 1year hands-on experience with S/4HANA Embedded Analytics, including development of Smart Business Tiles, Multi-Dimensional Reports, and Analysis Path Framework (APF)
Minimum of 3-5 years’ experience in Enterprise Data Warehouse architecture, data modeling and development
Expert data architecture and data modeling skills including 3rd NF, Dimensional, ODS and other techniques using various modeling tools
Minimum of 3-5 years’ experience with SQL and database procedural languages such as PLSQL and T-SQL
Experience with the architecture, design, development and testing of Data integration/acquisition process
Experience with SAP HANA Enterprise in following areas preferred
Analytical skills, problem solving ability
Experience with multiple data integration tools (including ETL, data replication and data streaming tools) a plus
Experience with database performance tuning (including optimizing HANA information models, SQLScript stored procedures and ETL data flows) a plus
Experience with SAP ECC a strong plus (functional modules, underlying data structures, BW)
Previous consulting experience required; Big consulting company experience a plus
Ability and desire to mentor/coach others in a team environment
Ability and desire to support sales team
Ability and desire to share expertise with internal and external audiences
Ability to demonstrate leadership skills through a variety of activities (related to practice, projects, accounts and prospects)
Experience and interest in speaking at events or writing intellectual property a plus

106

Lead Data Modeler Resume Examples & Samples

Proactively engage with the project stake-holders and understand requirements
Logical and Physical modeling for Data warehouse
Perform data analysis on source systems, data warehouse subject areas, and reporting data structures
Leading data modeling discussions with Business in JAD sessions
Strong SQL skills to pull data from Teradata/Oracle and perform usage analysis and/or data profiling
10 or more years of experience in Data Warehouse environment with emphasis on data modeling involving design, coupled with strong knowledge of end-to-end data warehouse development life cycle (data integration, logical and physical modeling, and data delivery) supporting enterprise analytics and BI solutions
At least 8-10 years of progressive experience in Data modeling with emphasis on Dimensional modeling
Five or more years of enterprise level data design and development
Hands on experience with modeling tool such as ERWIN or another tool
Functional knowledge/experience of the Consumer Banking/Financial Services Industry

107

Data Analyst / Data Modeler Resume Examples & Samples

A bachelor's degree in computer science, or a related field OR commensurate experience is required. The candidate must have a minimum of 8 years IT experience focused in software design with emphasis on the following technologies and tasks: UML (Use Case, Activity, State Chart, and Class Diagram), ERD and database normalization options, ETL, Data Warehousing, Business Intelligence, Data Marts, Cognos
Advanced RDBMS Database experience (one or more of the following: DB2, Oracle, SQL/Server or comparable) including database modeling, SQL query, and procedural programming
Experience using Requisite Pro, RUP, and Scrum
Data Warehousing / HIPAA 5010/ICD-10 experience a big plus!

108

Data Modeler Resume Examples & Samples

50% Data Modeling
Understand business requirements and build conceptual, logical and physical data models across multiple data domains or functions (customer, vendor, finance, procurement etc.)
Works with BU/function to determine high level project requirements and then translate those into data domain specific requirements for design
Identify and own integration scenarios across data domains, major process areas as well as across teams
Develop and maintain complex enterprise or project-specific architecture by providing significant insight into definition of target or solution architecture, architecture reviews and selection efforts
Assess impact of proposed changes and upgrades on architecture
Identify and address inter-application dependencies and interfaces
Provide support/consultation for detailed design, deployment, production support and ongoing Data Governance activities
Maintain domain related governance process and data model for the Master Data hub
Develop, recommend and implement continuous solution improvements to increase accuracy, reduce cost and increase speed to market
30% Data Catalog/Metadata Management
Works with the Enterprise Architects/Data Architects to define strategy for creating & maintaining metadata about Cargill’s diverse applications & data sources
Support the design, build, test and maintaining of the Data Catalog, a key component of Cargill’s Big Data and Advanced Analytics platform
20% Business Partnering, Relationship Management and Consulting
Regularly interfaces with other architects, analysts, process designers, and BU/Function subject matter experts to understand and evaluate business requirements
Provide technical consultation and recommendations for Data Management solutions for multiple BUs/FNs aligned to their business drivers and goals
Provides general awareness of projects creating Data Management opportunities for the organization and where they may impact existing DM solutions
Collaborates with key stakeholders, peers and project leadership to ensure DM solutions are implemented successfully including resolution of integration issues across teams
6 + years of experience in IT or business/industry experience
4 + years of experience building logical and physical data models
2+ years of experience using data modeling tools such as ER/Studio Data Architect, Erwin etc
Ability to lead the development of integrated solutions involving process, data, and technology
Demonstrated strong business facing skills
Proven ability to work effectively within a large organization that operates using matrix management structures
The ability to define data management solutions that cross multiple process areas and teams
Experience working in a global team
Experience with solution architecture, preferably with a data architecture component
Multiple implementation experiences with Major ERP, CRM, SRM and SCM solutions
Experience working on at least one full lifecycle ERP (Enterprise Resource Planning) or ECM (Enterprise Content Management) implementation, preferably in a global organization
Experience in building enterprise data models
SAP ERP Experience
SAP MDG Experience
Informatica MDM Experience
Master Data Management solution experience, including centralizing and consolidation
Information Steward Experience

109

Senior Data Modeler Resume Examples & Samples

Understand business requirement and create Conceptual, Logical and Physical models
Design and maintain data architecture, database that is used in relation with data architecture that is flexible and scalable
Define the overall data warehouse architecture (e.g., ETL process, EDW, Data Marts)
Define technical requirements, technical and data architectures for the data warehouse
Assist in the development of strategies for archive, data recovery, database implementation and data acquisition
Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
Design and direct the information access and delivery effort for the data warehouse
Work with other IT groups and departments to assist in the coordination of future activities and plans
Identify and recognize areas where the data models can be modified or enhanced to provide future business requirements
Lead and sometimes direct the work of others; works with a team to accomplish common goals
Experience in data modeling, meta data management and data integration tools
Expert in developing data models – relational, dimensional, subject areas, and business models
Experience in supporting as well as implementing Oracle and SQL data infrastructures
Experience in indexing, SQL performance tuning and optimization techniques
Knowledge of the entire process behind software development including design and deployment; SOA knowledge and experience is also preferred
Exhibit knowledge of the design, development and maintenance of data models and their components using different tools
Understand BI tools and technologies as well as the optimization of underlying databases
Hands on experience of SQL queries and reporting tools
Bachelor’s Degree in Computer Science, Information Systems, or other related field; 8-10 years relevant analysis and programming experience may substitute for the degree
5 years (minimum) work experience with data warehouse/business intelligence projects using Data Warehouse best practices
5-7 years’ experience working as a data warehouse data modeler
5 years’ experience data warehouse/business intelligence projects using Data Warehouse best practices
Exceptional analytical skills necessary to identify and resolve technical issues or problems
Experience in clinical setting is preferred

110

Data Modeler Senior Specialist Resume Examples & Samples

Data preparation (sourcing, acquisition, integration)
Information delivery (portals, mobile)
Enterprise / Corporate Performance Management

111

Data Modeler Specialist Resume Examples & Samples

Develop, maintain and support GWS SSIS framework
Develop, maintain and support SSAS Cubes
Develop, maintain and support reports in Tableau
Resolve any data warehouse issues in a timely and accurate manner, whilst ensuring all key controls and SLAs are strictly adhered to
Perform root cause analysis of on-going issues and implement an optimal solution with data architect
Reviewing existing stored procedures, advise on improvements using advanced T-SQL
Creating ad-hoc reports and data extracts for business needs
Troubleshooting reporting issues, ETL job failures, optimizing query performances
Support the whole project life cycle from designing, development, through implementation and post implementation support
3+ years’ experience in developing and administering Microsoft SQL Server
Advanced T-SQL development E
SSIS E
SSAS HD
MCSE D

112

Data Modeler Resume Examples & Samples

Map logical entities to the conceptual Data Model
Ensure data objects adhere to defined enterprise standards and best practices
Create logical data model using ER STUDIO as the modeling tool
Experience with XML data and modeling XSDs
Support DDL PROD implementation
Support post-production validation of DDL
Experience with data management standards
Experience with physical data structure design in Oracle & SQL Server using ER Studio
Mortgage/finance industry data modeling experience
Proven ability to quickly earn the trust of key stakeholders
Thrives in an environment with changing priorities
Able to navigate through a large corporate environment and ensure appropriate processes are met

113

Senior Cassandra Data Modeler Resume Examples & Samples

Analyze functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models
Create data models (logical) and DB designs (physical), that depict the business areas and systems in the customer portal to ensure the integrity of the business data is being maintained; incorporate applicable standard data elements; ensure solutions are accessing the system of record for shared or enterprise data; and ensure adherence to technical DB design standards in accordance with the approved WFS Data Modeling and DB Design Standard
Refine existing data models of WFS’s business areas and systems
Facilitate data modeling sessions, ranging from information gathering to model validation
Create the data architecture sections of system design document for development efforts
Provide requirements analysis support to development teams and educate project and development teams on the proper usage of the data structures. Analyze data access and modification requirements to ensure efficient data retrieval/ ingestion and optimal DB design
Perform DB design, review DB design from development team, and generate initial data definition language, as needed
Design and develop a data migration strategy and source to target mapping to migrate the data out of the legacy systems into the Cassandra customer DB
Provide optimal design for structured and non-structured data using SQL and NoSQL databases
Enhance DB performance from physical DB design perspective
Provide technical advice and prepare technical documentation on data architecture related trends, issues, and tools and provide input into the agency-wide data architecture standards
Analyze relevant technical issues, data structures, and data, and at the discretion of the Development Manager, Program Manager, or Business Analyst
Breadth and depth of skill to build and deliver scalable data and reporting solutions for WFS
Deep knowledge and experience with the Cassandra, related software tools, and performance optimization
An obsession with delivering an exceptional customer experience and site resiliency
Desire, initiative and resourcefulness to learn new tools, frameworks, languages
A commitment to WFS ideals of efficiently delivering the world’s energy needs

114

Enterprise Data Modeler Resume Examples & Samples

Development of Business Intelligence Data Warehousing areas include: Data Analysis, Data Modeling
Responsible for detail Data analysis and translates Business requirements into logical data models
Derives data designs and identifies opportunities to re-engineer data structures, and recommends efficiencies as it relates to data storage and retrieval
Responsibilities include translating business requirements into data designs
Working knowledge of the software implementation lifecycle, leadership skills and the ability to work well with both business clients, developers and other architects
Development of data warehousing centric Data Analysis and Data Modeling strategic direction for the department
Serve as a liaison between the business experts/users and the project technical team to ensure the users requirements are understood and interpreted correctly by the technical team
Ability to participate as a senior Data Analyst gathering of source systems, processing logic, content and operational system usage
Bridges gaps across business areas, operational business units, infrastructure team, and Data Warehouse development teams
Experience in capturing and presenting all levels of Enterprise Metadata
Works on multiple large complex projects with cross functional teams and business
Applies broad in depth retail business and technical knowledge to establish direction
Develops technical architecture, data model, and documentation of all projects
Enforces data and technical solutions, standards, and governance
Generates documentation for the program or project and other technical deliverables
Stays current in new technologies as well as new opportunities to develop knowledge and staff
Excellent communication (written and verbal). Full life cycle experience in Data Warehousing, Data Modeling, Data Integration, and Master Data Management
Excellent understanding of solutions architectural principles, data integration, and data warehousing

115

Data Modeler / Analyst Resume Examples & Samples

Develops/manages complex data models (conceptual, logical, & physical) in multiple formats (relational, star/snowflake, object-oriented, etc..)
Analyzes & acquires data from primary and secondary data sources – creating mapping specifications/requirements for use by ETL development resources
Drives data modeling best practices within the team
Works with business partners to prioritize business and information needs
Maintains knowledge on current and emerging developments/trends for assigned areas of responsibility, assesses the impact, and collaborates with management to incorporate new trends and developments in current and future solutions
Champions and enhances organizational initiatives by positively influencing and supporting change management and/or departmental/enterprise initiatives within assigned areas of responsibility
Serves as a resource to team members and applicable internal/external stakeholders on more complex assignments/projects for his/her assigned areas of responsibility
Identifies and recommends process improvements that significantly reduce workloads or improve quality for his/her assigned areas of responsibility
Analyzes, designs, codes, debugs, integrates and tests increasingly complex software application solutions for systems
Determines how existing applications, systems, databases, interfaces and/or hardware can interact to meet new and emerging enterprise initiatives
Identifies potential application solutions by understanding increasingly complex business/technical problems and opportunities
Provides input and validates increasingly complex project plans, test plans and implementation plans
Creates increasingly complex technical specifications from business requirements/business specifications
Consults and/or participates in the requirements, design and coding walkthroughs to ensure the development of quality solutions
Investigates and resolves increasingly complex problems including providing support for production systems in a timely manner
Proactively identifies problems and presents/develops solutions
Communicates effectively with internal stakeholders and management
Defines detailed development tasks, task dependencies and estimates to complete work
3 - 5+ Years experience in application development that directly aligns with the specific responsibilities for this position (Required)
2+ Years experience implementing relational database designs, data warehousing, data architecture, & data modeling, including strong knowledge of various data modeling approaches and practices (experience with 3NF, star schemas, and multi-dimensional designs)
Experience with ERwin Enterprise Data Modeler Suite or equivalent modeling software (Required)
Experience with data quality management and metadata management
Strong knowledge of various SDLC practices in both waterfall and agile team environments
Hands-on experience with large, transactional databases (Oracle 11g or 12c) including strong SQL & PL/SQL skills
Good communication and interpersonal skills for interacting and collaborating with developers, analysts, and business staff throughout the organization. Ability to express complex technical information in a user friendly language and style and present information effectively in 1-on-1 and small group settings

116

Data Modeler Resume Examples & Samples

This position requires working onsite daily at our facility in Vancouver
Working with the client to obtain detailed information on every data field in the legacy database, a release of the client’s production database
Evolves the present-case data model into the future-case data model, working with the business analysis, development and test teams
Transforms and migrates the data into the future-case data model using the Dell data modernization tools
Maintains the data model and migration processes during development
Ensures the quality of the migration
Executes the data migration
Produces test data for the development team using the DMT and DMW
Works closely with the client to cycle migrated data

117

Data Modeler Analyst Resume Examples & Samples

At least 2 years of technology experience
Experience as a Data Modeler and knowledge of Erwin is a plus
Experience with Oracle, DB2, or Teradata databases is a plus

118

Logical Data Modeler Resume Examples & Samples

Identifies cause of data issues and works with broader team to resolve issues
Leads design reviews of data deliverables such as models, data flows, and data quality assessments
Provides senior level data modeling services, including updating and building logical/physical database models
Works closely with the development and QA teams to communicate the business rules and ensure testing use cases target the quality and integrity of the data model
Works with senior DBA staff to identify and resolve issues or transform logical database models into physical database designs that represent the business rules while optimizing the performance and maintainability of the design in the physical database
Uses a variety of information gathering techniques (e.g., interviews, diagrams, facilitation) to gather complex business data requirements from internal business clients and development teams
Provides design feedback to web service development developers to highlight design considerations that impact data quality and integrity of the model
Works closely with other application areas within the company to ensure that data integrations are efficient, follow AA technical standards, and meet the business requirements
Ensures that all data deliverables comply with AA security policies and regulations (PCI, PII)
Minimum 5 years of experience in data modeling, including conceptual, logical, physical, Operational data store
Experience with a modeling tool (Embarcadero ER/Studio, Erwin, etc)
Experience designing and developing logical and physical data models
Experience in data architecture and strong understanding of data movement and data layout
Some Technical experience in coding or database administration or system administration would be preferred
Experience working in a master data management solution or other large CRM system
Experience working with database (Oracle/SQL Server) and writing SQL
Strong facilitation experience with business stakeholders to capture data requirements
Experience in identifying and resolving data quality issues to the team and business partners
Strong analysis and deep problem solving skills
Must be a self-motivated driver to find out data issues and resolve them quickly
Must be a self-motivated driver to understand the broader system
Ability to evaluate DDL for completeness and accuracy before submission to a DBA
Ability to perform data analysis, and data discovery

119

Data Modeler Resume Examples & Samples

Analyze business reports and analytical requirements
Conduct interviews and brainstorming discussions with teammates
Develop logical and physical dimensional data models
Ensure data objects adhere to defined standards and best practices
Statistical Data modeling, including reverse and forward engineering
Programming in R (required), SAS (desired), SPSS
Data collection, cleansing, analysis, inference
3+ years of overall experience in data modeling
Experience with data analysis, data profiling, and data mapping
Experience maintaining and coordinating a data modeling effort in an Agile SDLC environment
Experience with various data modeling tools
MUST have an ACTIVE SECRET security clearance and be confident no personal issues will prevent the government from issuing a work-site access badge. This includes successful completion of, work experience, education, credit/financial and criminal history records checks
U.S. Citizenship is required

120

Data Modeler Resume Examples & Samples

Participate in requirements definition, analysis and the design of logical and physical data models
Map business requirements to logical and physical da ta models
Conduct data model reviews with project team members
Generate, modify, and version data object scripts using HCA source control solution. Enforce & promote standards and best practices in data modeling efforts
Improves data models by evaluating results, implementing enhancements, develop and maintain source-to-target mapping documentation
Work independently to develop, configure, code and test programs from specifications and agency needs
Presents all work in design review and code review sessions to team members, and must be able to explain and support decisions made and actions taken
Interfaces with business analysts, project managers and subject matter experts to clarify requirements
Understand the structure and processes of the data management and analytics organization, including the roles of team members and the information and/or resources they may require
Provides technical consulting and advises teams and customers on the design of conceptual and logical data models resulting in an efficient and effective physical design for all internal and enterprise systems
Studies and documents existing and proposed data definitions, uses and characteristics for reuse and integration opportunities. Defines data elements and data relationships based on existing agency data architecture standards. Identifies master data candidates and collects metadata
Collaborates with HCA's Data Architect to ensure application of agency standards, policies and procedures for creating and maintaining enterprise data models and documentation
Participate in data architecture sessions and promote integrated systems and controlled data redundancy
Develop highly complex and cross-functional business intelligence and custom Extract, Transform, and Load (ETL) solutions
Ability to work effectively as a member of a multi-disciplinary team
Ability to work in a fast-paced, agile environment
Commitment to quality, diversity, and public service values including a demonstrated commitment to meeting customer needs
Must be extremely responsive, able to work under pressure in crisis with a strong sense of urgency
Must be detail oriented and possess strong problem-solving skills and ability to analyze for potential future issues
Responsible, conscientious, organized, self-motivated and able to work with limited supervision
Exhibits sound judgment and the ability to make reasonable decisions in the absence of direction
Advanced knowledge of data warehouse/business intelligence methods, tools, standards, and technical architecture best practices; the ability to analyze and develop technical capabilities and apply best practice principles to best meet agency needs
Ability to work collaboratively with multiple different team members including business, technical and external stakeholders
Demonstrated technical expertise with Oracle, Microsoft SQL Server or other Relational Database Management System (RDBMS)
Demonstrated ability in developing, Implementing Extract, Transform ad Load (ETL) procedures and Business Intelligence Solutions
Three professional references
Persons under final consideration for initial appointment with HCA are subject to a background check*

121

Senior Data Analyst / Data Modeler Resume Examples & Samples

Learn the current data flows and be able to change or improve upon them based on current use cases
Demonstrable experience using data modeling tools - e.g., ERStudio
Work with Business & Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc
Background in ETL development, data analysis, mapping, and automated loading preferred
5+ years of hands-on experience on data architecture, data analysis and logical/physical data modeling
Good Concept of Dimensional modeling
Good Concept of Data Warehousing

122

Enterprise Data Modeler Resume Examples & Samples

Data Architecture and Modeling, tasks include
Develop, document and maintain conceptual, logical and physical data models for medium to high complexity projects
Capture technical metadata through data modeling tools
Convert logical data models into the first cut physical database models and generation of Data Definition Language (DDL)
Bachelor’s degree in business management, computer science, information technology, or equivalent education and/or 10+ years work experience in Data Management field
A minimum of four (4) years of experience working as a data architect, modeler and/or business intelligence designer utilizing a set of frameworks, methods, and techniques to develop complex data models in support of business requirements
10+ years’ experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data
7+ years’ experience with Oracle and/or SQL Server RDBMS, PL/SQL & SQL
5+ years’ experience in ETL tools such as Informatica, ODI & SSIS
5+ years’ experience in Data Modelling tools like Embarcerdero
Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills
Good understanding of Data warehouse and Operational Data Store concepts
Good understanding of Informatica/ODI/SSIS or related ETL tools
Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk
Experience with Data Modelling tools such as Embarcerdero / ERWIN / SQL Modeller
Familiarity with development methodology such as Agile, Waterfall and Systems Engineering

123

Senior Data Analyst / Data Modeler Resume Examples & Samples

Gather and analyze business requirements
Architect and design Data Warehouse infrastructure and solutions
Develop technical specifications and design documents
Develop, enhance, and integrate Data Warehouses / Data Marts and Business Intelligence Solutions
Deploy and maintain Data Warehouses / Data Marts
5+ years of Data Analysis with mindset of translating into Data Marts
3+ years of work experience enterprise size Data Warehouse
3+ years of work experience writing SQL
Familiarity with ETL tools
Health care or Insurance (Claims) industry experience
Experience with Microsoft Parallel Data Warehouse (PDW)
7+ years of work experience enterprise size Data Warehouse
7+ years of work experience writing SQL
Experience querying data from multiple database platforms

124

Senior Data Modeler Resume Examples & Samples

Partners with Business and IT groups to design and implement data and modeling solutions that meet or exceed organizational initiatives and are consistent with enterprise architectural standards
Ensures compliance with all architecture directions and standards through cross organization consulting and direct involvement in development efforts
Develops and documents artifacts and templates in the chosen tool repository
Understand the Project Proposal and assist the team in analyzing how the new system or functionality can be integrated in the environment, identifying existing systems, concepts, possible data sources and issues
Analyze data-related systems integration opportunities and challenges
Ensure solution designs address performance requirements and reusability, availability, integrity and security challenges, and business functional requirements
9-10 years' experience in a Data Modeler role with deep knowledge of Relational and Dimensional Modeling in a Complex Data warehouse environment
MUST be strong in Dimensional & 3NF Data modeling
To be well versed with financial regulations related to capital adequacy, BSA AML compliance, regulatory reporting and IHC
Should have Good inter personals skills
Expertise in implementing Data warehouse solutions, Operational data stores and real time data integration
Experience with Development Methodologies, Databases Platforms (Teradata, Oracle/ SQLServer), including deep knowledge in SQL & PL/SQL
Expertise in Data Modeling tools (Erwin/Model Manager)
Superior relationship management, consultative, presentation, and communications skills

125

Data Modeler Resume Examples & Samples

Assess and interpret customer needs and requirements
Involved in solving moderately complex problems and/or conduct moderately complex analysis
Provide explanation and information to others on difficult issues
Coach, provide feedback and guide others
Maintain knowledge of current domains and strategic roadmaps
Identify/quantify scope and impact of business changes on systems
Incorporate software and system architecture into conceptual designs
Support applicable modeling efforts (e.g., data modeling, process modeling, hardware modeling, performance modeling)
Provide oversight of conceptual designs to ensure alignment with enterprise architecture governance (e.g., principles, policies, standards, future-state reference architectures)
Maintain awareness of current technology assets, and the applicability and capability of each
Responsible for maintaining awareness of current business and industry issues/trends and incorporate into enterprise architecture designs as appropriate
Undergraduate degree or a minimum of 5 years of IT experience
5+ years of Information Management Experience (Data Modeling, Database Design, Data Integration, etc.)
Solid understanding of industry patterns for data architecture and integration

126

Dhts Data Modeler Resume Examples & Samples

Work independently or partnered with other IT analysts to gather business and technical requirements from users and business analysts
Capture and document project scope and requirements
Develop a logical and physical data model to support project requirements
Document and publish relevant metadata and specifications
Work under the oversight of the BI Architect on project BI Design
Maintain a shared data model in ERWin
Perform source system analysis and data profiling
Generate SQL statements to demonstrate and validate data model and guide development
The Data Modeler will be expected to leverage their knowledge of data modeling best practices along with industry data expertise and data modeling tool expertise
Solid and effective written, interpersonal, oral and presentation skills
Excellent analytical and problem-solving ability
Skilled in requirements gathering and data analysis
Data sourcing, data mapping and managing metadata
Experience with Agile development methods preferred
Proven ability to produce logical flows to support the design of data solutions
Experience using data modeling tools - e.g., ErWin
Evaluate existing data models and physical databases for variances and discrepancies
Validate business use cases for accuracy and completeness of proposed data models
Ability to plan and lead meetings with diverse participants
Ability to effectively lead a project team In addition to the above
Leadership for data modeling team including but not limited to

127

Data Modeler Resume Examples & Samples

Work with offshore team members
Participating in data modeling discussions with Business in JAD sessions
Work with lead to establish standards around flexibility of the data model to ensure deviations are within established guard rails
Define/maintain application specific solution designs that align to target state data ecosystem architectures, including viable alternatives with value propositions / trade-offs
Assist with defining data model development methodologies, principles, standards, and governance considering People and Process optimization aspects
Decompose requirements into project specific deliverables and prioritize
At least 5+ years of progressive experience in Data modeling with emphasis on Dimensional modeling
Hands on experience with Massively Parallel Processing (MPP) and NoSQL database technologies used in modern data warehouse architectures supporting Discovery Analytics and BI
Understand Big data architecture for analytics and is capable of developing solutions per firm standards
Working in a fast pace environment handling multiple project deliverables
Excellent interpersonal skills, written and verbal communication skills

128

Data Modeler Resume Examples & Samples

4 Year IT College Degree/Masters preferred or equivalent work experience
10 years in business environments in Data Modeling, primarily in Manufacturing/Supply Chain
Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, PHYSICAL data models
Experience with industry mainstream modeling tools such as Erwin, Erstudio and PowerDesigner (ERwin required)
Ability to evaluate existing data models and physical databases for variances and discrepancies
Experience with managing meta data for data models
Ability to work with Business Analysts and Business Users and Data Owners
Ability to work with Data Architects and Data Management team
Knowledge of data access security options
Knowledge of more than one RDBMS platform such as SQL Server, Oracle, Netezza, Teradata and DB2 / UDB
Responsibilities
Acts as a champion to promote usage and adoption of models across the Enterprise
Creates, validates, publishes and maintains enterprise logical data models
Responsible for the Data Model repository maintenance and for the development and administration of the appropriate roles
Participates in the development and maintenance of technical and business metadata including table and column descriptions and an overall business glossary of terms
Assists with the design of the analytic data structures and the associated semantic (views) layer
Works with Business Analysts, Business Users and Data Owners to understand business needs
Works with other Data Architects and Data Management team
Leverages and enforces standards for data naming conventions to ensure consistency and reuse of data models
Performs reverse engineering of physical data models from databases and SQL scripts
Validates business use cases for accuracy and completeness of proposed data models
Participates in technical and design reviews and acts as the subject matter expert on source and target data structures

129

Senior Data Modeler Resume Examples & Samples

Bachelors Degree in a technical or business discipline or equivalent technical expertise
General knowledge in the following areas: IT concepts, strategies, and methodologies, IT architectures and data standards, and general knowledge of a business function(s) and of business operations
Knowledge of data design and tools
Proficiency in SQL and DBMS languages and tools
Knowledgeable in new and emerging technologies

130

Data Modeler Resume Examples & Samples

At least 10 years’ experience in data integration, and design of data flows from multiple sources and 3rd party collection processes for consolidation into data warehouse
At least 5 years’ experience developing predictive and prescriptive analytical tools; optimization modeling
Advanced knowledge of Tableau or Microsoft Power BI
Advanced SQL and VBA

131

Data Modeler Specialist Resume Examples & Samples

Working with project stakeholders and solution architects to understand requirements and help define appropriate solutions
Working with database administrators to set up and configure databases in accordance with the project needs
Working with project stakeholders to develop high-quality new data models
Working with project stakeholders to ensure quality of existing data models and database designs
Ensuring accurate and timely resolution of problems, applying structured development and implementation techniques
Delivery of online IT products and services
Ensure customer satisfaction through delivery of a high level of service
Working closely with external and internal service providers and maintain consistent standards and quality assurance
Previous experience of real time database based development using Oracle RDBMS
Practical experience of developing and implementing robust and scalable data models
Experience with overall system design, configuration, customization, integration, testing and support
Experience with all or some of the modern software engineering techniques e.g
Test-Driven Development (TDD)
Continuous Integration (CI)
Code validation and quality analysis
Solid written and verbal communication skills and able to articulate the technically complex to be understood by both technical and non technical personnel
Ability to manage conflicting priorities and multiple tasks
Stakeholder management skills at a technical and non-technical level
Good critical reasoning and problem solving skills – sticks to the problem until it is resolved
Customer-orientated, whether responding to support queries or developing new functionality

132

Data Modeler Resume Examples & Samples

5+ years of experience with architecting database solutions and database design
3+ years of experience with data modeling tools, including Embarcadero ER or Studio or Erwin Data Modeler
Experience in data modeling, supporting application development and data warehouse development and creating and maintaining enterprise data dictionary and logical or physical data models
Experience in defining and implementing naming standards, abbreviations, guidelines, and best practices
Experience in creating data flows and diagrams using tools, including Visio
Knowledge of relational and dimensional models, keys and constraints, normalization, and indexes
Experience with working in Agile environments
Experience with version control tools, including Rational ClearCase or SVN
Knowledge of Oracle or Sybase database
Knowledge of ETL process or data replication

133

Data Modeler Resume Examples & Samples

Bringing a solid technical expertise of creating abstract data models to be used as a basis in a highly available and scalable database architecture used for real time access
Using appropriate state-of-the art tools to reveal data models lying behind existing database designs
Working on enhancements to databases already in operation
Working with database administrators to design necessary changes to existing database designs
Embrace emerging technologies and solutions in order to ensure our online experience continually evolves to address the needs of the market and our customers
Excellent interpersonal skills and strong emotional intelligence
Able to develop scalable solutions that can be utilised by current and future channels – e.g. mobile
Stakeholder management and interpersonal skills at both a technical and non-technical level
Able to work in a collaborative environment
Understanding the importance of real business engagement in all stages of IT product lifecycle working in both waterfall and agile delivery methodologies
Excellent attention to details
Experience with large Full Life Cycle project implementations
Experience of setting, refining and implementing technical standards
Experience within a customer focused environment
Consumption and production of Application programming interfaces (API’s)

134

Data Modeler Resume Examples & Samples

Understand and translate business needs into data models supporting reporting and ad-hoc analysis
Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models
Create logical and physical data models using best practices to ensure high data quality
Optimize and update logical and physical data models as needed
Maintain conceptual, logical and physical data models along with corresponding metadata
Assist ETL and BI teams and end users to understand the data model
Create SQL code from data model and coordinate with DBAs to create non-prod and pre-prod databases

135

Data Modeler Resume Examples & Samples

Serves as subject matter expert responsible for applications related to the Microsoft .NET environment
Performs needs assessments, data analysis, data base design, programming, testing, debugging, deployment, implementation and documentation of databases and applications within the Microsoft .Net environment
Works with application developers from High School Scheduling and Transcripts (HSST), Automate The Schools (ATS), Sourcecorp, Special Education Component (SEC) and the Child Assistance Program (CAP) systems, to code programs, perform uploads, develop stored procedures of views, update processes for various applications, assist with the maintenance of databases and perform extracts
Provides data to outside entities such as the University Academic Planning Council (UAPC) and to the New York State Education Department regarding the eScholar system information
Coordinates and directs data management activities that include the migration of data from existing Department of Education databases to the Schools Interoperability Framework (SIF) database. Migration will occur as needed for new system development and for the migration of existing systems to the .Net environment
Performs data mapping, and data conversion. Develops business objectives for retrieving data
Defines data into precise data models which specify entities, attributes and relationships between the data
Assists in performing project planning, feasibility studies, cost-benefit analyses, impact analyses, and prioritization for tasks related to the migration of data from existing mainframe and SQL server databases and related applications to the SIF model. Works to troubleshoot, provide data services and resolve problems arising from the conversion of data from the Student Information System (SIS) to the SIF model
Works to ensure accuracy and completeness of data backup and recovery is completed. Monitors databases for optimal performance, best practices, policies and procedures
A four-year high school diploma or its educational equivalent and six years of satisfactory full-time computer software experience as described in "1"above, including one year in a project leader capacity or as a major contributor on a complex project; or

136

Junior Data Modeler Resume Examples & Samples

Design, develop and test deliverables in our Data Virtualization - Data Self-Service environment
Become the subject matter expert on toolset and technology - must demonstrate personal drive to achieve expert status
Review and manage work assignments (includes support cases) for team in an Agile environment
Estimate tasks and successfully deliver upon committed dates
Demonstrate ability to set and manage own priorities effectively in a dynamic organization
Be an effective listener, who can give timely and constructive feedback. Is willing to state opinions assertively and deals constructively with conflict situations. A problem solver as well as willing to comprise for a common effective and efficient solution
Work as a team; cross trains as well communicates effectively and efficiently in a virtual team environment
Support enforcement of security and access control measurements to safeguard database authentication and authorization infrastructure
Work closely with business analysis and application owners to review and detail project requirements and design
Identify opportunities for improvement and innovation
Assist in the preparation of designs and technical and/or functional specifications
Perform code reviews and work with teammates on according to company coding standards and best practices
Ensure successful implementation and support of project efforts by working with team on integration activities
Use ETL standards and practices toward establishing and following a centralized metadata repository
Work with business areas and IT to ensure integrity and proper integration for all sources of enterprise data
Bachelor of Science in Computer Science or equivalent years of relevant work experience
Strong knowledge of relational databases (SQL)
1-2 years of ETL development project experience
1-2 years of data design/development experience (data modeling, analysis)
Prior data integration experience; ETL, EII, etc
Knowledge of technical concepts, such as: logical and physical data modeling, performance tuning, code reviews process, data normalization processes, data integration methods, Agile SDLC, production support, etc
Microsoft BI Stack (SQL Server 2012, SSIS, SSRS) experience is highly preferred
Data Virtualization (JBoss) experience is a plus
Java experience is a plus
Travel industry experience is a plus
Understanding of the Agile and Waterfall methodologies

137

Senior Data Modeler Resume Examples & Samples

Expert level knowledge of GRC data elements, sets
Experience in atleast one end to cycle of implementing data strategy of large enterprise level platform
Proficiency in tuning efficiencies across data life cycle – acquisition, load, transformation and reporting
Able to develop conceptual, logical, physical models of data using tools mentioned below
Ability to develop related meta data and data dictionaries
Thorough working of tools such as ER/Studio, Power designer
Good understanding of Object models and their relationship with relational models
Should have experience of implementing enterprise level platform data modeling for a cross domain ( preferably) GRC project
Should have at least 8-10 years of experience
Modeling of data across relational and object structures
Knowledge of GRC data
Proficiency in data modelling tools
First class degree with excellent academic qualifications. B.Tech in analytical braches such as Comp science, IT

138

Senior Data Modeler Resume Examples & Samples

Data Sourcing Rules and Authoritative Data Sources
Taxonomies and Ontologies
Reference Data Management Methods and Practices
Data Provenance, Lineage and Design Traceability
Logical functional components typical of an Corporate Banking organization
Regulatory and Standards environment affecting the Banking organization, such as BASEL Risk Data Aggregation Principles, FDS, ISO 20022, SWIFT
Industry and Vendor Standard Data Frameworks, such as BIAN, and IBM FSDM
UML Class, State Transition and Communication diagrams
Rule Expression Languages and Grammars such as Regular Expressions, Backus-Naur Form, OWL

139

Senior Logical Data Modeler Resume Examples & Samples

Minimum 5 years of experience gathering business requirements
Minimum 5 years of experience working with Teradata, Oracle, SQL Server Databases, SQL
Has a strong fundamental understanding of project management, specifically in the SDLC and Agile methodologies
Excellent written and verbal communication skills to enable
Ability to lead meetings with technical peers regarding the requirements definition
Ability to communicate effectively with business, vendor, and project management staff
Can participate in ongoing decisions regarding study design, data collection, data analysis, and Methodology

140

Hana Data Modeler Resume Examples & Samples

Ability to lead and facilitate design workshops (Blueprint), assessments, planning sessions i.e. demonstrate leadership experience in upfront projects
Analyze, design, create HANA data models to solution complex data transformations
Harmonize master data and transactional data and building data models (in HANA from non-SAP source systems)
HANA view optimization and performance tuning
The resource will provide guidance on best practices and provide knowledge transfer to other team members for ongoing support
Experience with the architecture, design, development , testing & deployment of various development artifacts in HANA
Well versed with Information Modeling, Table designs, and HANA SQLScript
Well versed in designing business intelligence architecture and reports on HANA
Experience with Data Provisioning and Business Intelligence
Should have excellent understanding of the In-memory columnar database functionality
Should be able to design relational databases for complex business scenarios
Should be well versed with HANA Studio, Modeler, SQLScript debugging,
Strong expertise in database performance tuning as well as optimizing SQL queries
Experience with multiple relational, dimensional, and MOLAP databases
Experience working with S4 on HANA is a definite plus as is experience in extending standard models
Experience working with HANA Modeling Artifacts like - Attribute Views, Analytics, Calculated Views (Graphical and Script), stored Procedures and Functions required
Experience working with Data Services, Smart Data Access (Data Virtualization) in HANA is a plus
SAP Hana
SAP S/4 HANA

141

Data Modeler Resume Examples & Samples

Conceptual data modeling experience
Logical data modeling experience
Erwin modeling tool experience
Workshop and interview experience

142

Data Modeler / Senior System Analyst Resume Examples & Samples

Iteratively refine the existing enterprise conceptual data model
Support and facilitate workshops and interviews to elicit information needed to develop logical and physical data models
Develop the enterprise logical data model, including entities, attributes, and relationships
Develop the enterprise physical data model, including tables, columns, and relationships
Develop data dictionaries with agreed-upon definitions for all entities and attributes
Map logical/physical attributes/columns to existing IT systems, identify gaps where data in existing systems do not exist to support the Target Data Architecture (TDA), and identify transformations where data must be altered from the source systems to be accommodated in the TDA
Architect and develop an overall master data hub for data elements that are used by multiple IT systems
NACI clearance or equivalent required
3 years of experience in financial lines of accounting and financial reporting
Knowledge of Financial Lines of Accounting/Chart of Accounts and NAF Standard LOAs/CoAs
Physical data modeling experience
Prior work and familiarity with databases (preferably Oracle, SQL Server and/or SQL Server)
Working knowledge of EDW tables containing Point of Sale data
Complex SQL statements experience
Experience creating complex SQL statements
Bachelor’s Degree required from an accredited college or university in a related field

143

Lead Data Modeler Resume Examples & Samples

Use SQL skills to pull data from Teradata/Oracle and perform usage analysis and/or data profiling
10+ years of experience in Data Warehouse environment with emphasis on data modeling involving design, coupled with strong knowledge of end-to-end data warehouse development life cycle (data integration, logical and physical modeling, and data delivery) supporting enterprise analytics and BI solutions
8+ years of progressive experience in Data modeling with emphasis on Dimensional modeling

144

Data Modeler Resume Examples & Samples

Facilitate the exposure of process data from functional experts and the user community
Provide mapping between existing processes and proposed replacement processes
Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community
Develop and manage the Conceptual, Logical and Physical data models and associated metadata for the enterprise
Design and normalize the logical data model to third normal form
Create the physical data model in the Erwin data modeling tool
Modify the physical data model for efficient data access paths
Generate DDL to create databases, tables, and views
Identify primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes
Identify statistics columns, and create and execute collect statistics statements
Recommend and establish standards, guidelines, and procedures for design and maintenance
Proven experience in an enterprise environment developing relational databases
Proven experience developing models for Business Intelligence solutions
Strong analytical, data profiling and problem solving skills
In depth knowledge of modeling methodologies and techniques
In depth knowledge of the ERwin data modeling tool or similar modeling tool
In depth knowledge of facilitation and conflict resolution processes
Experience with Business Intelligence products
Excellent teaming and communication skills
Strong consultative, facilitation and consensus building skills
Bachelor’s Degree in Management Information Systems, Computer Science, Computer Information Systems, or equivalent Information Technology discipline
Master’s Degree in MIS, MBA or Data Warehousing / Business Intelligence a plus
5+ years of data modeling experience
8+ years of related Information Technology Management or Data Warehousing – experience with Teradata and/or Teradata Partner products a plus

145

Enterprise Data Modeler Resume Examples & Samples

Data analysis and Business Intelligence experience
Good Financial Service industry knowledge(buy side is a plus)
Trade life cycle
Good knowledge of traditional products ( Equity and Fixed Income)

146

Systems Data Modeler Resume Examples & Samples

12 years of experience as a data modeler or data architect in programs and contracts of similar scope, type, and complexity required
3 years of experience with metadata harmonization activities supporting a DoD Enterprise
3 years of experience with designing and assessing system interfaces, end-to end data flows, and data storage and retrieval solutions
Experience with UML data modeling
Experience with using Sybase PowerDesigner, IBM Rational Rose, or Telelogic System Architect
BA or BS degree in Electrical, Systems, or Computer Engineering
Ability to work with a wide variety of clients
Ability to learn new technologies and maintain and develop technical currency
Possession of excellent interpersonal and communications skills

147

Lead Data Modeler Resume Examples & Samples

Bachelor’s degree or higher in Computer Science, Engineering, or related discipline, or equivalent, extensive and related technical, systems level experience
9 or more years of systems analysis, data modeling, data profiling and programming experience
6 or more years of experience in systems design
6 or more years of full software and systems development life cycle experience with both custom development and packaged application deployment, including experience working within a formal development methodology
6 or more years of experience in full project lifecycle including all stages of design, development and implementation of custom applications as well as the deployment of packaged solutions
Experience in application development utilizing a relational database such as Oracle and Big Data development using Hadoop
Specific understanding of the systems and applications used in the telecommunications and cable television or entertainment and retail industries
Experience working within a formal methodology for software development and a clear understanding of project management processes and tasks
Ability to organize, plan and execute major projects with minimal supervision
Ability to analyze project needs and determine resources needed to meet objectives and solve problems that involve remote and elusive symptoms, often spanning multiple environments in a business area
Project planning and management skills, including scope of work, time estimation, and resource assignment

148

Data Modeler Resume Examples & Samples

Accountable for analyzing and developing complex physical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements
Develop Hierarchical modeling and dimensional modeling constructs
Develop and maintain the Data Warehouse Business Matrix Architecture
Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations
Collaborate with Business Analysts, Data Architects and Business Customers to identify data usage patterns and to formulate Business names, definitions and data quality rules for data elements
We offer competitive salaries, an excellent benefit package including medical, dental, vision, and (401k)!*

149

Statistical Analyst Data Modeler Resume Examples & Samples

Drive the collection of new data and the refinement of existing data sources for deep statistical analysis and data modeling
Clean data in preparation for analysis and modeling
Perform statistical summaries and tests for relevant business questions
Develop predictive statistical, behavioral or other models
Perform statistical testing to enhance the predictability of deployed models
Deploy applicable models into production system for business use
Summarize conclusions and solutions for presentation
Develop strong relationships with subject matter experts
Develop best practices for experimentation

150

Data Modeler Resume Examples & Samples

Work with the Data Solution Manager to determine high level data strategy for PeopleSoft Data
Logical data modeling in Salesforce tool for creating Data Objects
Manage the Data Model repository maintenance and for the development and administration of the appropriate roles
Create logical and physical data models for operational applications
Provide data governance to ensure corporate data standards are met
Participate in ETL design and acts as the subject matter expert on source and target data structures
Occasionally participate in SQL query tuning on Oracle (SQL proficiency needed)
Produce data models and related documentation that can be understood and reviewed by a business audience
Reverse engineer data from various systems
Conduct other data analysis tasks including source system analysis and data profiling
Communicate and build consensus with other groups regarding data definitions, data solutions, and available implementation options
Revise ETL mapping specifications and/or stored procedures as required
Development: Develop/modify/test data to populate new tables and columns until the ETL team can develop Informatica mappings to replace the stored procedures
8+ years of large enterprise project experience that must include conceptual and logical data modeling

151

AWS Redshift Data Modeler Resume Examples & Samples

Certification: Should have Level 1 and seeking Level 2 BA
Experience in Business Analysis
Should be proficient in Business knowledge, Package Configuration and Change Management
Should have progressing skills on Functional Architecture Design and Architecture Knowledge

152

Data Modeler Resume Examples & Samples

Experience working with Medicare, Claims, and/or state Medicaid data
Experience using CA’s Erwin data modeling tool
Experience creating data dictionaries as well as logical and physical models
Experience working with Informatica PowerCenter Extract, Transform, Load (ETL) mappings/transformations
In depth understanding of identity resolution (IBM InfoSphere v10.1 or v11.5)
Expert level design/development skills for Extensible Markup Language (XML) schemas
EXML Stylesheet Language for Transformation [XSLT] skills
Please note that as a member of the Apex Systems team, you’d be eligible for Health, Dental, Vision and Life Insurance; Short Term Disability; Hospitalization Coverage; Direct Deposit; Weekly Pay Periods; Training and Development Programs; and our Referral Program.*

153

Logical Data Modeler Resume Examples & Samples

Experience with a modeling tool (Embarcadero ER/Studio or Erwin)
Ability to perform data analysis, and data discovery. Identifies cause of data issues and works with broader team to resolve issues
Works with senior DBA to identify and resolve issues or transform logical database models into physical database designs that represent the business rules while optimizing the performance and maintainability of the design in the physical database
Works closely with other application areas to ensure that data integrations are efficient, follow company's technical standards, and meet the business requirements
Ensures that all data deliverables comply with company's security policies and regulations (PCI, PII)
Minimum 7 years of experience in data modeling, including conceptual, logical, physical, Data Mart, Data Warehouse or Operational data store
Strong analysis and deep problem solving skills. Must be a self-motivated driver to find out data issues and resolve them quickly

154

Data Modeler Resume Examples & Samples

Participate in design review sessions with development teams
Translate business requirements into conceptual, logical and physical models
Identify patterns and data relationships from disparate systems and model
Create and maintain corporate Data Models in the data modeling tool
Ensure conformance to corporate naming standards and data modeling methodologies
Provide guidance to enhance query and load performance
Read and interpret explain plans
Write and understand moderately complex SQL queries
Perform data profiling of source systems
Bachelor's degree or equivalent experience in Data Modeling
5+ years Data Modeling experience
Experience in creation or usage of Relational Models (OLTP)
Experience in creation or usage of Dimensional Models (Kimball)
Thorough understanding of data modeling and experience in modeling techniques required
Ability to recognize and identify patterns in data relationships from disparate systems
Ability to write and understand moderately complex SQL queries and deploy DDL
Proficiency with Erwin 9 data modeling tool
Good MS Office software skills
Experience with SQL Server and Oracle DBMS; experience with DB2 and Teradata preferred
Experience with source code control preferred
Excellent oral and written communication skills; ability to build relationships and work with all levels of the business (team player)
Ability to multitask and manage concurrent work loads
Ability to follow established processes, as well as improve or develop new processes
Ability to work with minimal supervisionSearch Jobs US

155

IT Data Modeler Resume Examples & Samples

Bachelor's Degree in Computer Science or related field or direct and applicable work experience
Minimum four years database administration experience; four years of data modeling experience
Minimum three years database security experience
Demonstrated experience in programming and scripting languages to automate processes
Systems administration experience, including knowledge of network technologies and protocols
Advanced experience troubleshooting database connectivity issues
Ability to work well with people from many different disciplines with varying degrees of technical experience

156

Data Modeler / Analyst Resume Examples & Samples

Partners with IT groups to design and implement data and modeling solutions
Perform a detailed Data analysis on every project and support IT groups for any data related issues
Develops and documents artifacts and templates in the chosen Erwin tool repository
Understand the Project Proposal and assist the team in performing Data analysis how the new system or functionality can be integrated in the environment, identifying existing systems, concepts, possible data sources and issues
Develop, validate and communicate modeling solutions, including both relational and dimensional models
Partners with the Data Architects, Clients, ETL developers, Business Systems Analysts and other technical data warehouse team members and database administrators to design and develop high performing data models and maintain consistent data element definitions
Perform periodical Data validation checks to ensure the Quality of the Data in Production environments meet the standards
Create Conceptual, Logical data models that need to be validated with Business Users for current projects as well as other impacted projects
5- 10 years’ experience in a Data Modeler/Data Analyst role with deep knowledge of Relational and Dimensional Modeling in a Complex Data warehouse environment
MUST have Erwin 9.5 Model Mart experience for developing the Data Models
MUST be Strong in Oracle Data Warehousing Design and Oracle SQL
MUST be strong in Oracle SQL development, PL/SQL, and Data Profiling
Experience in technical, process, and business metadata management (eg. Informatica Metadata Manager) as well as Master Data Management throughout SDLC, including data quality, metadata and workflow technologies
Experience working in Scrum, Agile and waterfall used in completing projects
Expertise in Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Data Dictionary, Metadata and Business glossary
Familiarity with Retail and Commercial banking, Consumer Banking, Mortgage and Dealer lending concepts desired
Experience with Development Methodologies, Databases Platforms (Oracle/ SQLServer), including deep knowledge in Oracle SQL & PL/SQL
Expertise in Data Modeling tools (Erwin/Model Manager) & TOAD
Sound leadership, negotiation, critical thinking, and project/time management skills

157

Lead Data Modeler Resume Examples & Samples

Experience with data modeling in a relevant domain (health care, public health, etc.)
Familiarity with XML and XML Schema technologies
Experience working with both technical experts and business owners
Expereiince communicating complex technical concepts to non-technical audiences (e.g., white papers, presentations, documents)
Experience with UML and MagicDraw
Experience with NIEM
Experience with a programming language (especially Java)

158

Junior Data Modeler Resume Examples & Samples

Design data models and architectures, translating data so that it can be read by various types of computer systems
Design and build databases which can be used to support the larger data architecture
Responsible for the development of database archive and recovery design
Responsible for building data dictionaries and meta-data technical repositories to improve the overall end-to-end data function
Work closely with the DBA team, recommending data restructuring, clean-up, and other maintenance to ensure maximum performance with minimized overhead
Identify areas in which policy or procedure changes could improve the way we operate
Develop best practices and standard naming conventions and coding practices to ensure consistency of data models
Recommend opportunities to reuse data models across the landscape
Ability to reverse engineer physical data models from databases and SQL scripts
Develop and govern against a set of well-defined and approved data modeling best practices and principles
Guide developers and DBAs on the functional and non-functional limitations and capabilities of the model
Responsible for the creation and governance against a set of well-defined data model naming conventions
Respond to Production Support issues
Conduct preliminary estimates / Rough Order of Magnitude for the level of effort of new models and changes to existing models
Analyze and make recommendations for the need for system backup, security, restart/recovery, balancing & controls; recommend approaches for meeting such needs
Analyze and document the requirements and approaches to data conversion and data modeling
Design, develop, and maintain data model documentation
Perform preliminary evaluation of pre-packaged data models and software
Support implementation/training activities
Troubleshoot data model issues, as required
Experience in meta-data management and data integration engines (i.e. Informatica)
Experience in modeling best practices and differences between operational and analytical purposes
Possesses experience or knowledge in DB2, Oracle, Exadata, SQL Server, and HANA
Exhibits knowledge of the entire end-to-end SDLC process
Understands BI tools and technologies and how they interact with the underlying data models
3-5 years doing data modeling for systems that go into production

159

Associate Data Modeler Resume Examples & Samples

Researches, extracts, analyzes, validates, and prepares data for use in analytical projects by inspecting, cleansing, and transforming data and evaluates results by interrogating the data to find and understand anomalies and / or outliers
Define and execute analytical procedures to identify patterns, historical trends and drivers using various methods and analytical tools
Review analytical outputs and provide insights and recommendations through data visualization and reporting techniques as well as verbal and written communication to team members and business partners
Interact with applicable team members and/or business partners to ensure adequate understanding of data needs, data availability and information delivery output expectations
Collaborate with members of the department, SME's, and internal customers in ongoing decisions regarding study design, data collection, data analysis and methodology
Support the management of marketing activity from consumer acquisition and member engagement campaigns and marketing activity
Extensive experience using spreadsheets, database, and query tools
Excellent quantitative and analytical abilities
Ability to create and interpret various reports to monitor, track and evaluate campaign results and processes and identify trends
Advanced knowledge/skill in data analysis specifically statistical analysis for the identification of trends, root causes and improvements
Ability to work in team environment and independently
Extensive experience with systems and tools supporting relational databases and analysis. SAS, SPSS, SQL
MBA degree
Marketing analysis experience in a healthcare environment

160

Data Modeler Resume Examples & Samples

Logical and Physical modeling for Data warehouses
Semantic layer modeling; dimensional modeling to support Data Warehouse and Marts
Participating in data modeling discussions with the Business in JAD sessions
Work with the lead to establish standards around flexibility of the data model to ensure deviations are within established guard rails
5+ years of experience working in Data Warehouse environments with emphasis on data modeling involving design, coupled with strong knowledge of the end-to-end data warehouse development life cycle (data integration, logical and physical modeling, and data delivery) supporting enterprise analytics and BI solutions
5+ years of progressive experience in Data modeling with emphasis on Dimensional modeling
Hands on experience with modeling tools such as ERWIN
Experience working in a fast paced environment handling multiple project deliverables
Understand Big data architecture for analytics

161

Data Modeler Manager Resume Examples & Samples

Requires excellent planning, conceptual, consulting and communication skills, analytical ability, strong judgment and management skills, and the ability to interact with senior business area and IT management and staff solutions
Strong experience in logical and physical data modeling in OLTP and OLAP environments
Able to recognize and identify patterns in data relationships from disparate systems
Strong database fundamentals and data modeling knowledge
Strong experience performing data modeling studies and develops detailed data models
Strong experience in transforming logical models to physical models
Good understanding of understanding of ODS, data warehouse, data mart, and data cube, and database technologies
Strong SQL (PL/SQL preferred, T-SQL acceptable) background
Previous experience in gathering requirements for reporting solutions and data analysis
Good background working with quantitative data

162

Data Modeler Resume Examples & Samples

Translates business user information requirements into data structure requirements
Oversees new data development and ensures consistency and integration with existing data structures
Expert Knowledge in working with CA ERWIN CASE tool
Develops logical and physical database models across multiple platforms and computing environments
Participates in the evaluations of new tools and techniques to improve data management for the enterprise
Provides technical assistance and mentoring to staff for developing conceptual and logical database designs and the physical database
Ensure that relational designs and dimensional databases will perform effectively and efficiently, logically and physically
2-5 years’ work experience in database design
Effective knowledge and understanding of logical and physical database design concepts and some RDBMS platforms
Operational, service and technical knowledge in multiple Information Technology disciplines
Basic knowledge of their unit’s processes and procedures
Business knowledge of the Financial industry a PLUS.Search Jobs US

163

Big Data Modeler Resume Examples & Samples

Devise standards and processes for the group
Create architectural blue prints to enable understanding of high level business requirements,
Understand and incorporate industry standards into enterprise architectural guidelines
Manage and resolve multiple design priorities with various customers efficiently
Tool evaluation and work with vendor for new functionality based on enterprise requirements
Project planning activities in support of AD efforts
Partnership with AD to ensure best design solutions for most efficient use of data
Develops and implements data modeling standards and best practices, including re-use across the application portfolios. Prepares status reports on project work and work plan progress
Understand relational designs and dimensional database performance, conceptually, logically and physically
Solid understanding of the design principles of HBase and Mongo data containers and underlying components such as parallel processing
Working knowledge with CA ERWIN CASE tool preferred
Translate Logical Data Models to physical designs on big Data Platform: HBASE and Hive
Analyze and optimize data structures designs to meet queries and requirements
Bachelor’s degree in Computer Science or related years experience
5+ years experience with Big Data
Strong knowledge and understanding of logical and physical database design concepts,and some RDBMS platforms
Broad operational, service and technical knowledge in multiple Information Technology disciplines
Expert level knowledge of their unit’s processes and procedures
Expert oral and written communication skills
Requires an understanding of customer’s business practices
Excellent analytical and investigative ability
Ability to negotiate and influence results without direct authority
Able to understand and work with all other EI groups to ensure quality service delivery to customers
Business knowledge of the financial industry is very useful

164

Senior Data Modeler Resume Examples & Samples

Uses well documented procedures to create data dictionaries capturing business and technical metadata and Data Definition Language (DDL) scripts
Strong communication skills required; technical and business writing skills are a plus
One years of experience in relational data modeling required. Preferred three years of modeling experience in relational, dimensional or closely related data definition activity
Prior experience with a health care payer Member, Claim, Capitation, Warehouse, and Actuarial data is preferred
Should be able to analyses business requirements to develop data models with minimal oversight
Experience with All Fusion /ERwin, IBM Information Data Architect or similar modeling tool is required
Should understand impacts of model changes on databases
Excellent analytical skills required

165

Logical Data Modeler Resume Examples & Samples

Be a self-starter that does not require direct supervision
Expert in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio
Ability to write PL/SQL scripts to perform data refreshes from one system to another or run data queries
Ability to identify and map source and target data fields
Lead meetings with technical peers regarding the requirements definition
Communicate effectively with business, vendor, and project management staff
Participates in ongoing decisions regarding study design, data collection, data analysis and Methodology
Ability to show up to work and meetings on time
Ability to perform other activities as needed in order to help the team or the project to succeed

166

Data Modeler Resume Examples & Samples

Native level fluency in Japanese, Spanish or Portuguese is required
Mac OS X experience
Flexibility to work weekends or holidays

167

Data Modeler Resume Examples & Samples

Develop and deliver Dimensional Data Models and corresponding analysis according to the data architecture standards, for designated solution or segment architectures. This includes data model diagram, data object definitions, business rules, domain lists, data quality requirements
Deliver or support the delivery of additional data architecture artifacts, such as logical data models, mastership and utilization matrices, data flow diagrams, roadmaps, data mapping, data profiling
Identify and propose potential data model and data integration changes and improvements, including master data management solutions, data services
Work directly with project staff, business analysts, business representatives/SME's, and architects to ensure that the proposed models are fit for purpose and correct
Validate solution data model alignment with the Enterprise Data Model, identify gaps and propose resolutions
Ensure architecture artefact quality and retention in appropriate tools, e.g. System Architect
Participate in and contribute into various architecture networks
Build deep insight in how the business processes work, how the processes and applications interact and use data, and what the critical issues and success factors - for one or more business segments

168

Predictive Data Modeler Resume Examples & Samples

Develop and execute analyses alongside clinical and business teams to inform decision-making and program development within the client
Demonstrate ability to utilize data mining and probability to forecast outcomes
Develop and produce reports to support population health initiatives, including quality and safety metrics, cost and utilization metrics, and identify variation and trends
Acquire expert knowledge of the Client and Medical Health System (MHS) as needed to support population health analytics and initiatives
Function as a liaison between providers of information (Defense Health Agency, Air Force) and users of data such as client Analytics, client leadership, military treatment facility leadership and analytics assets

169

Senior Data Engineer, Data Modeler Resume Examples & Samples

Develop and maintain business object models, conceptual/logical/physical data models using IPS/IAA/IIW models to create operational data store
Collaborate with technical teams to define and implement Model Driven Architecture practices enterprise-wide
Interpret business requirements into a technical design
Define, document, and present technical design
Provide governance, technical knowledge and expertise, using best practices, supporting a culture of continuous improvement
Collaborate with subject matter experts, various stakeholders and fellow developers to design, develop, implement and support complex business solutions
5+ years of experience in data modeling, implementation standards and best practices using prevalent industry tools like Erwin, IDA
Ability to develop ETL Specifications based on requirements and communicate process to other technical teams
Ability to gather, analyze, and consolidate complex business requirements and translate into data models - conceptual, logical and physical
Ability to facilitate model design sessions with multiple teams
Ability to work collaboratively with both business and technical teams as a Subject Matter Expert on the IIW model
3+ years Commercial Insurance business knowledge
Strong Understanding of Model Driven Architecture
Strong Understanding of SOA, object modeling
Broad experience of working in diverse SDLC methodologies - waterfall, agile, iterative
Excellent Team Player
Self-motivated with the ability to work independently and in a team setting
Data aggregation/mining design patterns
3+ years experience with RDBMS including Oracle database
Strong SQL skills and ability to tune queries and database structures for performance
Ability to develop solutions involving geospatial data and time series
8+ years of solid, diverse work experience in IT, database management, analytics or an equivalent combination of education and work experience
Knowledge of IAA services design and object modeling a plus
Strong analytical ability, problem analysis techniques, a broad knowledge of technology alternatives
Excellent communication skills, and the ability to work effectively with business clients and IT resources
Ability to understand projects at a high level without losing sight of granular details when managing projects
Business Owner Mindset- Operate with keen business knowledge, expense, risk & controls driven mindset
Customer Driven- Focus on “Harvest” – (our enterprise continuous improvement effort), innovative problem solving, and efficient local decision making for continuous improvement
Growth & Development- Maximize development of self and others
NO AGENCIES PLEASE **

170

Data Modeler / Developer Resume Examples & Samples

Typically has 6 or more years of consulting and/or industry experience
Ability to work independently and autonomously
Problem solving and troubleshooting skills with experience exercising mature judgment
Able to direct multiple team members towards deliverable and milestone objectives with confidence
At least nine years’ experience developing analysis & design and software architecture documents
At least seven years coding experience with task specified programming languages (e.g., JAVA, C++, C#, PowerBuilder etc.)
At least seven years coding experience with SQL or database stored procedures
At least seven years’ experience with Internet/Intranet protocols and web server technologies, as required
At least six years’ experience building Service Oriented Architecture using web service standards (i.e., SOAP, RPC, or REST), if required
At least five years’ experience with current network, development and database architectures and technologies
At least five years’ experience developing systems architectures, if required
At least five years’ experience developing enterprise projects utilizing iterative system development methodologies, if required
At least two years’ experience with XML or JSON, if required

171

Data Modeler Resume Examples & Samples

Maintain change log for data models
Overall 8-10 years of exp Data Modeling experience of 5-6 years Well versed in data architecture
Understands how to interpret and integrate conceptual models, logical models, view models (snowflake, star-schema), object models
Strong database skills - Oracle/Netezza or any other database
Experience in ERWIN tool
Understands and has experience with using master data, reference data and meta data concepts for reusability of designs
Above all, the resource should have Healthcare Payer domain knowledge

172

Lead Data Engineer / Data Modeler Resume Examples & Samples

7-10 or more years of progressively complex related experience to data modeling activities
Experience building and implementing data transformation and processing solutions
Experience in Hadoop architecture, HDFS commands and experience designing and optimizing queries against data in the HDFS environment
Ability to understand and build complex systems and solve challenging analytical problems
Ability to leverage multiple tools and programming languages to analyze and manipulate large data sets from disparate data sources
Proven ability to create innovative solutions to highly complex technical problems
Ability to communicate technical ideas and results to non-technical clients in written and verbal form
Strong collaboration and communication skills within and across teams

173

Data Modeler Resume Examples & Samples

Working in isolation or with senior data modellers to capture business data requirements as a logical data model. Ensuring these models are consistent and that the Business Glossary is linked and maintained in a manner that allows impact assessment and lineage of metadata
Data model integration. The Corporate data model is actually 40+ individual models all linked together to form a single corporate model. All the individual models need to be checked to ensure they cross reference each other accurately
Semantic model mapping from Industry based models to JPMAM specific models to leverage industry standards and to test model completeness
Metadata support. Providing access to metadata information though the generation of pre-prepared or dynamic queries
Data quality analysis. Maintaining data validation rules, testing those rules and running data quality reports or generating data quality dashboards
Current state documentation and data lineage capture. In many cases existing database will need to be reverse engineered to assist in bringing all our data dictionaries up to date. At the same time we do this we need to capture and document data lineage. This part of the job will require the candidate to become familiar with a a range of different technologies to perform these functions so the ability to learn quickly is important
Data modeling tool customisation. In many cases model and DDL. generation is controlled by scripts in the data modeling tool. These scripts control the generation of many aspects of the data model including how data auditing is carried out and how XSD models are generated from the physical model. Maintaining these scripts and version upgrades to the data modeling tool is a key activity
Documentation. A central data portal details all the JPAM data standards. Keeping this information up to date and relevant is an important task

174

Logical Data Modeler Resume Examples & Samples

Develop and maintain Logical and Physical Data Models to support complex, data-centric analytic warehouses
Produce data models including metadata for communication with various audiences
Work with appropriate business and IT leads to incorporate data management best practices into IT solution roadmaps
Communicate and build consensus with other groups regarding data integration, semantic solution, metadata, data solutions, and available implementation options

175

DNA Hil-tech Lead-data Modeler Resume Examples & Samples

Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
At least 4 years of experience in Software development life cycle with primary experience in DW/BI, Oracle and related tools
At least 4 years of experience in Project life cycle activities on DW/BI Data Modeling and maintenance projects
At least 4 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks

176

Senior Data Modeler Resume Examples & Samples

2+ years of experience creating and modifying data models on a large scale system
2+ years of experience writing PL/SQL queries against a relational database
2+ years of experience writing Linux shell scripts
2+ years of experience using Perforce to manage code development environments
Ability to discuss database management techniques using ORACLE
Ability to analyze requirements and create PL/SQL scripts for production data fixes, ad hoc data requests, and data extracts
Ability to provide on-call support for a 24x7 application on a rotational basis
A strong commitment to process improvement
Ability to communicate effectively with management, business users, developers, and team members
Working knowledge and familiarity with Guidewire development tools
Working knowledge of IBM /JCL

177

Data Modeler Resume Examples & Samples

Highly logical with the ability to understand databases and complex data structures
Experience of data analysis of large and complex data structures
Experience deducing data semantics, doing data profiling, classification and utilization – understanding what it is, how it is used, how it could be used
Demonstrable experience of SQL query skills (Ever used a “Having” clause? An exists test of a sub query?)
Willingness to learn about new data tools
Willingness to learn or have knowledge of sampling and content analysis techniques and how they can be applied to address data issues
Experience in a service centric or consulting organization would be desirable, but not essential
Exposure to or understanding of legacy data storage technologies and concepts would also be desirable but not essential
Experience with multiple SQL variants, JPQL, Linq, Groovy, Ruby, Access, Java, C# would also be desirable
Educated to degree level in a mathematical or engineering discipline, or with a business or arts degree but really solid technically
Undergraduate degree and 6-8 years relevant data modeling experience
Data extraction, transformation and loading (ETL) experience
Experience reverse engineering legacy data and entity-relationship modeling
Thorough understanding of how data evolution process differs from classical data modeling or functional analysis
Object / Relational mapping

178

Operational Data Modeler Resume Examples & Samples

Will be working as part of the Analytical/Operational Data Modeling Team
Will be assigned to one or more of the project releases
Will be working on new Data Modeling development, as well as updating existing data models
Will be working on both traditional OLAP/OLTP and Guidewire’s Policy
Will be working both individually and with other team members
Will be guided by experienced Data Modelers
2-5 years of related experience
Insurance background preferred
Strong Data Modeler background/experience - will be doing "hands on" data modeling
Experienced in OLAP/OLTP modeling (both 3rd Normal and Dimensional)
Strong communicator, excellent verbal & written skills
Able to work in a team environment and individually
Experience with DB2, Greenplum, Hadoop and Oracle are preferred
Familiar with Embarcadero ER/Studio data modeling tool
OLTP Data Modeling experience
OLAP Data Modeling experience
Database Design experience

179

Senior Data Analyst / Data Modeler Resume Examples & Samples

Interested in working in an Agile environment
Understand certain compliance standards and guidelines and apply them when necessary
Desire to eventually move into a database design role
5 or more years of IT experience
3 or more years of experience in a data centric role with a desire to work in a Data Warehousing environment
1 or more years of work experience writing SQL
Must be flexible to work with global teams and stakeholders across time zones
Familiarity with ETL tools such as Talend or DataStage
Understanding of: Data Discovery and Profiling; Data Mapping; Data Modeling; and Data Management processes (e.g., Data Quality)
Aptitude and/or desire to move into a database design role
Familiarity with Big Data Technologies (Hadoop, Pig, Hive, HBase, and/or MapReduce etc.) and capabilities
Knowledge of Meta Data tools and technologies
Experience with Data Analysis with mindset of translating into Data Marts
Experience working in an enterprise size Data Warehouse
Strong background writing SQL

180

Data Modeler Resume Examples & Samples

Minimum 5 years of Data Modeling experience with a focus on multidimensional data modeling
Experience with ERWIN data modeler
Previous work experience in the financial industry (bank or credit union) required
Expert knowledge of relational DBMS, specifically Oracle and Microsoft SQL Server
Expert knowledge in areas of advanced data techniques
Proficient in leading business and internal team discussions to gather requirements, brain-storm and propose robust and scalable solutions; leverage business partner/unit input to enhance data models
Experience in developing and maintaining source to target mapping that includes extract requirements, derived field logic, domain values and data lineage
Experience designing conceptual, logical and physical data models and maintaining data dictionary and capturing metadata
Experience creating a and maintaining DDL scripts, data standards, and best practices to maintain integrity and security of the data; ensure adherence to developed standards
Strong verbal and written communication skills required
Strong negotiating and consensus building skills
Must be able to deal with ambiguous scenarios when working with business teams

181

Lead Data Modeler / Developer Resume Examples & Samples

At least 7 years experience with developing and implementing applications
Change control
Application maintenance
Application design, architecture
Release management
Application testing
System testing

182

Data Modeler Resume Examples & Samples

Understanding of Data Integration and modeling within Data Lake environment
Experience with physical data structure design in columnar databases ( such as RedShift , Vertical, GreenPlum etc )
Strong SQL query writing against Oracle/SQL Server Databases
Understanding/Data Modeling for Redshift / ParAccel databases will be a huge plus
Customer Care Data Mart modeling experience is a huge plus
Work with Client stake holders in understanding Data needs
Conduct requirement gathering sessions and participate in various discussions and scrum meetings
Analyze requirements, provide logical and Physical Data Model
Write detailed Data Modeling documents with sample data use cases and queries as necessary
Conduct walkthroughs of the Data Model with Functional and Technical resources

183

Data Modeler / Analyst Resume Examples & Samples

Work with the Sales, UST and Finance stakeholders to understand the impact to processes and data of the GTM strategy
Understand changes to customer master data across UST, SAP, Sales and drive outcomes that minimize the creation of duplicate customer data. Help teams understand the details and drive out ambiguity in the integration between the systems
Build and maintain conceptual and logical data models in ERStudio Data Architect (data modeling tool. Similar to ERWin)
Excellent verbal communication and facilitation skills
5+ years of Logical Relational Data Modeling (Business Data / Requirements Modeling) experience. Highly proficient with logical data modeling concepts such as normalization, natural vs surrogate keys, identifying vs non-identifying relationships
Experience with using ERWin, ERStudio or similar software for logical data modeling
Familiarity with revenue accounting principles such as recognized revenue, billed revenue, deferred/unearned revenue
Familiarity with common order to cash business processes
Familiarity with Microsoft volume licensing systems and processes
Familiarity with Microsoft's online services / commerce platform / universal store team systems

184

Data Modeler Resume Examples & Samples

Problem Solving – demonstrated ability to conceptualize, define and solve difficult problems
Modeling/Analysis – strong aptitude for modeling and analyzing business decisions, whether operational, tactical or strategic
Data Management/Manipulation – understanding of and ability to work with large amounts of data to clean inputs and present outputs in a visual, easy to understand manner
Communications – has strong written and oral communication skills. Must be able to communicate effectively even if the role is confined to model building and implementation. The focus is on gathering requirements, communicating (sometimes counter-intuitive) results and motivating line personnel to acting on EO outputs
Delivered Products – history of delivering completed products on time; strong attention to detail
SQL Server Integration Services
SQL Server experience
BI/reporting background
ETRM Experience with Endur and Natural Gas
Business Modeling – 3+ years’ experience modeling in Excel a must; understanding of linear programming and constraint-based modeling systems (e.g. OPL Studio, Lindo, GAMS) a strong plus; It is preferable that the experience be in modeling and analyzing the types of business problems that EO is typically applied to (e.g. operational, tactical and strategic planning), vs. tangential techniques such as simulation and statistics
Business Analyst/Management or Business Advisory Consultant – Prior experience supporting business decision making, including problem definition, research/analysis, expectation management, client management and business process definition
Data Management & Programming – understanding of database systems such as SQL Server, and ideally SSIS and reporting environments; VBA programming knowledge is a plus
SSIS

185

Data Modeler Resume Examples & Samples

Work with multiple teams to identify, design and build appropriate dataset and linkages for complex data
Support refactoring legacy systems into microservices which integrate with a Hadoop data lake
Contribute to evaluating and selecting new tools for data management and promoting industry best data management practices among the development teams
Manage metadata for all data sources within a Hadoop data lake
Organize, deliver, and ensure data integration support
Develop/manage complex data models (conceptual, logical, & physical) in multiple formats (relational, star/snowflake, object-oriented, etc.)
Analyze & acquire data from primary and secondary data sources – creating mapping specifications/requirements for use by ETL development resources
Maintain knowledge on current and emerging developments/trends for assigned areas of responsibility, assess the impact, and collaborate with management to incorporate new trends and developments in current and future solutions
Identify and recommend process improvements that significantly reduce workloads or improve quality for his/her assigned areas of responsibility
Determine how existing applications, systems, databases, interfaces and/or hardware can interact to meet new and emerging enterprise initiatives
Provide input and validate project plans, test plans and implementation plans
Consult and/or participate in the requirements, design and coding walkthroughs to ensure the development of quality solutions
Proactively identify problems and present/develop solutions
Communicate effectively with internal stakeholders and management
At least five (5) years of experience implementing relational database designs, data warehousing, data architecture, & data modeling, including strong knowledge of various data modeling approaches and practices (experience with 3NF, star schemas, and multi-dimensional designs)
At least six (6) years of SQL experience
At least five (5) years of experience creating physical data models for relational databases
At least four (4) years of experience working in Hadoop environment, including HDFS, Hive, Sqoop, HBase, Pig, Flume, Parquet, Avro and/or Spark
At least three (3) years of experience working with XML, UML and JSON
Knowledge of Informatics, analytics, computational science and service management
Experience with ERwin Enterprise Data Modeler or equivalent modeling software
Understanding of NoSQL databases is desired
Ability to logically model healthcare data is desired
Experience working with Agile methodologies is desired

186

Mid-level Data Modeler Resume Examples & Samples

Typically has 5 or more years of consulting and/or industry experience
Ability to manage small engagements or work streams and multiple team members with confidence
Professional oral and written communication skills
Strong problem solving and troubleshooting skills with experience exercising mature judgement
Excellent teamwork and interpersonal skills
Ability to obtain and maintain the required clearance for this role
4 to 6 years supporting/implementation of Information Technologies (IT) projects and have robust software or system implementation experience
Experience as a Database Designer/Data Modeler, Data Simulation, Business Intelligence (preferred Data Modeling Architect) in a variety of client/server software environments

187

Data Modeler Resume Examples & Samples

Possess solid technical skills regarding tools and technologies pertinent to enterprise data management including
Conceptual and logical data modeling, physical database design, data integration ETL and data profiling to provide the proper context regarding enterprise data assets to address business and technical requirements
Demonstrates leadership skills
Bachelor's degree in Computer Science preferred, or equivalent work experience
Experience in implementing enterprise applications across the application, data, and infrastructure domains
Full life-cycle data warehousing experience Data Warehousing architecture experience
Data Modeling (ERD's, Mapping, Metadata, dimensional and experience) using a modeling tool
Experience with a Financial industry model

Download Data Modeler Resume Sample as Image file

Related Job Titles

Data Developer Resume Sample

Data Warehousing Resume Sample

Data Manager Resume Sample

Data Administrator Resume Sample

Director, Data Management Resume Sample

Data Analysis Resume Sample

Data Resume Sample

Data Intern Resume Sample

Data Clerk Resume Sample

Data Visualization Resume Sample

Data Collection Resume Sample

Data Infrastructure Resume Sample

Browse More

Data Modeler Resume Samples

The Guide To Resume Tailoring

Craft your perfect resume by picking job responsibilities written by professional recruiters

Pick from the thousands of curated job responsibilities used by the leading companies

Tailor your resume & cover letter with wording that best fits for each job you apply

Resume Builder

Resume Builder

15 Data Modeler resume templates

Read our complete resume writing guides

How to Tailor Your Resume

How to Make a Resume

How to Mention Achievements

Work Experience in Resume

50+ Skills to Put on a Resume

How and Why Put Hobbies

Top 22 Fonts for Your Resume

50 Best Resume Tips

200+ Action Words to Use

Internship Resume

Killer Resume Summary

Write a Resume Objective

What to Put on a Resume

How Long Should a Resume Be

The Best Resume Format

How to List Education

CV vs. Resume: The Difference

Include Contact Information

Resume Format PDF vs Word

How to Write a Student Resume

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

GIW Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler / Developer Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

CIB Tech-logical Data Modeler, VP-brooklyn Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Enterprise Kyc Technology Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler / Developer Resume Examples & Samples

Data Modeler Resume Examples & Samples

Risk Data Modeler Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Data Modeler, Asset Management Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Lead Data Modeler Analyst Resume Examples & Samples

IT Data Specialist / Senior Data Modeler Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Senior Big Data Modeler Resume Examples & Samples

Enterprise Solutions Data Modeler Resume Examples & Samples

Associate Data Modeler Resume Examples & Samples

Senior Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Lead Data Modeler Resume Examples & Samples

Business Intelligence Data Modeler Resume Examples & Samples

Senior Data Analyst & Data Modeler Resume Examples & Samples

Data Modeler Analyst Resume Examples & Samples

Enterprise Data Modeler Resume Examples & Samples

Business Intelligence Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

M HIS Solutions Data Modeler Resume Examples & Samples

Enterprise Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Resume Examples & Samples

Data Modeler Manager Resume Examples & Samples

How to Make
a Resume

50 Best
Resume Tips

200+ Action
Words to Use

Internship
Resume