Data Modeler Resume Samples
4.7
(87 votes) for
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.
SS
S Schroeder
Sadye
Schroeder
87235 White Valley
Chicago
IL
+1 (555) 136 6014
87235 White Valley
Chicago
IL
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
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
15 Data Modeler resume templates
Read our complete resume writing guides
1
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
2
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
3
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
4
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
5
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
6
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*
7
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
8
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
9
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
10
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
11
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
12
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
13
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
14
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
15
Data Modeler Resume Examples & Samples
- Strong data management skills
- Strong Data Modeling
- Should have managed/participated in complete project life cycle
- CFA
16
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
17
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
18
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
19
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
20
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
21
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
22
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
23
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
24
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
25
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
26
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
27
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
28
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
29
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
30
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
31
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
32
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
33
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
34
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
35
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
36
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
37
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
38
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
39
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
40
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
41
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
42
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
43
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
44
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
45
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
46
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
47
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
48
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
49
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
50
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
51
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
52
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
53
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
54
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
55
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
56
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
57
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
58
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
59
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
60
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)
61
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
62
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)
63
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
64
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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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 locat