- Featured in:
-
More Data Architect Resumes
Use these Data Architect samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Architecture Resume Samples
Data Architect Resume Samples
No results found
6-10 years of experience
Managed and successfully developed Aptare’s Flagship Products – Capacity Manager, Backup Manager and File Analytics. Worked directly with Vice President of Products to recognize and identify potential areas for future business expansion. Owned roadmap and product-managed 6 releases of new product over 2 years – working with 3 scrum teams of 25 engineers spread across 3 global locations.
- Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
- Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
- Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
- Aggressively managed personnel across product development organization. Hired over 10 high-caliber individuals who delivered department objectives and helped exceed sales targets.
- Spent 20% of time in supporting customers in Americas and EMEA and training Aptare’s client services personnel which produced enhanced business results by focusing on delivering great customer satisfaction.
0-5 years of experience
This project is to implement a Data Warehouse and Data Mart for Global Signaling as a method to manage, utilize and optimize the transactional data created and stored on the ERP system (JD Edwards).
- Created and implemented the GS DW schema from the GS IBM AS400 production database and configuration of DB2 and informatica with repository creation.
- Applied transformation, mapplets and performed transaction control transformation in mapping.
- Provided Architectural design for engineering data unit and launched an ETL application for converting legacy data structures and mapping them to Oracle table structures for ECR/ECO, eCIS and eMIR application.
- Created the SOA architect for the work flow management web portals like ECR/ECO, eCIS and eMIR and integrated among the applications using the shared database.
- Created the mapping, extracting and translation from JDE to Oracle for the engineering data.
- Implemented Multi Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows, stored procedure.
0-5 years of experience
Held leadership responsibility and created strategic roadmap for data warehouse and BI initiatives visible at C-level for various [company name] real estate business entities. Collaborated with business and technology partners to provide enterprise data & BI solutions for various [company name] real estate business entities
- Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques. Mobilized and directed BI professionals and offshore development team of 30+.
- Generated 80%+ performance gain for enterprise BI systems and by strengthening OLAP database systems.
- Instituted end-to-end technical guidance and end state roadmaps for Sales & Marketing, Correspondence Analytics & Servicing and Broker and Correspondence data marts.
- Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps and blue prints and project plans.
- Formulated and executed corporate roadmaps to ensure compliance with SOX and corporate governance criteria.
- As member of executive Change Control Board, developed and refined repeatable framework/processes. Consolidated BI reporting technologies to increase project/program value proposition.
- Saved $1.7 million annually by consolidating servers/databases and leveraging enterprise licensing agreements.
0-5 years of experience
On-site Data Management technical lead for all Global Transportation Network (GTN) logical and physical data modeling efforts.
- Developed, tested and version controlled physical database changes (DDL) approved by the CCB for all GTN application system databases.
- Represented GTN Data Architecture team at Configuration Control Board (CCB) meetings.
- Integrated GTN database changes/updates into the GTN Enterprise Logical Data Model (ELDM).
- Designed and implemented a data transaction replication solution to move data transactions from an Oracle database to Sybase using Sybase stored procedure (T-SQL) coding (Global Command Control System (GCCS) to GTN). Replication solution was designed to be Defense Information Infrastructure Common Operating Environment (DIICOE) compliant.
- Managed status reporting, project planning, and time card approval for the onsite SAIC project team (3 employees).
0-5 years of experience
Managed, designed and implemented managed assets application projects utilizing ERwin and IBM Data Architect.
- Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
- Enforced naming standards and data dictionary for data models.
- Developed data migration and data validation PL/SQL scripts from old system to new system.
- Performed SQL Query performance analysis using Toad Client software for Oracle / DB2 / SQL Server.
0-5 years of experience
Served as backup DBA for 1500 databases across 25 production servers containing 50TB
- Created complex T-SQL stored procedures to manipulate data in real time in large, highly transactional
- Worked with programmers and project managers to create data models for new features
- Created and optimized indexes and queries to ensure peak performance at all times
- Designed, developed, and maintained all person matching logic using any data available
- Designed, developed, and maintained an internal data warehouse to allow cross database data sharing
- Designed, developed, and maintained a bulk processing backend which allowed clients to update live
0-5 years of experience
- Wrote logical and physical database descriptions including location, space, access
- Accelerated online order processing by creating a central database.
- Analyzed loopholes in the ordering process and addressed the fixes that led to to 40% less lost sales.
- Promoted from Data Entry clerk to Data Analyst after 45 days at work.
0-5 years of experience
Directly responsible for driving Logical and Physical Data Model deliverables while managing deployment of production, development and validation environments for Healthcare Master Data Management system.
- Accurately documented ETL strategy, then captured and documented detailed design specifications for the ETL process.
- Provided valuable input into project plans and schedules, translating business requirements into conceptual, logical and physical data models.
- Delivered regular status updates to project manager and technical manager; consistently completed project elements on time, adhering to all strict project requirements.
- Environment:DB2, Erwin, Data Studio, IBM Initiate, IBM mainframe, Oracle, Unix.
0-5 years of experience
Developed data-related standards and best practices for data modeling processes, procedures and standards guide.
- Lead Data Warehouse development team to implement Workers’ Compensation data mart and Cognos cube utilizing Business Analysis Studio within a 6 month time frame.
- Designed and Implemented a Workers Compensation Data Warehouse Turnaround Time evaluation and reporting system for external clients consistting of 5 fact tables, 1 datamart and 2 key reports.
- Improved external client reporting production response time from 48 – 52 hours to 45 – 55 seconds.
- 1 of 20 Delegates to Coventry’s IT 30 Month Planning Congress 2010. Presented ideas and innovative solutions to CIO and direct reports based on surveying employees and interviewing the business representatives.
0-5 years of experience
Designed, developed, tested, implemented and production supported CDW (Corporate Data Warehouse) ETLs in C, Pro-C, SQL, SQL PL and SAS on Unix (AIX) and Mainframe platforms utilizing DB2 UDB and DataStage.
- Managed investigation and resolution of production issues utilizing ClearCase, ClearQuest, Remedy and Vantive.
- Executed performance analysis and implemented performance improvements in main ETL processes including SQL tuning using DBstat.
- Performed data and process modeling using ERWIN.
- As a part of Data Quality effort performed large volume data conversion, data analysis, data cleansing and production report generation for a number of Data Marts and Operational Data Stores within CDW.
- Set up and maintained Autosys job scheduling.
0-5 years of experience
The Growth Operation Strategy (G0S) project implemented Salesforce.com as a tool to supports Marketing, Sales and Customer service personnel, providing access to real time data through a wide range of Cloud based applications. The Responsibilities involved designing Integrated Data Hub and Performance tuning.
- Interacted with the business analysts on regular basis to consolidate and analyze the data requirements and information gaps and outlined the diverse steps needed to build an integrated data system.
- Designed and implemented data integration and data warehousing solution for GOS (Growth Operation Strategy). This involved analysis of 360 degree view of the customer, broker information and inforce product information.
- Worked with Infrastructure team to set up a Layer 7 end point to interact with the Cloud system thru on-premise Informaica services for the data integration.
- Successfully implemented Test-driven development in agile methodology.
- Established best practices for data load from Integrated Data Hub to Salesforce on daily basis. This includes creating the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation.
- Provided development status reports to management.
- Helped team to resolve critical show-stopper production deployment issue.
0-5 years of experience
- Designed an operational data store, integrating 100% policy and claim data and enabling the planned merger of Japanese AIG subsidiaries.
- Developed solution architecture for the customer relation management capability of the new company, reducing delay in data availability by 75% and increasing data availability by 100%.
- Coordinated efforts of a 10-member data mapping team and acted as a bridge between the Global Data Management team in Ireland and Data Analyst team in Japan, ensuring milestones were met for the data integration project.
- Identified key differences in accounting practices and estimated remediation effort to Finance system, leading to planning of a $110MM financial transformation project.
0-5 years of experience
Involved in planning, architecture, and implementation in PMO office of multiple projects of BCBSMA in support of Affordable Care Act (ACA).
- Designed Conceptual Architecture and Dataflow for Connector Projects involving 834, 820 enrolment and payment files, tax credits, and reconciliation. Involved in identifying MDM domains, consolidating plans and integrating with existing DWH.
- Developed data mapping and dataflow for ACA-Reinsurance involving data extracts from DWH developed on Netezza platform.
- Designed Conceptual Architecture for small business involving real time quotes and Web Services.
0-5 years of experience
Instrumental in designing and implementing Order Capture data model. The data model needed to confer with Oracle ERP at application level.
- Designed developed and implemented ETL to move the transaction data from JD Edwards + Siebel to Oracle 10g database.
- Involved in object oriented design and development of Oracle technologies such as packages, stored procedures using TYPEs and TYPEs of TYPE.
- Designed and developed application level Audit feature to handle audit trial.
- Instrumental in getting out data dictionary and application documentation.
- Designed and developed performance evaluation report and fine-tuned the application queries based on the business need.
- Attended training on TOAD from QUEST Software on tips, tricks and best practice.
0-5 years of experience
Designed, modeled and maintained BNA publishing system logical and physical models.
- Responsible for migration of data out of STAR system to oracle database. Designed the logical and physical data models, provided data flow diagrams, transformation logic, source to target data mapping spreadsheets, data dictionary etc.
- Actively involved in redesigning regulation central application database.
- Worked on various applications at BNA and provides enterprise data solutions.
- Worked closely with data analysts, DBA’s and application developers.
- Created sequences, Triggers, index’s, constraints and views as part of physical data model using ER-Win and provided model change ER-Win scripts.
0-5 years of experience
Build Conceptual/Logical data model part of core business/functional team in coordination with business analyst, application owner, db design team.
- Involved in data modeling delivery, Data model domains, naming standards, Creating Model reports, Change management.
- UT Control Logical Data Model Span through multiple instrument class, retrieved data from trading applications, utilized by numbers of IT Technical teams to design PHYSICAL DATA MODELS
- Architected Data Quality LDM, resulted into high quality data; DQ model implementation recognized through-out the department, span into DQ initiative.
- Participated in interview with trading groups facilitator to gather requirements, acquire system flows, rectify issues come out of clients, supervisory reports.
- Updated design document with revised requirements.
- Participated in routine initiative review meeting with the stake holders, program managements, apprise the stakeholders with architecture.
- Data architecture Investment Bank FRONT OFFICE Risk & Control, Initiative involved building UT (unauthorized trading) Control to mitigate trading compliance risk.
0-5 years of experience
Spearheaded effort to replicate all Lazard databases to new Disaster Recovery Center in Chicago, Illinois, using MSA Replication and Subscription based replication, as well as MS-SQL Mirroring.
- Created new Sybase and MS-SQL Disaster Recovery Servers in Chicago, documented the same, and setup Autosys jobs to automatically re-synch and/or failover the databases.
- Planned and coordinated failover test where all Lazard applications connected to failover databases in Chicago Datacenter and New York systems were made to be inaccessible.
- Upgraded Sybase servers from v12.5.4 to v15.5. Coordinated pre-upgrade test procedures in development as well as debugging post upgrade performance issues.
- Analyzed problem queries using showplan to determine cause of query issues. Counseled developers on best practices for multi-table joins, search arguments, and proper indexing to resolve query issues.
- Migrated several Sybase IQ 12.7 servers to Sybase IQ 15.3. Created Autosys jobs to run 8TB IQ backup on weekends and load the backup to Chicago DR Server.
- Created scripts to compare Primary NY Databases with Chicago DR Databases and check object matching, row counts, currency of replication, and login synchronization.
0-5 years of experience
Hired as part of an organizational re-structuring initiative to design and implement the Data Architecture piece of the Strategy and Architecture team.
- Recently completed a project to upgrade the corporate intranet to SharePoint 2010 as Lead Architect and Scrum Master.
- Provided guidance and solution concepts for multiple projects focused on data governance and master data management.
- Participated in strategic planning process to align application portfolio to business capability objectives.
0-5 years of experience
Serviced contract under high security clearance for The Department of Homeland Security, Federal Law Enforcement Training Center
- Facilitated enterprise architecture efforts that analyze areas of common activity within an organization to guide future states from an integrated viewpoint of strategy, business and technology
- Developed presentations to communicate project status and recommendations
- Collaborated effectively with stakeholders, SME’s, and other key personnel necessary for data gathering, process mapping, business modeling, and team consensus
- Performed gap analysis
0-5 years of experience
Oracle 10G, Trillium & Siperion MDM, ERwin environment with Agile project implementation methodology
- Set enterprise data governance, modeling and object naming standards.
- Responsible for creating an enterprise logical data model for Party, Product & Services using ERwin
- Identify data integration opportunities and propose solutions, such as offer new way to track the services offered from multiple standards with over 20,000 service codes into one set of enterprise service code structure with a few thousand service codes to improve usability and provide much more detailed & accurate data analysis for service offered and revenue earned which could never be done previously.
- Assisted a Master Data Management project implementation such as, choosing a MDM tool, creating a physical data model to support the need of Siperian.
0-5 years of experience
- Developed corporate standards and procedures for business processes, IT development procedures, naming conventions, master data management and master data governance. Identified data patterns and implemented corporate data standards to conform with international data ISO, ANSI and ASC X12 when appropriate
- Reverse engineered corporate data models to create logical and physical database models.
- Managed project for eDiscovery of personally identifiable information to assess risk and identify possible candidates for archival and removal.
- Project manager for Team foundation version control and Sharepoint implementations.
- Architected and implemented SOA projects for EDI of Business to Business (B2B) and Business to Customer (B2C) data communications.
0-5 years of experience
In a telecom environment designed logical data model from business requirements and converted logical model to physical model using ER/Studio.
- Designed and Created databases, tables, and views. Developed data migration and data load scripts for moving data from various sources such as flat files, Excel files, legacy systems and loading into an Oracle 11g Db.
- Built data marts for transactional data for all subject areas.
- Assisted with performance tuning of application queries and SQL.
0-5 years of experience
Developed an Integrated Data Hub design using Master Data Management principals.
- Created a centralized Information Data Model using ERWIN.
- Created a centralized Data Dictionary design and reviewed possible Data Warehouse models.
- Provided in-depth knowledge of business areas; defining business needs, test requirements, software functionality, training, knowledge share and architectural design of systems.
0-5 years of experience
Responsible for providing database and data warehouse expertise and consulting, design and programming of custom ETL tools, data migration and aggregation strategies for data warehousing and reporting, managing a design team and project scheduling.
- Designed and implemented multidimensional data warehouses, data modeling of various databases, plan and implement ETL based data aggregation, creation of production reporting and portals, writing SQL based and OLAP reports, rovided database, system and network administration, wrote various .NET and Java applications, managed team of programmers, query optimization and database tuning.
- Requirements gathering and documenting. Planning and Project Management
- Database replication, database mirroring, failover, ETL, replication and database modeling tools. Query optimization and database tuning Oracle 10G
- Dataguard, Streams, PostgreSQL, PL\SQL, MDX, data Cube, dimensional modeling, SQL Server 2005
- Transactional Replication, Mirroring, T-SQL SSIS(ETL), Reporting Services. IBM DB2, Modeling – ERStudio, ERWin, PowerDesigner. Cognos
- PowerPlay, Impromptu .NET, ASP.NET, C#, Java, Multiple proprietary ESBs. MDM, Informatica. Ascential, Pervasive, EDI, EAI.
0-5 years of experience
Architected the DW and ETL solutions for norms generation. Legacy norms ETL process (using SAS) was taking approx 20 days and the new system taking only 4 days to load.
- Architected the Nebula EDW with all carriers’ data in one oracle schema and structured the platform for cross carrier analytics like norms, standards and regional disease analysis.
- Created Business process, Conceptual, Logical and Physical data models for Nebula and Parallax-I models.
- Designed data flow diagrams (DFD) and reviewed high level and low level design documents for ETL process.
- Designed effective solutions for data cleansing, exceptions handling and normalizing the data.
0-5 years of experience
As a data architect and data modeler documented and enhanced CRM BI data model.
- Created stored procedures for CRM datastore data profiling.
- As a data architect performed data modeling and data migration for financial investment CRM data repository.
- As a data architect performed requirements analysis, logical and physical data modeling for enterprise data warehouse while complying with corporate standards.
- Maintained data dictionaries and integration of systems through database design
- Supported and mentored development project teams.
- Projects included fraud management, benchmarking and infrastructure management applications.
0-5 years of experience
Assessed application requirements for data streams and documented as user stories. Developed ETL strategy and design for bringing product data in from Teradata and DB2 to SQL Server using IBM DataStage for a large grocery online service.
- Coordinated data requirements between application team, DB2 Data Architect, Teradata Architect, and SQL Server DBA to ensure data will meet application schema and accuracy requirements.
- Architected SQL Server database for a large grocery online service.
- Managed agile project including development story point estimations, Sprint schedule, Release Planning. Brought projects to finish early and under budget with additional work included.
0-5 years of experience
Designed Conceptual, Logical and Physical models based on enterprise reference models or from scratch
- Worked with data stewards to gather business requirements and develop data models for Data Warehouses.
- Applied continuous improvement to keep process structured, manageable and repeatable for metadata as a member of the Data Governance focus group.
- Integral member of team involved in data integration projects using Agile methodology to transfer data.
- Converted the Data Warehouse models to comply with modeling and metadata standards by reverse engineering from databases.
- Analyzed and enhanced standards and process of data modeling, metadata and reference data.
10+ years of experience
- Developed data models and source-to-target mappings for integration of BP and Amoco data
- Designed Star Schema Data Models for chemical logistics business area
- Designed and implemented gas measurement database using ERwin to stay well under budget
- Worked with intercompany team to design Drilling and Production modules for PPDM
- Advised vendor on data model intricacies for Drilling Information Management System (DIMS)
0-5 years of experience
Performed the role of Data Architect on the Business Intelligence -Data Warehousing team in Onstar.
- Designed logical and physical data models using Erwin. Created DDLs for new and modified database objects.
- Primarily responsible for Gen10 project, while supporting other major and several minor releases concurrently.
- Created SQL scripts performing complex queries, data validations, load testing and data quality analysis.
- Designed Data Marts to support business intelligence applications, and Data Warehouse structures for high-volume data capture, scalability, load performance and manageability.
- Supported daily operations for sustain and enhancements through trouble-shooting and performance tuning, ensuring high availability for very large Oracle databases, ETL processes and complex SQL queries.
- Supported real-time data integration into Operational data Store (ODS), change data capture, data replication and load-balancing processes that used Oracle GoldenGate 11g. Resolved issues causing lags or abends.
- Developed Project Planning techniques and strategies for effective Test Management in very dynamic, fast-paced environment where multiple projects and programs ran concurrently demanding massive changes to the DWHS.
- Collaborated effectively with system architects, business analysts and ETL developers.
- Created and enforced architectural guidelines, database development standards and best practices.
0-5 years of experience
Worked closely with the client and the business requirements team to develop the data requirements specifications for the Data Warehouse schemas and business reports
- Developed logical and physical data models for the Data Warehouse.
- Developed reporting data models (Cognos Framework manager).
- Provided the DBA team with the necessary DDLs codes to create physical objects.
- Conducted impact analysis assessments for the schema expansions.
- Collaborated with the DBA to devise physical aspects of the database (indexing, partitioning, etc.)
- Participated in the architecture to design and deploy efficient data loads (staging area, data marts, aggregates, etc.).
0-5 years of experience
Design, develop, test and implement new business oriented data warehouse including specific data marts for student enrollment, performance, attendance, discipline, and standardized test scores.
- Implemented Talend ETL tool along with ETL standards and best practices to replace customized SQL coding processes.
- Developed Talend ETL mappings/jobs for standardized district and school performance reports. These objects replaced hand written SQL scripts.
- Performed database comparative analysis to identify retained and replacement elements of old data warehouse.
- Performed QA testing and documentation for production rollout of data and BI delivery systems/products.
- Assisted with the design and implementation of Microstrategy environment for self-service reporting and analysis.
- Assisted with single sign-on implementation with data warehouse and Microstrategy tools to further self-service BI strategies.
6-10 years of experience
Responsible for the design and implementation of a scaleable data solution for StoredIQ’s high performance appliance for the Enterprise Content Management and eDiscovery markets.
- Designed and implemented a PostgreSQL-based, relational database model, and database-access layer with special emphasis on performance for database loads and queries.
- Designed and implemented a Lucene-based full-text search capability while heavily modifying Lucene itself. Provided a PostgreSQL interface to the search engine.
- Designed a data partitioning and distributed data processing solution for scalability and performance.
- Led the internationalization effort to support major European and Asian languages.
- Led the development for out query language and expression parsing.
0-5 years of experience
Consulting with Blue Cross Blue Shield of Minnesota migrating from an Internal Data Warehouse, IDW, to HighMark BlueCore Enterprise Data Warehouse, EDW.
- Analyzing all reports and outbound submissions from the IDW to determine business need, risks and remediation plans if needed.
- Performing data mapping from IDW to EDW, identifying gaps and the risks associated with those gaps.
- Collaborated with USG, Accenture, Deloitte and Seneca employees to architect and build out integrated solution for March 2015 production roll-out.
- Successfully gathered business requirements, mapped data from disparate systems, data modeling, created architecture and technical artifacts
- Have USG security clearance.
0-5 years of experience
Lead Data Architect for Google Fiber project.
- Tuning and establishing baseline for FMS and Ticketing Oracle 11g configuration including memory/buffer cache/stats collection/etc.
- Influenced and mentored DR design set up for Oracle 11g DataGuard.
- Automatic client failover implementation for Oracle 11g Active DataGuard using service based TNSNAMES.
- Actively participated in system development by designing database components.
- Developed and implemented Nagios plug-in to locally collect variety of database metrics and using AcqOps Monitoring framework forward stats into Monarch Datastore.
- Analized Booking Fee data and designed protobuff schema.
- Implemented BookingFeeCalculator, BookingFeeRule, QpxCountryDataSource classes. (Java, JUnit)
0-5 years of experience
Reviewed Architecture Blue Print for (Enterprise Risk Mgmt.) program for TD’s Risk Information Strategy for the Enterprise (RISE) program.
- Produced Architecture Assessment of Options (AAO) for custom application to gather risk metrics, from external financial systems, to meet BASEL- BCBS 239 reporting requirements.
- Produced Architecture Blue Print (ABP) from data sources to staging environment, Data Mart and Semantic Reporting Layer for BASEL – BCBS 239 regulatory reports 2016 deadline.
- Produced Future-State architecture for Risk and Regulatory Data Warehouse and Reporting Semantic Layers.
- Produced data modeling process for (RISE) program interim solution and future-state architectures.
- Analyzed Treasury Balance Sheet Management (TBSM) architecture proposal from Deloitte Consulting.
- Reviewed data requirement between Treasury, BASEL, ERM and Dodd-Frank CCAR programs.
0-5 years of experience
Translated business data definitions to systems and applications data definitions.
- Developed an enterprise data dictionary. Defined element level business rules.
- Profiled data and mapped it to data sources through the MS BizTalk canonical.
- Developed data flow diagrams and state diagrams.
- Worked with Application DBA/Development DBA to create the logical and physical data models.
- Assessed data quality and established a data confidence index for each data source/field.
- Developed ETL (extract, load and transform) processes using SQL Server Integration Services (SSIS) to move data from application databases to enterprise data marts or to the BizTalk canonical.
0-5 years of experience
- Developed, conceptual, logical, and physical data models.
- Reverse engineered and redesigned several database applications from Sybase and SQL*Anywhere to an Oracle 10G environment.
- Installed Oracle Internet Development Suite and reverse engineered applications into the repository.
- Conducted several facilitated modeling sessions and authored recommendations/justifications for enterprise level modeling efforts and governance.
0-5 years of experience
- Performed analysis of requirements, data sources and data quality to produce overall design and implementation of the enterprise data warehouses
- Developed conceptual, logical and physical data models for a large enterprise data warehouse based on business requirements using relational and star schema/dimensional modeling techniques
- Evangelized, received support for, designed and implemented enterprise customer data integration (CDI) solution and a centralized master data management (MDM) application for business users
- Established, documented and published data modeling standards, policies and procedures
0-5 years of experience
Redesigned the Data Architecture to support Big Data and new Change Data Capture Process.
- Implemented several new techniques to improve overall ETL performance.
- Designed customized processes to support various business requirements.
- Implemented Statistical Modeling for Parts Price Match application.
- Worked extensively with Statistical programming languages for Data Analysis and Data mining.
0-5 years of experience
Collaborate with business analysts, team leads and developers to define business requirements for data warehouse solutions for the SAM data mart.
- Design and developed data models and supporting stage and target database tables.
- Designed and implemented keys, indexes, grants, synonyms in support of the database objects.
- Developed supporting DML to load various code tables.
- Implemented database objects in the DEV and SIT environments.
- Maintained data modeling standards and operating procedures.
0-5 years of experience
ETL Developer, Team Lead, Project/Data Architect
- Provided technical leadership and project architecture for many projects, including leading teams of developers.
- Designed transformation logic for source to target mappings for staging, warehouse, and mart.
- Designed, developed, and tested ETL mappings, mapplets, sessions, and workflows, from staging to the data warehouse, and to the data marts.
- Developed ETL mapping interfaces to and from JD Edwards, PassPort, Primavera, and other enterprise applications.
- Designed and modeled star schemas including dimension and fact tables for the data marts.
0-5 years of experience
- Conducted the JAD sessions to determine the requirements for the Merchant Conceptual Model
- Designed the Merchant Conceptual, Logical and Physical Data Models.
- Analyzed Source Data to determine what meta-data was to be included in the Logical Data Model
- Performed data mapping to determine where identified source data belonged in the Data Base.
- Created Forward Engineered SQL from Case Tool, which was loaded to build and maintain the Data Base.
- Used SQL to load Source Data into the Data Base.
0-5 years of experience
Responsible for Logical and Physical Data Model development (using Sybase PowerDesigner modeling tool and MetaWorks Repository 6.15 and 7.5). Converted 5 MS Access databases to an Oracle 8i platform.
- Responsible for the Logical and Physical Design of the Private Label Services Billing Invoicing, Invoicing Reference, Reporting and Customer Business Billing Enterprise Reporting areas for a major conversion (from the Converges to Amdocs Wireless Billing Systems) project.
- Developed and administered the Change Control Process for corporate Billing databases/data models and reverse engineering processes.
- SBQA ([company name] Billing Quality Assurance) Billing Verification Capacity Analysis Project
- Rodeo PLS (Private Label Services) and Business Billing and Invoicing Conversion Projects
0-5 years of experience
- Lead Data Architect on the Trademark Datamart (TRDM) data warehouse project, responsible for creating and updating the 15+ star dimensional data models.
- Reviewed and analyzed COBOL reports, documentation and code on the mainframe, provided gap analysis, source to target mapping and data validations between source and target.
- Physical Data Modeling using IBM’s Data Architect using Oracle 11g as the database. Created and/or modified 20+ STAR data models, 29 Fact and 55 dimension tables in the TRDM data design project. Generated the DDL, Alter Scripts, Model Diagrams, Compared structure, property and merged objects.
- Performed data analysis, data profiling and data quality on the source (TRAM) and target data sources (TRDM).
- Create complex queries using Advanced Analytical Queries in SQL for data analysis, profiling and validations.
6-10 years of experience
Developed Data Warehouse solutions including analysis, architecture, and modeling for BI systems
- Led full life cycle development for enterprise healthcare, manufacturing, and financial info system projects
- Performed data analysis, data governance, data validation
- Performed database design, data architecture for OLTP, OLAP, dimensional Data Marts and Data Warehouses
- Performed conceptual, logical, and physical data modeling using Erwin and PowerDesigner
- Source to target mapping and data profiling
- Supported QA activities and V&V teams
0-5 years of experience
Data Architect tasked to design/build a very large Enterprise Level Trusted Integrated Information Layer as part of the Healthcare Master Data Management Initiative comprising subject areas like Provider, Consumer, Claims, Product, Contract and Finance.
- Support the current Legacy EDW and Analytics Data Mart activities.
- Enterprise Data Architecture Activities using 3rd Normal Form Master Data Management, 3rd Normal Form for the new Atomic Data Warehouse in subject domain Provider; Consumer; Claims; Contract; Quality Revenue and Risk Program Management with reference to Healthcare Industry standard Blue Cross Blue Shield Context Model.
- Prepared with the team Data Architecture documents to support UDB-DB2 or Mainframe DB2 standards to use Bi-temporal features.
- Worked with the team to prepare Metadata Standards document.
- Prepare Physical Models to support both UDB-DB2 and Mainfram-DB2 platforms for the MDM layer and the core Atomic Data warehouse layer.
- Star Schema Modeling using Kimball Methodologies for Enterprise Analytics Data Mart.
0-5 years of experience
Responsible for End to End Solution including Requirement Gathering, Conceptual & Logical & Physical Data Modeling, Database Design and Integration, Data Governance, Data Cleanup, Database Performance, Reporting and Application Development
- Implemented Big Data solutions including Data Integration, Big Data Governance, and Data Quality. The solutions were implemented using Hadoop, Hive, Impala and Cassandra.
- Clients in my portfolio include Wells Fargo, Rebuilders Automotive Supplies, LogistiCare and Allen Parish Hospital.
- Designed and implemented Oracle based OLAP solutions, and created Analytics solutions using Jaspersoft, QlikView and Tableau
- Lead Enterprise Data Governance practice.
- Lead Data Architect and ETL teams using IBM InfoSphere DataStage and Informatica.
- Created physical data models (PDM) for DB2 9.5 and Oracle 11g databases.
6-10 years of experience
Led architecture and systems engineering efforts to modernize seven legacy TSA Threat Assessment and Credentialing (TTAC) systems-of-systems (ACAT-2 acquisition)
- Led contractor team in development of AoA, CONOP, Mission Need Statement, Capability Development Plan, Data Management Plan for DHS Systems Engineering Life Cycle (SELC) acquisition
- As TTAC Modernization (TM) senior staff member, led high-level architecture and data architecture design
- Collaborated with DHS authorities to transition seven independent design models into a Service Oriented Architecture (SOA)-consolidated foundation, and CLOUD infrastructure (IaaS)
- Taught systems engineering life-cycle principles to senior and junior staff to establish PMO governance structure
- Led data, security, and privacy architectures and design activities
Data Architect Duties and Responsibilities
The data architect’s duties and responsibilities may vary depending on the industry in which they work. Based our research of current job listings, most data architects perform the following core tasks:
Evaluate Current Data Systems Data architects are responsible for evaluating the current state of the company’s databases and other data systems. They analyze these databases and identify new solutions to increase efficiency and performance.
Define Database Structure Data architects define the overall database structure, including recovery, security, backup, and capability specifications. This definition provides a way for data architects to determine overall requirements for database structure.
Propose Solutions After analyzing, evaluating, and defining current database structures, data architects create and propose solutions to upper management and stakeholders. This often includes designing a new database and presenting it to interested parties.
Implement Database Solutions Data architects are responsible for implementing the database solutions they propose. This entire process includes developing process flows, coordinating with data engineers and analysts, and documenting the installation process.
Train New Users Since data architects are the experts in the new database solutions they design and implement, they make the perfect trainers for new users. They may also be responsible for training new data analysts and data engineers.
Data Architect Skills and Qualifications
Data architects should use logical and analytical thinking to come up with creative and innovative database solutions. Employers look for candidates who have a bachelor’s or master’s degree in computer engineering and at least five years of experience in a data analysis position. Successful data architect candidates also demonstrate the following skills and qualifications:
- Data analytics – data architects are experts in everything data related. They know exactly how data is collected, analyzed, and delivered. They’re also familiar with both the technical and user-facing sides of databases
- Scripting languages – data architects should be familiar with scripting languages such as PHP, C, and SQL
- Project management experience – the data architect is responsible for each phase of new database implementation. As such, they should be experienced project managers who know how to meet deadlines and create efficient solutions that involve multiple teams
- Attention to detail – successful data architects pay meticulous attention to details and have a deep understanding of how even the smallest details fit into the big picture
- Critical thinking – data architects tackle problems by first evaluating them and thinking of several different potential solutions. They use their critical thinking skills to deliver the most efficient solution based on database structure and requirements
Data Architect Education and Training
Data architects should have at least a bachelor’s degree in computer science or computer engineering before they land a job. However, most employers prefer to hire data architects with master’s degree and at least five to seven years of experience in data analysis and management. Additional certification in project management may also be required depending on the employer.
Data Architect Salary and Outlook
According to PayScale, the median annual salary for data architects is $112,825. This salary increases depending on experience and advanced education. The top 10 percent of data architects make as much as $153,000 per year, while the bottom 10 percent make as little as $74,463. Data architects are also eligible to receive extensive benefits through their employers, such as health insurance with premiums fully paid and unlimited time off. They may also receive incentive-based bonuses. The Bureau of Labor Statistics reports that database administrators, a field very similar to data architects, will experience growth of 11 percent in the next decade. Database-as-a-service is growing in popularity, which only increases the need for more data architects as companies expand.
Helpful Resources
Read through some of these helpful resources to learn more about being a data architect:
Database Journal – one of the most popular and helpful websites for database professionals, Database Journal contains a wealth of information on a huge number of topics, such as MySQL, Oracle, and PHP, and provides tips, tutorials, and articles that help you better manage your databases
Oracle Database Insider – Oracle is one of the biggest names in the database game, and its blog contains a ton of useful information, including posts that help you update and modernize your databases
r/Database – this subreddit has over 16,000 subscribers and provides a forum where you can ask questions or read through posts to glean more information. The subscribers here are helpful and friendly, so don’t hesitate to get involved
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design – this book shows you how to design structurally sound databases that make sense. Topics covered in the book include database models, the purpose of good database design, and database analysis
Data and Reality: A Timeless Perspective on Perceiving and Managing Information in Our Imprecise World – this book was written in 1978 but still manages to maintain its timeless perspective in today’s world. It gives you significant insights into the world of data processing that are still relevant to today’s databases, and the third edition has been updated with examples that make sense with technological advances
Architecture Cover Letter Examples
Rate This Article
[Data Architect]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
