Job Summary:

• Create logical and physical data models using best practices ensuring scalability, maintainability, and data quality of the systems.
• Create Design and document data strategies, design data flows and conceptual data models following dimensional modeling principles.
• Drive requirements gathering activities, understand and translate business needs into data models supporting long-term solutions.
• Optimize and update logical and physical data models to support new and existing projects.
• Recommend opportunities for reuse of data models in reports or dashboards
• Complete logical Data warehouse design with Data modeling and metadata design
• Ensuring that the Data Model is up to date at all times reflecting the changes which have been made to the source systems and would be required to synchronize models to ensure that database structures match models
• Design for Integration with Hadoop and another source system
• Help with Data preparation and migration
• Generate DDLs, DMLs used to create the database schema
• Designing data models that encapsulate complex building industry projects
• Documenting and communicating design choices to peers and to clients

Skills on Resume: 

• Data Modeling (Hard Skills)
• Dimensional Design (Hard Skills)
• Requirements Gathering (Hard Skills)
• Data Warehouse Design (Hard Skills)
• Data Integration (Hard Skills)
• Data Migration (Hard Skills)
• Schema Development (Hard Skills)
• Design Documentation (Hard Skills)

Job Summary:

• Define and govern data modeling and design standards, tools, and best practices.
• Build and maintain the conceptual model in collaboration with the different business stakeholders
• Build and maintain the data models of the IT Data platform such as the Integration/Enterprise layer and Datamarts
• Share the knowledge within and outside the team pro-actively
• Collaborate with business, project managers, functional analysts and solution architects
• Understand business requirements and build a functional analysis that covers the needs of the business according to the target BI reference architecture.
• Provide cost estimates for data-related projects
• Recommending when to use industry standards and when to extend or adapt those standards
• Implementing JavaScript code to create and load data models
• Implementing JSON-based queries against data models (using custom query language which is similar to MQL)

Skills on Resume: 

• Data Modeling (Hard Skills)
• Data Strategy Design (Hard Skills)
• Requirements Gathering (Hard Skills)
• Model Optimization (Hard Skills)
• Data Reuse (Hard Skills)
• Data Warehouse Design (Hard Skills)
• Model Synchronization (Hard Skills)
• Data Integration Design (Hard Skills)

Job Summary:

• Assist in defining the optimum architectures of ETL tools and data warehousing by creating models and its data quality management solutions, roping in industrial and security best practices when possible to manage data quality and integrity.
• Establish and formalize guiding principles, procedures and standards that build business metrics and data models to integrate with current ETL tools and application interfaces.
• Ensures compliance with company policies, audit requirements, and data privacy acts within his/her area of expertise.
• Participates in solution implementations, upgrades, and enhancements. 
• Provide technical leadership for implementation teams
• Review and validate high-level design documentation and detailed-level design documentation.
• Provide some insights into data analysis and key performance metrics across functions so as to aid strategic decisions
• Building, developing and growing any business relationships vital for the success of EIM Strategy
• Analyze and develop logical database designs, data models and relational database definitions across multiple computing environments (e.g., host-based, distributed systems, client-server, Web, e-commerce)
• Analyze and design data models, logical databases and relational database definitions

Skills on Resume: 

• ETL Expertise (Hard Skills)
• Data Warehousing (Hard Skills)
• Data Quality Management (Hard Skills)
• Regulatory Compliance (Hard Skills)
• Technical Leadership (Soft Skills)
• Documentation Review (Hard Skills)
• Data Analysis (Hard Skills)
• Database Design (Hard Skills)

Job Summary:

• Work with dimensional models, by identifying the systems that will act as the sources of data, understand the way the data is shaped in those systems
• Create new normalized/denormalized models (flatten/deflate) that will import this data into data warehouse or data lake platforms, and then optimize consultation queries to extract only information requested in a presentation layer. 
• Collaborate with Business Analysts in discovering and understanding those systems and will be the translation interface for development teams that will process and manipulate the data
• Promote and practice data governance, to ensure data is always available, correct and accessible to the users that need it.
• Provide data element naming consistent with standards and best practices and ensure that data dictionaries are maintained across multiple database environments
• Confer with database administration and client areas in resolving questions during the translation to physical database design
• Develop detailed data models
• Work with peers, clients and management to establish and maintain consistent data element definitions across computing environments
• Implements and enforces data definitions, standards and procedures relating to logical design
• Leads data design efforts and assists software engineers in data source discovery, data modeling, metadata capture and normalization techniques
• Incrementally develop conceptual, logical and physical data models for new database objects

Skills on Resume: 

• Dimensional Modeling (Hard Skills)
• Data Warehouse Optimization (Hard Skills)
• Collaboration with Analysts (Soft Skills)
• Data Governance Practices (Soft Skills)
• Naming Conventions (Hard Skills)
• Database Design (Hard Skills)
• Data Model Development (Hard Skills)
• Data Standards Implementation (Hard Skills)

Job Summary:

• Support the translation of operational use cases into the detailed data structure and architecture to support the development of an information exchange model standard
• Provide knowledge of data modeling fundamentals and principles. 
• Creating conceptual, logical, and physical data models.
• Provide support designing XML from the UML class models.
• Managed offshore and local teams yet still hands-on. 
• Lead developer on numerous projects.
• Assisting with the establishment of program policies and procedures.
• Supporting the customer in communicating and monitoring adherence to information policy and process requirements.
• Interacting with multiple FAA organizations and personnel to facilitate the coordination required to meet information policy and process requirements
• Maintaining procedural documentation and developing reports and presentations
• Define data requirements and business rules, perform logical and physical data modeling, implement and test database design
• Coordinate data models, dictionaries and other documentation across multiple applications
• Lead database design sessions and capture data requirements for software engineering or re-engineering projects
• 
  

Skills on Resume: 

• Data Structure Translation (Hard Skills)
• Data Modeling Knowledge (Hard Skills)
• Model Creation (Hard Skills)
• XML Design Support (Hard Skills)
• Team Management (Soft Skills)
• Project Leadership (Soft Skills)
• Policy Development Support (Soft Skills)
• Documentation Maintenance (Hard Skills)

Job Summary:

• Producing conceptual and logical data models to a high standard and writing robust data definitions and business rules as part of these. 
• Work collaboratively with the business data owners and subject matter experts in construction, finance, housing operations, and building services to understand the data requirements. 
• Champion and drive the business design for master and reference data and data analytics datasets. 
• Work with data engineers and developers in the IT department and third-party solution providers who will derive physical designs from logical designs and implement them. 
• Partner with the IT Data Architecture, BI, and solution teams to ensure the business data design is translated correctly to deliver the trusted data assets.
• Work closely with project stakeholders to understand data needs
• Define, produce and implement data strategy across data from various data sources including MongoDB, PostgreSQL and mainframe
• Design effective solutions to process very large volumes of data within an acceptable SLA timeframe
• Complete Data Analysis and data modeling to build ERWIN data model and physical data model for the designed solution, align with architecture framework
• Transforming complex business structures, processes and activities into technical solutions
• Build out a data lake and transform data into usable data views e.g. Target Data Model with a Single Customer view of the customer.

Skills on Resume: 

• Data Model Production (Hard Skills)
• Collaborative Requirements Gathering (Soft Skills)
• Business Data Design Leadership (Soft Skills)
• Physical Design Implementation (Hard Skills)
• Data Architecture Partnership (Soft Skills)
• Data Strategy Development (Hard Skills)
• Large Data Processing Solutions (Hard Skills)
• Data Lake Development (Hard Skills)

Job Summary:

• Design, build and support scalable, high-performance data applications, repositories and data governance-related applications
• Contribute to the definition of data architecture standards and establish best practices for data management (including the handling of personal data)
• Design and implement logical and physical data models across platforms
• Manage equivalent, separate data sets across different development and staging environments as part of the release process
• Seek out opportunities to propose new concepts and ideas in ‘Big Data’ and expand existing platforms or leverage new technologies to meet more complex business needs
• Help mentoring the more junior developers and analysts in data product development
• Design database schemes based on Third Normal form (3NF) for relational databases utilizing normalizing principles.
• Write complex SQL queries based on different Database technologies
• Design Star schemas and Snowflake schemas and Interact with the internal business stakeholders, business data analysts, business analysts, data operations and data scientists in order to understand the requirements and provide guidance
• Work with Solution Architects in order to provide designs that are consistent based on existing frameworks and different technology products.
• Help in the process of cleaning, preparing and harmonizing different data sets in preparation for it to be used by Data Warehouses.

Skills on Resume: 

• Scalable Data Application Design (Hard Skills)
• Data Architecture Standards (Hard Skills)
• Data Modeling (Hard Skills)
• Data Set Management (Hard Skills)
• Big Data Concepts (Soft Skills)
• Mentoring (Soft Skills)
• Database Schema Design (Hard Skills)
• Data Preparation (Hard Skills)

Job Summary:

• Analyzing requirements documents created to fulfill regulatory reporting needs for Non-Financial Regulatory Reports and creating technical specifications for the sourcing and transformation of the data to meet requirements.
• Work with representatives of various data sources, determine the appropriate data source, negotiate usage of the data, and document the technical specifications.
• Responsible for the development and maintenance of a domain data dictionary to document a common taxonomy.
• Produce and maintain traceability and lineage relationships between requirements, design, technically implemented code, and data sources.
• Solving for Mortgage related modeling, ad-hoc analytics, etc. as per the requirements
• Prepare Data for exploratory analysis, variable treatment, logic building for modeling and analytics
• Provide options on mortgage modeling & analytics that are best suited to the client and prepare documentation in the form of Word docs, presentations, etc
• Prepare models or work on analytics projects as agreed with clients
• Advise and adapt to client’s data architecture quickly
• Handles data modeling for many areas of the org, work with different business groups & stakeholders to understand modeling needs
• Write SQL to access data

Skills on Resume: 

Regulatory Reporting Analysis (Hard Skills)

Data Source Documentation (Hard Skills)

Data Dictionary Development (Hard Skills)

Traceability Documentation (Hard Skills)

Mortgage Modeling (Hard Skills)

Data Preparation (Hard Skills)

Client Advisory (Soft Skills)

SQL Proficiency (Hard Skills)

Job Summary:

• Define, design, and implement enterprise data models.
• Build Kimball-compliant data models in the Analytic layer of the data warehouse
• Build 3rd normal form compliant data models in the hub layer of the data warehouse
• Translate tactical/strategic requirements to ensure effective solutions that meet business needs.
• Participate and provide consultation on complex initiatives.
• Comfortable tackling new problems and learning along the way.
• Review specifications and coach to ensure consistency in approach and use.
• Research improvements in coding standards, and participate in code reviews.
• Refactor code to improve testability and maintainability when needed.
• Perform detailed technical design, development and unit testing of custom applications and data flows in the context of projects, releases and production support.
• Deliver high-quality code for features and bug fixes.

Skills on Resume: 

• Enterprise Data Modeling (Hard Skills)
• Kimball Data Modeling (Hard Skills)
• 3NF Data Modeling (Hard Skills)
• Requirements Translation (Soft Skills)
• Complex Initiative Consultation (Soft Skills)
• Problem-Solving (Soft Skills)
• Code Review Participation (Hard Skills)
• Custom Application Development (Hard Skills)

Job Summary:

• Analyze data requirements and perform impact analysis
• Create conceptual, logical and physical data models (with a focus on physical data models)
• Analyze new and existing data sources
• Propose optimal data structures across data layers (integrated, reporting, ...)
• Describe transformation logic from source to target and design ETL
• Communicate with data source owners and other team members
• Ensure validation by business and data consumers
• Help with SDLC documentation for data stream
• Create and maintain data lineage and other documentation
• Provide inputs to the QA/testing team for the creation of test cases/scenario

Skills on Resume: 

• Data Requirements Analysis (Hard Skills)
• Data Model Creation (Hard Skills)
• Data Source Analysis (Hard Skills)
• Optimal Data Structure Proposal (Hard Skills)
• ETL Design (Hard Skills)
• Team Communication (Soft Skills)
• Validation Assurance (Hard Skills)
• Documentation Maintenance (Hard Skills)

Job Summary:

• Analyze data quality issues
• Write and refine stories to support product features
• Estimate stories in the backlog with the team
• Help with data testing/validation activities
• Orchestrate data jobs into workflows
• Support deployment and release activities
• Align with other data modelers within the same project portfolio
• Implement improvements to existing data mappings
• Work in an agile environment focused on the most important deliverables for our clients.
• Interact with application development, enterprise architecture, business intelligence, and technology services on a regular basis
• Establish and maintain a comprehensive data model and deployment documentation

Skills on Resume: 

• Data Quality Analysis (Hard Skills)
• Story Writing (Soft Skills)
• Backlog Estimation (Soft Skills)
• Data Testing Support (Hard Skills)
• Workflow Orchestration (Hard Skills)
• Deployment Support (Soft Skills)
• Collaboration with Data Modelers (Soft Skills)
• Documentation Maintenance (Hard Skills)

Job Summary:

• Create and maintain conceptual, logical and physical data models based on use cases including transactional, integration, data warehouse and analytical systems.
• Work with business teams, engineers and other stakeholders to understand data requirements
• Create a conceptual data model and identify key business entities and visualize their relationships.
• Create detailed logical models identifying all the entities, attributes and their relationships.
• Convert logical models to physical models for the databases in use and provide DDLs to the implementation teams.
• Create a taxonomy/data dictionary to communicate data requirements that are important to business stakeholders.
• Lead and participate in design workshops to facilitate an understanding of business data needs and how they are mapped to the data model.
• Facilitate resolution of model conflicts created by competing business requirements.
• Support review, sign-off and adoption of data models in collaboration with global businesses, architecture and delivery teams.
• Articulating modeling principles to other modelers and business users.

Skills on Resume: 

• Data Model Creation (Hard Skills)
• Data Requirements Analysis (Soft Skills)
• Conceptual Data Modeling (Hard Skills)
• Logical Data Modeling (Hard Skills)
• Physical Model Conversion (Hard Skills)
• Taxonomy Development (Hard Skills)
• Design Workshop Facilitation (Soft Skills)
• Conflict Resolution (Soft Skills)

Job Summary:

• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Prepare database object deployment DDL and DML scripts for DEV/UAT and Prod environments
• Enforce standards and best practices around DM and deployment efforts.
• Ensure data warehouse and data mart designs efficiently to support end users.
• Apply data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Support enhancing the technical documentation to align with the most recent documentation templates.
• Exercise professional judgment on engagements by providing proactive solutions and recommendations.
• Provide recommendations for improved and enhanced business efficiency to clients
• Maintain effective communications with clients and teams to ensure client satisfaction
• Investigate data quality issues to determine root cause, resolve any data issues and recommend process change to prevent reoccurrence

Skills on Resume:  

• Data Model Collaboration (Soft Skills)
• Model Review (Soft Skills)
• Script Preparation (Hard Skills)
• Standards Enforcement (Hard Skills)
• Data Warehouse Design (Hard Skills)
• Data Cleansing (Hard Skills)
• Documentation Enhancement (Hard Skills)
• Data Quality Investigation (Hard Skills)