Data Architect Resume Samples
4.5
(97 votes) for
Data Architect Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the data architect 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.
KH
K Hauck
Kimberly
Hauck
7880 Dicki Field
Los Angeles
CA
+1 (555) 361 7514
7880 Dicki Field
Los Angeles
CA
Phone
p
+1 (555) 361 7514
Experience
Experience
Boston, MA
Data Architect
Boston, MA
Pouros LLC
Boston, MA
Data Architect
- Client Credit Data Architect Data Architecture and Information Services (DAIS) is the group within the Enterprise Architecture Management and Services (EAM&S) department that is responsible for developing and maintaining data structures (physical database objects) and a repository for the formal definitions of the data and data structures (Global Data Dictionary) for all of client Credit globally
- Participate in data integration, business intelligence (BI) and enterprise information management programs by rationalizing the data architecture to support reuse
- Create reports
- Works with Data Engineers, DBA’s as part of Database Design and Development
- Working knowledge of software development methodologies including RUP, Agile, Extreme Programming, SDLC, and Waterfall
- Develop and maintain Enterprise Data Models for Enterprise Class Data Initiatives
- Developing and enforcing data modeling standards and best practices
present
San Francisco, CA
Data Architect
San Francisco, CA
Jenkins LLC
present
San Francisco, CA
Data Architect
present
- Organizing and managing the technical DATA team of data architects, data modelers, engineers and providing leadership, guidance, and mentoring
- Developing conceptual and logical information models within the context of the Enterprise and Line of Business Information Architecture
- 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
- Ensuring that DW/BI standards and guidelines are used to develop the information models and database designs
- Working with the DBA to transform the logical information model into a first-cut logical database design (physical information model for the target DBMS)
- Developing a comprehensive process used to drive efficient application of resources across the business
- House database expert and authority by defining, implementing, and enforcing all data integration standards and documentation. Review and suggest improvement to the data architecture processes, policies, and vision and explore new and emerging technologies. Lead the investigation and adaptation of beneficial data architecture technologies and tools and lead strategy, development, and implementation of an Enterprise Data Model and strategy development for usage of Operational Data Stores. Develop transparent and well understood enterprise data governance processes, rules, and technologies to support them, identify and promote best practices for data modeling within information areas, and provide oversight for all activities related to data cleansing, data quality, and data consolidation
Education
Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Colorado State University
Bachelor’s Degree in Computer Science
Skills
Skills
- Data Analysis- Strong SQL skills and data profiling. Comfortable with Informatica or similar data profiling tool
- Highly motivated, a quick learner, able to work independently or in a team and drive solutions with minimal supervision
- Strong knowledge on data profiling, data standardization, transformation, cleansing and best practices to apply on high volume data
- Strong business acumen that enables the ability to develop strategy, process capabilities, and enabling database technologies
- Strong knowledge of leading concepts in Data Quality, Master Data Management, Data Governance and Data Stewardship
- Experienced in creating highly available systems, leadership skills and ability to mentor and train other technical staff members
- Strong problem solving and logical thinking skills - the ability to take complex ideas and break them into logical actionable steps
- Great balance between offering quick solutions and writing maintainable code
- Excellent understanding of how data integrity is maintained across complex, distributed systems and good working knowledge of TPMS, XA, ETL and SOA solutions
- Excellent written and verbal presentation skills, and ability to present to technical and business audiences
15 Data Architect resume templates
Read our complete resume writing guides
1
Data Architect Resume Examples & Samples
- Responsible for designing and delivering Flexible & Performant Databases which align with Business Goals
- Help in developing Enterprise wide guidelines/standards for Database Design
- Works with Data Engineers, DBA’s as part of Database Design and Development
- Work with Solution Architects to develop ETL/Data Integration/Data Processing Flows
- Support Minor Database Change Requests as needed
- Develop and maintain Enterprise Data Models for Enterprise Class Data Initiatives
- Support ETL Teams in Development effort if needed
- Work with Development Teams to understand and make recommendations on Proposed Database Structures and Data Flows
- Expert Level working knowledge of Database Design and Data Modeling Principles
- Financial Services Industry knowledge is a plus
- Experience with IBM Infosphere (Business Glossary, Information Analyzer, Metadata Workbench) is a plus
- Experience with HP Non Stop SQL is a plus
- Bachelor’s Degree in a Technology Related Discipline is preferred
2
Data Architect Resume Examples & Samples
- Translates enterprise or business requirements into long-term information/data architecture solutions, including conceptual, logical and physical models
- Analyzes and defines enterprise master data management strategies and models
- Implements and promotes governance processes for information and metadata to ensure establishment of a common language and the ongoing accuracy, validity, and reuse of metadata
- Architects and designs data virtualization and data abstraction solutions, leads the related implementation efforts
- Defines and maintains best practice guidelines and standards for data, metadata, data modeling, and management
- Provides best practice leadership to database administrators and application developers
- Documents technology roadmaps and the transition from the current architectural framework to target architecture of the future
- Serves as point of escalation, review, and approval for key issues, significant projects, and decisions
- Advises business and technology groups on future technology options, outlining risks, costs, benefits, and capabilities
- Collaborates with business analysts and project managers on a wide range of technology projects, including software development, package implementations, and infrastructure upgrades/changes
- Bachelor's degree in Computer Science, Computer Information Systems or related required
- Master's degree in Computer Science preferred
- Detailed understanding of information/data architecture
- Experience successfully implementing data-centric applications, such as data warehouses, operational data stores, and data integration projects
- Comprehensive understanding and experience in master data management best practices and ability to be a leader in their implementation
- Experience in metadata management—maintenance as well as design and implementation of metadata-driven enterprise solutions
- Working knowledge of data architecture principles, terminology, and data modeling techniques
- Detailed understanding of data repository characteristics, including data warehouses, operational data stores, data marts, and application databases
- Demonstrated ability to produce conceptual, logical, and physical data models, proven experience with data modeling tools
- Experience with and knowledge of ETL methodologies and tools (Informatica, SQL Server Integration Services)
- Detailed understanding of relational databases (SQL Server 2000/2005/2008)
- Good understanding of reporting/analytic technologies (Cognos, SQL Server Reporting Services, SQL Server Analytic Services)
- Knowledge and experience with industry reference models and data governance processes
- Knowledge of data discovery methodologies
- Knowledge of data classification, business ownership/stewardship definition, and developing role-based data access
- Familiarity with data privacy, compliance, and security principles and standards (GLBA, COBIT, Sarbanes-Oxley, etc.)
- Experience with EAI, SOA, and web services
- Strong strategic planning capabilities
- Experience working with cross-functional IT groups to promote open communication and teamwork
- Familiarity with architectural frameworks (ZIFA, TOGAF, etc.)
- Understanding the enterprise architecture discipline, processes, concepts, and best practices
- Excellent verbal and written communication skills in order to document and present data models, strategies, standards, and concepts to both business and IT audiences
- 5 years systems/data architecture experience with large-scale, mission-critical databases and applications
- Previous Financial Services/Investment Management industry experience preferred
3
Data Architect Resume Examples & Samples
- 5 years of data architecture and data modeling experience
- Expert in at least one Data Modeling tool (Power Designer or CA Ervin is preferred)
- Proven ability to transform business information into conceptual, logical and physical data models
- Strong skills in Relational Database (preferably DB2) including database design & SQL writing
- Advanced collaboration and communication skills to be able to interact with business units
- Experience in finance industry, domain knowledge in Operational Risk & Control business functionalities
- Unix & Autosys expousore, system administrator background
- Informatica ETL and IDQ
- Experience working datawarehouses
- Experience working with Enterprise Data Warehouse Frameworks and ETL design.*LI-MW
4
Data Architect Resume Examples & Samples
- Work with Head of Data, Documents and Imaging on data management standards
- Manage a team of Data Modelers, Data Analysts, and Metadata Repository Administrators, providing technical leadership and coaching to team members
- Understand data flows and lineage from operational data sources to analytical data sources
- Review and approve project designs including data models and ETL
- Work with Chief Architect to evaluate new/upgraded software and infrastructure
- Work with project teams to ensure compliance with data management standards
- 10 years in information technology
- 5 years in architecting enterprise class data management solutions
- 5 years of experience managing direct report employees
- Ability to lead the design and development of a large-scale data warehouse
- 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
- Experience in enterprise data modeling standards and tools such as Erwin
- Experience in Microsoft SQL Server 2008 R2 or higher. Experience in Oracle 11g or higher a plus
- Experience in SQL or query optimization, indexing and performance tuning, and design for performance
- Experience working with database deployment architecture that includes clustering and replication
- Experience with capturing enterprise metadata including structure, data lineage and data quality. Experience with Ab Initio Metadata Hub a plus
- 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
5
Data Architect Resume Examples & Samples
- Demonstrated communication skills with business and technology
- A College or University degree and/or relevant proven work experience is preferred
- The candidate will have excellent communication skills and have demonstrated the ability to marry the needs of a business with a balanced risk based approach to implementation of systems
6
Data Architect Resume Examples & Samples
- Data Analysis and Modelling – Working with the business and data analysts in the EDH team, as well as the key stakeholders, drive out requirements for data from consumers and understand how these map onto the data within the warehouse, and within the systems that feed the warehouse. Use this information to drive the data modelling activities both to the relational and XML models. This will require being proactive in understanding the requirement of the service consumers as well as the capabilities of the data providers
- Manage the data governance forum – the data model for the EDH is tightly governed and the role holder will chair the meetings of the data modelling governance forum
- Technical architecture – drive evaluation of the technology architecture to support new requirements and improve existing capabilities
- SQL (ideally in a data warehouse environment)
- Messaging middleware (IBM MQ or similar)
- SOAP web services
7
Data Architect Resume Examples & Samples
- Contribute to data architecture frameworks, data architecture strategy, policies, guiding principles and standards to govern how technology solutions will be developed and implemented
- Support the communication and execution of a comprehensive data strategy
- Contribute to the evolution of the enterprise information model to support all operational platforms, data marts and data warehouses
- Contribute to the development of project plans by providing input and manage projects/initiatives by directing assigned resources, communicating project status and providing timely escalation of issues. Contribute to meeting key project milestones
- Work with Solution Architects, Application Architects and Subject Matter Experts to develop conceptual data models consistent with enterprise frameworks, standards and data strategies
- Ensure projects are compliant with technology architecture and review all related activity against technology architecture and development standards
- Demonstrate proficiency in facilitating large complex assignments while taking an enterprise wide view of data requirements
- Apply knowledge of business requirements and industry knowledge and best practices to the maintenance and enhancement of the enterprise-wide and/or project specific architecture frameworks
- Engage with vendors, clients and project teams for data architecture
- Review the database deliverables to ensure quality and traceability to requirements and adherence to all quality management plans and standards
- Support the development and test teams with the creation of test data and ensure test data conforms to data security requirements and enterprise data standards
- Extend and promote the TDI data policies, standards and guidelines and align with the enterprise and contribute to decisions on technology standards
- Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
- Develop advanced knowledge of business/organization, Bank and Insurance standards from an architecture perspective
- Assist in determining the cross-application data standards, data distribution standards and integration strategies
- Provide strategic and technical advice to senior managers and technical resources in the creation and implementation of new data standards and databases
- Assess the technical characteristics of proposals and alternatives considered to optimize database performance
- Continuously enhance knowledge/expertise in own area and keep current with emerging industry trends, new technologies and best practices
8
Data Architect Resume Examples & Samples
- 5+ years of experience in a formal Data, Services and Solution Architecture role in a complex development organization
- 2+ years of experiences in Big Data Solution Architecture role
- Provide expertise and counsel; ensuring technology teams and business areas understand the architectural options in support of their business initiatives
- Research/analyze business requirements to evaluate and recommend optimal solutions
- Influence from an architectural perspective within the business environment, and fulfill a data/service governance role
- Apply industry knowledge to provide solutions that increase business results and/or minimize risk
- Identify, recommend, source, negotiate and implement emerging data trends, developments and improvements/solutions (buy/build/reuse)
- Knowledge of process and enterprise architecture governance (TOGAF, Zachman)
- Knowledge of SAP Business Objects, and OBIEE would be considered an asset
- Development of Business and Data Roadmaps and associated plans
- Use specialized tools and techniques to develop data model and enhance existing data model. Experience in ETL, data architecture, data modeling, data analysis and profiling, Metadata Management, Reference Data Management, Big Data, Master Data Management, and the Teradata Financial Services Logical Data Model considered an asset
- Use specialized tool and technique to develop service/message model and enhance existing service/message model. Experience in EAI, SOA, and ESB, designing and implementing solutions using WSDL, REST and SOAP
- 2+ years of experience with the following tasks in the context of Distributed Data Analytics
- Implementation of Data Warehouse applications
- Administration of relational databases
- Data migration from existing data stores
- Able to multi-task in a very dynamic environment as a Data/Services/Integration Architect may be juggling 5-10 projects within their portfolio at a time
- Build consensus and alignment between enterprise-wide direction and business specific initiatives and requirements
- Excellent logical thinking skills possessing the ability to prepare logically structured papers
- Very good written and verbal communication / presentation skills
9
Data Architect Resume Examples & Samples
- Proactively educate delivery teams on MB guiding principles, standards, and data governance practices
- Engage in multiple information architecture initiatives to guide data requirements, ensure proper data model design, build data models when required (logical and physical), and enforce information architecture standards
- A good teacher and communicator on the modeling techniques, data solutions, modeling & governance
- Identify new trends in data management architecture and tools
- Experience with data warehouse design, master data management, and “Large Data” technologies is a plus
- Excellent communication skills, including verbal, written and presentation, are required
- Requires technical understanding of Data Integration, SOA, MDM, Metadata, DWH, Reporting & BI product suites
10
Data Architect Resume Examples & Samples
- Minimum of 2 year of hand-on experience programming in Hadoop framework, HDFS, MapReduce processing implementation
- Minimum of 5 years systems development and implementation experience using Java/J2EE, RDBMS, Linux/Unix
- Working experience with large scale Hadoop environments build and support including design, configuration, installation, performance tuning and monitoring
- Experience with the following tasks in the context of Hadoop
- Bachelor's degree (or higher) in Computer Science, Engineering or Technical Science
- Hands-on experience with the overall Hadoop ecosystem (e.g. MapReduce, HDFS, Pig, Hive, HBase, Flume, HCatalog, Sqoop, Oozie, Zookeeper)
- Hands-on experience with related/complementary open source software platforms and languages (e.g. Java, Linux, Apache, Perl/Python/PHP, JSP, XML)
- Well versed in installing & managing Cloudera distribution of Hadoop (CDH5, Cloudera Manager, etc.)
- Hands-on experience with analytical tools, languages, or libraries (e.g. SAS, SPSS, R, Mahout)
- Experience with ETL (Extract-Transform-Load) tools
- Hands-on experience with Visualization and BI tools and reporting software (e.g. Tableau, Cognos, Microstrategy, Pentaho)
- Hands-on experience with Hadoop based monitoring tools (CM, NagiOS, Ganglia etc.)
- Previous experience with NoSQL or distributed RDBMS would be an assist (Cassandra, MongoDB, etc.)
- Knowledge of cloud computing infrastructure (e.g. Amazon Web Services EC2, Elastic MapReduce) and considerations for scalable, distributed systems
- Must be proactive and be prepared to address meetings
- Must show initiative and desire to learn business subjects
- Excellent problem solving skills; proven teamwork and communication skills
11
Data Architect Resume Examples & Samples
- Lead and collaborate within WMTS to select and define appropriate data architecture in line with the Wealth Data Strategy
- Align Wealth Data Strategy with Enterprise Data Strategy
- Deliver effective, agile data designs
- Develop, maintain, and refine data models: conceptual, logical, and physical, in relational, dimensional, multidimensional and non-structured environments
- Define data integration architecture
- Develop, maintain and refine data standards for WMTS
- Create Data Movement/Preparation/Transformation data standards
- Determine business requirements and based on those requirements define what data is required for projects
- Determine non-functional characteristics of data: timeliness, access-to data/batch/online/existing service
- Define data quality standards
- Review existing database deployments for alignment to WMTS data models
- Identify data sources, confirm which systems have the data required, construct data decomposition diagrams, data flows & data context diagrams
- Obtain buy-in and adoption, through socializing key concepts, objectives, benefits and plans of the program
- Liaise with other areas of the enterprise to identify possible areas of synergy and leverage to accelerate the development of WMTS’s data architecture and facilitate stronger integration with other parts of the bank
- Further advance the TD Enterprise Data Model (EDM) for any new data that is required
- Research and innovate: continually recommend improvements to data modeling techniques, data-related technologies and standards and governance resources and processes
- Ensure a good relationship is maintained with stakeholders, to keep them informed of business needs and current direction
- Act as an expert consultant / resource in data design, architecture governance principles and best practices
- Work effectively as a team, supporting other members of the team in achieving business objectives. Provide leadership / consulting / direction to the team on all aspects of data architecture to ensure advanced learning occurs. Lead and manage data architecture activities within the team
- Work with Solution Architects, Application Architects and Solution Designers to define data requirements and provide a foundation for data design
- Model and design the application data structure, storage, and integration in collaboration with Solution Designers and DBAs for operational systems, web APIs, DataWarehouse and BI analytics
- Ensure that the Developers and DBAs responsible for developing the database thoroughly understand the requirements and designs
- Review the data deliverables to ensure quality and traceability to requirements and adherence to all quality management plans and standards
- Provide guidance on database analysis, design, and build effort
- Primary Subject Matter Expert with specialized knowledge related to data architecture of multiple TD applications and/or lines of business
12
Data Architect Resume Examples & Samples
- 10 plus years of experience in Data Architecture and Modeling in Data and Information Architecture and Data Warehousing
- Practical experience with Big Data technologies and Architecture
- Experience building multiple Logical Data Models, both custom and industry banking models (FSLDM or BDWM)
- Experience designing and supporting a multi-terabyte Data Warehouse using Teradata, Oracle, Hadoop or DB2
- Requires technical understanding of key aspects of current architectures regarding Data Integration, SOA, Master
- Data Management, Metadata, Data Warehousing, Reporting & BI product suites
- Experience with data security and privacy architecture is critical
- Requires extensive understanding of Data Warehousing, Active Data Warehousing, Operational Data Stores, Data Integration, Reporting and BI technologies
- Experience achieving objectives in a large organization including influencing and negotiating with Sr. Management
- Experience with and a strong understanding of the Teradata RDBMS, Hadoop and the SAS product suite
- Experience with different classes of BI tools. Experience with Cognos, Tableau is a plus
- Excellent people skills, leadership skills and experience motivating people to achieve objectives
- Understanding of Data Integration and ETL technologies. Experience with DataStage or SAS is preferred
- Bachelor's degree in Science, Business or Arts is required, Master's degree in Computer Science or similar is
13
Data Architect Resume Examples & Samples
- Performs data modeling (conceptual, logical and physical) for supported applications (OLTP, ODS, MDM, Data Marts, Data Warehouse etc.,) and projects and creates related diagram deliverables
- Performs initial table storage capacity and predicted future growth based on the application use and online retention requirements
- Prepares table access properties and volatility transactions
- Creates technical specifications, documentation and data dictionaries
- Assesses the impacts and efforts of new projects and continuous enhancements to existing application data architectures and data models
- Generates sequenced sets of DDL scripts through the use of versioning
- Leads the creation of database related scripts and programs required to compliment the auto-generated DDL scripts
- Partners with application teams on the data loading technology and logic to achieve the best results
- Partners with the DBA’s on the database design, co-existence and consolidation and replication/propagation strategies for new applications
- Evaluate SQL and NoSQL technologies that are appropriate for specific use cases
- Design models for NoSQL DB based on the business requirements
- Analyze Big Data use cases and design data stores and data architecture using Hadoop and related technologies
- Collaborates with the Sr. Data Architect, defines standards in data architecture and modeling for transaction, reporting, data warehouse databases with considerations to database availability, scalability, manageability and performance
- Collaborates with the Sr. Data Architect in defining standards for how data will be organized, stored, accessed and propagated while maintaining a flexible and extensible architecture that allows evolving information needs
- Seeks for opportunities to reuse, share, consolidate and leverage existing data architectures
- Maintains an accurate and up to date Meta data repository containing data and business definitions, data sources and usage of information that can be used by business users and application teams to enhance overall data quality and the ability to rapidly deliver business solutions
- Assists the application teams in the definition of extract, transformation and load processes used to populate tables
- Manages the data modeling tool and repository and ensures accurateness and up to date information
- Develop project plans and estimate efforts for projects
- Researches, evaluates and recommends trends and products to deliver high quality and low cost data management solutions
- Stays abreast of data modeling, RDBMS features and functionality through attendance at seminars, classes and other training material
- Six years of experience as data architect or data modeler
- A Bachelor of Sciences Degree in Computer Science or equivalent training and practical experience
- Experience in designing data models and architecture standards for multi-terabyte databases in both OLTP and Data Warehousing. Minimum of two years in Data Warehousing environments
- Experience in designing data models for MDM and ODS
- Experience designing utilizing ETL technologies
- Experience designing utilizing Data Federation and Data Virtualization technologies
- Extensive experience with Oracle RDBMS and applying features to produce highly manageable, performing and scalable data architectures with multi-terabyte databases
- Experience with designing data architectures leveraged by OLAP, MOLAP and ROLAP applications
- Knowledge of NoSQL technologies and design concepts
- Knowledge of Big Data and Hadoop technologies and design concepts
- Experience in managing multiple concurrent projects using standard software development life cycle methodologies
- Requires knowledge of web, middleware technology, Object Oriented design and Service Oriented Architectures
- Data modeling and architecture experience with SQLServer, Sybase and DB2
- Practical work experience with Informatica ETL tool or other ETL technologies
- Practical work experience with NoSQL DBs
- Practical work experience with Hadoop based solution implementation
- Practical work experience as a DBA in development and production environments
- Experience in the design and maintenance of near real-time data warehousing
- Experience in the financial services or mutual fund industry
- Ability to work across functional teams to gather requirements needed for the design of the solution
- Ability to work on multiple, concurrent projects of varying size and scope and core team activities in a fast paced, global environment
- Ability to build consensus and collaborate with others
- Ability to meet objectives within short timeframes and prioritize conflicting deadlines
- Creative and innovative in the use of technology
14
Data Architect Resume Examples & Samples
- Experience working successfully in data management domain (with primary focus on information / data architecture as well as Master Data Management, Data Quality and Data Governance) gained from a mixture of development, design, architecture and technical lead roles
- Consulting / software background and /or extensive experience of dealing and managing such consulting organizations, system integrators and software vendors
- Proven track record and experience in end-to-end architecture obtained from multiple implementations of enterprise scale, data centric projects
- Strong academic and practical background in architecture development and design methodologies, holding formal architectural certifications and / or being able to demonstrate significant IS industry experience across major consulting and delivery organisations
- Advanced Microsoft Office skills (Word, Excel including VBA, PowerPoint, Visio and Access)
- Proficient user of data modelling (e.g. Erwin, ER/Studio and PowerDesigner) and enterprise architecture tools (e.g. Enterprise Architect, ARIS and Mega)
- Experience using SQL for modifying, manipulating and transforming data
- Experience with RDBMS technologies (e.g. Oracle, SQL Server, Teradata)
- Exposure to / experience of using project management tools (such as MS Project or suitable alternatives)
- Exposure to / experience of using collaboration tools (e.g. SharePoint, Wiki etc)
- Exposure to / experience with ETL technologies (e.g. Informatica, MS SSIS, Ab Initio etc)
- Exposure to / experience with data quality tools (e.g. Trillium, SAS DataFlux, Informatica Data Quality etc)
- Exposure to / experience with MDM technologies (e.g. SAP Netweaver, IBM InfoSphere Advanced, Oracle Siebel UCM etc)
15
Data Architect Resume Examples & Samples
- Analyze business needs and information requirements, define optimum system requirements to meet business needs, and prioritize and manage new requirements
- Develops detailed analysis, design, construction and testing specifications ensuring technical compatibility and integration
- Verifies decision support program specifications with users for reliability, accuracy and functionality. Provide support to development team through tuning, indexing, sizing and debugging to ensure that quality and standards meet customer expectations
- Maintain modeling and naming standards and data normalization, meta data management, source to target data mapping
- Provides technical leadership to onsite/offshore development team through mentoring and technical documentation
- Manages overall physical database structures for business functionality, data integrity, performance, recoverability, maintenance, and space requirement considerations
- Monitors system and database performance to identify performance improvement opportunities via physical database design, SQL or programming changes
- Creates and maintains logical and physical data models, metadata repositories, data catalogs, performing database design
- Maintain data model and queries for data retrieval and data distribution to downstream systems
- Bachelor's Degree with a minimum 2 years of IT experience
- Minimum 2 years of SQL skills and experience tuning both SQL code and physical database design
- Minimum 2 years experience in PL/SQL and extensive experience in stored procedures Eligibility Requirements
- Must submit your application for employment through COS (Internal Candidates) or GECareers.com (External Candidates) to be considered for this opening
- Must be willing to travel up to 5% of time
- Experience in analyzing source system, data flows, and delivering data architecture designs
- Possesses SQL skills
- Experience working as a Data/Information Architect
- Experience performing logical and physical design, performance monitoring and tuning as well as project implementation
- Knowledge of backup, recovery, and security procedures for Oracle databases, and data modeling
- Review business requests for data and data usage, researches and recommends changes to upcoming data sources
- Extensive experience with performance tuning and metadata design and management
- Performance tuning and stored procedure development using PL/SQL
- Work with BI team to build and run ETL workflows with Informatica or similar
- Design and maintain logical and physical database models with ERwin or similar
- Maintain existing Oracle schemas for self-service applications including data dictionaries
- Optimize database model and queries for data retrieval and data distribution
- Strong communication skills to work on a cross-functional team and leverage IT COE's
- Ensure all disaster recovery and replication scripts are running
16
Data Architect 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
- 10 to 15 years minimum in technology preferably with a financial services firm
17
Data Architect Resume Examples & Samples
- 10+ years hands-on data architecture experience - in both maintenance/operational and project support role. 6+ years in data centric initiatives
- Proficient in supporting data design activities
- Experience in Financial Services industry preferred
- Bachelors degree or equivalent work experience or certification
18
Data Architect Resume Examples & Samples
- Work with business users and project teams to gather robust metadata and complete projects within specific timeframes
- Ensure that element definitions are robust and meaningful
- Name elements according to established standards
- Utilize ERWin to develop logical data models from functional specifications, data requirements, and business rules provided by clients. These models will be consistent with the Group Template Models, Group Logical Data Modeling standards, and modeling best practices
- Support the various loading procedures of’ logical models and databases into the metadata repository (GMR)
- Maintain and enhance existing logical data models based on change requests or enhancement requests
- Follow established data administration standards for quality and referential integrity
- As necessary, develop task project plans and track against same
- As necessary, monitor the plan’s critical paths and modify project plans accordingly
- Communicate project status to management
- Miscellaneous duties as assigned
- Provides instructions to teammates on new procedures, techniques and software. Assist in providing guidance on continuous improvement of operations, decreasing turnaround times, streamline work processes and work to provide seamless customer service
- Good communication, interpersonal and professionalism skills who can work directly with applications/client users of all levels of staff and management
- Master’s degree in business supplemented by technical coursework preferred
- 1-3 years working as a Business Analyst – focus on gathering requirements
- Ability to read a logical data model
- Familiarity with a data modeling tool, ERWin preferred
- Understanding of relational database structures
- The ability to work in a team environment, collaborate and work well with peers
- A high sense of ownership with customer service focus
19
Data Architect Resume Examples & Samples
- Bachelor's degree in Computer Science or equivalent, Master's degree preferred
- Minimum 6 years of database architecture experience
- Expert understanding of complex SQL
- Ability to work in a dynamic team environment and interact with resources from technical and non-technical organizations
- Outstanding organizational and time management skills - able to manage and prioritize multiple assignments
- SQL, python , Shell , Ruby
- MYSQL important, Netezza and Vertica plus
- Hadoop, Impala, Spark nice to have
- Developing logical and physical data models and designs based on customer requirements
- Dimensional modeling and NOSQL modeling
- Developing and implementing data replication schemes
- Measuring, analyzing, and tuning the performance of database applications
- Database security, encryptions, SSL, and user profiles
- Business intelligence/Data Warehouse solutions
20
Data Architect Resume Examples & Samples
- 5+ years of related experience
- College Diploma or University Degree in the field of Computer Science / Engineering or Information Systems
- Expert level SQL skills, experience with SQL Server 2012 including SSIS and SQL Server
- Hands-on experience with systems requirements gathering/analysis Management Studio
- Solid understanding of governance frameworks developed to resolve data ownership, sharing, and access rights
- Knowledge of enterprise architecture concepts and approaches
- Experience with Agile, SCRUM and XP development methods
- Demonstrated experience of software integration principles and practices
- Experience with application development tools, including Microsoft Visual studio
- Previous experience working on a large legacy system migration and conversion project
21
Data Architect Resume Examples & Samples
- Technical Management and Project Development Functions
- Provide leadership and direction for integrating and rationalizing data design within RBC’s Data Management Environment
- Provide DWE solution architecture for data warehousing projects
- Conduct studies of new tools and technologies relevant to Data Management & Data Warehousing
- Improve EIM performance by providing technology leadership through
- Education and awareness
- Development of business cases for tools and technology introduction
- Extend and promote the RBC data policies, standards and guidelines across the enterprise
- Exercise influence and impact across the enterprise in promoting the thought leadership and the strategic data management direction across the enterprise - Establish, publish, and evangelize the use of information standard data models, policies, tools and infrastructure across the enterprise
- Lead research efforts and introduction of new data management tools and technologies
- Initiate and direct studies related to enterprise data standards, strategies, issues and opportunities
- Liaise with other technical areas, conduct technology research, evaluate software and produce strategy/direction papers
- Effectively communicate complex architectural strategies and directions to both systems and business users
- Interface with systems and business management to raise their level of understanding and support for information integration
- Promote the goal of data stewardship
- In-depth understanding of application, information and data architectures; broad knowledge of RBC businesses and systems
- Ability to balance creativity with pragmatism, concepts with practical applications
- Very strong interpersonal and communication skills; ability to communicate with people in wide variety of areas and at various levels from technical specialists to senior executives
- Strong technical skills in data management: data modeling and db design, DWE Solution Architecture, data movement, business intelligence, data quality, reference and master data management, data governance processes etc
- Enterprise data modeling and integration
- Understanding of Business and Solution Architecture disciplines and techniques
- Experience and ability to solution with current technologies (DB2, SQL Server, Oracle, Teradata, Datastage, Oracle BI etc)
- Ability to assess and solution with emerging technologies (Big Data, Hadoop, NoSQL, Cloud etc.)
- Data model entities and relationships of a financial services platforms and enterprise functions (e.g. Banking, Insurance, Investments, Wealth Management, AML, Risk, Finance, Fraud etc....)
- Patterns of usage of the entities and relationships in the data model
- Database integration patterns and performance considerations for operational and DWE databases
22
Data Architect Resume Examples & Samples
- 5+ years of prior experience as a Data Analyst
- Prior FPA experience
- Proficient in designing and developing spreadsheets, databases, and graphs
- Working knowledge of statistical analysis tools
- Comprehensive knowledge of Excel, Access, PowerPoint, Business Objects, Crystal Reports and SAS and Oracle data bases
- Knowledge of the banking industry products and regulatory requirements
- Familiarity with loan accounting requirements
23
Data Architect Resume Examples & Samples
- As the Data Architect in the CoE you will be responsible for building and maintaining the data model that underpins the operations and analytic capabilities of our business
- Drawing on your skills and experience, you will create innovative insights for the CoE and our clients, adapt methods and practices to fit operational team and cultural needs and contribute to thought leadership exposing by previously hidden knowledge through the use of leading edge technologies and solutions
- Create, design and architect the data model based upon business and user requirements
- Perform both logical and physical modelling of the DB as well as designs of the XML schema (not just the database)
- Maintain metadata and mappings for correlating information
- Define the data dictionary and information taxonomies
- Use modelling tools to provide clarity over technical specifications for the solution delivery teams
- Provide proof of concept support and basic delivery capability, before full design and development is provided by the delivery teams
- Review all current operational data structures and recommend optimizations and reconfigurations
- Develop and maintain all standards required for our data structures and models
- Work with business analysts, technical staff, and CoE team members to plan, design, develop, implement, and enhance applications and metadata for CoE systems
- Work closely with 3rd party vendors to integrate selected packages
- Recommend and evaluate new tools and methodologies
- Will provide full-life cycle architectural guidance and ensure quality technical deliverables
- Plan and lead the design of data conversion (Extract/Transform/Load) processes, utilising external resources as required to ensure we have a comprehensive data lifecycle process and governance in place
- Development of the Information Strategy
- Experience working successfully in data management domain (with primary focus on information / data architecture as well as Master Data Management, Data Quality and Data Governance) gained from a mixture of development, design, architecture and technical lead roles)
- Consulting / software background and /or experience of dealing and managing such consulting organizations, system integrators and software vendors
- Proven track record and experience in end-to-end architecture obtained from multiple implementations of data centric projects
- Proficient user of data modelling (e.g. Erwin, ER/Studio or similar)
- Experience with RDBMS technologies (e.g. SQL Server)
- Experience in web based Architecture, end user usage analytics and design improvements
- Experience with business analysis and requirements gathering techniques
- Knowledge of business process modelling techniques and workflow systems
- Knowledge of XML and XBRL
- Ability to manage multiple priorities, follow a project plan and meet project deliverables
- Strong conceptual, analytical and decision making skills
- Proficiency with Microsoft Office (Word, Excel, PowerPoint, Access)
- Exposure to enterprise architecture tools (e.g. ARIS, Mega)
- Exposure to unstructured data (e.g. Hadoop)
- Exposure to middleware technologies EAI and ETL tools
24
Data Architect Resume Examples & Samples
- Extensive database/data warehouse modeling and design experience (ERWin, PowerDesigner preferred)
- In-depth knowledge and hands-on experience with data integration ETL development
- In-depth knowledge and hands-on experience with reporting and analytic tools such as Business Objects, SAS, etc
- In-depth knowledge and hands-on experience of database systems, specifically Teradata, Sybase, Oracle and/or DB2
- Strong SQL and database performance tuning skills
- Team management skills
- Experience in NoSQL/Big Data
- Experience with Java or any other programming language
25
Data Architect Resume Examples & Samples
- Participate with BI team in the implementation of processes which result in a high degree of data quality and integrity, and assist in the resolution of data quality issues
- Establish and maintain an Enterprise Data Model describing how data is processed, stored, and utilized, including source to report lineage
- Develop data governance strategy and controls to ensure consistency of data between various systems, and across the enterprise system architecture
- Provide advice and give presentations on solutions for business intelligence and data warehousing activities including reporting, and data analytics for stakeholders at different levels within the organization
- Consultation and collaboration with Enterprise Architect, Security and Service delivery areas to ensure solutions adhere to strategies, standards and policies
- Help drive best practice in the Architecture domain through the introduction of enhanced development, testing and deployment standards and policies
- 10 + years commercial development experience of hands-on design and implementation of business solutions that include data design/modelling, ETL technologies and reporting/BI technologies, for multi-terabyte data warehouse solutions
- Exposure to projects involving data warehouse replacements, including platform selection
- Track record of delivery of projects in mission critical environments
- Exposure to multiple, diverse business systems, technologies and processing environments
- Solid understanding of metadata management best practices with experience implementing or operating a metadata repository
- Awareness of Big Data Solutions and Fraud Analytics
- Prior experience of contributing to the development of IT strategies
- Knowledge of all aspects of IT architecture (TOGAF or other frameworks is a benefit)
26
Data Architect Resume Examples & Samples
- Strong knowledge of SQL in terms of performance tuning and optimizations
- In depth experience with data/information modeling
- Data Warehouse experience
- Experience with risk management platform development in financial industry, i.e, market risk/credit/liquidity stress
27
Data Architect Resume Examples & Samples
- Provide technical expertise to identify and build data-models
- Develop data-entity and relationships diagrams based on business processes/models
- Assist in designing of master data management models and technical reference models
- Demonstrated experience designing and implementing data-dictionaries
- Work with governance teams to identify data governance and select applicable standards
- Bachelor's degree or an additional 4 years of relevant experience
- Active high level government security clearance
- 5+ years of System/Applications Development experience with focus on complex client/server and n-tier architecture systems
- 3+ years of data management and architecture experience
- 3+ years of experience using IBM System Architect or other architecture development tools
- Strong practical knowledge of data-management and modeling
- Understanding of National Information Exchange Model (NIEM)
28
Data Architect Resume Examples & Samples
- Establishes metadata management, modeling approaches and standards, and best practices for DW
- Adapts and implements data governance standards in the DW environment
- Develops standards, guidelines, and processes to consistently address recurring issues such as data convergence, data duplication, semantic issues, and data integration/synchronization
- Defines data strategy, policies, and controls to ensure that the DW environment is accurate, complete, secure and reliable
- Identifies areas for data quality improvement and helps to resolve data quality problems through teams and platforms including the DW itself, the MDM platform, ETL and related services, and systems of record and reference
- Engages with relevant internal parties and external vendors in best practice sharing and DW solution delivery
- Manages the DW Data Logical, Physical, and Canonical Models, including data dictionary/metadata registry
- Provides data consultation on complex projects and is considered to be a top level contributor/specialist
- Develops and deploys scripts through established turnover processes
- Analyzes and optimizes database and query performance
- Designs, tests, and deploys data integrity and other data quality mechanisms for the DW
- Develops and ensures compliance with data architecture principles and standards within the DW environment
- Proven leadership experience
- Strong experience working with metadata repositories and data modeling tools (e.g. Erwin, Rational Data Architect)
- Strong working knowledge of MDM processes, governance, and platforms
- Master-level knowledge of relational databases, Data Warehouse and business Intelligence solutions
- Demonstrable teamwork and collaboration skills
- Modeling/Design experience for high-performance platforms such as Oracle Exadata and Teradata will distinguish applicants
- Applicants must have significant experience outside the Microsoft stack. Oracle experience with strong PL-SQL skills preferred. Experience migrating SQL Server to Oracle is a plus
- Ability to function at the platform architect level as well as the application level is required, as the position is reponsible for both the DW platform and working with application teams (e.g., for view design)
29
Data Architect Resume Examples & Samples
- Minimum of 10+ year’s of businesss requirements analysis and information modeling (logical and physical) of key financial products (Bilateral, OTC & exchange traded, centrally cleared) and concepts (e.g. positions, trades, financing transactions, future flows, collateral/margining) in the securities/financial industry
- Minimum of 8+ years in handling Oracle based Physical Modeling
- Minimum of 5+ years in Leading database level tuning and optimization in support of application development teams
- Proficiency in SQL in order to access and analyze data residing in relational and dimensional databases
- Proficiency in a data modeling tool – preferably Erwin
30
Data Architect Resume Examples & Samples
- Provide strategic technology guidance to the business
- Develop a deep understanding of the business to identify new innovative data tools that support continued growth
- Identify opportunities for enterprise data quality and availability improvement - seek continuous improvement
- Establish and enforce best practices for extracting, transforming and integrating a flexible and maintainable Data Warehousing architecture
- Develop database architectural strategies at the modelling, design and implementation stages to address business and industry requirements
- Provide and design tools to assist in the management of the data base
- Collaborate with system architects, software architects, design analysts, and others to achieve a state of the art environment that meets current and future business objectives
- Develop guidelines and standards for cataloguing and maintaining data
- Minimum 3-5 years' experience in an analytical or architectural role
- Experience in building, maintaining and evolving end-to-end analytics data sources to meet the needs of analysts & data scientists
- Highly motivated, with a proven ability to work on own initiative and as part of a team within a challenging and dynamic work environment
- Experience with Oracle, Toad, SQL, Microsoft Excel and Excel VBA would be beneficial
- Proven track record of using strong analytical skills and a logical approach to problem solving
- Ability to prioritise tasks and work on multiple assignments
- Experience leading and motivating teams
- Flexibility as required by the business from time to time
31
Data Architect Resume Examples & Samples
- Designs and builds relational databases
- Develops strategies for data acquisitions, archive recovery, and implementation of a database
- Translates business needs into long-term architecture solutions
- Reviews and develops object and data models and the metadata repository to structure the data for better management and quicker access
- Must have Bachelor's degree
- Must have 8 years of experience in IT with 5 years as a Data Architect
- 5 years experience with Data Modeling & Data Administration Tools
- 5 years experience in data architecture, data modeling and database design
32
Data Architect Resume Examples & Samples
- 1) Data Architects produce Logical and Physical Data Models with corresponding Data Dictionaries while following Guidelines, Standards, and Procedures
- 2) Data Architects maintain Data Models over life of application under request of project teams
- 3) In addition, Data Architects review database designs, or packaged software solutions for fitness to project needs, architecture standards and best practices
33
Data Architect Resume Examples & Samples
- Work with Stakeholders and Product Owners to understand and maintain a high level understanding of the current and upcoming requirements for the portfolio
- Develop close links with key data stakeholders and a deep understanding of the purpose and future needs of the company with regards to data, working closely with Team Data and Business Intelligence
- Evaluate design alternatives and perform cost benefit analysis
- Create, develop and maintain appropriate descriptions of company data and data structures, including: data definitions, dictionaries, models, data mappings, data flow diagrams, etc
- Define and split architectural epics into features for the program backlog specifically focusing on data
- Be the focal point for research into new data technologies and design
- Serve as the technical governance representative within cross functional teams to make appropriate system and component level design decisions during the implementation phases, ensuring visibility through the technical governance process
- Be hands on and able to lead and perform technical spikes to prove out product ideas
- Oversee and provide quality assurance on all data designs with third parties
- Survey, evaluate and recommend toolsets, systems and solutions in response to current and future business need
- Highly motivated, a quick learner, able to work independently or in a team and drive solutions with minimal supervision
- Flexible: capable of juggling multiple priorities and willing to do what it takes to meet critical deadlines
- Able to show strong written communication skills including design documentation proof of concept and prototype analysis and documentation
- Able to have a proactive appoach and be able to take responsibility to act and think laterally to rapidly solve problems or identify opportunities as they arise
- Practical knowledge of applying some of these techniques into practice : large scale data migration, data segmentation, encryption, PII data implications, data mining concepts, context analysis and knowledge engineering theory
34
Data Architect Resume Examples & Samples
- Drives the architecture for key cross team / cross PD projects (via architecture/design documents and developing code key modules)
- Establishes software development patterns and best practices (via examples and shipping code)
- Focuses on quality by implementing a high-value test automation frameworks and using continuous delivery to optimize the flow of software delivery and enabling fast and reliable deploys
- Continuous delivery and Dev Ops experience - infrastructure automation, monitoring, logging, auditing and security implementation and practices
- Ensures that all relevant project teams follow a common set of principles and patterns and utilize a standard set of technology frameworks and libraries
- Provide leadership across the Architecture community to ensure solutions are built in alignment with platform principles and standards
- Proven knowledge of successful design, architecture and development in data platforms using Hadoop ecosystem
- Deep knowledge of HBASE and Cassandra technologies is a big plus
- BS/MS in Computer Science/Computer Engineering, Science, Math
- A minimum of 10 years of experience in architecture and development, 5 years with experience in Java/J2ee specific is required
- A minimum of 3 years experience with Hadoop and related technologies is required
- A minimum of 3 years experience with RDBMS development (Oracle, DB2, etc.) is required
35
Data Architect Resume Examples & Samples
- Provide expert guidance and consultancy in all matters relating to information management
- Collaborate broadly with business analysts, developers, DBAs and architects to support business analysis & gain understanding of the business data needs
- Create a robust, sustainable data/information architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources
- Create conceptual, logical and physical data models in support of the business needs
- Ensure data models are fully documented and appropriate data dictionaries are created
- Provide information architecture and data modeling support and mentoring to development team members
- Independently conducts moderate to highly complex assignments with minimal guidance and little or no supervision
- Create mapping specifications from source to target
- Communicate physical database designs to database administrator and ensure consistentcy between data models and the implemented databases
- Develop data modeling standards(naming conventions, model patterns etc.) and ensure adherence to the standards
- Provide regular coaching & guidance to less experienced analysts
- Provide solution architecture guidance in data related aspects of systems development
- Define and document data architecture for operational databases, reporting and provisioning platforms, including the physical components and their functionality
- Promote the goals of data integration, data stewardship, data quality and governance
- Implement data governance policies and provide leadership in the advancing the practic and articulating the value
- Provide recommendations into the selection, use and positioning of hardware, storage, and software products to support data architecture requirements
- Provide leadership in researching and architecting emerging technology solutions to meet business objectives
36
Data Architect Resume Examples & Samples
- Determine the data architecture from data sources to data integration and distribution for asset management data domains – clients, products, instruments, books & records etc
- Own the data architecture and oversight of core data platform, to facilitate Master Data Management, Meta Data Management, Data Quality Management, Data Integration, Data Distribution and Reporting / Business Intelligence. The core data platform would be a multi-purpose solution serving the needs of several asset management functions
- Collaborate with relevant business and functional heads to ensure alignment with tactical and strategic goals
- Partner with vendors and internal IT to deliver the IT architecture
- Collaborate with IT team to develop a phased delivery plan for the target architecture
- Present the architecture, choice of technology (internal and external) and delivery plan to AM Steering Committees to get scope and budget approvals
- Provide regular advice and direction during program execution
- Partner with UBS Group architecture teams to ensure reuse and adherence to firm principles
- Partner with Information Security Officer to ensure compliance with divisional and regional rules for data security and encryption
- 12+ years of diverse experience in designing and managing innovative data solutions beyond ETL and Warehousing within Financial Services
- Proven experience in managing complete SDLC from architecture to delivery
- Proven experience in MDM implementation
- Deep knowledge of Client, Product and Instrument data domains in Asset Management
- Broad knowledge of different database technologies beyond RDBMS - Columnar, JSON/XML, NoSQL, Hadoop
- Broad knowledge of vendor capabilities in data management solutions – MDM, Data Federation, Big Data, Data Quality, Business Intelligence etc
- Hands on experience in a Big Data solution, Data Quality solution, Meta Data management would be preferred
- Excellent communication skills to explain technical designs to non-technical colleagues
- Excellent interpersonal skills to work with other domain architects, IT and functional heads
- Maturity to participate in multiple complex programs at the same time in an agile environment
- Ability to handle teams working in multiple sites (onsite, offshore, near shore)
- LI-Priority
37
Data Architect Resume Examples & Samples
- Have 3-5 years experience in leading 5-10 member teams
- Agile development experience is an asset
- Must have experience dealing with multiple groups such as enterprise architecture, enterprise infrastructure, information securing and business partners
- Must have experience leading / facilitating meetings
- Must have good communication & presentation skills
- Must have experience in leading production deployments
38
Data Architect Resume Examples & Samples
- Designs, develops, manages and/or updates data models (both logical and physical) of the staging, data warehouse and data mart areas
- Coordinates collection of business requirements for data needs
- Captures and maintains metadata and data dictionaries for BI data stores
- Works with DBAs to migrate schema changes between development, QA and production environments
- Designs schemas for optimal query performance on the Netezza platform
- 6+ years of experience as a data architect in large-scale, complex BI environments, with numerous data sources, BI applications, and thousands of users
- 4+ years of experience with ERwin Data Modeler or similar tools
- 4+ years of hands-on experience with large-scale data warehousing MPP platforms such as Netezza and/or Teradata
- Experience with ELT (Extract-Load-Transform) data integration methodology
- Familiarity with BI tools such as MicroStrategy and/or Tableau
39
Data Architect Resume Examples & Samples
- Build a data governance approach across our Institutional finance
- Establish data/information capabilities and services within Enterprise Architecture
- Set appropriate standards, guidelines, and frameworks for enabling agility, stability, and value
- Provide expertise on specific project initiatives to guide and assist with high-level data modelling design
- In-depth practical understanding of data modelling and design, including data flow mapping, canonical formats, lineage tracking, data quality assurance, modelling from heterogeneous sources (experience with Data Vault modelling desirable)
- Extensive experience with established and emerging data technologies including practical experience with data warehouses, RDMS, NoSQL/NewSQL and related technologies
- Experience with establishing data governance desirable
- Experience with institutional financial data models (trading, settlements and risk management) desirable
40
Data Architect Resume Examples & Samples
- Lead, participate in gathering business requirements, analysis of source systems, define underlying data sources and transformation requirements, design suitable data model, and develop metadata for the Data Warehouse/Analytical Reporting
- Work with architect peers at Universal Parks and at NBCUniversal to develop and leverage appropriate data/information architecture strategies that enable business goals
- Work effectively with Technology Operations/Infrastructure teams to ensure a seamless transition of the completed data architect solution to the final data platform for its continued operations and maintenance
- Develop Entity-Relationship / Dimensional Data Models for relevant projects
- Document data management processes and mentor other IT staff to develop data analysis and data modeling skills
- Develop and ensure compliance with data modeling, data Integration , Business Intelligence, Data Quality standards, Master Data , managing the enterprise data model and managing all metadata in the current data warehouse environment
- Strong knowledge of systems development and project management Agile methodologies/processes
- Experience with one or more relational databases such as DB2, Teradata, SQL Server etc.and NOSQL databases
- Familiarity with ETL/Data Quality tools such as IBM’s Data Stage/Quality Stage, Informatica Power Center etc
- Familiarity with reporting/ad-hoc analysis tools such as MicroStrategy, Cognos, Business Objects, Tableau etc
- Familiarity with one or more statistical modeling tools by SPSS or SAS etc
- Must be able to utilize and effectively communicate functional and technical components of an initiative to applicable parties both verbally and through documentation
- A plus includes previous experience with DBA activities including high performance physical database design & performance tuning
41
Data Architect Resume Examples & Samples
- Defines the data and process architectures for major areas of development. This includes an assessment of the current environment, a roadmap for future development, the impact of the development and the rationale for key decisions
- Communicates detailed technical information in both written and verbal form across a wide range of audiences, including business stakeholders, users, developers, project management, and other architects
- Collaborates with colleagues, customers, vendors, and other parties to understand and develop architectural solutions across the enterprise
- Leads and/or facilitates the development of appropriate standards and best practices, in addition to the paths by which they may be achieved and monitored
- Develops a sound understanding of existing systems and processes, their strengths and limitations, and the current and future needs of the environment in which they exist. Provides vision on how they may be improved and developed
- Understands and explains the interactions between systems, applications, and services within the environment, and evaluate the impact of changes or additions to the environment
- Participates in the evaluation and/or selection of solutions or products, including requirements definition, vendor and product evaluations, testing and benchmarking
- Acts as a local expert for areas of domain expertise
- Presents proposed technologies and processes for peer review and critique, providing rationale and explanation of decisions and assumptions, and accepting suggestions and improvements
- Leads a technical team in the delivery of key projects or components when necessary, providing task definition, quality review, and accurate representation of project status
- Bachelor's degree in Computer Science, Engineering, or related discipline with an IT or similar focus
- At least 10 years of experience in design, specification, deployment, and maintenance of large systems, preferably across multiple business functions
- Demonstrated competency developing efficient, effective solutions to diverse, complex problems
- Demonstrated competency in strategic thinking, communication, and leadership
- Demonstrated experience in designing systems and/or processes, including written specifications and documentation
- Excellent written and verbal communication skills; able to communicate effectively across all levels of the organization; able to communicate ideas precisely and accurately
- Able to form and express reasoned opinions; able to communicate and collaborate with others to reach consensus or compromise when necessary
- Able to define a vision and set realistic goals toward achieving it
- Comfortable with ambiguity - able to define alternatives to progress toward vision
- Able to resolve the theoretical with the practical and to balance cultural and maturity-level reality against vision
- Able to use computer for extended period of time
- ECommerce, retail and/or catalog business experience a plus
- Demonstrated experience in several of the following skills/experiences is necessary
- Modeling of complex entities and services
- Creation and review of non-trivial data and process specifications
- Content classification (canonicalization, taxonomies, organization)
- Content and/or Document Management
- Web Information Architecture, including REST architectural principles, RDF
- Creation of data validation and maintenance processes (interactive and batch)
- Object-oriented design and development (Java, C++, etc.)
- Internet technologies (TCP/IP, HTTP, HTML, CSS, XML, SMTP, JavaScript)
- ECommerce applications and/or support services
- Retail/Catalog systems
- Database storage and interaction (SQL, Oracle, JDBC, "no-SQL" alternatives)
- Working knowledge of security and cryptography (PKI, Hashing, SSL, Encryption)
- Data manipulation/automation (scripting/filtering, ETL, XSLT)
- Scripting and automation languages and support tools (sh, perl, python, awk, sed, ssh, etc.)
- Communication protocol implementation and design (SMTP, HTTP, Telnet)
- Digital imaging and image processing (file formats, batch processing, color
42
Data Architect Resume Examples & Samples
- Create conceptual, logical and physical data models
- Meet with business stakeholders to gather and analyze requirements
- Meet with Information Systems (IS) stakeholders to understand and
- Bachelor’s or Master’s degree in Computer Science or Computer Information Systems
- At least 5 years work experience in data modeling and integration, preferably in financial services
- At least 3 years work experience in data warehousing projects using IBM DB2, Oracle, or
43
Data Architect Resume Examples & Samples
- Participate in project scope definition, data architecture development and project planning in coordination with other members of the Data warehouse team
- Create design pattern templates for deliverable objects
- Define and implement ETL development standards and procedures and provide leadership and mentoring to less senior data warehouse developers
- Provide on-going support of existing warehouse as well as continually re-evaluate current processes and techniques for increased efficiency and maintainability
- Ensure completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
- Clear understanding of data models for implementing data warehouse projects using ETL tools
- Define and implement ETL tool configuration
- Maintain an awareness of existing, new and emerging data warehousing technologies
- Provide detailed estimates of time for software development efforts
- Ensure ETL quality through reviews and knowledge sharing. Ensure effective ETL functional decomposition into deliverable objects
44
Data Architect Resume Examples & Samples
- Successful track-record in leading and implementing large projects
- Hands-on data warehouse architect experience
- Demonstrable leadership skills
- 7+ years of financial industry experience designing and implementing DW/BI solutions
- Experience with ETL tools, including Informatica PowerCenter and Business Intelligence tools
- Experience in Commercial Lending products such as loans and guarantees, market products such as Derivatives and Fixed Income Securities
- Java, Perl/Shell scripting, FIX protocol, Equities knowledge
45
Data Architect Resume Examples & Samples
- Take ownership of data models of all data science projects in ICSV
- Create and enhance Relational, OLAP and NoSQL data models
- Guide data modeling efforts on storage technologies like HBase, Cassandra, MongoDB, as well as DWH technologies like Teradata, Vertica
- Research and Innovate using emerging open source storage technology stack like Opentsdb, Rocksdb, Druid etc
- Master the enterprise data vocabulary
- Open Source contributions...you may be altering code maintained as an open source project
- BS, MS in Computer Science or equivalent along with hands-on experience in dealing with large data sets and distributed computing in data warehousing and business intelligence systems using Hadoop
- Foundation in systems development: The Data Architect should understand the system development life cycle; software Project Management approaches; and requirements, design, and test techniques
- Depth in Data Modeling and database design across various disciplines like relational Data Modeling, OLAP Data Modeling (ex:- Star Schema) and NoSQL Data Modeling (ex:- HBase, Cassandra etc)
- Breadth in established and emerging Data technologies. In addition to depth in established Data Management and reporting technologies, the Data Architect is either experienced or conversant in emerging tools like Columnar and NoSQL Databases, Predictive Analytics, Data Visualization and Unstructured Data
- Ability to conceive and portray the Big Data picture: When the Data Architect initiates, evaluates and influences projects he/she does from the perspective of the entire organization. The Data Architect maps the systems and interfaces used to manage data, sets standards for Data Management, analyzes current state and conceives desired future state and conceives projects needed to close the gap between current state and future goals
- Ability to astutely operate in the organization: Well respected and influential, able to emphasize methodology, modeling, and governance, technologically and politically neutral, articulate, persuasive, a good salesperson and enthusiastic
46
Data Architect Resume Examples & Samples
- Demonstrated ability to work under tight deadlines
- Strong experience with Data Modeling, SQL, DB2 and Oracle
- Java, Perl/Shell scripting, FIX protocol, and Equities knowledge
47
Data Architect Resume Examples & Samples
- Lead the development and execution of GWT data architecture strategy/target state including principles, best practices and overall integration and centralization approach
- Work with GWT technology teams and solution architecture group to analyze data requirements (functional and non-functional) and provide data architectural designs solutions/reviews for business application and technology initiatives
- Model and design the application data structure, storage, and integration in collaboration with Solution Designers and DBAs for operational systems, web APIs, Data Warehouse and BI analytics
- Acting as an internal consultant on all data architecture related activities while participating in all phases of the project development life cycle
- Develop, maintain, and refine data models (conceptual, logical, and physical)
- Work with the enterprise architecture group in terms of how GBM aligns and integrates with their data capabilities including the Enterprise Data Lake
- Mentoring and coaching other peers and team members on data architecture issues
- Providing suggestions for viable solutions to data management and architecture problems of high complexity
- Advanced knowledge of data architecture principles and best practices
- Advanced knowledge of data modeling in relational, dimensional (Stars), multidimensional (Cubes), and non-structured (BigData) environments
- Advanced knowledge of data integration patterns and procedures (ETL)
- Advanced knowledge of financial services data domains and technology standards: processes, applications, batch vs. real time, etc
- Knowledge of an industry standard financial data model (e.g. FSDM) plus data messaging formats (e.g. xml/fpml ) is an asset
- Advance knowledge of architectures supporting data integration for different data consumption requirements: operational data store, data warehouse, data marts, analytical data stores
- Advanced knowledge of data mastering (MDM) principles (client master, security master, etc)
- Understanding of data governance principles
- Strong advocate for the reusability of architecture and processes by new business initiatives across all areas
48
Data Architect Resume Examples & Samples
- Define right technology that suites our data at rest needs
- Define reusable schemas to represent data on the wire
- Interact with business experts and define conceptual data model
- Understand existing applications, how data is moving between systems and optimize
- Follow industry standard design patterns to define schemas & data models
49
Data Architect Resume Examples & Samples
- Very good knowledge on Oracle performance and tuning and development which includes writing PL SQL, procedures, triggers, functions and packages
- Good knowledge on Sybase performance and tuning and development which includes writing procedures, triggers etc
- Knowledge on any scheduling tool like CA or Autosys
- Good knowledge on Informatica and other ETL tools like Pentaho etc
- Knowledge on any Big Data Technology like Greenplum, Hadoop etc. is desirable
- Should have very good communication skills
50
Data Architect Resume Examples & Samples
- A meticulous approach to work and an eye for detail
- Ability to work in a high energy environment with demanding deadlines
- Able to work well alone as well as within a multidisciplinary team via email as the primary form of communication with the team
- Self-starter and highly motivated, with a demonstrated ability to meet deadlines
51
Data Architect Resume Examples & Samples
- 5+ years of experience working in a Data Architecture role; SQL Database Administration and Development.; 2+ years of experience with JavaScript/Node.js or other scripting tools
- Excellent knowledge of data modeling, master data management and database design from conceptualization to database optimization
- Experience with emerging tools like columnar databases, predictive analytics, data visualization, and unstructured data
- Past experience working in both Windows and Linux operating environments
- Strong analytical skills; ability to document business data requirements in complete, accurate, extensible, and flexible
- Supply Chain and Consumer Goods Retail / Distribution experience
52
Data Architect Resume Examples & Samples
- Work together with our architect/analyst colleagues in BEX and abroad to define and implement data related components for Credit Risk
- Lead design workshops for data related items
- Design and implement the performance and scalability aspects of the data related components
- Expert knowledge in data architecture and data modelling
- Expert in DB technology; Oracle is a must
- Expert level in SQL and PL/SQL
- DWH experience
- Reporting tools experience (e.g. Business Objects, Cognos)
- Data modelling, data modelling tools (e.g. Power Designer)
- Data integrity tools
53
Data Architect Resume Examples & Samples
- Contributing to the overall strategy and roadmap for data architecture for the COO function, capturing the top-down thoughts of the chief data architect and broader CDO function
- Coordinating with senior architects and stakeholders in each area of the COO, including the Group Technology Office (GTO), the Group Data Management Office (GDMO) and other COO functions
- Point of integration and ‘clearing’ for all data architecture work products, ensuring that work done by each area and ensuring projects all “fit together” into a coherent group-wide picture
- Liaison point for data architecture to the various initiatives developing data quality frameworks and governance
- Supporting the development of an enterprise-wide “systems of record” catalogue to capture and maintain the approved data sources and access/distribution mechanisms for all data classes group-wide
- Partnering with the Chief Technology Office (CTO) organization, solution architecture, and engineering to ensure best use of standards for the key data use cases / patterns tech standards
- Supporting the key data control functions (GDMO, CISO, GDP, CSBC) in ensuring a joined up approach to Level 1 and Level 2 data controls and their implementation in GTO
- Supporting the management of the Enterprise Data Taxonomy within the scope of data managed by COO
- Supporting data architecture toll-gates and quality-gates within the emerging Deutsche Bank ‘programme governance framework’ used for investment and execution governance across GTO
- Supporting data architecture toll-gates and quality-gates within the emerging Deutsche Bank ‘software development lifecycle’
- Supporting the overall initiatives of the Chief Data Office, including the data architecture professional framework, training and set-up of communities of practice group-wide spanning the sub-disciplines of data architecture
54
Data Architect Resume Examples & Samples
- Oversee project deliverables thru the whole system development life cycle process and manage the delivery of the project by creating an overall project plan
- Review business requirement documents and collaborate with the business users regarding the project requirements
- Design and develop technical solution to provide business users with functionalities requested
- Write technical specifications for the delivery of the technical solution
- Assign programming specifications to onshore and offshore developers, supervise the delivery of quality program codes and manage the timely delivery of the project
- Conduct code and standard checks, including code review and peer-testing for programming modules developed
- Review, approve and ascertain execution of the test scripts and review test results in development environment prior to promotion of code to QA environment
- Discuss changes and enhancement to QA team and provide support to QA testers in preparation for QA testing
- Educate business users on new functionalities developed and prepare the environment for user acceptance testing
- Manage production implementation of the project
- Conduct post production implementation checkouts to ensure successful delivery of the project to production
- Communicate the system changes and enhancements to the business users and to downstream applications impacted by the change
- At least 7 years of hands-on technical experience in areas of development, design and production support in mainframe technologies
- Strong interpersonal skills, ability to interact and collaborate with business users and downstream application owners
- Ability to work on a fast-paced environment and availability to work on extended hours
55
Data Architect Resume Examples & Samples
- Demonstrates ability to forward & reverse engineer databases to established technical and metadata standards
- Demonstrates ability to translate complex technical terminology, concepts and issues in terms understandable to technical and non-technical management and staff
- Demonstrates strong verbal and written communication skills
- Demonstrates ability to create and maintain conceptual, logical, physical and dimensional models
- Demonstrates strong time management and prioritization skills
- Demonstrates advanced understanding of operational and analytical data architectures; of relational and dimensional theory; and Software Development Life Cycles and development methodologies
- Demonstrates ability to define data management standards and methods
- Demonstrates awareness of DAMA-DMBOK
- Demonstrates awareness of Total Quality Information Management (TQIM) principles and practices
- Demonstrates ETL architecture and development skills
- Demonstrates Oracle / DB2 / SQL Server database design skills
- Demonstrates financial industry knowledge
56
Data Architect Resume Examples & Samples
- Wealth Management Network
- Design, create, and manage Investment Services’ data architecture vision
- Define how data will be stored, consumed, integrated and managed by IT systems and applications using and processing that data
- Work closely with Enterprise Technology Group (ETG) in the design and support of the data platform
- Perform application query tuning, review and feedback
- Recommend database performance tuning, review and feedback working with ETG
- Develop and maintain a data dictionary to support an Enterprise Data Management program. Focus on data quality, accountability and governance
- Support Operations in troubleshooting of upper region issues in application database areas
- Develop change control processes for delivering quality deployments of database objects
- Research, design, and recommend technical solutions
- A minimum of four to six years of experience working with mission critical database systems (like Oracle and SQL Server)
- Logical data modeling and physical database design
- Production application hosting operations support experience
- T-SQL and Stored Procedure performance tuning
- Linux and Microsoft server technologies
- Working knowledge of Oracle and SQL Server
- Working knowledge of TCP/IP and related protocols
- Knowledge of high availability systems design and disaster recovery strategies
- Familiarity with No-SQL database solutions (Geo-distributed, Hadoop, etc) is a plus
57
Data Architect Resume Examples & Samples
- Act as an advisor & recommend actionable data architecture solutions in support of client initiatives
- Define data architecture solutions using Big Data and Data Science
- Define and drive adoption of data management and data modelling processes
- Define data governance including operating models for client data teams and their wider organisation
- Lead technology selection, evaluation, recommendation and configurations
- Lead the data architecture of client engagements, which may include applications, infrastructure and/or database strategies
- Build and maintain effective relationships with client data architects and technical leads
- Provide proactive technical oversight and advise to DBA and development teams fostering re-use, scalability, stability, and operational efficiency of data/analytical solutions
58
Data Architect Resume Examples & Samples
- Understand and translate business requirements into data models, facilitating data modeling sessions with business stakeholders and technical partners. Translate the business and user requirements into system requirements
- Create or update conceptual, logical and physical data models using best practices and company standards. Define, design, and oversee implementation of standards and best practices involved in modeling, describing data entities and relationships
- Recommend opportunities for reuse of data models and data where appropriate. Oversee design of information solutions, ensuring that they align with business and IT strategies, maximize reuse and integrate well with existing solutions
- Generate DDL scripts for deployment to QA and Production environments. Ensure design and construction meet quality standards and that the testing and operational readiness tasks are conducted and produce quality results
- Perform reverse engineering of physical data models from databases and SQL Scripts. Perform software analysis, code analysis, requirements analysis, software review, identification of code metrics, system risk analysis, software reliability analysis
- Bachelor’s degree in appropriate field (Finance, MIS) or two year degree with equivalent experience
- 10+ years' experience of Data Architecture and Data management Services, Data Governance, Data Quality processes and Data Lifecycle, Data Access and Privacy Principles
- 5+ years leadership experience in design and deployment of Data Architecture within a large Enterprise environment, in combination with
- 4+ years of data analysis, modeling and architecture experience
- 4+ years of DDL&DML programming experience
- 2+ years in ERWIN or ERStudio and Visio experience
- Demonstrated Complete System Development Life Cycle experience for large scale complex projects with various industries
- Knowledge of and experience applying data modeling techniques and best practices
- Excellent relationship building skills; ability to interface with a variety of associates
59
Data Architect Resume Examples & Samples
- Lead the Data Services team in implementing best practices for EDW data modeling, design, development, testing, production support, and end user training
- Design and build data integration processes between Nordstrom and NR|HL systems
- Partner with the stakeholders to understand business objectives and requirements
- Work in a highly Agile/Scrum/Kanban environment to support incremental delivery of functionality
- Ensure the quality of all EDW data inputs and outputs
- Act as the gatekeeper to EDW change requests and actively seek to reduce risk and minimize downtime
- Travel occasionally (around once per quarter) to Seattle to participate in integration discussions
- Provide occasional on-call production support of ETL processes after hours
- Minimum 6 years of experience in data warehouse architecture design, logical and physical data and ETL process modeling
- Extensive experience in all phases of Data Warehouse development
- Expert SQL skills
- Experience with various ETL platforms, ideally including Pentaho Data Integration (Kettle)
- Experience with Amazon Redshift or other MPP database platforms
- Experience supporting BI tools
- Must be self-motivated, energetic, detail oriented and a team player
- Superior verbal and written presentation skills are required
- Demonstrate skills to suggest and lead others to think critically in discussions
- Python, Perl, or Java
- Statistical programming (e.g. R, SAS)
- Experience using AWS for data applications (e.g. EC2, S3, Redshift, RDS, Data Pipeline)
- Monitoring tools such as Nagios
60
Data Architect Resume Examples & Samples
- Minimum of 5+ year’s of business requirements analysis and information modeling (logical and physical) of key financial products (Bilateral, OTC & exchange traded, centrally cleared) and concepts (e.g. positions, trades, financing transactions, future flows, collateral/margining) in the securities/financial industry
- Minimum of 5+ years in handling Oracle based Physical Modeling
- Exposure to Big data is a plus
61
Data Architect Resume Examples & Samples
- Maintain our Enterprise Data Model that describes how data sourced, processed, stored, and utilized
- Identify and recommend appropriate techniques / tools for data acquisition and retention
- Develop innovative data management solutions
- Define our data governance strategy
62
Data Architect Resume Examples & Samples
- Experience with Database Administration for MongoDB, Postgres, and MSSQL
- Experience in performance tuning and optimization
- Experience with Data modeling and data flow design
- Knowledge of HA and DR options for MongoDB, Postgres, and MSSQL
- Knowledge of indexes, index management, and statistics
63
Data Architect Resume Examples & Samples
- Coordinate of Information Architecture activities across relevant Technology teams
- Integration of Data Modelling output across the Technology Organization
- Ensure alignment of Controlled Vocabulary, Logical Data Modelling and physical data modelling activities
- Establish processes for continual integration of metadata and joining it with existing BAU processes within Technology
- Implement progress and quality assessment measures for metadata
- Maintain close alignment and integration with Firmwide Chief Data Office models, processes and standards
- Oversight for the appropriate training and support of individuals and teams in their understanding Information Architecture responsibilities
- Hands-on leadership experience in introducing and managing governance and new operational processes for metadata in a complex environment
- Prior experience and familiarity with methodologies and tools (e.g. Logical Data modelling, UML, MagicDraw, RDF)
- Proven ability to lead, influence, and drive decision making in a federated, multi-stakeholder environment
- Excellent communication skills, and experienced in presenting to senior audiences that include technical and non-technical members
- B.S./B.A. required; MBA or equivalent is desirable
64
Data Architect Resume Examples & Samples
- Maintains a comprehensive view of current information assets, program/project architecture, and future information needs while delivering data effectively and efficiently across projects and programs
- Gathers information for planning and design of new or upgraded systems
- Aids the evolution of enterprise product and system roadmaps
- Collaborates with departments to implement improvements in processes and with cross-organizational teams to determine Business Support System/Operations Support System support for business requirements
- 1-2 years writing SQL queries
- 1-2 years' experience with an ETL tool (preferably Informatica or SSIS)
- Experience writing stored procedures
- Understanding of data modeling and data warehouse concepts
- Experience with Teradata or SQL Server is preferred
65
Data Architect Resume Examples & Samples
- Create and maintain the Enterprise Data Model at the Logical and Physical Level
- Steward of Enterprise Data Lifecycle Management including data storage, data retention, backup/recovery and data security technologies
- Manage data design standards, master data and metadata management
- Manage data governance by bringing together stakeholders and driving data quality
- Leads strategy & architecture for Data Management
- Champion & drive data architecture solutions from conception to implementation
- Participation in ARF architecture reviews
- Master's degree in CS/EE or equivalent experience, 7 ~10 years of Data Architect / Modeling experience
- Demonstrated experience in design and implementation of an enterprise data model, metadata solution and data life cycle management in both RDBMS, Big Data environments
- Excellent understanding Oracle technologies and related products, strong experience using Oracle 11g, 12C RAC, ADG, Data Partition
- Good knowledge of data modeling tools like ER Studio/ERwin
- Expertise in information and integration architecture and technologies
- Domain knowledge of eCommernce, Data Warehousing, Financial, Account system
66
Data Architect Resume Examples & Samples
- Implement data models, database designs, data access and table maintenance codes
- Resolve database performance issues, database capacity issues, replication and other data issues
- Work with other Information Architects and Database Designers to implement the physical data model
- Develop the database performance monitoring process and analyze data for optimization opportunities
- Work with business users and other systems up/downstream to gather and define data requirements
- Conduct data analysis
- Design and architect data modeling
- Leverage tools to view and classify complex data
- Program in SQL to support business enhancements to the WebServices middle tier
- Write complex SQL queries to provide critical business analysis and reporting
- Participate in build of strategic data processing platform by developing semantic models, tracing complex data lineage and loading data into metadata repository
- Develop and use reporting and analytic tools to gain insight into complex data
- Design and Code ETL solutions to combine data from multiple sources
- Minimum 7 years of work experience as a Data Architect/Analysis
- Expert level SQL query and stored procedure development experience (DB2 preferred)
- 7+ years SQL programming and implementing relational database models (DB2 preferred)
- Experience working with ETL tools, data mapping, like Informatica, Ab Initio
- At least 3 years ETL experience
- Experience with data architecture, data management and/or database administration a must
- Experience with vendor reporting products such Ab Initio, Cognos is useful
67
Data Architect Resume Examples & Samples
- Support database design requests in DB2, Teradata, Oracle, AS400 or SQL Server
- Manage the Ford Credit Database changes using the DBCR system
- Develop Data Definition Language (DDL) to implement and maintain database structures Migrate
- Develop conceptual, logical & physical data models
- Perform impact analysis on data structure changes
- Define and enforce database standards including SPII & data compliance
- Review SQL for potential performance improvements
- Developing new data structures in online transaction (OLTP) or data warehouse (OLAP) database
- Experience with managing the Database changes
- Able to multi-task and be flexible to respond to changing priorities
- Excellent interpersonal skills to succeed with internal and external teams and business customers
- Effective verbal and written communication and presentation skills
- Ability to work closely with application developers to ensure business goals succeed
- Must demonstrate good judgment and pragmatic approach to delivering a solution that optimizes architecture activities across company needs, considering business constraints and technological realities
68
Data Architect Resume Examples & Samples
- Provide IT cost modeling support
- Develop whitepapers and briefings
- Demonstrate problem solving skills
- Working in small teams
- Mandatory 1 year minimum experience designing, developing, and building cost models or providing information management support
- Mandatory B.S./B.A. degree, or higher, in Mathematics, Statistics, Accounting, Finance, or a related field
- Proficiency in MS Excel, Word, and PowerPoint
- Ability to work independently under tight deadlines with changing priorities
- ABC Methodologies
- SAS ABM Experience
- Information/Data Management
- Business Process Mapping
- Executive Reporting
69
Data Architect Resume Examples & Samples
- 10+ years of relevant technology architecture consulting or industry experience
- 3+ years industry experience within any of the following industries, Banking, Insurance
- Proficient with one or more of procedural database language, building functions, procedures, triggers, database types in DB2 on Mainframe
- TOGAF 9 Foundation
- Solution architecture expertise
- Quality assurance methods
- Test management methods and tools
- Demand and capacity planning
- Estimation methods
- Development of statements of work and/or client proposals
- Experience with program leadership, governance and change enablement
- Lead workshops for client
- Ability to scope out the effort and cost for an enterprise reporting solution
- Ability to define how an enterprise information system will align with the organization’s business and strategic objectives
- Ability to manage multiple teams on a data warehousing engagement and not only
- Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint, etc.) and consulting skills
- An advanced degree in the area of specialization is preferred
- Experience in leading, coordinating, managing teams formed of more than 5 persons and the ability to lead, coordinate, manage teams formed of up to 15 persons
70
Data Architect Resume Examples & Samples
- Understands business requirements and translates into technical solutions
- Applies technical knowledge of technology and industry trends to develop, implement and maintain complex data solutions
- Leads the resolution of complex data problems for large/complex projects
- Elicit review, and validate data requirements, including: Data integration (ETL, EAI, and web services), Meta data, Modelling (Conceptual, Logical, and Physical), Data delivery, and Business intelligence. Participate in research and method selection for solutions, being actively involved in design meetings with stakeholders
- Designs and builds the data architecture and data integration layers
- Leads in data quality analysis / data profiling, to produce a data quality assessment (and baseline)
- Respond to ad hoc analysis requests for data and analytics needed by senior management
- Bachelor's degree in Data Base Management/Systems Engineering or related Engineering. Specialization, Masters or PhD level degree is desirable. Additional formal studies will be a plus
- SSIS (SQL Integrating Services) / SQL / PL SQL language, MS SQL Server, Windows Server and Unix/Linux Operating Systems, Programming Languages (Minimum of 3 to 5 years of related work experience)
- Experience working on Service Operations with a high customer orientation is strongly preferred
- Ability to effectively communicate design proposals and architectures, and negotiate options at senior leadership levels
- Expert knowledge and experience with data modeling, data warehousing, dimensional modeling, big data solutions and ETL development
- Solid track record of transforming concepts and requirements into workable products and solutions is a must
- Expert knowledge of software development life-cycles with its principles, practices, strategies and tactics
- Excellent project management skills and ability to execute on multiple projects simultaneously
- Familiarity with the “Knowledge Hierarchy” / “Data, Information, Knowledge, Wisdom pyramid”
- Data literacy: Finding and managing data, cleansing data, appropriately address extremes, outliers, etc., manipulating data
- Mathematical reasoning; Competent in the interpretation of numeric data, understand and/or practice statistical principles
- Advanced verbal and written communication skills for writing reports/proposals and making presentations, in particular the ability to clearly and effectively communicate technical results to a non-technical business audience
- Ability to work independently under a fast-paced environment, comfortable to deliver results under pressure
- Strong work ethics and collaborative attitude
- Self/starter Innovative thinker with analytical/problem solving skills
71
Data Architect Resume Examples & Samples
- 5+ Years Data Architecture/Modeling Experience using Erwin, PowerDesigner, or ER/Studio
- 3+ Years Data Profiling and Analysis Experience using Informatica or similar data profiling tool
- 3+ Years Information Integration Experience using leading ETL and/or Data Virtualization tool(s)
- 3+ Years of Experience with Collecting and Analyzing Business Requirements and Process Designs
- Influences others without authority
- Communicates in professional context
- Navigates large organizational landscapes
- Presents ideas and concepts effectively
- Partners closely with stakeholders and peers
- Demonstrates a sincere sense of urgency
- Understands the “big picture” and constituent parts
- Collaborates effectively with others
- Information Architecture
- Data Virtualization/Abstraction/Federation
- Data Governance & Standards
- Data Cleansing
- Cisco Information Server (aka Composite)
- EA Sparks
- ArchiMate
72
Data Architect Resume Examples & Samples
- Provide analysis, design, training, maintenance, tuning, documentation, and implementation of enterprise class logical data models and physical database objects
- Successful completion of a full 4-year course of study in an accredited college or university leading to a bachelor's or higher degree in computer science or equivalent with two to four years in a senior database analyst or architect position; OR appropriate combination of education and experience
- Must have the ability to manage multiple projects and requests at one time
- Experience with Healthcare Data Warehousing
73
Data Architect Resume Examples & Samples
- 10+ years’ experience in designing high performing and scalable data models
- 1+ years of experience in Financial Services industry
- 1+ years of experience in understanding mainframe technologies
74
Data Architect Resume Examples & Samples
- Design and develop a distributed data processing platform using Big Data technologies
- Provide ongoing maintenance, support and enhancements in existing systems and platforms
- Collaborate with product managers, data scientists, business users and other engineers to define requirements and design solutions
- Influence the team by providing recommendations for continuous improvement
- Mentor other engineers in the team regarding technology and best practices
- 10+ years of hands-on experience working with software development and enterprise data warehouse solutions
- 4+ years of hands-on experience developing a distributed data processing platform with Big Data technologies like Hadoop, Hive, Pig, Oozie, Map Reduce, Spark, Shark, Kafka, Flume, etc
- Experience with commercial ETL platforms like Informatica, SSIS, Talend, etc
- Experience working with, processing and managing large data sets (multi TB scale)
- Experience with test driven development and automated testing frameworks
- Capable of delivering on multiple competing priorities with little supervision
75
Data Architect Resume Examples & Samples
- Lead in the analysis and development of logical and physical data models
- Understand and communicate how data models can be used to support, interact and integrate with other information systems
- Oversee, direct and/or provide consultation on implementation of data management technologies and platforms
- Lead t