Data Modeler Resume Samples
4.9
(100 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 locations
- Experience in managing risk and control within a financial software development environment
- Knowledge of the financial industry in relation to Treasury & Trade Service business is an advantage
- Significant project management experience of applications development or implementation
- Extensive IT experience, preferably encompassing analysis and/or development
- Experience of working within-in a multi-cultural and remote team structure
- Proficient in use of Microsoft Project
- Proven influencing and negotiation skills
- Ability to manage multiple activities
- Ability to identify the critical success factors and risks
- Focus and determination
- Self-supporting
- Maturity and sense of responsibility
- Ownership and accountability
76
Data Modeler Resume Examples & Samples
- Work with application development teams in designing new data structures and modifications to existing structures
- Review data models and data structures developed by data modeling team and application development teams
- Review SQL developed by development teams in terms of standards, best practices and performance impacts
- Develop deployment data definition language(DDL) scripts
- Perform deployments across all environments
- 5+ Years Data Modeling(Preferably on Large Scale DWH)
- Experience in tuning SQL
- Understanding of Logical vs. Physical Modeling
- Experience with Analytical and Operational Data Store Modeling
- Experience with Dimensional Data Modeling at an enterprise level
- Experience with tools including: TOAD, SQL Developer
- Experience with Source Control Tools (i.e. Subversion, Clearcase)
- Familiarity with Big Data
77
Data Modeler Resume Examples & Samples
- Provide expert data modeling and data validation services that produce flexible, extensible data structure design solutions that support effective business decisions
- Mapping of relational entities to use cases or business requirements and assisting in the development of data models
- Create and manage an array of data design deliverables including data models, data diagrams, data flows and corresponding data dictionary documentation
- Follow standards for database design and overall data architecture to assess data quality and act as a liaison with various technical service teams which include database administrators and platform administrators
- Identify opportunities for sharing and utilizing data across boundaries, thus extracting maximum benefit from the data resource
- Support analysts in requirements development, research and verification
- Participate in full life cycle development to meet project objectives
- Participate in the development of software documentation
- Analyze business user requirements in order to define data requirements for new analytics, reporting, and data governance
- Knowledgeable in concepts around modeling Slowing changing Dimensions and Capturing Transactional History
- Strong technical understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data
- Deep knowledge of best practices through relevant experience across data-related disciplines and technologies, particularly for enterprise-wide data architectures, data management, data governance and data warehousing
- Highly competent with relational database design and structured query language (SQL)
- Strong familiarity with data management tools, including enterprise repository tools, data modeling tools, data quality tools, data mapping tools, and data profiling tools
- Solid understanding of Business Intelligence and Data Warehouse technologies (e.g.., Informatica Business Objects, Oracle, SQL Server). Hands on experience a plus
- Strong aptitude to learn business processes/products and the role of data within the business domain
- In-depth experience in managing/operating information solutions
- Candidate should have a combination of strong communication/facilitation skills with conceptualization/design skills
- Strong applied knowledge of software development efforts through implementation including good design, documentation and supportability practices
- Five years' experience managing multiple complex systems with
- Demonstrated leadership of multi-discipline, high-performance work teams/groups; and
- Demonstrated high competency in execution of multiple large projects
- Experience working in a program management office (PMO) using project and portfolio management tools
- Candidate should have a minimum of ten years of experience in IT, with at least three years in Deployment, Maintenance and Operations Project Management
78
Data Modeler Resume Examples & Samples
- Effective listener, who can give timely and constructive feedback. Is willing to state opinions assertively and deals constructively with conflict situations. A problem solver as well as willing to comprise for a common effective and efficient solution
- Develop and maintain relationships with key business and technology partners
- Participate in production on-call rotation, where required
- Ensure all code changes are managed according to the company best practices
- Identify opportunities for improvement; innovate
- Hands on experience with Microsoft SQL database tools
- Hands on experience with Data Virtualization technology (RedHat/JBoss, Cisco, Denodo, others)
- LI-LOCS VIRTUAL-US
79
Senior Data Modeler / Analyst Resume Examples & Samples
- Designs and builds relational database models and defines data requirements to meet the business requirements
- Develops strategies for data acquisitions, archive recovery, and implementation of databases
- Develops logical and physical database models
- Data lineage and audit controls for data movement life cycle
- Writes scripts and commands for data manipulation
- Plans and conducts database unit and system tests, monitors results, and takes corrective action
- Monitors and resolves database performance, database capacity, data integrity and replication issues
- Assures integrity of data, software, and hardware; develops policies and procedures related to development and support of new and ongoing systems
- Determines transition strategy from current to new architecture, including integration from current data and information systems
- Provides technical consulting to application development teams during application design and development for highly complex or critical projects
- Ensures compliance with the organization's database standards
- 6+ years’ experience with Application development with focus on Data Management
- 6+ years’ experience with the concepts, philosophies and tools behind the design of applications, information and underlying information technologies
- Data analytics and modeling (SAS)
- Data Governance Processes and Technologies (IBM)
- Data warehouse modeling and Dimensional Modeling (Star Schema Design). I
- Involved in creating Logical and Physical data models for Data warehouse and Data Marts of end to end BI/Analytics solutions
- Data acquisition and integration, OLAP and data modeling tools (Erwin and Enterprise Architect)
- Development and management of data lineage and audit controls for data movement life cycle
- Large scale transformational initiatives (Financial Crimes), Data profiling and Data Quality initiatives
- Creating a very performance oriented physical data models in Oracle. To take advantage of partitions, indexes and Aggregates
- Query Tuning from Reports/Integration perspective to meet performance SLA requirements
- Self Service BI programs and creating semantic models for successful adaptions by the business team
- Building of Data Discovery Platform using analytic/data technologies SAS, R, Hadoop, Oracle and others
- Product and vendor liaison
- IT standards, procedures, policy
- Experience working in a fast pace IT environment with strong ability to meet tight deadlines
- Self-motivated and not afraid to work in ambiguous situations
80
Data Provisioning Data Modeler Resume Examples & Samples
- BS in Computer Science or related IT field, or equivalent work experience required
- Experience: 3-5 years development experiences in building large scale data warehouse
- Strong data analyses skills and proficient in SQL writing
- Ability to translate business requirements into IT requirements
- In depth working experience with at least one data base e.g. Oracle
- Strong data model capability. Familiarity with Oracle OFSAA is a big plus, but not a prerequisite
- Ability to use project management tool such MS Project to help run or coordinate a project
- Good experience in financial industry is desirable. Familiarity with investment banking data is a big plus
- Experience in data integration (ETL / API)
- Knowledge with core ETL development technologies such as Informatics is desirable
- Ability to analyse and understand data flows and derives a data architectural solution
- Highly motivated and delivery focused
- Solution centric mindset and creativity
- Shows initiative, autonomy, self-motivated, self-starter
- Experience working successfully in a multicultural environment
- Excellent communication skills and ability to deal effectively with customers
- Proven ability to pick up new technologies independently and quickly
81
Data Modeler, Associate Resume Examples & Samples
- Work with product owners, business analysts and subject matter experts to gather requirements
- Identify the set of entities that satisfy the requirements
- Create draft models that contain necessary properties to meet business requirements
- Build the actual models and create sample documents that conform to the model schemas and show what the data will look like
- Collaborate in meetings with product owners to understand the functional requirements; will need to translate those into technical solutions
- 3+ months- 3 years experience working as a Data Modeler, Business or Data Analyst
- Basic technology skills and knowledge including but not limited to: Windows and Linux operational systems, code and text editors, Web browsers
- Technology-centric Education from a 4 year college or university in technology I preferred (basic understanding of SDLC/software development/database technology), etc
- Exposure to, or basic knowledge of, databases, data modeling (for integration or storage), data warehouses (should understand the basic concepts of how data is stored and communicate this effectively). In depth experience in this space is not required, because the role will be trained in how to create JSON files using various Ellucian tools
- Clear communication is a must. Candidate must communicate effectively with senior architects and business analysts, ask questions, and learn quickly
- Reading/collecting requirements for software development and collaborating with business analysts and data architects
- Multiple types of systems (transactional, reporting, etc.)
- Able to express ideas clearly and communicate well with both SMEs and development teams
- Ability to deal with complex information, ability to structure effectively, and present the data in simple form and the way it was requested
- Basic knowledge of SQL and exposure to databases, data warehouses, big data environment; data analysis, data profiling, data mining
- Basic knowledge of DBMS concepts, experience with database and data warehouse design and implementation, reports design and development, data visualization and presentation
- Facilitate and gather requirements for new data models and modifications of existing ones
- Create mapping between incoming and outgoing data formats
- Data warehousing, data profiling, data visualization, data mining, MongoDB, and NoSQL
82
Data Modeler Resume Examples & Samples
- Data modeling and using tools such as ERWin, Power Designer and Visio
- Data modeling methodology (ex. Kimball)
- Enterprise metadata (managing information assets of organization) and data governance
- Work with product development and support staff to document, categorize and classify information used by our various business systems
- Create and maintain custom and vendor provided data dictionaries for all business systems
- Database and data warehouse design across multiple platforms and computing environments
- Support new and existing development projects with logical data and process modeling activities. Provide entity, logical and physical data models
- Communicate to leadership within our partner companies to convey the importance and business value of data architecture
- Promote information management strategies that drive value to our organization and integrate our business systems
- Keep pace with latest trends and technologies related to information management to guide our future business strategies
- Participate in data governance processes related to data quality and information management
- Assist in product evaluations for technology to support the Enterprise Data Office
- An understanding of the staffing or professional services profession a plus
- Strong people skills including the ability to effectively and concisely communicate orally and in writing across all levels of the organization
- Demonstrated strong analytical skills including the ability to solve problems in a systematic, logical and effective way leveraging defined processes and methods
- Ability to collaborate in a team environment and ability to work independently to meet individual and team goals
- Ability to handle multiple projects or issues concurrently
- Familiar with concepts and strategies of a Service Oriented Architecture (SOA)
- Familiar with enterprise ERP and CRM systems such as PeopleSoft and Siebel
83
Data Modeler Resume Examples & Samples
- Pull data from multiple databases across different platforms such as Oracle, SQL Server, Teradata and Hadoop to integrate data and build a Data Lake and analytical datamarts
- Works with the Lead Data Architect to determine high level data strategy for the Enterprise Data Warehouse
- Creates logical and physical data models for operational applications and all analytic applications
- Participates in ETL design and acts as the subject matter expert on source and target data structures
- Work with various outside vendors and internal support teams in maintaining and/or enhancing processes and data integrations
- Support business by generating ad-hoc analysis, using SQL, for overall business as needed
- Perform extensive data quality / data analysis checks to ensure integrity of database for business use
- Work with business partners on the full lifecycle of data related projects from requirements analysis and design through development
- Maintain and manage scheduling and distribution of reporting
- Manage and monitor server processes and jobs for on-premise and cloud environments
- Investigate and resolve root cause for complex data issues
- Script and automate processes
- Diagram and document databases and data flows
- Bachelor’s degree in Information Technology, Computer Science
- Minimum 4 years’ experience in database development and administration
- Experience with data integration and database design, knowledge of Data Warehousing methodologies. Exposure to ETL tools such as Microsoft SSIS
- Experience with enterprise reporting tools; Business Objects, Microsoft SQL Reporting Services, Power BI or Tableau preferred
- Excellent data interpretation and communication skills; ability to summarize complex findings clearly and concisely, ability to communicate effectively to all levels of management
- Strong conceptual/analytical/creative thinker
- Strong skills in SQL to analyze, manipulate data, investigate data problems, and develop reports
- Familiarity with a programming/scripting language such as Java, .Net, powershell or Python
84
Data Modeler Resume Examples & Samples
- Supports all aspects of maintaining a database environment
- Installs and troubleshoots database applications, patches, and updates
- Implements mirroring and clustering techniques
- Creates, maintains and monitors databases (i.e. Shrink/Manage Transaction Logs, Daily database administration, user accounts)
- Analyze sand troubleshoots logs for performance and resource planning purposes
- Performs daily database backups, maintenance, monitoring
- Owns, tracks and resolves database-related incidents and requests, fulfilling requests and resolving incidents within SLAs
- Creates Stored Procedures and Views for use in various front-end applications
- Responds to database-related alerts
- Assists in the design and use of databases, the global view of databases, and access to the databases
- Tunes the databases to maintain optimum performance
- Creates conceptual data models based on user requirements
- Creates data dictionaries, data flow diagrams and logical data models
- Bachelor’s degree in math, computer science or equivalent technical field with 4 years of experience in Data Management arena
- Minimum 3-4 years experience in data modeling/database design
- Knowledge of DBMS concepts
- Proficient in Oracle and/or SQL DBMS
- Individuals in this position work in a group or on project teams under deadlines and heavy workloads
- Must have good interpersonal skills and the ability to coordinate actions with supervisor and peers
85
Data Modeler Resume Examples & Samples
- Work in a team of Professional Services consultants, architects and project managers who implement SAP and Big Data and Analytics solutions
- Provide a good SAP HANA modelling expertise and Analytics guidance in the development of new solutions as well as the improvement of existing solutions
- Being able to articulate defined analytics solutions al all levels of the organisation
- Deliver industry-centric customer projects through providing analytics for the desired business metrics
- Ability to work as a visualisation expert to recommend the best visualisation stories for customer’s business KPI’s
- Meet with clients, analyse their requirements, produce requirements documents (technical and functional)
- Strong work ethic, driven, dependable, and responsible
- Willingness and ability to learn quickly new Big Data and Cloud and Analytics solutions
- Willingness to participate in the sales process
- Motivated, and able to work effectively under pressure
- Ability to present complex information in a clear and precise manner; with technical and non-technical audiences
- Master’s or Bachelor’s degree in Business Administration, Computer Science, Information Management or equivalent
- 3-5 years overall experience in business and technical roles, ideally in SAP analytics
- Experience in SAP HANA modelling and SQL scripting is required
- Experience in data warehousing and data modelling concepts
86
Data Modeler Resume Examples & Samples
- Work with the Lead Data Architect to determine a high-level data strategy for the Enterprise Data Warehouse
- Work with business partners on the full lifecycle of data-related projects from requirements analysis and design through development
- Pull data from databases on different platforms (i.e. Oracle, SQL Server, Teradata, Hadoop) to integrate data and build an analytic datamart
- Participate in ETL design and act as subject matter expert on source and target data structures
- Generate ad-hoc analyses using SQL
- Diagram and document data flows and databases
- Bachelor’s degree in Information Technology or Computer Science
- Minimum 4 years’ experience in database development and administration; Experience with data integration and database design, knowledge of Data Warehousing methodologies. Exposure to ETL tools such as Microsoft SSIS
- Strong SQL skills to analyze, manipulate data, investigate data problems, and develop reports
- Experience with enterprise reporting tools such as Business Objects, Microsoft SQL Reporting Services, Power BI or Tableau
87
Data Modeler Resume Examples & Samples
- Partner with multiple global MDM and/or application project teams to define data requirements, influence data design to achieve Enterprise and Sector goals
- Lead requirements gathering meetings with application teams, Database Administrators, and/or business partners to understand business needs; help define and anticipate business needs
- Design and model relational databases in Teradata, Oracle, Sybase, SQL Server, and/or IBM DB2 environments; create data and process solutions for business and systems requirements; convert logical models to physical models and build database in development platform
- Perform quality assurance reviews on data models, created by junior members, to ensure requirements have been met and design is optimized for functionality and performance
- Update Technical Design documents; create and maintain metadata, including table/column definitions
- Support application and functional teams with data identification and analysis
- Collaborate with Enterprise Architects to establish, and enforce data principles, standards and best practices; advocate Enterprise data strategies, architecture, and direction
- 7+ years experience in application development, data design and analysis, or data management/governance
- 5 years of Data Modeling/Design experience, required
- Proficiency with ER/Studio, or other data modeling tools
- Demonstrated analytical skills and aptitude
- Strong interpersonal skills; strong written and verbal communications skills; experience with remote or virtual teams
- Development experience with SQL and UNIX
- Experience translating business and application requirements
- Knowledge of PepsiCo master data, applications, and Business, a plus
- Team player; ability to work well with changing priorities; demonstrated flexibility
88
Data Modeler Resume Examples & Samples
- Conceptual data modeling experience required
- Logical data modeling experience (third normal form) required
- Physical data modeling experience required
- Prior work and familiarity with databases (preferably Oracle or SQL Server) required
- ERwin modeling tool experience preferred
- Data analysis experience required
- Outstanding communication and presence in front of senior level customers required
- Workshop and interview experience preferred
89
Data Modeler / Analyst Resume Examples & Samples
- Review and analyze client workforce or operational data
- Review, analyze and develop models to report on and/or optimize cost, staffing, performance or operations
- Perform performance and cost analysis on client interpret findings
- Develop recommendations for improving organizational effectiveness or efficiency based on data review findings or model outputs
- Develop reports detailing the analysis of data and next steps for implementing organizational improvements
- Proficiency in statistical analysis and data modeling as well as Microsoft Word and Excel
- Ability to translate analytical findings into context that non-technical clients can understand
- Flexibility and willingness to address client ideas and feedback
- Responsiveness to client and project manager requests
- Good time and project management skills
- Experience with River Logic Enterprise Optimizer or analytical packages a strong plus
90
Senior Data Modeler Resume Examples & Samples
- Perform data research, analysis, conceptual and logical data modeling to validate and document business data artifact with an in-depth understanding of entity relationship design, data normalization & relational modeling techniques
- Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems
- Identify key business processes and deliver subject specific OLAP data-marts and manage logical and physical data models for data warehouse
- Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures
- Familiarity with Bill Inmon & Ralph Kimball Data Warehousing methodologies
- Work very closely with business analysts, development teams and project managers for requirements and business rules
- Support ongoing data modeling efforts for Development, QA, Production environments
- Experience with ERWIN or similar data modeling tools
- Experience in design and deployment of logical and physical structures preferably Banking Risk Area
- Experience in business analysis techniques and data warehouse design techniques
- Experience deploying and supporting large, complex data warehouse/business intelligence solutions
91
Data Modeler Resume Examples & Samples
- 5+ years of experience using SQL, SSRS, SSAS etc
- Professional Billing Epic Clarity Data Model certification
- Previous experience working in a Hospital setting
- Working knowledge of Sharepoint and Business Intelligence
92
Data Modeler Resume Examples & Samples
- Review current data models to understand the as is environment. Review report design documents to understand where data model structures can address requirements
- Work with the key business representatives, data owners, end users, application designers and data architect to model the current data (where models do not already exist) and for the to be system. Create logical and physical data models for as is and proposed or to be system
- Create entity-relationship diagrams for relational systems and dimensional diagrams for the Data Warehouse, Data Marts and data cubes
- Review, update and validate data model with key business representatives and end users
- Work with the technical architect, data architect and database administrator to understand current data storage constraints and define to be needs with growth allocation
- Work with data architect to define and create required metadata. Maintain data models continuously as modifications and enhancements are made
- Create data model structures to enhance performance of the application by creating aggregation and summarization structures
- Minimum of 3 years professional services experience in data modeling and big data technologies
- Ability to travel a minimum of 80%, up to 100% where applicable
- Experience with a minimum of one of the following technologies: Hadoop/Cassandra/Mongo DB/Couch DB Oracle DB/MS SQLServer, SAP HANA/Oracle Exadata
- Minimum of a Bachelor's Degree
- Life sciences clients and experience preferred
- Strong power point presentation skills
- Should be able to work independently with Accenture and client organization
- Able to lead teams and able to interface directly in client facing interactions
93
Business Intelligence Senior Data Modeler Resume Examples & Samples
- Apply rigorous data management principles and industry standard development approach to model SE NAM ‘s data assets to build and maintain conceptual, logical, and physical data models
- Coordinate with Data Architect & DBAs to define the optimal physical data model
- Develop and employ the industry and SE technical standards, procedures, and guidelines used to govern data models
- Direct, coach, and guide development teams in applying data modeling techniques and the usage of data modeling and repository tools
- Provide architectural expertise in Data warehouse construction and engineering, data source identification and engineering, data modeling, database design, operational flexibility and user self-service capabilities
- Support system integration of diverse components and technologies used in the design, construction, testing, deployment and operations of DW & BI solutions
- Detail and process oriented with great organizational, collaboration and analytical skills
- Advanced communication and interpersonal skills
- Advanced Data Modeling for Star Schema design
- Use-case analysis
- SQL query development for investigation and analysis
- Working knowledge of Reporting tools, ETL tools and database technology
- Working knowledge of Data Warehousing tools, theory and methodology
- Working knowledge of business domains
- 10-12 years of experience in architectural design of Data Warehouse Data Star Schema modeling
- Demonstrated expertise in Data Warehousing and Data management domains
94
Data Modeler Resume Examples & Samples
- BS or equivalent + 2 yrs related experience, or MS + 0 yrs experience
- Software design experience desired
- C++ programming experience desired
95
MDM Data Modeler Resume Examples & Samples
- Works in conjunction with the Requirements, Architecture, and Development Teams,
- Supports new and existing development projects through the completion of logical data and process modeling activities,
- Provides entity, logical, and physical data models
- Develops, documents, and maintains technical solutions and design artifacts for various MDM system components,
- Prepares high quality design documentation, including visual diagrams and processing flows,
- Maintains and updates Database Design Documents DDDs
96
Guidewire Data Modeler Resume Examples & Samples
- Bachelors Degree in Computer Science, Computer Engineering, or related field with 6 or more years of data modeling experience
- Data Mapping and Data Modeling experience
- Experience with Data Warehousing, Data Marts, and BI Design best practices and techniques
- Experience with ETL tools such as SAP, Informatica, or SSIS
- Bachelor’s Degree in Computer Science, Computer Engineering, or equivalent field preferred
- SQL scripting (TSQL or PL/SQL) including query optimization
- Guidewire experience
- DataHub experience
97
Data Modeler Resume Examples & Samples
- Design and Develop Application Data Models
- Design and Develop Reference and “Data Warehouse” Data Models
- Ensure the consistent use of Enterprise Reference Data within the application and “Data Warehouse” data models
- Develop and deliver long-term strategic goals for data architecture vision. Global and divisional stake holder standards must be met while creating short term tactical solutions to reach the long-term goals mapped out over all data management
- Establish processes for governing the identification, collection, and use of corporate metadata as well as create methods for tracking such data for quality, completeness, redundancy, and improvement
- Create data capacity planning, life cycle, duration, usage requirements, feasibility studies and other related required tasks
- Strategize what the best practices are in relation to data security, backup, disaster recovery, business continuity and archiving. Ensure all strategies are in compliance with enterprise procedures and regulations
- Act as liaison to vendors and service providers to select the products or services that best meet company goals and requirements
- Select and implement the appropriate tools, software, applications, and systems to support data technology goals. Drive best practice in regards to data warehouse, business intelligence, and reporting technologies
- The Data Architect will oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality. Collaborate with project managers, address data related problems in regards to systems integration and compatibility, as well as act as a leader for coaching, training and providing career development to stakeholders
- Developing and implementing key components as needed to support global application development and support initiatives
- Documenting enterprise data architectures and environments in order to maintain a current and accurate view of global data landscape
- Identifying and developing opportunities for data reuse, migration, or retirement
- Minimum of Bachelor’s Degree or equivalent degree
- Ability to review and provide feedback for complex data models implemented by partners
- Proven experience working in an outsource and offshore environment on major delivery programs
- Knowledge of all phases of SDLC and full lifecycle implementations
- Database Technologies: Acutate, Business Objects, MS Access, PowerMart, SQL, Trillium, Oracle, Sql Server, MySql, Teradata etc
- Others – ERWIN, SQL Designer, other data modeling tools
98
Data Modeler Resume Examples & Samples
- Understand and translate business requirements into data models supporting long-term solutions
- Work with the development team to implement data strategies, build data flows and develop data models
- Create conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
- Validate business data objects for accuracy and completeness
- Analyze data-related system integration challenges and propose appropriate solutions
- Ability to understand and integrate data from multiple systems, domains, and activities into the Operational Data Store model
- Guide the development team and others on project limitations and capabilities, performance requirements and interfaces
- Ability to communicate to business users the decisions made in the data model for optimal performance
- Design and development of data flow and transformations (input and output)
- Data standardization and quality
- 8-10 years of Experience
- Expert in dimensional data modeling for building structured data warehouses
- Should have implemented at least 2 full projects of large scale
- Data warehousing experience with data modeling of a min of 6 yrs
- Hands on experience with any modeling tool, Power designer will be an advantage
- Deep understanding of business processes (Key Process Chains) in high tech manufacturing business
- Exposure to Hadoop will be nice to have
- Exposure to ECC and understanding of SAP ECC data models will be a huge plus
- Experience with agile or other rapid application development methodologies
- Experience with a RDBMS –Microsoft SQL Server, Oracle, DB2, SAP ECC
- Experience in an market leading ETL tools (SAP DS, SSIS) and reporting tools (such as BO and Tableau) is a plus
- Experience collaborating with global teams
- Excellent verbal, written and presentation communications skills, organizational capabilities, and collaborative interpersonal skills
99
Senior Data Modeler Resume Examples & Samples
- Develop and maintain various data subject area data models for Data Warehouse, Operational Data Store and Data Marts
- Experience in Building complex, large scale logical data models with Erwin, E/R Studio, or another data modeling tool
- Experience in relational and dimensional schemas for Enterprise Data Warehouse
- Experience in data modeling (physical and logical), ER diagrams, data dictionary, data mapping
- Experience in Data Architecture and database design
- Experience with Database technologies (e.g. Oracle)
- Compose accurate and complete definitions for entities and attributes
- Design and Validate data solutions which are achieved through the application of industry proven architectural principles, standards and governance
- Gap analysis
- Data Mapping / Data Lineage mapping
- 5+ years of experience working as an Data Warehouse Data Modeler / Architect
- Oracle 11g
- Data Movement Architectural Patterns
- Thorough understanding of system development life cycles
100
Senior Data Modeler Resume Examples & Samples
- 8 or more years of experience with database architecture and design solutions
- 5 or more years of experience with data modeling tools such as Embarcadero ER/Studio or Erwin Data Modeler
- Extensive background in data modeling supporting application development and/or data warehouse development
- Clear understanding of relational and dimensional models, keys and constraints, normalization and indexes
- Experience in creating and maintaining enterprise data dictionary and logical/physical data models
- Hands on experience with writing SQL statements and running database queries in support of data analysis
- Experience in documenting and writing SOPs
- Experience in creating data flows and diagrams using tools like Visio
- Excellent organizational skills with the ability to work independently
- Experience with SDLC
- Experience working in Agile environments
- Experience with version control tools such as Rational Clear Case or SVN
- Knowledge in Oracle or Sybase database
- Knowledge in ETL process or data replication
101
Data Modeler Resume Examples & Samples
- 5+ years health insurance experience
- 5+ years experience of data modeling related projects (e.g. data warehousing, migration, data quality, data governance, analytics)
- 5+ years data analytics tools exposure (e.g. Business Objects, Cognos, SAS, Tableau)
- Consulting and development project experience
102
Data Modeler Resume Examples & Samples
- Develop Data Models, mapping documentation, ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code
- Works independently to develop, configure, code and test programs from specifications
- Presents all work in design review and code review sessions to senior team members, and must be able to explain and support decisions made and actions taken
- Interfaces with business analysts, project managers and clients to clarify requirements
- Assists other team members with their assignments (e.g., onboarding junior team members)
- Tests own work and contributes to the development of test plans
- Prepares documentation that describes installation and operating procedures, including application user guides, with limited guidance
- Can troubleshoot applications problems, with limited support
- Required to create or choose an approach or procedure from a variety of complex options for addressing a work task
- Has developed an understanding of the technical architecture, application landscape and IT environment, as well as tools used in development, deployment and testing
- Understands the structure and processes of the IT organization, including the roles of IT team members and the information and/or resources they may require
103
Data Modeler / Analyst Resume Examples & Samples
- 5+ years of experience with database design and data modeling
- Experience with configuration or version management of data models, including performing ER or studio tool maintenance, as needed
- Experience with creating or maintaining data flows and other documents using Visio or equivalent tools
- Knowledge of SQL, including running queries against the database for the purposes of data analysis on the Sybase platform
- Ability to enforce documented standards and provide guidance to application teams
- Ability to manage a SharePoint site and keep the contents updated
- Experience with SDLC preferred
- Experience with using the Rational suite of products and SVN a plus
- Knowledge of Oracle a plus
- Ability to work in a team environment and independently on assigned tasks
- Possession of excellent documentation and analytical skills
104
Data Modeler, Senior Resume Examples & Samples
- 3+ years of experience with data modeling tools, including Embarcadero ER, Studio, or Erwin
- Experience with data modeling, including supporting application development or data warehouse development and creating data flows and diagrams using tools, such as Visio
- Experience with defining and implementing naming standards, abbreviations, guidelines, and best practices
- Experience with creating and maintaining an enterprise data dictionary and logical or physical data models
- Experience with writing SQL statements and running database queries in support of data analysis
- Experience with documenting and writing SOPs
- Knowledge of relational and dimensional models, keys and constraints, and normalization and indexes
- Experience with working in Agile environments a plus
- Knowledge of Oracle or the Sybase database a plus
- Knowledge of the ETL process or data replication
- Possession of excellent analytical and organizational skills, including working independently
105
S/hana Cds/hana Data Modeler Resume Examples & Samples
- Minimum of 2-3 years’ hands-on and deep experience with HANA Enterprise (data architecture, data modeling, information modeling, SQLScript development)
- Minimum of 1 year hands-on experience with Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA, as well as deep development knowledge of Basic, Composite, and Consumption Views
- Minimum of 1year hands-on experience with S/4HANA Embedded Analytics, including development of Smart Business Tiles, Multi-Dimensional Reports, and Analysis Path Framework (APF)
- Minimum of 3-5 years’ experience in Enterprise Data Warehouse architecture, data modeling and development
- Expert data architecture and data modeling skills including 3rd NF, Dimensional, ODS and other techniques using various modeling tools
- Minimum of 3-5 years’ experience with SQL and database procedural languages such as PLSQL and T-SQL
- Experience with the architecture, design, development and testing of Data integration/acquisition process
- Experience with SAP HANA Enterprise in following areas preferred
- Analytical skills, problem solving ability
- Experience with multiple data integration tools (including ETL, data replication and data streaming tools) a plus
- Experience with database performance tuning (including optimizing HANA information models, SQLScript stored procedures and ETL data flows) a plus
- Experience with SAP ECC a strong plus (functional modules, underlying data structures, BW)
- Previous consulting experience required; Big consulting company experience a plus
- Ability and desire to mentor/coach others in a team environment
- Ability and desire to support sales team
- Ability and desire to share expertise with internal and external audiences
- Ability to demonstrate leadership skills through a variety of activities (related to practice, projects, accounts and prospects)
- Experience and interest in speaking at events or writing intellectual property a plus
106
Lead Data Modeler Resume Examples & Samples
- Proactively engage with the project stake-holders and understand requirements
- Logical and Physical modeling for Data warehouse
- Perform data analysis on source systems, data warehouse subject areas, and reporting data structures
- Leading data modeling discussions with Business in JAD sessions
- Strong SQL skills to pull data from Teradata/Oracle and perform usage analysis and/or data profiling
- 10 or more years of experience in Data Warehouse environment with emphasis on data modeling involving design, coupled with strong knowledge of end-to-end data warehouse development life cycle (data integration, logical and physical modeling, and data delivery) supporting enterprise analytics and BI solutions
- At least 8-10 years of progressive experience in Data modeling with emphasis on Dimensional modeling
- Five or more years of enterprise level data design and development
- Hands on experience with modeling tool such as ERWIN or another tool
- Functional knowledge/experience of the Consumer Banking/Financial Services Industry
107
Data Analyst / Data Modeler Resume Examples & Samples
- A bachelor's degree in computer science, or a related field OR commensurate experience is required. The candidate must have a minimum of 8 years IT experience focused in software design with emphasis on the following technologies and tasks: UML (Use Case, Activity, State Chart, and Class Diagram), ERD and database normalization options, ETL, Data Warehousing, Business Intelligence, Data Marts, Cognos
- Advanced RDBMS Database experience (one or more of the following: DB2, Oracle, SQL/Server or comparable) including database modeling, SQL query, and procedural programming
- Experience using Requisite Pro, RUP, and Scrum
- Data Warehousing / HIPAA 5010/ICD-10 experience a big plus!
108
Data Modeler Resume Examples & Samples
- 50% Data Modeling
- Understand business requirements and build conceptual, logical and physical data models across multiple data domains or functions (customer, vendor, finance, procurement etc.)
- Works with BU/function to determine high level project requirements and then translate those into data domain specific requirements for design
- Identify and own integration scenarios across data domains, major process areas as well as across teams
- Develop and maintain complex enterprise or project-specific architecture by providing significant insight into definition of target or solution architecture, architecture reviews and selection efforts
- Assess impact of proposed changes and upgrades on architecture
- Identify and address inter-application dependencies and interfaces
- Provide support/consultation for detailed design, deployment, production support and ongoing Data Governance activities
- Maintain domain related governance process and data model for the Master Data hub
- Develop, recommend and implement continuous solution improvements to increase accuracy, reduce cost and increase speed to market
- 30% Data Catalog/Metadata Management
- Works with the Enterprise Architects/Data Architects to define strategy for creating & maintaining metadata about Cargill’s diverse applications & data sources
- Support the design, build, test and maintaining of the Data Catalog, a key component of Cargill’s Big Data and Advanced Analytics platform
- 20% Business Partnering, Relationship Management and Consulting
- Regularly interfaces with other architects, analysts, process designers, and BU/Function subject matter experts to understand and evaluate business requirements
- Provide technical consultation and recommendations for Data Management solutions for multiple BUs/FNs aligned to their business drivers and goals
- Provides general awareness of projects creating Data Management opportunities for the organization and where they may impact existing DM solutions
- Collaborates with key stakeholders, peers and project leadership to ensure DM solutions are implemented successfully including resolution of integration issues across teams
- 6 + years of experience in IT or business/industry experience
- 4 + years of experience building logical and physical data models
- 2+ years of experience using data modeling tools such as ER/Studio Data Architect, Erwin etc
- Ability to lead the development of integrated solutions involving process, data, and technology
- Demonstrated strong business facing skills
- Proven ability to work effectively within a large organization that operates using matrix management structures
- The ability to define data management solutions that cross multiple process areas and teams
- Experience working in a global team
- Experience with solution architecture, preferably with a data architecture component
- Multiple implementation experiences with Major ERP, CRM, SRM and SCM solutions
- Experience working on at least one full lifecycle ERP (Enterprise Resource Planning) or ECM (Enterprise Content Management) implementation, preferably in a global organization
- Experience in building enterprise data models
- SAP ERP Experience
- SAP MDG Experience
- Informatica MDM Experience
- Master Data Management solution experience, including centralizing and consolidation
- Information Steward Experience
109
Senior Data Modeler Resume Examples & Samples
- Understand business requirement and create Conceptual, Logical and Physical models
- Design and maintain data architecture, database that is used in relation with data architecture that is flexible and scalable
- Define the overall data warehouse architecture (e.g., ETL process, EDW, Data Marts)
- Define technical requirements, technical and data architectures for the data warehouse
- Assist in the development of strategies for archive, data recovery, database implementation and data acquisition
- Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
- Design and direct the information access and delivery effort for the data warehouse
- Work with other IT groups and departments to assist in the coordination of future activities and plans
- Identify and recognize areas where the data models can be modified or enhanced to provide future business requirements
- Lead and sometimes direct the work of others; works with a team to accomplish common goals
- Experience in data modeling, meta data management and data integration tools
- Expert in developing data models – relational, dimensional, subject areas, and business models
- Experience in supporting as well as implementing Oracle and SQL data infrastructures
- Experience in indexing, SQL performance tuning and optimization techniques
- Knowledge of the entire process behind software development including design and deployment; SOA knowledge and experience is also preferred
- Exhibit knowledge of the design, development and maintenance of data models and their components using different tools
- Understand BI tools and technologies as well as the optimization of underlying databases
- Hands on experience of SQL queries and reporting tools
- Bachelor’s Degree in Computer Science, Information Systems, or other related field; 8-10 years relevant analysis and programming experience may substitute for the degree
- 5 years (minimum) work experience with data warehouse/business intelligence projects using Data Warehouse best practices
- 5-7 years’ experience working as a data warehouse data modeler
- 5 years’ experience data warehouse/business intelligence projects using Data Warehouse best practices
- Exceptional analytical skills necessary to identify and resolve technical issues or problems
- Experience in clinical setting is preferred
110
Data Modeler Senior Specialist Resume Examples & Samples
- Data preparation (sourcing, acquisition, integration)
- Information delivery (portals, mobile)
- Enterprise / Corporate Performance Management
111
Data Modeler Specialist Resume Examples & Samples
- Develop, maintain and support GWS SSIS framework
- Develop, maintain and support SSAS Cubes
- Develop, maintain and support reports in Tableau
- Resolve any data warehouse issues in a timely and accurate manner, whilst ensuring all key controls and SLAs are strictly adhered to
- Perform root cause analysis of on-going issues and implement an optimal solution with data architect
- Reviewing existing stored procedures, advise on improvements using advanced T-SQL
- Creating ad-hoc reports and data extracts for business needs
- Troubleshooting reporting issues, ETL job failures, optimizing query performances
- Support the whole project life cycle from designing, development, through implementation and post implementation support
- 3+ years’ experience in developing and administering Microsoft SQL Server
- Advanced T-SQL development E
- SSIS E
- SSAS HD
- MCSE D
112
Data Modeler Resume Examples & Samples
- Map logical entities to the conceptual Data Model
- Ensure data objects adhere to defined enterprise standards and best practices
- Create logical data model using ER STUDIO as the modeling tool
- Experience with XML data and modeling XSDs
- Support DDL PROD implementation
- Support post-production validation of DDL
- Experience with data management standards
- Experience with physical data structure design in Oracle & SQL Server using ER Studio
- Mortgage/finance industry data modeling experience
- Proven ability to quickly earn the trust of key stakeholders
- Thrives in an environment with changing priorities
- Able to navigate through a large corporate environment and ensure appropriate processes are met
113
Senior Cassandra Data Modeler Resume Examples & Samples
- Analyze functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models
- Create data models (logical) and DB designs (physical), that depict the business areas and systems in the customer portal to ensure the integrity of the business data is being maintained; incorporate applicable standard data elements; ensure solutions are accessing the system of record for shared or enterprise data; and ensure adherence to technical DB design standards in accordance with the approved WFS Data Modeling and DB Design Standard
- Refine existing data models of WFS’s business areas and systems
- Facilitate data modeling sessions, ranging from information gathering to model validation
- Create the data architecture sections of system design document for development efforts
- Provide requirements analysis support to development teams and educate project and development teams on the proper usage of the data structures. Analyze data access and modification requirements to ensure efficient data retrieval/ ingestion and optimal DB design
- Perform DB design, review DB design from development team, and generate initial data definition language, as needed
- Design and develop a data migration strategy and source to target mapping to migrate the data out of the legacy systems into the Cassandra customer DB
- Provide optimal design for structured and non-structured data using SQL and NoSQL databases
- Enhance DB performance from physical DB design perspective
- Provide technical advice and prepare technical documentation on data architecture related trends, issues, and tools and provide input into the agency-wide data architecture standards
- Analyze relevant technical issues, data structures, and data, and at the discretion of the Development Manager, Program Manager, or Business Analyst
- Breadth and depth of skill to build and deliver scalable data and reporting solutions for WFS
- Deep knowledge and experience with the Cassandra, related software tools, and performance optimization
- An obsession with delivering an exceptional customer experience and site resiliency
- Desire, initiative and resourcefulness to learn new tools, frameworks, languages
- A commitment to WFS ideals of efficiently delivering the world’s energy needs
114
Enterprise Data Modeler Resume Examples & Samples
- Development of Business Intelligence Data Warehousing areas include: Data Analysis, Data Modeling
- Responsible for detail Data analysis and translates Business requirements into logical data models
- Derives data designs and identifies opportunities to re-engineer data structures, and recommends efficiencies as it relates to data storage and retrieval
- Responsibilities include translating business requirements into data designs
- Working knowledge of the software implementation lifecycle, leadership skills and the ability to work well with both business clients, developers and other architects
- Development of data warehousing centric Data Analysis and Data Modeling strategic direction for the department
- Serve as a liaison between the business experts/users and the project technical team to ensure the users requirements are understood and interpreted correctly by the technical team
- Ability to participate as a senior Data Analyst gathering of source systems, processing logic, content and operational system usage
- Bridges gaps across business areas, operational business units, infrastructure team, and Data Warehouse development teams
- Experience in capturing and presenting all levels of Enterprise Metadata
- Works on multiple large complex projects with cross functional teams and business
- Applies broad in depth retail business and technical knowledge to establish direction
- Develops technical architecture, data model, and documentation of all projects
- Enforces data and technical solutions, standards, and governance
- Generates documentation for the program or project and other technical deliverables
- Stays current in new technologies as well as new opportunities to develop knowledge and staff
- Excellent communication (written and verbal). Full life cycle experience in Data Warehousing, Data Modeling, Data Integration, and Master Data Management
- Excellent understanding of solutions architectural principles, data integration, and data warehousing
115
Data Modeler / Analyst Resume Examples & Samples
- Develops/manages complex data models (conceptual, logical, & physical) in multiple formats (relational, star/snowflake, object-oriented, etc..)
- Analyzes & acquires data from primary and secondary data sources – creating mapping specifications/requirements for use by ETL development resources
- Drives data modeling best practices within the team
- Works with business partners to prioritize business and information needs
- Maintains knowledge on current and emerging developments/trends for assigned areas of responsibility, assesses the impact, and collaborates with management to incorporate new trends and developments in current and future solutions
- Champions and enhances organizational initiatives by positively influencing and supporting change management and/or departmental/enterprise initiatives within assigned areas of responsibility
- Serves as a resource to team members and applicable internal/external stakeholders on more complex assignments/projects for his/her assigned areas of responsibility
- Identifies and recommends process improvements that significantly reduce workloads or improve quality for his/her assigned areas of responsibility
- Analyzes, designs, codes, debugs, integrates and tests increasingly complex software application solutions for systems
- Determines how existing applications, systems, databases, interfaces and/or hardware can interact to meet new and emerging enterprise initiatives
- Identifies potential application solutions by understanding increasingly complex business/technical problems and opportunities
- Provides input and validates increasingly complex project plans, test plans and implementation plans
- Creates increasingly complex technical specifications from business requirements/business specifications
- Consults and/or participates in the requirements, design and coding walkthroughs to ensure the development of quality solutions
- Investigates and resolves increasingly complex problems including providing support for production systems in a timely manner
- Proactively identifies problems and presents/develops solutions
- Communicates effectively with internal stakeholders and management
- Defines detailed development tasks, task dependencies and estimates to complete work
- 3 - 5+ Years experience in application development that directly aligns with the specific responsibilities for this position (Required)
- 2+ Years experience implementing relational database designs, data warehousing, data architecture, & data modeling, including strong knowledge of various data modeling approaches and practices (experience with 3NF, star schemas, and multi-dimensional designs)
- Experience with ERwin Enterprise Data Modeler Suite or equivalent modeling software (Required)
- Experience with data quality management and metadata management
- Strong knowledge of various SDLC practices in both waterfall and agile team environments
- Hands-on experience with large, transactional databases (Oracle 11g or 12c) including strong SQL & PL/SQL skills
- Good communication and interpersonal skills for interacting and collaborating with developers, analysts, and business staff throughout the organization. Ability to express complex technical information in a user friendly language and style and present information effectively in 1-on-1 and small group settings
116
Data Modeler Resume Examples & Samples
- This position requires working onsite daily at our facility in Vancouver
- Working with the client to obtain detailed information on every data field in the legacy database, a release of the client’s production database
- Evolves the present-case data model into the future-case data model, working with the business analysis, development and test teams
- Transforms and migrates the data into the future-case data model using the Dell data modernization tools
- Maintains the data model and migration processes during development
- Ensures the quality of the migration
- Executes the data migration
- Produces test data for the development team using the DMT and DMW
- Works closely with the client to cycle migrated data
117
Data Modeler Analyst Resume Examples & Samples
- At least 2 years of technology experience
- Experience as a Data Modeler and knowledge of Erwin is a plus
- Experience with Oracle, DB2, or Teradata databases is a plus
118
Logical Data Modeler Resume Examples & Samples
- Identifies cause of data issues and works with broader team to resolve issues
- Leads design reviews of data deliverables such as models, data flows, and data quality assessments
- Provides senior level data modeling services, including updating and building logical/physical database models
- Works closely with the development and QA teams to communicate the business rules and ensure testing use cases target the quality and integrity of the data model
- Works with senior DBA staff to identify and resolve issues or transform logical database models into physical database designs that represent the business rules while optimizing the performance and maintainability of the design in the physical database
- Uses a variety of information gathering techniques (e.g., interviews, diagrams, facilitation) to gather complex business data requirements from internal business clients and development teams
- Provides design feedback to web service development developers to highlight design considerations that impact data quality and integrity of the model
- Works closely with other application areas within the company to ensure that data integrations are efficient, follow AA technical standards, and meet the business requirements
- Ensures that all data deliverables comply with AA security policies and regulations (PCI, PII)
- Minimum 5 years of experience in data modeling, including conceptual, logical, physical, Operational data store
- Experience with a modeling tool (Embarcadero ER/Studio, Erwin, etc)
- Experience designing and developing logical and physical data models
- Experience in data architecture and strong understanding of data movement and data layout
- Some Technical experience in coding or database administration or system administration would be preferred
- Experience working in a master data management solution or other large CRM system
- Experience working with database (Oracle/SQL Server) and writing SQL
- Strong facilitation experience with business stakeholders to capture data requirements
- Experience in identifying and resolving data quality issues to the team and business partners
- Strong analysis and deep problem solving skills
- Must be a self-motivated driver to find out data issues and resolve them quickly
- Must be a self-motivated driver to understand the broader system
- Ability to evaluate DDL for completeness and accuracy before submission to a DBA
- Ability to perform data analysis, and data discovery
119
Data Modeler Resume Examples & Samples
- Analyze business reports and analytical requirements
- Conduct interviews and brainstorming discussions with teammates
- Develop logical and physical dimensional data models
- Ensure data objects adhere to defined standards and best practices
- Statistical Data modeling, including reverse and forward engineering
- Programming in R (required), SAS (desired), SPSS
- Data collection, cleansing, analysis, inference
- 3+ years of overall experience in data modeling
- Experience with data analysis, data profiling, and data mapping
- Experience maintaining and coordinating a data modeling effort in an Agile SDLC environment
- Experience with various data modeling tools
- MUST have an ACTIVE SECRET security clearance and be confident no personal issues will prevent the government from issuing a work-site access badge. This includes successful completion of, work experience, education, credit/financial and criminal history records checks
- U.S. Citizenship is required
120
Data Modeler Resume Examples & Samples
- Participate in requirements definition, analysis and the design of logical and physical data models
- Map business requirements to logical and physical da ta models
- Conduct data model reviews with project team members
- Generate, modify, and version data object scripts using HCA source control solution. Enforce & promote standards and best practices in data modeling efforts
- Improves data models by evaluating results, implementing enhancements, develop and maintain source-to-target mapping documentation
- Work independently to develop, configure, code and test programs from specifications and agency needs
- Presents all work in design review and code review sessions to team members, and must be able to explain and support decisions made and actions taken
- Interfaces with business analysts, project managers and subject matter experts to clarify requirements
- Understand the structure and processes of the data management and analytics organization, including the roles of team members and the information and/or resources they may require
- Provides technical consulting and advises teams and customers on the design of conceptual and logical data models resulting in an efficient and effective physical design for all internal and enterprise systems
- Studies and documents existing and proposed data definitions, uses and characteristics for reuse and integration opportunities. Defines data elements and data relationships based on existing agency data architecture standards. Identifies master data candidates and collects metadata
- Collaborates with HCA's Data Architect to ensure application of agency standards, policies and procedures for creating and maintaining enterprise data models and documentation
- Participate in data architecture sessions and promote integrated systems and controlled data redundancy
- Develop highly complex and cross-functional business intelligence and custom Extract, Transform, and Load (ETL) solutions
- Ability to work effectively as a member of a multi-disciplinary team
- Ability to work in a fast-paced, agile environment
- Commitment to quality, diversity, and public service values including a demonstrated commitment to meeting customer needs
- Must be extremely responsive, able to work under pressure in crisis with a strong sense of urgency
- Must be detail oriented and possess strong problem-solving skills and ability to analyze for potential future issues
- Responsible, conscientious, organized, self-motivated and able to work with limited supervision
- Exhibits sound judgment and the ability to make reasonable decisions in the absence of direction
- Advanced knowledge of data warehouse/business intelligence methods, tools, standards, and technical architecture best practices; the ability to analyze and develop technical capabilities and apply best practice principles to best meet agency needs
- Ability to work collaboratively with multiple different team members including business, technical and external stakeholders
- Demonstrated technical expertise with Oracle, Microsoft SQL Server or other Relational Database Management System (RDBMS)
- Demonstrated ability in developing, Implementing Extract, Transform ad Load (ETL) procedures and Business Intelligence Solutions
- Three professional references
- Persons under final consideration for initial appointment with HCA are subject to a background check*
121
Senior Data Analyst / Data Modeler Resume Examples & Samples
- Learn the current data flows and be able to change or improve upon them based on current use cases
- Demonstrable experience using data modeling tools - e.g., ERStudio
- Work with Business & Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc
- Background in ETL development, data analysis, mapping, and automated loading preferred
- 5+ years of hands-on experience on data architecture, data analysis and logical/physical data modeling
- Good Concept of Dimensional modeling
- Good Concept of Data Warehousing
122
Enterprise Data Modeler Resume Examples & Samples
- Data Architecture and Modeling, tasks include
- Develop, document and maintain conceptual, logical and physical data models for medium to high complexity projects
- Capture technical metadata through data modeling tools
- Convert logical data models into the first cut physical database models and generation of Data Definition Language (DDL)
- Bachelor’s degree in business management, computer science, information technology, or equivalent education and/or 10+ years work experience in Data Management field
- A minimum of four (4) years of experience working as a data architect, modeler and/or business intelligence designer utilizing a set of frameworks, methods, and techniques to develop complex data models in support of business requirements
- 10+ years’ experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data
- 7+ years’ experience with Oracle and/or SQL Server RDBMS, PL/SQL & SQL
- 5+ years’ experience in ETL tools such as Informatica, ODI & SSIS
- 5+ years’ experience in Data Modelling tools like Embarcerdero
- Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills
- Good understanding of Data warehouse and Operational Data Store concepts
- Good understanding of Informatica/ODI/SSIS or related ETL tools
- Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk
- Experience with Data Modelling tools such as Embarcerdero / ERWIN / SQL Modeller
- Familiarity with development methodology such as Agile, Waterfall and Systems Engineering
123
Senior Data Analyst / Data Modeler Resume Examples & Samples
- Gather and analyze business requirements
- Architect and design Data Warehouse infrastructure and solutions
- Develop technical specifications and design documents
- Develop, enhance, and integrate Data Warehouses / Data Marts and Business Intelligence Solutions
- Deploy and maintain Data Warehouses / Data Marts
- 5+ years of Data Analysis with mindset of translating into Data Marts
- 3+ years of work experience enterprise size Data Warehouse
- 3+ years of work experience writing SQL
- Familiarity with ETL tools
- Health care or Insurance (Claims) industry experience
- Experience with Microsoft Parallel Data Warehouse (PDW)
- 7+ years of work experience enterprise size Data Warehouse
- 7+ years of work experience writing SQL
- Experience querying data from multiple database platforms
124
Senior Data Modeler Resume Examples & Samples
- Partners with Business and IT groups to design and implement data and modeling solutions that meet or exceed organizational initiatives and are consistent with enterprise architectural standards
- Ensures compliance with all architecture directions and standards through cross organization consulting and direct involvement in development efforts
- Develops and documents artifacts and templates in the chosen tool repository
- Understand the Project Proposal and assist the team in analyzing how the new system or functionality can be integrated in the environment, identifying existing systems, concepts, possible data sources and issues
- Analyze data-related systems integration opportunities and challenges
- Ensure solution designs address performance requirements and reusability, availability, integrity and security challenges, and business functional requirements
- 9-10 years' experience in a Data Modeler role with deep knowledge of Relational and Dimensional Modeling in a Complex Data warehouse environment
- MUST be strong in Dimensional & 3NF Data modeling
- To be well versed with financial regulations related to capital adequacy, BSA AML compliance, regulatory reporting and IHC
- Should have Good inter personals skills
- Expertise in implementing Data warehouse solutions, Operational data stores and real time data integration
- Experience with Development Methodologies, Databases Platforms (Teradata, Oracle/ SQLServer), including deep knowledge in SQL & PL/SQL
- Expertise in Data Modeling tools (Erwin/Model Manager)
- Superior relationship management, consultative, presentation, and communications skills
125
Data Modeler Resume Examples & Samples
- Assess and interpret customer needs and requirements
- Involved in solving moderately complex problems and/or conduct moderately complex analysis
- Provide explanation and information to others on difficult issues
- Coach, provide feedback and guide others
- Maintain knowledge of current domains and strategic roadmaps
- Identify/quantify scope and impact of business changes on systems
- Incorporate software and system architecture into conceptual designs
- Support applicable modeling efforts (e.g., data modeling, process modeling, hardware modeling, performance modeling)
- Provide oversight of conceptual designs to ensure alignment with enterprise architecture governance (e.g., principles, policies, standards, future-state reference architectures)
- Maintain awareness of current technology assets, and the applicability and capability of each
- Responsible for maintaining awareness of current business and industry issues/trends and incorporate into enterprise architecture designs as appropriate
- Undergraduate degree or a minimum of 5 years of IT experience
- 5+ years of Information Management Experience (Data Modeling, Database Design, Data Integration, etc.)
- Solid understanding of industry patterns for data architecture and integration
126
Dhts Data Modeler Resume Examples & Samples
- Work independently or partnered with other IT analysts to gather business and technical requirements from users and business analysts
- Capture and document project scope and requirements
- Develop a logical and physical data model to support project requirements
- Document and publish relevant metadata and specifications
- Work under the oversight of the BI Architect on project BI Design
- Maintain a shared data model in ERWin
- Perform source system analysis and data profiling
- Generate SQL statements to demonstrate and validate data model and guide development
- The Data Modeler will be expected to leverage their knowledge of data modeling best practices along with industry data expertise and data modeling tool expertise
- Solid and effective written, interpersonal, oral and presentation skills
- Excellent analytical and problem-solving ability
- Skilled in requirements gathering and data analysis
- Data sourcing, data mapping and managing metadata
- Experience with Agile development methods preferred
- Proven ability to produce logical flows to support the design of data solutions
- Experience using data modeling tools - e.g., ErWin
- Evaluate existing data models and physical databases for variances and discrepancies
- Validate business use cases for accuracy and completeness of proposed data models
- Ability to plan and lead meetings with diverse participants
- Ability to effectively lead a project team In addition to the above
- Leadership for data modeling team including but not limited to
127
Data Modeler Resume Examples & Samples
- Work with offshore team members
- Participating in data modeling discussions with Business in JAD sessions
- Work with lead to establish standards around flexibility of the data model to ensure deviations are within established guard rails
- Define/maintain application specific solution designs that align to target state data ecosystem architectures, including viable alternatives with value propositions / trade-offs
- Assist with defining data model development methodologies, principles, standards, and governance considering People and Process optimization aspects
- Decompose requirements into project specific deliverables and prioritize
- At least 5+ years of progressive experience in Data modeling with emphasis on Dimensional modeling
- Hands on experience with Massively Parallel Processing (MPP) and NoSQL database technologies used in modern data warehouse architectures supporting Discovery Analytics and BI
- Understand Big data architecture for analytics and is capable of developing solutions per firm standards
- Working in a fast pace environment handling multiple project deliverables
- Excellent interpersonal skills, written and verbal communication skills
128
Data Modeler Resume Examples & Samples
- 4 Year IT College Degree/Masters preferred or equivalent work experience
- 10 years in business environments in Data Modeling, primarily in Manufacturing/Supply Chain
- Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, PHYSICAL data models
- Experience with industry mainstream modeling tools such as Erwin, Erstudio and PowerDesigner (ERwin required)
- Ability to evaluate existing data models and physical databases for variances and discrepancies
- Experience with managing meta data for data models
- Ability to work with Business Analysts and Business Users and Data Owners
- Ability to work with Data Architects and Data Management team
- Knowledge of data access security options
- Knowledge of more than one RDBMS platform such as SQL Server, Oracle, Netezza, Teradata and DB2 / UDB
- Responsibilities
- Acts as a champion to promote usage and adoption of models across the Enterprise
- Creates, validates, publishes and maintains enterprise logical data models
- Responsible for the Data Model repository maintenance and for the development and administration of the appropriate roles
- Participates in the development and maintenance of technical and business metadata including table and column descriptions and an overall business glossary of terms
- Assists with the design of the analytic data structures and the associated semantic (views) layer
- Works with Business Analysts, Business Users and Data Owners to understand business needs
- Works with other Data Architects and Data Management team
- Leverages and enforces standards for data naming conventions to ensure consistency and reuse of data models
- Performs reverse engineering of physical data models from databases and SQL scripts
- Validates business use cases for accuracy and completeness of proposed data models
- Participates in technical and design reviews and acts as the subject matter expert on source and target data structures
129
Senior Data Modeler Resume Examples & Samples
- Bachelors Degree in a technical or business discipline or equivalent technical expertise
- General knowledge in the following areas: IT concepts, strategies, and methodologies, IT architectures and data standards, and general knowledge of a business function(s) and of business operations
- Knowledge of data design and tools
- Proficiency in SQL and DBMS languages and tools
- Knowledgeable in new and emerging technologies
130
Data Modeler Resume Examples & Samples
- At least 10 years’ experience in data integration, and design of data flows from multiple sources and 3rd party collection processes for consolidation into data warehouse
- At least 5 years’ experience developing predictive and prescriptive analytical tools; optimization modeling
- Advanced knowledge of Tableau or Microsoft Power BI
- Advanced SQL and VBA
131
Data Modeler Specialist Resume Examples & Samples
- Working with project stakeholders and solution architects to understand requirements and help define appropriate solutions
- Working with database administrators to set up and configure databases in accordance with the project needs
- Working with project stakeholders to develop high-quality new data models
- Working with project stakeholders to ensure quality of existing data models and database designs
- Ensuring accurate and timely resolution of problems, applying structured development and implementation techniques
- Delivery of online IT products and services
- Ensure customer satisfaction through delivery of a high level of service
- Working closely with external and internal service providers and maintain consistent standards and quality assurance
- Previous experience of real time database based development using Oracle RDBMS
- Practical experience of developing and implementing robust and scalable data models
- Experience with overall system design, configuration, customization, integration, testing and support
- Experience with all or some of the modern software engineering techniques e.g
- Test-Driven Development (TDD)
- Continuous Integration (CI)
- Code validation and quality analysis
- Solid written and verbal communication skills and able to articulate the technically complex to be understood by both technical and non technical personnel
- Ability to manage conflicting priorities and multiple tasks
- Stakeholder management skills at a technical and non-technical level
- Good critical reasoning and problem solving skills – sticks to the problem until it is resolved
- Customer-orientated, whether responding to support queries or developing new functionality
132
Data Modeler Resume Examples & Samples
- 5+ years of experience with architecting database solutions and database design
- 3+ years of experience with data modeling tools, including Embarcadero ER or Studio or Erwin Data Modeler
- Experience in data modeling, supporting application development and data warehouse development and creating and maintaining enterprise data dictionary and logical or physical data models
- Experience in defining and implementing naming standards, abbreviations, guidelines, and best practices
- Experience in creating data flows and diagrams using tools, including Visio
- Knowledge of relational and dimensional models, keys and constraints, normalization, and indexes
- Experience with working in Agile environments
- Experience with version control tools, including Rational ClearCase or SVN
- Knowledge of Oracle or Sybase database
- Knowledge of ETL process or data replication
133
Data Modeler Resume Examples & Samples
- Bringing a solid technical expertise of creating abstract data models to be used as a basis in a highly available and scalable database architecture used for real time access
- Using appropriate state-of-the art tools to reveal data models lying behind existing database designs
- Working on enhancements to databases already in operation
- Working with database administrators to design necessary changes to existing database designs
- Embrace emerging technologies and solutions in order to ensure our online experience continually evolves to address the needs of the market and our customers
- Excellent interpersonal skills and strong emotional intelligence
- Able to develop scalable solutions that can be utilised by current and future channels – e.g. mobile
- Stakeholder management and interpersonal skills at both a technical and non-technical level
- Able to work in a collaborative environment
- Understanding the importance of real business engagement in all stages of IT product lifecycle working in both waterfall and agile delivery methodologies
- Excellent attention to details
- Experience with large Full Life Cycle project implementations
- Experience of setting, refining and implementing technical standards
- Experience within a customer focused environment
- Consumption and production of Application programming interfaces (API’s)
134
Data Modeler Resume Examples & Samples
- Understand and translate business needs into data models supporting reporting and ad-hoc analysis
- Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models
- Create logical and physical data models using best practices to ensure high data quality
- Optimize and update logical and physical data models as needed
- Maintain conceptual, logical and physical data models along with corresponding metadata
- Assist ETL and BI teams and end users to understand the data model
- Create SQL code from data model and coordinate with DBAs to create non-prod and pre-prod databases
135
Data Modeler Resume Examples & Samples
- Serves as subject matter expert responsible for applications related to the Microsoft .NET environment
- Performs needs assessments, data analysis, data base design, programming, testing, debugging, deployment, implementation and documentation of databases and applications within the Microsoft .Net environment
- Works with application developers from High School Scheduling and Transcripts (HSST), Automate The Schools (ATS), Sourcecorp, Special Education Component (SEC) and the Child Assistance Program (CAP) systems, to code programs, perform uploads, develop stored procedures of views, update processes for various applications, assist with the maintenance of databases and perform extracts
- Provides data to outside entities such as the University Academic Planning Council (UAPC) and to the New York State Education Department regarding the eScholar system information
- Coordinates and directs data management activities that include the migration of data from existing Department of Education databases to the Schools Interoperability Framework (SIF) database. Migration will occur as needed for new system development and for the migration of existing systems to the .Net environment
- Performs data mapping, and data conversion. Develops business objectives for retrieving data
- Defines data into precise data models which specify entities, attributes and relationships between the data
- Assists in performing project planning, feasibility studies, cost-benefit analyses, impact analyses, and prioritization for tasks related to the migration of data from existing mainframe and SQL server databases and related applications to the SIF model. Works to troubleshoot, provide data services and resolve problems arising from the conversion of data from the Student Information System (SIS) to the SIF model
- Works to ensure accuracy and completeness of data backup and recovery is completed. Monitors databases for optimal performance, best practices, policies and procedures
- A four-year high school diploma or its educational equivalent and six years of satisfactory full-time computer software experience as described in "1"above, including one year in a project leader capacity or as a major contributor on a complex project; or
136
Junior Data Modeler Resume Examples & Samples
- Design, develop and test deliverables in our Data Virtualization - Data Self-Service environment
- Become the subject matter expert on toolset and technology - must demonstrate personal drive to achieve expert status
- Review and manage work assignments (includes support cases) for team in an Agile environment
- Estimate tasks and successfully deliver upon committed dates
- Demonstrate ability to set and manage own priorities effectively in a dynamic organization
- Be an effective listener, who can give timely and constructive feedback. Is willing to state opinions assertively and deals constructively with conflict situations. A problem solver as well as willing to comprise for a common effective and efficient solution
- Work as a team; cross trains as well communicates effectively and efficiently in a virtual team environment
- Support enforcement of security and access control measurements to safeguard database authentication and authorization infrastructure
- Work closely with business analysis and application owners to review and detail project requirements and design
- Identify opportunities for improvement and innovation
- Assist in the preparation of designs and technical and/or functional specifications
- Perform code reviews and work with teammates on according to company coding standards and best practices
- Ensure successful implementation and support of project efforts by working with team on integration activities
- Use ETL standards and practices toward establishing and following a centralized metadata repository
- Work with business areas and IT to ensure integrity and proper integration for all sources of enterprise data
- Bachelor of Science in Computer Science or equivalent years of relevant work experience
- Strong knowledge of relational databases (SQL)
- 1-2 years of ETL development project experience
- 1-2 years of data design/development experience (data modeling, analysis)
- Prior data integration experience; ETL, EII, etc
- Knowledge of technical concepts, such as: logical and physical data modeling, performance tuning, code reviews process, data normalization processes, data integration methods, Agile SDLC, production support, etc
- Microsoft BI Stack (SQL Server 2012, SSIS, SSRS) experience is highly preferred
- Data Virtualization (JBoss) experience is a plus
- Java experience is a plus
- Travel industry experience is a plus
- Understanding of the Agile and Waterfall methodologies
137
Senior Data Modeler Resume Examples & Samples
- Expert level knowledge of GRC data elements, sets
- Experience in atleast one end to cycle of implementing data strategy of large enterprise level platform
- Proficiency in tuning efficiencies across data life cycle – acquisition, load, transformation and reporting
- Able to develop conceptual, logical, physical models of data using tools mentioned below
- Ability to develop related meta data and data dictionaries
- Thorough working of tools such as ER/Studio, Power designer
- Good understanding of Object models and their relationship with relational models
- Should have experience of implementing enterprise level platform data modeling for a cross domain ( preferably) GRC project
- Should have at least 8-10 years of experience
- Modeling of data across relational and object structures
- Knowledge of GRC data
- Proficiency in data modelling tools
- First class degree with excellent academic qualifications. B.Tech in analytical braches such as Comp science, IT
138
Senior Data Modeler Resume Examples & Samples
- Data Sourcing Rules and Authoritative Data Sources
- Taxonomies and Ontologies
- Reference Data Management Methods and Practices
- Data Provenance, Lineage and Design Traceability
- Logical functional components typical of an Corporate Banking organization
- Regulatory and Standards environment affecting the Banking organization, such as BASEL Risk Data Aggregation Principles, FDS, ISO 20022, SWIFT
- Industry and Vendor Standard Data Frameworks, such as BIAN, and IBM FSDM
- UML Class, State Transition and Communication diagrams
- Rule Expression Languages and Grammars such as Regular Expressions, Backus-Naur Form, OWL
139
Senior Logical Data Modeler Resume Examples & Samples
- Minimum 5 years of experience gathering business requirements
- Minimum 5 years of experience working with Teradata, Oracle, SQL Server Databases, SQL
- Has a strong fundamental understanding of project management, specifically in the SDLC and Agile methodologies
- Excellent written and verbal communication skills to enable
- Ability to lead meetings with technical peers regarding the requirements definition
- Ability to communicate effectively with business, vendor, and project management staff
- Can participate in ongoing decisions regarding study design, data collection, data analysis, and Methodology
140
Hana Data Modeler Resume Examples & Samples
- Ability to lead and facilitate design workshops (Blueprint), assessments, planning sessions i.e. demonstrate leadership experience in upfront projects
- Analyze, design, create HANA data models to solution complex data transformations
- Harmonize master data and transactional data and building data models (in HANA from non-SAP source systems)
- HANA view optimization and performance tuning
- The resource will provide guidance on best practices and provide knowledge transfer to other team members for ongoing support
- Experience with the architecture, design, development , testing & deployment of various development artifacts in HANA
- Well versed with Information Modeling, Table designs, and HANA SQLScript
- Well versed in designing business intelligence architecture and reports on HANA
- Experience with Data Provisioning and Business Intelligence
- Should have excellent understanding of the In-memory columnar database functionality
- Should be able to design relational databases for complex business scenarios
- Should be well versed with HANA Studio, Modeler, SQLScript debugging,
- Strong expertise in database performance tuning as well as optimizing SQL queries
- Experience with multiple relational, dimensional, and MOLAP databases
- Experience working with S4 on HANA is a definite plus as is experience in extending standard models
- Experience working with HANA Modeling Artifacts like - Attribute Views, Analytics, Calculated Views (Graphical and Script), stored Procedures and Functions required
- Experience working with Data Services, Smart Data Access (Data Virtualization) in HANA is a plus
- SAP Hana
- SAP S/4 HANA
141
Data Modeler Resume Examples & Samples
- Conceptual data modeling experience
- Logical data modeling experience
- Erwin modeling tool experience
- Workshop and interview experience
142
Data Modeler / Senior System Analyst Resume Examples & Samples
- Iteratively refine the existing enterprise conceptual data model
- Support and facilitate workshops and interviews to elicit information needed to develop logical and physical data models
- Develop the enterprise logical data model, including entities, attributes, and relationships
- Develop the enterprise physical data model, including tables, columns, and relationships
- Develop data dictionaries with agreed-upon definitions for all entities and attributes
- Map logical/physical attributes/columns to existing IT systems, identify gaps where data in existing systems do not exist to support the Target Data Architecture (TDA), and identify transformations where data must be altered from the source systems to be accommodated in the TDA
- Architect and develop an overall master data hub for data elements that are used by multiple IT systems
- NACI clearance or equivalent required
- 3 years of experience in financial lines of accounting and financial reporting
- Knowledge of Financial Lines of Accounting/Chart of Accounts and NAF Standard LOAs/CoAs
- Physical data modeling experience
- Prior work and familiarity with databases (preferably Oracle, SQL Server and/or SQL Server)
- Working knowledge of EDW tables containing Point of Sale data
- Complex SQL statements experience
- Experience creating complex SQL statements
- Bachelor’s Degree required from an accredited college or university in a related field
143
Lead Data Modeler Resume Examples & Samples
- Use SQL skills to pull data from Teradata/Oracle and perform usage analysis and/or data profiling
- 10+ years of experience in Data Warehouse environment with emphasis on data modeling involving design, coupled with strong knowledge of end-to-end data warehouse development life cycle (data integration, logical and physical modeling, and data delivery) supporting enterprise analytics and BI solutions
- 8+ years of progressive experience in Data modeling with emphasis on Dimensional modeling
144
Data Modeler Resume Examples & Samples
- Facilitate the exposure of process data from functional experts and the user community
- Provide mapping between existing processes and proposed replacement processes
- Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community
- Develop and manage the Conceptual, Logical and Physical data models and associated metadata for the enterprise
- Design and normalize the logical data model to third normal form
- Create the physical data model in the Erwin data modeling tool
- Modify the physical data model for efficient data access paths
- Generate DDL to create databases, tables, and views
- Identify primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes
- Identify statistics columns, and create and execute collect statistics statements
- Recommend and establish standards, guidelines, and procedures for design and maintenance
- Proven experience in an enterprise environment developing relational databases
- Proven experience developing models for Business Intelligence solutions
- Strong analytical, data profiling and problem solving skills
- In depth knowledge of modeling methodologies and techniques
- In depth knowledge of the ERwin data modeling tool or similar modeling tool
- In depth knowledge of facilitation and conflict resolution processes
- Experience with Business Intelligence products
- Excellent teaming and communication skills
- Strong consultative, facilitation and consensus building skills
- Bachelor’s Degree in Management Information Systems, Computer Science, Computer Information Systems, or equivalent Information Technology discipline
- Master’s Degree in MIS, MBA or Data Warehousing / Business Intelligence a plus
- 5+ years of data modeling experience
- 8+ years of related Information Technology Management or Data Warehousing – experience with Teradata and/or Teradata Partner products a plus
145
Enterprise Data Modeler Resume Examples & Samples
- Data analysis and Business Intelligence experience
- Good Financial Service industry knowledge(buy side is a plus)
- Trade life cycle
- Good knowledge of traditional products ( Equity and Fixed Income)
146
Systems Data Modeler Resume Examples & Samples
- 12 years of experience as a data modeler or data architect in programs and contracts of similar scope, type, and complexity required
- 3 years of experience with metadata harmonization activities supporting a DoD Enterprise
- 3 years of experience with designing and assessing system interfaces, end-to end data flows, and data storage and retrieval solutions
- Experience with UML data modeling
- Experience with using Sybase PowerDesigner, IBM Rational Rose, or Telelogic System Architect
- BA or BS degree in Electrical, Systems, or Computer Engineering
- Ability to work with a wide variety of clients
- Ability to learn new technologies and maintain and develop technical currency
- Possession of excellent interpersonal and communications skills
147
Lead Data Modeler Resume Examples & Samples
- Bachelor’s degree or higher in Computer Science, Engineering, or related discipline, or equivalent, extensive and related technical, systems level experience
- 9 or more years of systems analysis, data modeling, data profiling and programming experience
- 6 or more years of experience in systems design
- 6 or more years of full software and systems development life cycle experience with both custom development and packaged application deployment, including experience working within a formal development methodology
- 6 or more years of experience in full project lifecycle including all stages of design, development and implementation of custom applications as well as the deployment of packaged solutions
- Experience in application development utilizing a relational database such as Oracle and Big Data development using Hadoop
- Specific understanding of the systems and applications used in the telecommunications and cable television or entertainment and retail industries
- Experience working within a formal methodology for software development and a clear understanding of project management processes and tasks
- Ability to organize, plan and execute major projects with minimal supervision
- Ability to analyze project needs and determine resources needed to meet objectives and solve problems that involve remote and elusive symptoms, often spanning multiple environments in a business area
- Project planning and management skills, including scope of work, time estimation, and resource assignment
148
Data Modeler Resume Examples & Samples
- Accountable for analyzing and developing complex physical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements
- Develop Hierarchical modeling and dimensional modeling constructs
- Develop and maintain the Data Warehouse Business Matrix Architecture
- Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations
- Collaborate with Business Analysts, Data Architects and Business Customers to identify data usage patterns and to formulate Business names, definitions and data quality rules for data elements
- We offer competitive salaries, an excellent benefit package including medical, dental, vision, and (401k)!*
149
Statistical Analyst Data Modeler Resume Examples & Samples
- Drive the collection of new data and the refinement of existing data sources for deep statistical analysis and data modeling
- Clean data in preparation for analysis and modeling
- Perform statistical summaries and tests for relevant business questions
- Develop predictive statistical, behavioral or other models
- Perform statistical testing to enhance the predictability of deployed models
- Deploy applicable models into production system for business use
- Summarize conclusions and solutions for presentation
- Develop strong relationships with subject matter experts
- Develop best practices for experimentation
150
Data Modeler Resume Examples & Samples
- Work with the Data Solution Manager to determine high level data strategy for PeopleSoft Data
- Logical data modeling in Salesforce tool for creating Data Objects
- Manage the Data Model repository maintenance and for the development and administration of the appropriate roles
- Create logical and physical data models for operational applications
- Provide data governance to ensure corporate data standards are met
- Participate in ETL design and acts as the subject matter expert on source and target data structures
- Occasionally participate in SQL query tuning on Oracle (SQL proficiency needed)
- Produce data models and related documentation that can be understood and reviewed by a business audience
- Reverse engineer data from various systems
- Conduct other data analysis tasks including source system analysis and data profiling
- Communicate and build consensus with other groups regarding data definitions, data solutions, and available implementation options
- Revise ETL mapping specifications and/or stored procedures as required
- Development: Develop/modify/test data to populate new tables and columns until the ETL team can develop Informatica mappings to replace the stored procedures
- 8+ years of large enterprise project experience that must include conceptual and logical data modeling
151
AWS Redshift Data Modeler Resume Examples & Samples
- Certification: Should have Level 1 and seeking Level 2 BA
- Experience in Business Analysis
- Should be proficient in Business knowledge, Package Configuration and Change Management
- Should have progressing skills on Functional Architecture Design and Architecture Knowledge
152
Data Modeler Resume Examples & Samples
- Experience working with Medicare, Claims, and/or state Medicaid data
- Experience using CA’s Erwin data modeling tool
- Experience creating data dictionaries as well as logical and physical models
- Experience working with Informatica PowerCenter Extract, Transform, Load (ETL) mappings/transformations
- In depth understanding of identity resolution (IBM InfoSphere v10.1 or v11.5)
- Expert level design/development skills for Extensible Markup Language (XML) schemas
- EXML Stylesheet Language for Transformation [XSLT] skills
- Please note that as a member of the Apex Systems team, you’d be eligible for Health, Dental, Vision and Life Insurance; Short Term Disability; Hospitalization Coverage; Direct Deposit; Weekly Pay Periods; Training and Development Programs; and our Referral Program.*
153
Logical Data Modeler Resume Examples & Samples
- Experience with a modeling tool (Embarcadero ER/Studio or Erwin)
- Ability to perform data analysis, and data discovery. Identifies cause of data issues and works with broader team to resolve issues
- Works with senior DBA to identify and resolve issues or transform logical database models into physical database designs that represent the business rules while optimizing the performance and maintainability of the design in the physical database
- Works closely with other application areas to ensure that data integrations are efficient, follow company's technical standards, and meet the business requirements
- Ensures that all data deliverables comply with company's security policies and regulations (PCI, PII)
- Minimum 7 years of experience in data modeling, including conceptual, logical, physical, Data Mart, Data Warehouse or Operational data store
- Strong analysis and deep problem solving skills. Must be a self-motivated driver to find out data issues and resolve them quickly
154
Data Modeler Resume Examples & Samples
- Participate in design review sessions with development teams
- Translate business requirements into conceptual, logical and physical models
- Identify patterns and data relationships from disparate systems and model
- Create and maintain corporate Data Models in the data modeling tool
- Ensure conformance to corporate naming standards and data modeling methodologies
- Provide guidance to enhance query and load performance
- Read and interpret explain plans
- Write and understand moderately complex SQL queries
- Perform data profiling of source systems
- Bachelor's degree or equivalent experience in Data Modeling
- 5+ years Data Modeling experience
- Experience in creation or usage of Relational Models (OLTP)
- Experience in creation or usage of Dimensional Models (Kimball)
- Thorough understanding of data modeling and experience in modeling techniques required
- Ability to recognize and identify patterns in data relationships from disparate systems
- Ability to write and understand moderately complex SQL queries and deploy DDL
- Proficiency with Erwin 9 data modeling tool
- Good MS Office software skills
- Experience with SQL Server and Oracle DBMS; experience with DB2 and Teradata preferred
- Experience with source code control preferred
- Excellent oral and written communication skills; ability to build relationships and work with all levels of the business (team player)
- Ability to multitask and manage concurrent work loads
- Ability to follow established processes, as well as improve or develop new processes
- Ability to work with minimal supervisionSearch Jobs US
155
IT Data Modeler Resume Examples & Samples
- Bachelor's Degree in Computer Science or related field or direct and applicable work experience
- Minimum four years database administration experience; four years of data modeling experience
- Minimum three years database security experience
- Demonstrated experience in programming and scripting languages to automate processes
- Systems administration experience, including knowledge of network technologies and protocols
- Advanced experience troubleshooting database connectivity issues
- Ability to work well with people from many different disciplines with varying degrees of technical experience
156
Data Modeler / Analyst Resume Examples & Samples
- Partners with IT groups to design and implement data and modeling solutions
- Perform a detailed Data analysis on every project and support IT groups for any data related issues
- Develops and documents artifacts and templates in the chosen Erwin tool repository
- Understand the Project Proposal and assist the team in performing Data analysis how the new system or functionality can be integrated in the environment, identifying existing systems, concepts, possible data sources and issues
- Develop, validate and communicate modeling solutions, including both relational and dimensional models
- Partners with the Data Architects, Clients, ETL developers, Business Systems Analysts and other technical data warehouse team members and database administrators to design and develop high performing data models and maintain consistent data element definitions
- Perform periodical Data validation checks to ensure the Quality of the Data in Production environments meet the standards
- Create Conceptual, Logical data models that need to be validated with Business Users for current projects as well as other impacted projects
- 5- 10 years’ experience in a Data Modeler/Data Analyst role with deep knowledge of Relational and Dimensional Modeling in a Complex Data warehouse environment
- MUST have Erwin 9.5 Model Mart experience for developing the Data Models
- MUST be Strong in Oracle Data Warehousing Design and Oracle SQL
- MUST be strong in Oracle SQL development, PL/SQL, and Data Profiling
- Experience in technical, process, and business metadata management (eg. Informatica Metadata Manager) as well as Master Data Management throughout SDLC, including data quality, metadata and workflow technologies
- Experience working in Scrum, Agile and waterfall used in completing projects
- Expertise in Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Data Dictionary, Metadata and Business glossary
- Familiarity with Retail and Commercial banking, Consumer Banking, Mortgage and Dealer lending concepts desired
- Experience with Development Methodologies, Databases Platforms (Oracle/ SQLServer), including deep knowledge in Oracle SQL & PL/SQL
- Expertise in Data Modeling tools (Erwin/Model Manager) & TOAD
- Sound leadership, negotiation, critical thinking, and project/time management skills
157
Lead Data Modeler Resume Examples & Samples
- Experience with data modeling in a relevant domain (health care, public health, etc.)
- Familiarity with XML and XML Schema technologies
- Experience working with both technical experts and business owners
- Expereiince communicating complex technical concepts to non-technical audiences (e.g., white papers, presentations, documents)
- Experience with UML and MagicDraw
- Experience with NIEM
- Experience with a programming language (especially Java)
158
Junior Data Modeler Resume Examples & Samples
- Design data models and architectures, translating data so that it can be read by various types of computer systems
- Design and build databases which can be used to support the larger data architecture
- Responsible for the development of database archive and recovery design
- Responsible for building data dictionaries and meta-data technical repositories to improve the overall end-to-end data function
- Work closely with the DBA team, recommending data restructuring, clean-up, and other maintenance to ensure maximum performance with minimized overhead
- Identify areas in which policy or procedure changes could improve the way we operate
- Develop best practices and standard naming conventions and coding practices to ensure consistency of data models
- Recommend opportunities to reuse data models across the landscape
- Ability to reverse engineer physical data models from databases and SQL scripts
- Develop and govern against a set of well-defined and approved data modeling best practices and principles
- Guide developers and DBAs on the functional and non-functional limitations and capabilities of the model
- Responsible for the creation and governance against a set of well-defined data model naming conventions
- Respond to Production Support issues
- Conduct preliminary estimates / Rough Order of Magnitude for the level of effort of new models and changes to existing models
- Analyze and make recommendations for the need for system backup, security, restart/recovery, balancing & controls; recommend approaches for meeting such needs
- Analyze and document the requirements and approaches to data conversion and data modeling
- Design, develop, and maintain data model documentation
- Perform preliminary evaluation of pre-packaged data models and software
- Support implementation/training activities
- Troubleshoot data model issues, as required
- Experience in meta-data management and data integration engines (i.e. Informatica)
- Experience in modeling best practices and differences between operational and analytical purposes
- Possesses experience or knowledge in DB2, Oracle, Exadata, SQL Server, and HANA
- Exhibits knowledge of the entire end-to-end SDLC process
- Understands BI tools and technologies and how they interact with the underlying data models
- 3-5 years doing data modeling for systems that go into production
159
Associate Data Modeler Resume Examples & Samples
- Researches, extracts, analyzes, validates, and prepares data for use in analytical projects by inspecting, cleansing, and transforming data and evaluates results by interrogating the data to find and understand anomalies and / or outliers
- Define and execute analytical procedures to identify patterns, historical trends and drivers using various methods and analytical tools
- Review analytical outputs and provide insights and recommendations through data visualization and reporting techniques as well as verbal and written communication to team members and business partners
- Interact with applicable team members and/or business partners to ensure adequate understanding of data needs, data availability and information delivery output expectations
- Collaborate with members of the department, SME's, and internal customers in ongoing decisions regarding study design, data collection, data analysis and methodology
- Support the management of marketing activity from consumer acquisition and member engagement campaigns and marketing activity
- Extensive experience using spreadsheets, database, and query tools
- Excellent quantitative and analytical abilities
- Ability to create and interpret various reports to monitor, track and evaluate campaign results and processes and identify trends
- Advanced knowledge/skill in data analysis specifically statistical analysis for the identification of trends, root causes and improvements
- Ability to work in team environment and independently
- Extensive experience with systems and tools supporting relational databases and analysis. SAS, SPSS, SQL
- MBA degree
- Marketing analysis experience in a healthcare environment
160
Data Modeler Resume Examples & Samples
- Logical and Physical modeling for Data warehouses
- Semantic layer modeling; dimensional modeling to support Data Warehouse and Marts
- Participating in data modeling discussions with the Business in JAD sessions
- Work with the lead to establish standards around flexibility of the data model to ensure deviations are within established guard rails
- 5+ years of experience working in Data Warehouse environments with emphasis on data modeling involving design, coupled with strong knowledge of the end-to-end data warehouse development life cycle (data integration, logical and physical modeling, and data delivery) supporting enterprise analytics and BI solutions
- 5+ years of progressive experience in Data modeling with emphasis on Dimensional modeling
- Hands on experience with modeling tools such as ERWIN
- Experience working in a fast paced environment handling multiple project deliverables
- Understand Big data architecture for analytics
161
Data Modeler Manager Resume Examples & Samples
- Requires excellent planning, conceptual, consulting and communication skills, analytical ability, strong judgment and management skills, and the ability to interact with senior business area and IT management and staff solutions
- Strong experience in logical and physical data modeling in OLTP and OLAP environments
- Able to recognize and identify patterns in data relationships from disparate systems
- Strong database fundamentals and data modeling knowledge
- Strong experience performing data modeling studies and develops detailed data models
- Strong experience in transforming logical models to physical models
- Good understanding of understanding of ODS, data warehouse, data mart, and data cube, and database technologies
- Strong SQL (PL/SQL preferred, T-SQL acceptable) background
- Previous experience in gathering requirements for reporting solutions and data analysis
- Good background working with quantitative data
162
Data Modeler Resume Examples & Samples
- Translates business user information requirements into data structure requirements
- Oversees new data development and ensures consistency and integration with existing data structures
- Expert Knowledge in working with CA ERWIN CASE tool
- Develops logical and physical database models across multiple platforms and computing environments
- Participates in the evaluations of new tools and techniques to improve data management for the enterprise
- Provides technical assistance and mentoring to staff for developing conceptual and logical database designs and the physical database
- Ensure that relational designs and dimensional databases will perform effectively and efficiently, logically and physically
- 2-5 years’ work experience in database design
- Effective knowledge and understanding of logical and physical database design concepts and some RDBMS platforms
- Operational, service and technical knowledge in multiple Information Technology disciplines
- Basic knowledge of their unit’s processes and procedures
- Business knowledge of the Financial industry a PLUS.Search Jobs US
163
Big Data Modeler Resume Examples & Samples
- Devise standards and processes for the group
- Create architectural blue prints to enable understanding of high level business requirements,
- Understand and incorporate industry standards into enterprise architectural guidelines
- Manage and resolve multiple design priorities with various customers efficiently
- Tool evaluation and work with vendor for new functionality based on enterprise requirements
- Project planning activities in support of AD efforts
- Partnership with AD to ensure best design solutions for most efficient use of data
- Develops and implements data modeling standards and best practices, including re-use across the application portfolios. Prepares status reports on project work and work plan progress
- Understand relational designs and dimensional database performance, conceptually, logically and physically
- Solid understanding of the design principles of HBase and Mongo data containers and underlying components such as parallel processing
- Working knowledge with CA ERWIN CASE tool preferred
- Translate Logical Data Models to physical designs on big Data Platform: HBASE and Hive
- Analyze and optimize data structures designs to meet queries and requirements
- Bachelor’s degree in Computer Science or related years experience
- 5+ years experience with Big Data
- Strong knowledge and understanding of logical and physical database design concepts,and some RDBMS platforms
- Broad operational, service and technical knowledge in multiple Information Technology disciplines
- Expert level knowledge of their unit’s processes and procedures
- Expert oral and written communication skills
- Requires an understanding of customer’s business practices
- Excellent analytical and investigative ability
- Ability to negotiate and influence results without direct authority
- Able to understand and work with all other EI groups to ensure quality service delivery to customers
- Business knowledge of the financial industry is very useful
164
Senior Data Modeler Resume Examples & Samples
- Uses well documented procedures to create data dictionaries capturing business and technical metadata and Data Definition Language (DDL) scripts
- Strong communication skills required; technical and business writing skills are a plus
- One years of experience in relational data modeling required. Preferred three years of modeling experience in relational, dimensional or closely related data definition activity
- Prior experience with a health care payer Member, Claim, Capitation, Warehouse, and Actuarial data is preferred
- Should be able to analyses business requirements to develop data models with minimal oversight
- Experience with All Fusion /ERwin, IBM Information Data Architect or similar modeling tool is required
- Should understand impacts of model changes on databases
- Excellent analytical skills required
165
Logical Data Modeler Resume Examples & Samples
- Be a self-starter that does not require direct supervision
- Expert in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio
- Ability to write PL/SQL scripts to perform data refreshes from one system to another or run data queries
- Ability to identify and map source and target data fields
- Lead meetings with technical peers regarding the requirements definition
- Communicate effectively with business, vendor, and project management staff
- Participates in ongoing decisions regarding study design, data collection, data analysis and Methodology
- Ability to show up to work and meetings on time
- Ability to perform other activities as needed in order to help the team or the project to succeed
166
Data Modeler Resume Examples & Samples
- Native level fluency in Japanese, Spanish or Portuguese is required
- Mac OS X experience
- Flexibility to work weekends or holidays
167
Data Modeler Resume Examples & Samples
- Develop and deliver Dimensional Data Models and corresponding analysis according to the data architecture standards, for designated solution or segment architectures. This includes data model diagram, data object definitions, business rules, domain lists, data quality requirements
- Deliver or support the delivery of additional data architecture artifacts, such as logical data models, mastership and utilization matrices, data flow diagrams, roadmaps, data mapping, data profiling
- Identify and propose potential data model and data integration changes and improvements, including master data management solutions, data services
- Work directly with project staff, business analysts, business representatives/SME's, and architects to ensure that the proposed models are fit for purpose and correct
- Validate solution data model alignment with the Enterprise Data Model, identify gaps and propose resolutions
- Ensure architecture artefact quality and retention in appropriate tools, e.g. System Architect
- Participate in and contribute into various architecture networks
- Build deep insight in how the business processes work, how the processes and applications interact and use data, and what the critical issues and success factors - for one or more business segments
168
Predictive Data Modeler Resume Examples & Samples
- Develop and execute analyses alongside clinical and business teams to inform decision-making and program development within the client
- Demonstrate ability to utilize data mining and probability to forecast outcomes
- Develop and produce reports to support population health initiatives, including quality and safety metrics, cost and utilization metrics, and identify variation and trends
- Acquire expert knowledge of the Client and Medical Health System (MHS) as needed to support population health analytics and initiatives
- Function as a liaison between providers of information (Defense Health Agency, Air Force) and users of data such as client Analytics, client leadership, military treatment facility leadership and analytics assets
169
Senior Data Engineer, Data Modeler Resume Examples & Samples
- Develop and maintain business object models, conceptual/logical/physical data models using IPS/IAA/IIW models to create operational data store
- Collaborate with technical teams to define and implement Model Driven Architecture practices enterprise-wide
- Interpret business requirements into a technical design
- Define, document, and present technical design
- Provide governance, technical knowledge and expertise, using best practices, supporting a culture of continuous improvement
- Collaborate with subject matter experts, various stakeholders and fellow developers to design, develop, implement and support complex business solutions
- 5+ years of experience in data modeling, implementation standards and best practices using prevalent industry tools like Erwin, IDA
- Ability to develop ETL Specifications based on requirements and communicate process to other technical teams
- Ability to gather, analyze, and consolidate complex business requirements and translate into data models - conceptual, logical and physical
- Ability to facilitate model design sessions with multiple teams
- Ability to work collaboratively with both business and technical teams as a Subject Matter Expert on the IIW model
- 3+ years Commercial Insurance business knowledge
- Strong Understanding of Model Driven Architecture
- Strong Understanding of SOA, object modeling
- Broad experience of working in diverse SDLC methodologies - waterfall, agile, iterative
- Excellent Team Player
- Self-motivated with the ability to work independently and in a team setting
- Data aggregation/mining design patterns
- 3+ years experience with RDBMS including Oracle database
- Strong SQL skills and ability to tune queries and database structures for performance
- Ability to develop solutions involving geospatial data and time series
- 8+ years of solid, diverse work experience in IT, database management, analytics or an equivalent combination of education and work experience
- Knowledge of IAA services design and object modeling a plus
- Strong analytical ability, problem analysis techniques, a broad knowledge of technology alternatives
- Excellent communication skills, and the ability to work effectively with business clients and IT resources
- Ability to understand projects at a high level without losing sight of granular details when managing projects
- Business Owner Mindset- Operate with keen business knowledge, expense, risk & controls driven mindset
- Customer Driven- Focus on “Harvest” – (our enterprise continuous improvement effort), innovative problem solving, and efficient local decision making for continuous improvement
- Growth & Development- Maximize development of self and others
- NO AGENCIES PLEASE **
170
Data Modeler / Developer Resume Examples & Samples
- Typically has 6 or more years of consulting and/or industry experience
- Ability to work independently and autonomously
- Problem solving and troubleshooting skills with experience exercising mature judgment
- Able to direct multiple team members towards deliverable and milestone objectives with confidence
- At least nine years’ experience developing analysis & design and software architecture documents
- At least seven years coding experience with task specified programming languages (e.g., JAVA, C++, C#, PowerBuilder etc.)
- At least seven years coding experience with SQL or database stored procedures
- At least seven years’ experience with Internet/Intranet protocols and web server technologies, as required
- At least six years’ experience building Service Oriented Architecture using web service standards (i.e., SOAP, RPC, or REST), if required
- At least five years’ experience with current network, development and database architectures and technologies
- At least five years’ experience developing systems architectures, if required
- At least five years’ experience developing enterprise projects utilizing iterative system development methodologies, if required
- At least two years’ experience with XML or JSON, if required
171
Data Modeler Resume Examples & Samples
- Maintain change log for data models
- Overall 8-10 years of exp Data Modeling experience of 5-6 years Well versed in data architecture
- Understands how to interpret and integrate conceptual models, logical models, view models (snowflake, star-schema), object models
- Strong database skills - Oracle/Netezza or any other database
- Experience in ERWIN tool
- Understands and has experience with using master data, reference data and meta data concepts for reusability of designs
- Above all, the resource should have Healthcare Payer domain knowledge
172
Lead Data Engineer / Data Modeler Resume Examples & Samples
- 7-10 or more years of progressively complex related experience to data modeling activities
- Experience building and implementing data transformation and processing solutions
- Experience in Hadoop architecture, HDFS commands and experience designing and optimizing queries against data in the HDFS environment
- Ability to understand and build complex systems and solve challenging analytical problems
- Ability to leverage multiple tools and programming languages to analyze and manipulate large data sets from disparate data sources
- Proven ability to create innovative solutions to highly complex technical problems
- Ability to communicate technical ideas and results to non-technical clients in written and verbal form
- Strong collaboration and communication skills within and across teams
173
Data Modeler Resume Examples & Samples
- Working in isolation or with senior data modellers to capture business data requirements as a logical data model. Ensuring these models are consistent and that the Business Glossary is linked and maintained in a manner that allows impact assessment and lineage of metadata
- Data model integration. The Corporate data model is actually 40+ individual models all linked together to form a single corporate model. All the individual models need to be checked to ensure they cross reference each other accurately
- Semantic model mapping from Industry based models to JPMAM specific models to leverage industry standards and to test model completeness
- Metadata support. Providing access to metadata information though the generation of pre-prepared or dynamic queries
- Data quality analysis. Maintaining data validation rules, testing those rules and running data quality reports or generating data quality dashboards
- Current state documentation and data lineage capture. In many cases existing database will need to be reverse engineered to assist in bringing all our data dictionaries up to date. At the same time we do this we need to capture and document data lineage. This part of the job will require the candidate to become familiar with a a range of different technologies to perform these functions so the ability to learn quickly is important
- Data modeling tool customisation. In many cases model and DDL. generation is controlled by scripts in the data modeling tool. These scripts control the generation of many aspects of the data model including how data auditing is carried out and how XSD models are generated from the physical model. Maintaining these scripts and version upgrades to the data modeling tool is a key activity
- Documentation. A central data portal details all the JPAM data standards. Keeping this information up to date and relevant is an important task
174
Logical Data Modeler Resume Examples & Samples
- Develop and maintain Logical and Physical Data Models to support complex, data-centric analytic warehouses
- Produce data models including metadata for communication with various audiences
- Work with appropriate business and IT leads to incorporate data management best practices into IT solution roadmaps
- Communicate and build consensus with other groups regarding data integration, semantic solution, metadata, data solutions, and available implementation options
175
DNA Hil-tech Lead-data Modeler Resume Examples & Samples
- Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
- At least 4 years of experience in Software development life cycle with primary experience in DW/BI, Oracle and related tools
- At least 4 years of experience in Project life cycle activities on DW/BI Data Modeling and maintenance projects
- At least 4 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks
176
Senior Data Modeler Resume Examples & Samples
- 2+ years of experience creating and modifying data models on a large scale system
- 2+ years of experience writing PL/SQL queries against a relational database
- 2+ years of experience writing Linux shell scripts
- 2+ years of experience using Perforce to manage code development environments
- Ability to discuss database management techniques using ORACLE
- Ability to analyze requirements and create PL/SQL scripts for production data fixes, ad hoc data requests, and data extracts
- Ability to provide on-call support for a 24x7 application on a rotational basis
- A strong commitment to process improvement
- Ability to communicate effectively with management, business users, developers, and team members
- Working knowledge and familiarity with Guidewire development tools
- Working knowledge of IBM /JCL
177
Data Modeler Resume Examples & Samples
- Highly logical with the ability to understand databases and complex data structures
- Experience of data analysis of large and complex data structures
- Experience deducing data semantics, doing data profiling, classification and utilization – understanding what it is, how it is used, how it could be used
- Demonstrable experience of SQL query skills (Ever used a “Having” clause? An exists test of a sub query?)
- Willingness to learn about new data tools
- Willingness to learn or have knowledge of sampling and content analysis techniques and how they can be applied to address data issues
- Experience in a service centric or consulting organization would be desirable, but not essential
- Exposure to or understanding of legacy data storage technologies and concepts would also be desirable but not essential
- Experience with multiple SQL variants, JPQL, Linq, Groovy, Ruby, Access, Java, C# would also be desirable
- Educated to degree level in a mathematical or engineering discipline, or with a business or arts degree but really solid technically
- Undergraduate degree and 6-8 years relevant data modeling experience
- Data extraction, transformation and loading (ETL) experience
- Experience reverse engineering legacy data and entity-relationship modeling
- Thorough understanding of how data evolution process differs from classical data modeling or functional analysis
- Object / Relational mapping
178
Operational Data Modeler Resume Examples & Samples
- Will be working as part of the Analytical/Operational Data Modeling Team
- Will be assigned to one or more of the project releases
- Will be working on new Data Modeling development, as well as updating existing data models
- Will be working on both traditional OLAP/OLTP and Guidewire’s Policy
- Will be working both individually and with other team members
- Will be guided by experienced Data Modelers
- 2-5 years of related experience
- Insurance background preferred
- Strong Data Modeler background/experience - will be doing "hands on" data modeling
- Experienced in OLAP/OLTP modeling (both 3rd Normal and Dimensional)
- Strong communicator, excellent verbal & written skills
- Able to work in a team environment and individually
- Experience with DB2, Greenplum, Hadoop and Oracle are preferred
- Familiar with Embarcadero ER/Studio data modeling tool
- OLTP Data Modeling experience
- OLAP Data Modeling experience
- Database Design experience
179
Senior Data Analyst / Data Modeler Resume Examples & Samples
- Interested in working in an Agile environment
- Understand certain compliance standards and guidelines and apply them when necessary
- Desire to eventually move into a database design role
- 5 or more years of IT experience
- 3 or more years of experience in a data centric role with a desire to work in a Data Warehousing environment
- 1 or more years of work experience writing SQL
- Must be flexible to work with global teams and stakeholders across time zones
- Familiarity with ETL tools such as Talend or DataStage
- Understanding of: Data Discovery and Profiling; Data Mapping; Data Modeling; and Data Management processes (e.g., Data Quality)
- Aptitude and/or desire to move into a database design role
- Familiarity with Big Data Technologies (Hadoop, Pig, Hive, HBase, and/or MapReduce etc.) and capabilities
- Knowledge of Meta Data tools and technologies
- Experience with Data Analysis with mindset of translating into Data Marts
- Experience working in an enterprise size Data Warehouse
- Strong background writing SQL
180
Data Modeler Resume Examples & Samples
- Minimum 5 years of Data Modeling experience with a focus on multidimensional data modeling
- Experience with ERWIN data modeler
- Previous work experience in the financial industry (bank or credit union) required
- Expert knowledge of relational DBMS, specifically Oracle and Microsoft SQL Server
- Expert knowledge in areas of advanced data techniques
- Proficient in leading business and internal team discussions to gather requirements, brain-storm and propose robust and scalable solutions; leverage business partner/unit input to enhance data models
- Experience in developing and maintaining source to target mapping that includes extract requirements, derived field logic, domain values and data lineage
- Experience designing conceptual, logical and physical data models and maintaining data dictionary and capturing metadata
- Experience creating a and maintaining DDL scripts, data standards, and best practices to maintain integrity and security of the data; ensure adherence to developed standards
- Strong verbal and written communication skills required
- Strong negotiating and consensus building skills
- Must be able to deal with ambiguous scenarios when working with business teams
181
Lead Data Modeler / Developer Resume Examples & Samples
- At least 7 years experience with developing and implementing applications
- Change control
- Application maintenance
- Application design, architecture
- Release management
- Application testing
- System testing
182
Data Modeler Resume Examples & Samples
- Understanding of Data Integration and modeling within Data Lake environment
- Experience with physical data structure design in columnar databases ( such as RedShift , Vertical, GreenPlum etc )
- Strong SQL query writing against Oracle/SQL Server Databases
- Understanding/Data Modeling for Redshift / ParAccel databases will be a huge plus
- Customer Care Data Mart modeling experience is a huge plus
- Work with Client stake holders in understanding Data needs
- Conduct requirement gathering sessions and participate in various discussions and scrum meetings
- Analyze requirements, provide logical and Physical Data Model
- Write detailed Data Modeling documents with sample data use cases and queries as necessary
- Conduct walkthroughs of the Data Model with Functional and Technical resources
183
Data Modeler / Analyst Resume Examples & Samples
- Work with the Sales, UST and Finance stakeholders to understand the impact to processes and data of the GTM strategy
- Understand changes to customer master data across UST, SAP, Sales and drive outcomes that minimize the creation of duplicate customer data. Help teams understand the details and drive out ambiguity in the integration between the systems
- Build and maintain conceptual and logical data models in ERStudio Data Architect (data modeling tool. Similar to ERWin)
- Excellent verbal communication and facilitation skills
- 5+ years of Logical Relational Data Modeling (Business Data / Requirements Modeling) experience. Highly proficient with logical data modeling concepts such as normalization, natural vs surrogate keys, identifying vs non-identifying relationships
- Experience with using ERWin, ERStudio or similar software for logical data modeling
- Familiarity with revenue accounting principles such as recognized revenue, billed revenue, deferred/unearned revenue
- Familiarity with common order to cash business processes
- Familiarity with Microsoft volume licensing systems and processes
- Familiarity with Microsoft's online services / commerce platform / universal store team systems
184
Data Modeler Resume Examples & Samples
- Problem Solving – demonstrated ability to conceptualize, define and solve difficult problems
- Modeling/Analysis – strong aptitude for modeling and analyzing business decisions, whether operational, tactical or strategic
- Data Management/Manipulation – understanding of and ability to work with large amounts of data to clean inputs and present outputs in a visual, easy to understand manner
- Communications – has strong written and oral communication skills. Must be able to communicate effectively even if the role is confined to model building and implementation. The focus is on gathering requirements, communicating (sometimes counter-intuitive) results and motivating line personnel to acting on EO outputs
- Delivered Products – history of delivering completed products on time; strong attention to detail
- SQL Server Integration Services
- SQL Server experience
- BI/reporting background
- ETRM Experience with Endur and Natural Gas
- Business Modeling – 3+ years’ experience modeling in Excel a must; understanding of linear programming and constraint-based modeling systems (e.g. OPL Studio, Lindo, GAMS) a strong plus; It is preferable that the experience be in modeling and analyzing the types of business problems that EO is typically applied to (e.g. operational, tactical and strategic planning), vs. tangential techniques such as simulation and statistics
- Business Analyst/Management or Business Advisory Consultant – Prior experience supporting business decision making, including problem definition, research/analysis, expectation management, client management and business process definition
- Data Management & Programming – understanding of database systems such as SQL Server, and ideally SSIS and reporting environments; VBA programming knowledge is a plus
- SSIS
185
Data Modeler Resume Examples & Samples
- Work with multiple teams to identify, design and build appropriate dataset and linkages for complex data
- Support refactoring legacy systems into microservices which integrate with a Hadoop data lake
- Contribute to evaluating and selecting new tools for data management and promoting industry best data management practices among the development teams
- Manage metadata for all data sources within a Hadoop data lake
- Organize, deliver, and ensure data integration support
- Develop/manage complex data models (conceptual, logical, & physical) in multiple formats (relational, star/snowflake, object-oriented, etc.)
- Analyze & acquire data from primary and secondary data sources – creating mapping specifications/requirements for use by ETL development resources
- Maintain knowledge on current and emerging developments/trends for assigned areas of responsibility, assess the impact, and collaborate with management to incorporate new trends and developments in current and future solutions
- Identify and recommend process improvements that significantly reduce workloads or improve quality for his/her assigned areas of responsibility
- Determine how existing applications, systems, databases, interfaces and/or hardware can interact to meet new and emerging enterprise initiatives
- Provide input and validate project plans, test plans and implementation plans
- Consult and/or participate in the requirements, design and coding walkthroughs to ensure the development of quality solutions
- Proactively identify problems and present/develop solutions
- Communicate effectively with internal stakeholders and management
- At least five (5) years of experience implementing relational database designs, data warehousing, data architecture, & data modeling, including strong knowledge of various data modeling approaches and practices (experience with 3NF, star schemas, and multi-dimensional designs)
- At least six (6) years of SQL experience
- At least five (5) years of experience creating physical data models for relational databases
- At least four (4) years of experience working in Hadoop environment, including HDFS, Hive, Sqoop, HBase, Pig, Flume, Parquet, Avro and/or Spark
- At least three (3) years of experience working with XML, UML and JSON
- Knowledge of Informatics, analytics, computational science and service management
- Experience with ERwin Enterprise Data Modeler or equivalent modeling software
- Understanding of NoSQL databases is desired
- Ability to logically model healthcare data is desired
- Experience working with Agile methodologies is desired
186
Mid-level Data Modeler Resume Examples & Samples
- Typically has 5 or more years of consulting and/or industry experience
- Ability to manage small engagements or work streams and multiple team members with confidence
- Professional oral and written communication skills
- Strong problem solving and troubleshooting skills with experience exercising mature judgement
- Excellent teamwork and interpersonal skills
- Ability to obtain and maintain the required clearance for this role
- 4 to 6 years supporting/implementation of Information Technologies (IT) projects and have robust software or system implementation experience
- Experience as a Database Designer/Data Modeler, Data Simulation, Business Intelligence (preferred Data Modeling Architect) in a variety of client/server software environments
187
Data Modeler Resume Examples & Samples
- Possess solid technical skills regarding tools and technologies pertinent to enterprise data management including
- Conceptual and logical data modeling, physical database design, data integration ETL and data profiling to provide the proper context regarding enterprise data assets to address business and technical requirements
- Demonstrates leadership skills
- Bachelor's degree in Computer Science preferred, or equivalent work experience
- Experience in implementing enterprise applications across the application, data, and infrastructure domains
- Full life-cycle data warehousing experience Data Warehousing architecture experience
- Data Modeling (ERD's, Mapping, Metadata, dimensional and experience) using a modeling tool
- Experience with a Financial industry model
