Data Warehouse Architect Resume Samples

The Guide To Resume Tailoring

Guide the recruiter to the conclusion that you are the best candidate for the data warehouse 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.

Create a Resume in Minutes

S Frami

Scottie

Frami

671 Russel Trace

Phoenix

+1 (555) 873 5549

671 Russel Trace

Phoenix

Phone

p +1 (555) 873 5549

Experience Experience

San Francisco, CA

Data Warehouse Architect

San Francisco, CA

Welch Inc

San Francisco, CA

Data Warehouse Architect

Work with Teradata IT project managers and/or solution providers to scope projects and develop statements of work, project plans, and risk assessments
Work with internal and client-side architecture, application development and operations teams to meet current and future data management objectives
Design and provide tools to assist in the upgrade, management and optimization of data systems
Provides oversight for database & server performance including leadership for SQL performance and tuning
Develop, test, and integrate code for existing data warehouse development in compliance with firm-wide data management principles and security controls
Working with solution and system architects (peers) to deliver enterprise class database tier solution and/or integration into custom product development
Develop and implement various work plans for projects

Dallas, TX

Microstrategy Data Warehouse Architect

Dallas, TX

Gutmann Group

Dallas, TX

Microstrategy Data Warehouse Architect

Knowledge of systems development and project management methodologies/processes
Partner with the ETL development team in developing solutions
Keeps management, project managers, team members and business stakeholders informed of critical issues, project status, changes, etc
Performs change management regarding MicroStrategy environment
Provide project estimates for cost-benefit analysis
Performs on-call responsibilities including off-hours support
Work effectively with Technology Operations/Infrastructure teams to ensure a seamless transition of the completed solutions to the responsible technology/3rd party support organization for its continued operations and maintenance

present

Philadelphia, PA

Senior Data Warehouse Architect

Philadelphia, PA

Konopelski Group

present

Philadelphia, PA

Senior Data Warehouse Architect

present

An interesting and challenging architectural role in designing a global data warehouse solution for liquidity management
Responsibility of the overall design of the application and ownership of the architectural vision of the solution
Work closely with the implementation teams on solution architecture topics
Evaluate design alternatives and perform cost benefit analyses
Manage the solution architecture decision process within the program
Responsibility for creating of the overall system architecture models for the program
Ensure alignment to the departmental architecture and the enterprise architecture within the bank

Education Education

Bachelor’s Degree in Computer Science

Rowan University

Bachelor’s Degree in Computer Science

Skills Skills

Working knowledge of basic analytics/statistical principles, and the ability to synthesize complex information into an easy to understand manner
The ability to execute with efficiency and with quality
Strong attention to detail
Proficiency with Oracle eBusiness Suite -- functionality and table structure
Our total compensation approach includes a competitive base salary, 401(k), strong work/family programs, and medical, dental and disability coverage
Ability to learn and apply new skills and concepts quickly
Strong interpersonal skills and able to work easily with client personnel
Team player, with strong emphasis on knowledge sharing (heart of a teacher)
Some experience with and knowledge of optimizing database performance and capacity utilization to provide high availability and redundancy
Ability to create technical and business documentation including white papers, knowledgebase articles, system diagrams, workflow diagrams, and presentations

Create a Resume in Minutes

15 Data Warehouse Architect resume templates

Read our complete resume writing guides

Big Data Warehouse Architect Resume Examples & Samples

Define key business drivers for the data warehouse initiative
Identify and assist in short-term improvements to existing data warehouse
Establish the long-term strategy and technical architecture for the data warehouse
Define the overall data warehouse architecture (e.g., ETL process, ODS, EDW, BI, Data Marts)
Create a detailed design and development plan for the data warehouse initiative
Define and implement technical requirements, technical and data architectures for the data warehouse
Design and manage the ETL process, including data quality and testing
Design and manage the information access and delivery effort for the data warehouse
Define and manage the implementation of security requirements for the data warehouse
Define and enforce meta data standards for the data warehouse
Define and implement production release requirements and sustainment architecture

Data Warehouse Architect Resume Examples & Samples

Collaborate with business areas to identify and assess business requirements for information/data and then provide options, risks, costs and benefits for the appropriate solution
Provide project estimates for cost-benefit analysis
Partner with the application architects to ensure effective data schemas for operational applications
Participate in vendor management to include oversight and monitoring vendor progress of development deliverables through to implementation
Able to cross train and mentor others as needed
Keeps management, project managers, team members and business stakeholders informed of critical issues, project status, changes, etc
Able to embrace and adapt to change while demonstrating flexibility and the ability to develop and follow new processes
Bachelor’s degree from a four-year college or university is required; majors in a technical field preferred
Knowledge of data requirements, data modeling concepts, data integration, master data management, metadata management, enterprise data warehousing (EDW) and business intelligence/analytics, tools, protocols and practices
Demonstrated ability to produce high quality technical documentation
Knowledge of systems development and project management methodologies/processes
Experience with one or more databases, preferred Teradata
Experience with one or more reporting/ad-hoc analysis tools, preferred MicroStrategy
Experience in the hospitality industry
Familiarity with one or more statistical modeling tools by SPSS or SAS etc
Familiarity with Cloud Computing architectures, protocols, and practices

Data Warehouse Architect Resume Examples & Samples

Strong business system, analysis and software development experience
Software development methodology experience
10+ year's relevant Technical experience within consumer finance industry
10+ year's experience with designing, development and implementation of Data warehouses
Minimum of 5+ years of work experience in as a lead architect in Data warehouse design and development
Bachelor degree in such fields as information systems, computer science, mathematics and statistics. Must have solid application development and data warehouse implementation background
Require experience in,

Senior Data Warehouse Architect Resume Examples & Samples

Knowledge of the complete DW/BI stack
Ability to write and understand complex SQL
Experience with data warehouse data modeling
Experience w/ one or more of the following relational databases: MySQL, Postgres, Oracle, Sybase, SQL Server
Experience with one or more BI tools like: Tableau, Jasper, Pentaho, Microstrategy, Cognos, Business Objects
BS degrees in computer science or equivalent experience
Statistical background a plus
Familiarity with one or more scripting languages such as Python, Perl, Ruby, bash
Demonstrated leadership of project teams - ability to inspire, explain and maintain high standards
Experience w/ Amazon RedShift or similar large scale data warehousing systems such as Vertica, Aster, Teradata, Netezza, BigQuery
Experience w/ Tableau
Experience w/ the R statistical modeling language, PMML or similar technologies
Experience managing other DW engineers and Data Scientists and a desire to provide leadership
Experience w/ clickstream analysis
Experience w/ Hadoop and related technologies such as Hive, PIG, Hue
Experience w/ Amazon Web Services technologies like S3, SQS, EMR, SimpleDB, etc
Experience with one or more of the following tools for data integration / ETL: Talend, Informatica, Kettle
Experience w/ very large data volumes (billions of daily events)

Data Warehouse Architect Resume Examples & Samples

The candidate will manage and enhance the data warehousing environment and to take it through the future iterations
Database architecture and design of data warehouse subject areas and OLAP cubes
Hands on SQL development
Hands on support of current ETL processes, share responsibilities for monitoring the data warehouse loading process
Troubleshoot and resolve data issues in production systems
Communicate with business users and project managers to resolve business problems and create solutions
Use of technical experience to suggest better solutions to new and existing problems
Involvement with other IT departments providing systems communication processes
Meet with various IT groups (other departments and computer operations' staff) to address issues/concerns. This includes other business unit IT groups, as well as the technical operations group (Server Group and other Infrastructure groups)
Identify software solutions needed for new projects
Weekly reporting to management on project status and issues
3+ years of data warehousing / OLAP experience
3+ years multidimensional database architecture and design experience
3+ years of SQL Experience
Team and vendor partner management
Clear understanding of principles and techniques of Web development
Data Warehouse operations experience is a plus
Dimensional database architecture experience
Formal systems life cycle methodology experience
MicroStrategy, big data and Realtime BI experience are a plus

Enterprise Data Warehouse Architect Resume Examples & Samples

Understand and translate customer requirements
Formulate solution options and recommendations for the Enterprise Data Warehouse
Design, build and support of the Enterprise Data Warehouse architecture utilizing best practices
Develop reporting and analytical data models to meet the needs of the organization
Support Teradata database migration activities
Provide technical knowledge, project management and leadership to implement the solution
Provide business overviews and communicate strategies to business stakeholders and executives
Create and maintain documentation for the Enterprise Data Warehouse environment
Mentor Enterprise Reporting team on Teradata and Enterprise Data Warehouse best practices and skills required to design, develop and build a successful data warehouse
Support data governance and metadata management documentation, processes and activities

Senior Data Warehouse Architect / Developer Resume Examples & Samples

The successful candidate should have or offer
5-8 years of data warehouse development and data warehouse architecture experience
Strong data analysis and data profiling skills, as well as knowledge of principles, techniques, and best practices of enterprise data model and dimensional data model. Prior experience with modeling tools such as Power Designer or CA Erwin is desirable but not required
Proven ability to transform business information into data mart designs preferably in the financial services sector
Experience with ETL tool (Informatica preferred) with the ability to develop ETL design specifications and troubleshoot ETL issues
Strong collaboration and communication skills
Experience with Unix and Autosys is a plus
Architect, design, and develop data warehouse components including databases, data integration, data extraction, ETL mappings and DQ rules required for BI applications
Develop a thorough understanding of the data definitions, domain values, data relationships, business rules, sources and data integration for each subject area
Work with client and business analysts to review their business requirements
Responsible for data analysis, data profiling and data sourcing
Identify and document DQ rules and metrics
Interact closely with Business Analysis team, ETL team and BI Reporting teams to ensure understanding of proper use of data architecture. Conduct data model, data architecture and data integration design review sessions. Support business analysts and developers with data subject expertise, query building and optimization
Unix & Autosys
Power Designer or CA Erwin
Informatica Data quality (IDQ)

ETL / Data Warehouse Architect Designer Resume Examples & Samples

Assist the development team with the analysis and documentation of the current warehouse application
Work closelly with Business Analyst and Application Development teams to architect and design the new Warehouse application
Be a key resource to the project team and assist with
Strong data modelling skills, 5 + years of experience
Strong data warehouse experience, 5 + years
Programming background in SQL and ORACLE, 5 + years of experience
Linux/Unix shell scripting, 5 + years of experience
ETL development experience - preferably Informatica, 5 + years of experience
Clear and concise documentation
Background in Finance
Excellent communication skills, ability to multi-task, and work towards tight deadlines
Good analytical problem solving skills
Self motivated personality and able to work independently as well as in a team

Data Warehouse Architect Resume Examples & Samples

Architecting improvements to existing platform (eg near real time architecture)
Optimization of new and existing SQL procedures on different technologies
Mentoring existing teams within BI on best practices
Tuning the BI front end for maximum performance
Monitoring internal BI metrics and prioritizing workstreams to meet SLAs
Working with BI leadership to create a roadmap to ensure scalability of the platform
5-7 years of experience in a business intelligence, data science or engineering role
Positive, people-oriented, and energetic attitude
Experience with SQL, OLAP (SSAS preferred), ETL, and MPP technologies (Netezza, Vertica, Paraccel,Teradata etc.)
Analytical, creative, and innovative approach to solving problems
Entrepreneurial spirit
Experience with Python, Java, or C++ a plus
BA in computer science, economics, or other quantitative discipline with strong academic record

Microstrategy Data Warehouse Architect Resume Examples & Samples

Collaborate with business areas to identify, assess and document business requirements for information/data/reporting and then provide options, risks, costs and benefits for the appropriate solution
Assess and document the flow of data between system components
Able to develop, understand and interpret logical and physical data models
Partner with the ETL development team in developing solutions
Determine and develop the business intelligence solutions such as dashboards etc. required to support data mining, analytics, and reporting needs
Help coordinate the development of necessary project documentation and standards required for compliance and identified best practices
Coordinate with the business users during project implementations and continue to serve as a point of contact for future data questions and issues
Work effectively with Technology Operations/Infrastructure teams to ensure a seamless transition of the completed solutions to the responsible technology/3rd party support organization for its continued operations and maintenance
Ensure business user issues are resolved in a timely manner
Facilitate and lead meetings and requirements gathering sessions with end users at all levels (VP, Director, Managers, and Subject Matter Experts)
Ownership for administration, security rights and maintenance of MicroStrategy environment; includes being able to perform patching and upgrades as needed
Performs change management regarding MicroStrategy environment
Coordinates outages with infrastructure and business teams on routine maintenance
Partners with Finance team to perform data loading and validation activities regarding monthly, quarterly and yearly budget/forecast cycles
Performs on-call responsibilities including off-hours support
7+ years of demonstrated experience working as part of large Information Technology teams and/or consulting organizations partnering with clients/business groups to support complex data warehouse environment
Experience with one or more databases; will be hands on with Teradata but potentially Oracle and SQL Server
Experience with MIcrostrategy
Must be able to utilize and effectively communicate functional and technical components of an initiative to applicable parties both verbally and through documentation
Attention to detail, good analytical and problem solving skills and critical thinking
A self-starter/motivator and having a proactive, agile and strategic mindset
Familiarity with Financial concepts/KPI’s
Experience with one or more ETL tools, preferred Informatica Power Center
Familiarity with one or more data modeling tools such as Erwin, Embarcadaro etc
Familiarity with any additional reporting/ad-hoc analysis tools besides MicroStrategy

Senior Data Warehouse Architect Resume Examples & Samples

An interesting and challenging architectural role in designing a global data warehouse solution for liquidity management
Responsibility of the overall design of the application and ownership of the architectural vision of the solution
Work closely with the implementation teams on solution architecture topics
Understand, consult on and communicate the non-functional requirements of the data warehouse solution
LI-MK1*

Big Data / Data Warehouse Architect Resume Examples & Samples

Experience in traditional DW environments- Teradata, Oracle, DB2, SQL Server
Strong understanding of data warehousing concepts
Experience developing Big data configurations, architectural diagrams and proposals

VP-global Operations Risk Technology Lead Database Modeler & Data Warehouse Architect Resume Examples & Samples

Provide Technical Leadership to a team of developers, modelers and analysts
Interface with Business and technical teams on Requirements and functional analysis
Design, build and maintain the transactional / operational data stores
Maintain the existing data warehouses and Design subject area wise data marts / cubes to facilitate aggregation, slicing and dicing of data by reporting tools such as Micro Strategy
Undertake extraction, transformation and population of the data warehouse and data mart
Evaluate new data sources for adherence to the organization's quality standards and ease of integration
Interface with Data governance teams to leverage central data repositories
Providing expertise in technical analysis and solving technical issues during project delivery
Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks
Support the Quality Assurance team during Product Test phase
Provide bug fixes and level-3 support to troubleshoot Production problems
Application Database Performance tuning
8-10 Years of project experience as database modeler / Data warehouse architect within a distributed, service-based enterprise environment for financial institutions
Experience with systems / applications in Risk technology for financial institutions is preferred
Demonstrates expertise in a variety of data warehousing and business intelligence concepts, practices, and procedures
Understanding of ETL design and development best practices
Experience with Tools like ERwin Data Modeler tools/Power Designer
Understanding of Big Data storage Technologies is preferred
Previous experience conducting requirements gathering and design sessions with customers
Previous experience producing written deliverables for technical designs
Understanding of indexing, partitioning and data design performance considerations for industry standard DBMS
Strong understanding of software development life cycle and Release Management
Ability to design, organize, and implement module, perform system testing, plan and automate tasks to maintain existing system
Ability to research and trouble-shoot application problems
Highly motivated team player, Excellent communication and interpersonal skills
Excellent analytical and troubleshooting skills
Ability to balance multiple demands and work both independently and as part of a team to develop solutions
Bachelor’s Degree or equivalent experience required

Big Data / Data Warehouse Architect Melbourne Resume Examples & Samples

Exposure to ETL solutions such as Datastage, Informatica, ODI, Map/Reduce
Experience working on Big Data platforms / Hadoop / Azure etc
Understanding of Big Data software environment such as Hadoop, NoSQL, Hive, HBase, Sqoop and other ecosystem tools

Research Data Warehouse Architect Resume Examples & Samples

Develops a close working relationship with the ACE Research Customer Support Team
Provides oversight for ensuring appropriate Design Patterns are defined and used
Responsible for ensuring the data architecture design and implementation (logical and physical) will meet research needs
Performs ETL development
Provides oversight for database & server performance including leadership for ETL & SQL performance and tuning
Builds and maintains relationships with leaders and technical staff involved with research to understand current and future information and data needs and strategy
Partners with other ACE Architects as appropriate
Works closely with other ACE groups to design reusable solutions for research that can support ACE reporting projects and services
Mentors, trains and develops less experienced staff and project/business personnel who need to understand Data Warehouse and ETL Architecture processes
Defines and delivers consistent information standards, methodologies, guidelines and techniques
Responsible for oversight of security of data provided to researchers
Evaluate and recommend tools and practices for proactive data warehouse development effectively anticipating the needs of future ACE product and services delivery to support research
5 -10 years of experience in a combination of development and architecture roles with at least 3 years in a technical leadership function
Experienced with driving the Software Delivery Life Cycle
Experience with large-scale data integration and reporting (e.g. data warehousing)
Healthcare data preferred
Understanding of data requirements in complex environments (e.g. data warehouse)
Significant knowledge of / experience with contemporary information management technologies such as tool-based data standardization, XML, ETL, data profiling, semantic matching, data cleansing, and metadata management
Appropriate industry certifications, including CDMP
Experience with appropriate software, hardware, network and related technologies to support data warehouse architecture
Strong writing skills

Data Warehouse Architect Resume Examples & Samples

Leads implementation of data warehousing vision, strategy and roadmaps for the organization
Accountable for building data warehouse solutions
Provides oversight for ensuring appropriate Design Patterns are defined
Responsible for oversight of data warehouse and BI Security
Provides oversight for ETL Design
Provides oversight for database & server performance including leadership for SQL performance and tuning
Leads Oracle & SQL Server monitoring
Provides leadership with Oracle RDBMS features including Oracle client installation/AD integration
Provides guidance on change data capture and oversight of master data model
Serves as liaison with Enterprise Architect Office for architecture efforts, to align ACE and information architecture across the organization
Develops and documents methodology for collection, storage and control of data architecture and key system interfaces
Experience with Oracle Exadata and other RDBMS technology
Experience with OLAP cubes
Experience with data migration tools such as IBM DataStage
Experience with data architecture design and implementation (logical and physical)
Contributes to the organization's financial health by ensuring that business and goals are a major part of evaluating the performance of projects and solutions, in conjunction with business analysts and other stakeholders
Manages technology selection criteria in conjunction with technical architects and designers
Works closely with other ACE groups to support ACE reporting projects and services
Rationalizes all current business architecture activities for consistency and possible redundancy
Evaluate and recommend tools and practices for proactive data warehouse development effectively anticipating the needs of future ACE product and services delivery
Builds and maintains relationships with a wide variety of internal organizations (business owners, practices) to understand current and future information and data needs and strategy
Builds and maintains relationships with a wide variety of key vendors
Builds and maintains relationships with other architects and technology leaders and understand future strategy
Provides leadership to project and technical staff for system design and implementation, as appropriate
Develops data/information framework and ensures compliance with standards
Mentors, trains and develops less experienced staff and project/business personnel who need to understand Data Warehouse Architecture processes
Ensures compliance to standards through consistent engagement of non-conforming parties with a view toward reducing non-conformance
Plans for data consolidation and information lifecycle management in conjunction with appropriate stakeholders
Ensures architectural integration with key focus areas
Healthcare data
Data Migration Tools
BI Reporting tools
Understanding of strategic architecture
Performance tuning of complex SQL
Experience with data warehouse architecture tools and technologies
Strong relationship and project management skills
Ability to contribute to the growth of the resource pool
5 -10 years of experience in a combination of development and architecture roles with at least 3 years in a leadership function
Experienced with driving the Software Delivery Life Cycle in a business environment
Experience with Vendor Management, software evaluation and selection Leadership Behaviors
Provides vision and direction consistently for the section of the enterprise architecture
Sets policies, standards and frameworks for information architecture in the responsible domain
Provides team members with customized career-enhancing work where possible

Public Sector Oracle Obiee Data Warehouse Architect Manager Resume Examples & Samples

Technical components to an implementation
Implementation and support of Oracle packaged solutions, including but not limited to: Fusion, EBS, PeopleSoft, CC&B, Siebel and Hyperion
Contributing as a technical team member in consulting, designing, and implementing those solutions
Designing, implementing and supporting business processes in an Oracle environment
Designing, building, testing and deploying various Oracle solutions
Identifying and addressing client needs: building solid relationships with clients; developing an awareness of Firm services; communicating with the client in an organized and knowledgeable manner; delivering clear requests for information; demonstrating flexibility in prioritizing and completing tasks; and communicating potential conflicts to a supervisor

Data Warehouse Architect Resume Examples & Samples

Thorough knowledge of data warehouse principles and techniques, including data modeling techniques such as normalization and dimensional modeling
Organization/Project Management
Logical/Mathematical thinking
Programming experience and problem solving
Experience working in health care organizations
Analytical experience including requirements gathering, user case creation, agile methodology and testing
Medicaid or other healthcare experience
Awareness of current and emerging technologies for data management, analytics and business intelligence such as columnar databases, graph databases and NoSQL databases
R or comparable statistical software
Python or other general purpose language
Application Programming Interface (API) data access
BI/Dashboard experience
SQL and database design
SAS experience
Cognos experience
Strong organizational and documentation skills
Technical and Architecture design skills a plus
Experience with data standards and security practices such as NIST, HIPAA
BS in Computer Science, Management or related degree, or equivalent experience

Data Warehouse Architect Resume Examples & Samples

Work with internal and client-side architecture, application development and operations teams to meet current and future data management objectives
Define project scope and deliverables, and then follow through with appropriate implementation
Design and provide tools to assist in the upgrade, management and optimization of data systems
Design and construct high performance ETL tools and routines
Design and construct high performance, scalable data and system management applications and tools
Develop technical support and applications documentation and training materials for client staff
10 years IT operation with demonstrated understanding of data warehousing, database architecture, theories, principles, and practices

Senior Data Warehouse Architect Resume Examples & Samples

Works with the business teams to define requirements and translate those into logical database designs, consistent metadata while ensuring accuracy and reporting flexibility
Creating, documenting, and maintaining ETL specifications including workflow dependencies ensuring data quality
Monitor and communicate time lines for all ETL tasks whether new, enhancements, error handling or infrastructure related. Work collaboratively with the entire Data Warehouse team to ensure priorities are understood
Reviews the current state and maintains a high level vision of how the Data Architecture performs. Suggests new approaches or architectures that might be warranted. Handles day to day support issues
Works closely with the businesses to understand how key data and metrics might remove the need for internally built applications
10 years IT related experience with 5-7 years directly involved in building, extending and maintaining a Data Warehouse Data Architecture
Hands-on knowledge of Data Modeling and ETL tools
Closely involved with the day to day operations of the Data Warehouse or Marts with trouble shooting and error recovery responsibilities
Hands on experience with Informatica Power Center 9.x
Use of modeling tools, preferably Erwin
Familiarity with BI reporting tools, preferably MicroStrategy
Bachelor Degree or related experience

Data Warehouse Architect Resume Examples & Samples

Bachelor’s Degree in Computer Science
5+ years experience in data warehousing
2+ years experience with Informatica
Master's Degree preferred
Deep expertise in the technical architectures associated with information integration, data visualization, & data warehousing
Advanced knowledge of the data architectures associated with information integration, data visualization, and data warehousing
Advanced knowledge of semantic data model best practices
Demonstrated versatility in business integration, project management, and systems/software development and implementation
Expertise in data virtualization tools, techniques and technologies
Demonstrated experience with and deep knowledge of systems and the integrations between infrastructure technologies (i.e., servers, operating systems, networks, firewalls, security.) and applications or information
Understanding of quality standards and practices, including risk-based methods
Strong teamwork, self-management, and problem-solving abilities
A high level of intellectual curiosity, external perspective, and innovation interest
Demonstrated initiative to build relationships, learn new business processes and identify opportunities
Experience working with individuals across organization boundaries
Leadership abilities and ability to achieve results through others
Demonstrated ability to influence peers
Demonstrated broad and deep technology learning agility
Advanced problem solving skills
Qualified candidates must be legally authorized to be employed in the United States. Lilly does not anticipate providing sponsorship for employment visa status (e.g., H-1B or TN status) for these positions
Experience with ITIL and key IT processes
Previous Pharmaceutical experience
Experience leading teams or in formal leadership roles

Data Warehouse Architect Resume Examples & Samples

Gain understanding of the business and IT strategy driving our go-forward reporting needs
Propose the go-forward solution (strategy, tools, approach) – While we are a Microsoft shop we are open to/committed to finding the best overall approach to support our long-term needs regardless of vendor(s)
Lead the Master Data team and processes including creation of an automated data quality framework with an emphasis on achieving strong governance and support for data stewardship
Drive Data Warehouse development including
All aspects of schema design and data modeling
ETL process definition and creation
Prototyping, analysis, design, development, testing, documentation, and training other team members
Design optimization
Drive BI/Portal development
Ensure our current environment continues to work and meet business needs; primarily focused on the SSAS. As needed
Optimize, enhance and maintain SSAS cubes
Optimize, enhance and maintain SSRS reports
Maintain and update SSIS ETL processes supporting the reporting environment
Support of business team with ad hoc queries for analysis and reporting
Expert knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems
Knowledge of Business Intelligence and Data Warehousing concepts and proven experience delivering both
Expert knowledge of ETL concepts, development, and experience
Demonstrated ability to architect BI environments including sizing and capacity planning
Solid understanding of systems engineering in relation to creating a high performance BI architecture which will efficiently use CPU, memory, storage, caching, IO, etc
Extensive knowledge of and experience with Microsoft tools (SSAS, MDX, SSIS, SSRS, etc.)
Demonstrated understanding of multidimensional database design and architecture
Strong understanding of and experience delivering under the Kimball Methodology, Star Schemas, Slowly changing dimensions
Ability to lead a high performance team and guide newer developers
Bilingual English/Spanish – Excellent written and oral communication skills in English and Spanish
8+ years BI and data management experience delivering and driving enterprise data management and services including Master data, Metadata, Data architecture, Data Warehousing, Data analytics, data governance and data quality
Significant experience with design, development, and maintenance of SQL Server Enterprise level data systems
6+ years of experience with

Data Warehouse Architect Resume Examples & Samples

Supporting and strengthening the capacity of the Ministry of Health (MoH) and other partner public health institutions to continue to develop, maintain, and sustain the national data warehouse
Providing strategic technical leadership in selecting information technologies that are appropriate and locally sustainable in the Zambian context
Conducting requirements gathering for data warehouse design and composition with the focus on users’ requirements for reporting and analysis
Designing and developing the data warehouse that aggregates HIV/AIDs and other health data from a variety of sources
Developing and implementing electronic data exchange standards from patient- to aggregate-level data systems
Developing and implementing data marts for key health program areas for HIV/AIDS and other services
University degree in information systems, systems/business analysis or business and management
At least 6 years demonstrated experience in database and data warehouse design and development for U.S. Government-funded projects, other internationally funded programs, Zambian NGOs, or private sector
Strong knowledge and experience in data warehouse principles and technology
Experience with business process analysis, workflow, requirements specification development, and data modeling
Strong knowledge and experience with data extract, transform, and load (ETL) principles, methods, and technology, and the use of application programming interfaces (APIs) for electronic data transfer
Knowledge of DHIS 2 data structures, data export capabilities, and API desired
Experience with software quality assurance and software development methodologies
Experience developing data warehouse standard operating policies and procedures
Experience with information systems organizational development including capacity building plans, and job description development
Demonstrated ability to transfer technical skills through mentoring
Strong oral and written communication skills in English required, including evidence of quality report writing and presentations
Experience in large scale government health, education or governance systems analysis with a strong focus on business process assessment
Demonstrated ability to meet deadlines with quality products
Strong organizational and interpersonal skills
Ability to collaborate and share ideas

Data Warehouse Architect Resume Examples & Samples

8+ years hands-on data warehousing / data modeling experience
4+ years experience writing ETL mapping specifications
Experience with data quality management and metadata management
Experience with credit reporting and analytics highly desired

Data Warehouse Architect Resume Examples & Samples

Work with Product Managers as well as consulting and customer technical team to research/gather/analyze business requirements and competitive offerings
Lead global development teams through the full development lifecycle and ensure the OUA product meets the market/customer’s expectations
Design and develop data warehouse architecture, data modeling/conversion solutions, and ETL mapping solutions within structured data warehouse environments
Define best practices for data loading and extraction and ensure architectural alignment of the designs and development
Develop reporting applications and data warehouse consistency
Develop market-leading utility Business Intelligence dashboards
Develop product-based performance and scalability options to meet customer enterprise requirements
Write technical design documents, supervise full product design and implement consistent development processes throughout the implementation lifecycle
Facilitate and participate in design/code/test walkthroughs/reviews with Product Development and Quality Assurance teams
Establish quality processes to deliver a stable and reliable solution
Provide technical leadership in resolving internal or external customer issues
Write product release notes, feature/function documents, white papers, and other documents in support of sales and marketing
Provide guidance on structure and content of product documentation, and review for quality
Provide assistance to sales (gathering feedback from the field, helping prepare standard sales tools, helping respond to RFP's and involvement in sales demonstrations)
Prefer a BS degree with at least ten years of experience designing and/or developing Business Intelligence / Data Warehousing solutions
Highly technical and analytical, possessing significant experience in software development and/or IT implementation/consulting experience
Demonstrated knowledge of Data Warehousing / Data Mining standards and best practices
Demonstrated knowledge of Business Intelligence and Analytics concepts
Demonstrated knowledge of relational database design and dimensional modeling
Knowledge of modern Web Services standards
Experience in code migration, database change management and data management through various stages of the development life cycle
Experience with PL/SQL and Oracle Databases as well as ETL processes
Ability to write and optimize complex SQL queries, procedures and functions
Some experience with and knowledge of the J2EE architecture
Some experience with and knowledge of Oracle Spatial, Map Viewer, Golden Gate, Data Integrator & OBIEE/OBIA
Some experience with and knowledge of web-based application designs
Some experience with and knowledge of optimizing database performance and capacity utilization to provide high availability and redundancy
Strong IT skills and a programming aptitude
Experience in the utility and/or telecom industries is a plus
Experience with cloud-based data warehouse solutions is a plus
Quick learner, self starter and self motivator
Ability to present confidently in front of a group (internal or customer)
Proficient at use of Microsoft Office products including Word and PowerPoint
Team player, with strong emphasis on knowledge sharing (heart of a teacher)
Strong verbal and written communications skills are preferred, as well as the ability to work effectively across internal and external organizations and virtual/global teams

Data Warehouse Architect Resume Examples & Samples

Feasibility analysis and effort estimation of new project requests
Effort estimation, technical specification, development and documentation in the area of the AIMS DWH
Data Modelling Expert in a Dimensional Data Warehouse
SAP Data Services - Expert Level

Senior Data Warehouse Architect Resume Examples & Samples

Applies broad knowledge of technology options, technology platforms, design techniques and approaches to design an integrated, quality Data Mart to address the business requirements
Meets and collaborates with business users on requirements, objectives and measures
Designs the technology infrastructure across all technical environments
Ensures completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
Designs and plans for the integration of all data mart technical components
Ensures the technical implementation of the data mart
Provides input and recommendations on technical issues to the project manager
Reviews and participate in testing of the data design, tool design, data extracts/transforms
Builds creative and elegant solutions to complex technical problems and real world challenges
Has willingness to own all stages of development process: requirements, design, implementation, testing, and operational support
Has ability to create and manage work plans, timelines and accommodate multiple priorities
10+ years experience with and detailed knowledge of data warehouse technical architectures, infrastructure components, ETL, reporting/analytic tools and environments, data models etc
3+ years experience in architecting data warehouse or data mart solutions and integrating technical components
5+ years experience with relational and star schema data modeling concepts
Experience in relational database concepts with a solid knowledge of SQL and PL/SQL
Strong ability to interact, communicate, present and influence within multiple levels of the organization

Data Warehouse Architect Resume Examples & Samples

Online marketing and distribution of tee times
Web hosting, development and customer management solutions
Revenue optimization, database expansion and other course products
Design database schemata based on data modeling of business requirements and entities
Document schema design in E-R diagrams using MS Visio and maintain data dictionaries for all tables
Write new stored procedures, functions, views, triggers, constraints, etc
Review SQL code written by application developers to ensure compliance to coding standards and best practices
Create deployment and rollback scripts for all database objects manually or auto-generated
Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries
Troubleshoot performance problems and propose short term fixes and long term solutions
Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer
Create OLTP real time reports using SSRS
6 years of hands on SQL Server development experience
Expert knowledge of all aspects of SQL Server 2005/2008 Transact SQL
Extensive experience in SQL performance analysis and optimization (query plans, hints, perf tests, etc)
Advanced understanding of SQL Server concurrency features, transactions, and locking
Excellent data modeling and schema design skills, including normalization and de-normalization
Strong experience with SQL Server debugging and tracing
In-depth knowledge and hands-on experience developing, deploying, and maintaining substantial SSIS packages
Experience using full text search and XML in SQL Server
Full grasp of the pros and cons of table partitioning and distributed partitioned views
Basic SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc
Strong understanding of SQL Server high availability and disaster recovery technologies, such as backups and restores, log shipping, mirroring, and replication
Strong familiarity with data access technologies and protocols, such as ODBC, OLEDB, ADO.NET, LINQ to SQL, Entity Framework, JDBC, Hibernate/NHibernate, etc
Strong familiarity with SQL Server Service Broker, MS Sync Framework, and Master Data Service
Strong familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies
Strong familiarity with .NET, C#, and CLR objects
Bachelor degree, preferably in Computer Science or equivalent
Experience using Visual Studio for Database Professional (2008 or 2010) to maintain source control and deployment scripts of all DB objects highly preferred

Data Warehouse Architect Resume Examples & Samples

Requires an active DoD Secret clearance
Serve as technical lead on Health Services Data Warehouse (HSDW) team
Manage, mentor and develop development resources and provide project related directions team
8+ experience in systems analysis, data analysis, software design, or a combination of roles within SDLC lifecycle
5+ years of recent and hands-on data management and BI experience with Informatica ETL toolset and SQL Server environments
5+ years of experience as a SDLC functional lead (development lead, lead system analyst, solution architect, tech lead etc.)
5+ years of experience working in a matrixed business/technical enablement organization
Experience with Data Modeling techniques, database design and business intelligence tools
Extensive knowledge of relational databases principles and structures
Experience with additional industry standard ETL tools (Pentaho etc.)
Experience and familiarity with healthcare measurement and delivery
Advanced degree in Computer Science, Business, or IT
Exposure to big data platforms (Hadoop, MS PDW, and other platforms and appliances etc.)
Experience in Cloud Data Warehouse Solutions
Experience in Data Virtualization
Typically requires bachelor’s degree or equivalent, and ten to twelve years of related experience

Data Warehouse Architect Resume Examples & Samples

Must be able to work with Business Customers, Section Managers, Project Managers, Business Analysts and Subject Matter Experts (SMEs) in a professional and collaborative manner to design strategies and implementation approaches
Must be able to work with the Data Warehouse, Database Administration, and Business Intelligence Teams in a professional and collaborative manner to ensure that data models comply with organizational standards
Must prepare all required artifacts accurately and in a timely fashion
Must possess strong written, verbal, and interpersonal communication skills
Must be able to develop processes and procedures for Data Warehouse and Business Intelligence infrastructure
Must be able to work independently in a team environment with local and remote teams
Must possess knowledge of project management methodologies both traditional and Agile/Scrum
Must possess problem-solving skills and ability to multi-task with readiness to put in extra efforts when necessary
Must perform work as assigned without direct supervision
Candidate may have to work evenings or weekends in order to meet business needs and or deadlines

Data Warehouse Architect / Team Lead Resume Examples & Samples

Ensure that data management methodologies include the steps, activities, and deliverables required to consistently achieve high quality data
Ensure that the applications adhere to defined data management practices, policies and procedures
Coordinate with and support ETL processes and practices in a high availability VLDB data warehousing and data mart environments
Plan and coordinate API, and database roll-outs with project team members, development and database engineers
Understanding of API based integration solutions which may consist of transactional/real-time integrations, workflow processes, and related functions and various scripting tasks
5-7 years of extensive hands-on experience with designing, developing, and ongoing support of a data warehouse environments
3-5 years of deep understand of Kimball dimensional modeling, OLTP and OLAP database designs and implementation strategies
3-5 years of practical hands-on experience with Business Objects Data Integrator and reporting platform
3-5 years of experience with metadata based API processes, and the design and implementation of metadata driven solutions
3 years of familiarity with ETL tools such as SAP Data Services. Microsoft SSIS/DTS, Data Stage, Informatica
3 years of familiarity with API based integration tools such as Mulesoft, Snaplogic, Cast Iron, etc
Familiarity with Agile methodologies such as Scrum or Kanban and working in an iterative delivery model
Strong customer relations and ability to deliver business value with technical excellence
Understanding of in-memory, highly parallel, columnar based data platforms
Understanding of Data Lakes, Hadoop

Data Warehouse Architect Resume Examples & Samples

12+ year’s experience in information technology with over 10+ experience in thought leadership and development experience in Business Intelligence/Data Warehouses
Experience working closely with users on BI projects/programs
Experience managing Data Mart/DW development
Expertise in prototyping applications and gathering/facilitating requirements sessions
Experience in BI migration and transformation projects
OBIEE 11g experience including OBIEE Migration
Thorough knowledge and experience in ETL/BI tools and large database technologies
Experience working in Banking vertical
Proven leadership skills - leading 10+ onshore and offshore resources
Excellent communication and stakeholder management skills
ETL

Data Warehouse Architect Resume Examples & Samples

Define data integration process and collaborate with Business analyst for various project needs
Develop, test, and integrate code for existing data warehouse development in compliance with firm-wide data management principles and security controls
Establish and promote design guidelines, best practices and standards
Develop and maintain controls on data quality and process
Make recommendations, based on data profiling and data analysis, for changes to existing systems
Document data integration strategies for data flows between disparate source/target systems for data warehouse
Support production process in NY and London
7+ years hands-on development experience in SQL Server 2012/2014 Integration Service (SSIS) development, scripting development, error checking, performance tuning, job scheduling, and deployment methodology
7 + years of experience in SQL Server 2012/2014 database development such as SQL, XML, function, procedure, indexes, table partition, and query optimization
7+ years of experience in large complex 1TB + data warehouse environment and strong knowledge in ETL and data warehouse methodology
Deep understanding in full Microsoft BI stack and future roadmap
Deep understanding on enterprise data management and governance design approach
Understanding of project development life cycle
Experience in scheduling tool such as Autosys
Experience in C#, ASP.net, Javascript
Experience in SQL Server Data Quality and Profiling is a plus
Experience in regulatory reporting is a plus
Ability to analyze data, support testing process, communicate with business users and implement multiple projects independently
Understanding of enterprise data integration framework and approaches from multiple data sources
Advanced skills and experience with data modeling and dimensional modeling techniques and approaches
Understanding of modern data warehouse design

Data Warehouse Architect Resume Examples & Samples

Lead the planning and delivering of multiple projects
Create project plans, milestones, and execution
Deliver projects/work on-time, on-budget, and in a way that accomplishes client goals
Able to work on simultaneous part-time clients without sacrificing client service
Manage, lead, and mentor the consultants in the data services team of the Business Intelligence & Analytics practice
Foster relationships and nurture partnerships with data management partners
Assist in the sales and marketing functions of the practice as they relate to data services
Provide thought leadership, create white-papers, speak at conferences, and other activities that help market data services in the industry
Work with data warehouse and data integration teams to ensure successful delivery of enterprise data warehouse solutions
Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work
Prepare and present ideas and recommendations to colleagues and management
Hands-on development, architecture and expertise of the Informatica product suite
Document systems through data models, data definitions and naming conventions
Speak effectively before groups of business and IT personnel
Bachelor’s degree in Business, Computer Science, Management Information Systems, Engineering or a related field
10+ years of business/technology work experience
5+ years of hands-on experience implementing data management solutions
Working knowledge of BI architecture, data warehousing concepts, and data integration best practices
Working knowledge of the all components of the Informatica product architecture
Knowledge and experience with Big Data solutions a plus
High level of SQL language proficiency with SQL Server, Oracle, Teradata, and other database management systems
Understands and can navigate complex multi-dimensional source data business systems
Must be able to travel to client locations
Motivated, demonstrates initiative and leadership
Able to critically think and be solution-oriented
Strong interpersonal skills and able to work easily with client personnel
Works well independently and within a team
Great organizational, time management and problem-solving skills
Able to work in fast-paced environment
Possesses a professional demeanor

Data Warehouse Architect Resume Examples & Samples

Support of 9 out of 10 technology mergers in Poland
Facilitation of 80% of mobile calls in Poland by systems implemented by Accenture
Most complex IT transformations in Poland
60% of current accounts in Polish banks work on systems implemented by Accenture
Higher degree in Management / Computer Science / Econometrics,
Minimum 3 years of experience with design and implementation of data warehouses, management information systems, operational data stores including relational and multi-dimensional data modelling; and esign and implementation of ETL processes
Solid knowledge of one or more of the leading RDBMS platforms (e.g.. Oracle, Teradata, DB2, MS SQL Server)
Excellent command of SQL
Extensive knowledge of one or more leading ETL tools (e.g. Informatica PowerCenter, IBM Data Stage, Oracle Data Integrator, SAS Data Integration Studio, Business Objects Data Integrator, Microsoft SQL Server Integration Services)
Knowledge of banking services business model, products and value drivers
Strong problem-solving skills combined with the ability to creatively untangle complex issues and develop innovative and efficient solutions within a narrow time frame

Data Warehouse Architect Resume Examples & Samples

Adapts existing methods and procedures to create possible alternative solutions to moderately complex problems
Understands the strategic direction set by senior management as it relates to team goals
Minimum of Bachelor's Degree required in related field
Familiarity with Cognos and SAS would be an asset
Experience to support ETL and Data Warehouse for the Application Outsourcing Transition and Run for the client Enterprise Wide Digital Strategy EWDS
Reliability Security Clearance
Required technical experience in SQL Server
Experience in discipline of data warehouse

EIM Data Warehouse Architect Resume Examples & Samples

Bachelor’s Degree in Statistics, QBA, Business, or Computer Science
Five (5+) years of enterprise-level data warehouse development experience, specifically with Business Intelligence (BI)
Proven track record in delivering large scale, complex ETL, data mart/warehouse, and business intelligence projects
Broad knowledge of BI toolsets including IBM TM1, Cognos, Microsoft SQL Server

Data Warehouse Architect Resume Examples & Samples

Design, develop, test, modify, and manage Ciber’s data warehouse
Clean, consolidate and organize available data
Work across departments to gather requirements and determine project scope and limitations
Design logical and physical database models for Data Warehouse
Design and implement ETL procedures for intake of data from both internal and external sources; ensure data is verified and quality checked
Ensure implementation of ETL process and data architecture are properly functioning from sources through user dashboard
Specify user access and access levels for each segment of the database
Implement security measures to safeguard information against accidental or unauthorized damage, modification, or disclosure
Develop standards, guidelines and technical documentation
Identify and evaluate industry trends in database systems as a source of information
Work with business analysts to mine needed data for people across the organization
Bachelor or advance Degree in CS, Mathematics, MIS, or similar
5+ years’ experience performing data warehouse architecture, development, management, modification, and support
4+ years’ experience with Microsoft SQL Server - SSIS, SSAS, and SSRS
2+ years' experience with star schemas
Experience integrating with REST & SOAP endpoints
Experience modeling Reoccurring Revenue products
Working knowledge of PowerBI
Strong analytical and consultative experience
Experience with Microsoft Azure services
Experience with products sold in multiple currencies
Experience with CRM Dynamics
Experience with C#

Data Warehouse Architect Resume Examples & Samples

Business process analysis and data modeling / analysis
Data warehouse loading/operations techniques and methodology
Requirements gathering and analysis
Expert in SQL and proficiency in PL/SQL
Solid understanding of Informatica, Oracle database capabilities & functionality
Basic understanding of *NIX/AIX operating systems
Oracle Business Intelligence (OBIEE) or equivalent report and dashboard writing experience
Proficiency with Oracle eBusiness Suite -- functionality and table structure
Actively seeks to understand new technologies affecting the data warehouse
Understands agile approaches to Data Warehouse design and development
Worked on data warehouse & end user reporting projects with diverse internal and external data sources
Proficiency with query, reporting and OLAP Tools (e.g. Business Objects, Cognos, Oracle Business Intelligence, SSRS, Tabeau, Qlik)
Proficiency with relational database technology (e.g. Oracle and MS SQL RDBMS)
Worked on projects that utilized a major ERP software system (e.g. Oracle eBusiness Suite, MS Dynamics, SAP, Peoplesoft)
4+ years relevant experience

Data Warehouse Architect Resume Examples & Samples

Creating star schema data models, performing extract, transform and load (ETL) and validating results with business representatives
Support design for all metadata according to various ETL processes
Supporting implemented Business Intelligence solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
Perform troubleshoot on all ETL processes and resolve issues effectively
Prepare appropriate status reports and submit it to management
Analyze all data warehouse architecture goals and identify skill requirement for same
Develop both physical and logical data models
Prepare designs for database systems and recommend improvements for performance
Maintain and develop various database scripts and tools to facilitate automation process
Provide support to all data warehouse initiatives
Analyze all data warehouse activities and identify key resources for same
Design various ETL processes and perform tests on data
Monitor processes and develop plans to capture and access all metadata
Develop and implement various work plans for projects
Evaluate all proposals requests and assist to improve structure of data warehouse
Contributes in a leadership capacity to advance the project team and its effectiveness
Shares knowledge capital and proactively identifies issues with client or within team that need to be addressed
Contributes to team performance by providing key stakeholders with direction and critical knowledge to help drive best outcome for overall IT strategy
Documents all work as part of client deliverables, consistently using a professional documentation approach throughout span of engagement and beyond, resulting in high quality materials for internal and external usage
Monitors industry trends and identifies policies or requirements to ensure enterprise data warehouse fits with government and industry directions for technology. Then consults with clients on the requirements and oversees the direction of the architecture
Effectively communicates to clients about current and future domain functionality
Responsible for contributing to the development and mentoring of Business Intelligence and Clinical Analytics
Performs other responsibilities as needed
Familiar with common technologies for data warehousing and extract, transform and load (ETL) methodologies
Project Management experience to support project lifecycle work
Strong mentoring skills
Demonstrated ability to work within a team environment
Demonstrated ability to work with diverse groups and difficult customers
Ability to work on multiple projects simultaneously
Extensive computer skills, including Microsoft Office suite
Ability to sit and view computer monitors or other monitoring devices for a prolonged period of time
Ensure the quality, completeness, security, privacy, and integrity of data throughout the data lifecycle
Bachelor's Degree in Computer Science, Computer Engineering, Information Technology or other degree with significant related IT and leadership experience
1+ years of experience in healthcare and/or sciences
Deep experience in information systems, or related field (e.g. statistics, mathematics, physics)
Ability to work on a flexible schedule and overtime and/or irregular hours when needed
Must be able to travel up to 10%
Must reside in the greater Washington D.C. Metropolitan area
3 years of experience with database tools, application development, or health information standards
Working knowledge of Business Objects, PowerInsight Explorer, Tableau, Hadoop and Vertica

Data Warehouse Architect Resume Examples & Samples

Develop Data Warehouse, Data Integration and Business Intelligence requirements
Create Detailed Scope for the Data Warehouse Modernization
Project and create smaller, business domain specific phases based on business priorities (such as marketing, finance, HR, etc.)
Define MS-Azure based architecture for next generation Data Warehouse, Data Lakes and Data Integration
Develop and Implement Data Warehouse, Data Lakes and associated Data Integration Processes
Provide an the end-to-end solution for assigned projects
Conduct Knowledge Transfer Sessions
Develop Technical Documentation using documentation templates for the Data Warehouse, Data Lake, Data Integration and other components of the Technical Solution
Minimum of five (5) years of experience as a dedicated Data Warehouse Architect, with expertise in Designing and Developing Data Models for Enterprise Data Warehouses is required. The Models would include Dimensional Modeling (Star, Snowflake and Hybrid), and Data Lakes for in Cloud and on Premise implementations
Minimum of five (5) years of working experience with complex TSQL, or a mix of TSQL and PL/SQL required
Minimum of two (2) years of working experience with complex SSIS, SSAS, and some experience with SSRS/Power BI is required
Minimum of two (2) years of working experience at the Database level, designing Stored Procedures, Triggers, Tables, Extensions, and other data loading mechanisms
Solid communication skills, team work and ability to work with business and IT teams is a must
Minimum of two (2) years of prior experience with Data Quality / MDM or Data Governance related projects
Strong understanding of Graph and Unstructured storage systems, Data Lakes and associated methodologies
Prior experience in the education domain would be preferred
Minimum of two (2) years of working experience with Agile methodology

Data Warehouse Architect Resume Examples & Samples

Data integration (ETL), data quality, EDW data modeling, EDW data design and architecting, Metadata standards and BI system administration
Map the current data structure to the future state with a realistic transition plan and road map that integrates with the strategic objectives of the company
Drive an agile-based approach to implementing data services and solutions to deliver value rapidly and evolve to the future state
Perform detailed data requirements analyses, design and implementation of complex data models
Design, direct and implement ETL processes, including data capture, data quality, testing and validation methods
Leads architecture governance activities related to BI and Analytics including participation in data governance board (as required) and technology architecture review (as required)
Building innovative data management, real-time, and predictive analytic capabilities
Own and assist in data model documentation, data dictionary, data flow, data mapping and other MDM and Data Governance documentation
Provide analysis, recommendations, and influence to overall strategy and roadmap to build data warehouse environment and supporting toolsets
Bachelor’s degree in computer science, information systems or engineering or equivalent technology domain experience
10+ years of experience in designing/leading the conceptual, logical and physical design for distributed databases (OLAP, OLTP)
5+ years of experience in driving the Meta data architecture and master data management (MDM) solutions
5+ years of experience in performing analysis and high-level design for data management projects
Experience with SQL DBMSs, Big Data/Hadoop/NoSQL, Visualization and reporting tools, data profiling analysis and transformation,
Strong understanding of activities within primary discipline such as Master Data management (MDM), Metadata Management and Data Governance
Consistently demonstrate strong experience in Conceptual, Logical, and Physical Database architectures, design patterns, best practices, and programming techniques around relational modeling, dimensional modeling and data integration
Strong Business and Data Analysis skills
Demonstrate excellent verbal and written communication skills
Demonstrate exemplary teamwork skills as well as excellent interpersonal skills
Strong leadership and influence skills across Business and Technology organizations
Must be a self-starter and should be able to initiate, prioritize, and complete assignments with little to no supervision
Ability to consistently deliver accurate effort estimates for work

Data Warehouse Architect Resume Examples & Samples

Develop and maintain existing stored procedures and ETL packages
Develop and maintain job execution plans with Enterprise Job Scheduler
Monitor job and FTP queues to ensure they are functioning as expected
Provide business users data require for metrics and analysis
Develop new SPs, SSIS/SSRS packages to meet business needs
Provide application technical support for SQL based applications
Tune SQL and ETL for reliability and performance
Provide support in the consolidation of Oracle and SQL based tools
4 or more years of related experience
Experience with SAP Business Objects Data Services
Experience with Crystal Reports, WebI Dashboards, Xcelsius, SDK or CMC
Experience with Oracle OBIEE
Experience with Hadoops
Prior experience with data visualization tools such as Tableau
Experience documenting work products, processes, checklists and best practices relating to ETL and reporting
Solid understanding of Master Data Management
Experience in transaction or the banking industry

Data Warehouse Architect Resume Examples & Samples

Experience working with analytical models or techniques and the ability to apply these methods to solve business problems
Experience working with statistical and data visualization tools and techniques
Experience in structured problem-solving
Strong project and people management skills
Advanced Microsoft SharePoint, PowerPivot, SQL Server Reporting Services and Excel skills
Demonstrates significant experience working with large scale data warehouses, database, storage, collection and aggregation models, techniques and technologies, with the ability to apply such methods to solve business problems
Experience working with statistical and data visualization tools and techniques and knowledge of Kimball and/or Inmon methodology
Played a role of a data warehouse and analytics architect leading projects with 4+ team members
Demonstrated experience of working with business stakeholders
Must possess excellent communication and presentation skills
Experience in structured problem solving assignments and strong project management and people management skills - Excel, PowerBI, PowerPivot, SQL Server, SQL Server Analytics Services, SQL Server Reporting Services (SSRS) SQL Server Integration Services(SSIS), and SharePoint
Preference would be given to candidates with experience in one more of the following; Azure Data Factory, Stream Analytics, Azure IoT Hub, Hadoop, and Azure Data Warehouse

Data Warehouse Architect / Senior Resume Examples & Samples

Responsible for data warehousing, data modeling and ODI ETL development and deployment
Defines and develops physical and logical data models to support departmental and functional reporting needs
Responsible for front-end development, metadata and ETL specification to support business requirements for reporting across the organization
Provides OBIEE reports and/or dashboard development or the ability to translate reporting requirements to report developers for implementation
Develops mappings/interfaces, packages, procedures and scheduled jobs
Creates, maintains, and manages documentation for all data warehouse and reporting development efforts
Helps to create and implement a long term storage and business continuity strategy including backup & recovery and data storage and archiving
Designs, sets up and maintains both Production and Non-Production environments
Troubleshoots Production issues, identifies root cause and migrate fixes
Collaborates with the business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solutions
Develops reporting standards and best practices to ensure data standardization and consistency
Performs data cleansing and data auditing as necessary to ensure data quality
Assists with documentation and training development for new process/tool rollouts
5 or more years’ experience with data modeling and data analysis experience with the following tools: Oracle Business Intelligence Enterprise Edition (OBIEE), SQL, Server Reporting Service, Excel or IBM Cognos
Background and experience in Master Data Management
Experience with relational and hierarchical database structures
Background and experience in predictive analytics, trending, and forecasting in Payments Processing industry
Statistical process control, analysis of variance, predictive modeling, operational research and blending business background context with statistical information experience
Strategic and creative thinker with an ability to apply advanced analytics approaches to help support and grow business objectives and priorities
Knowledge of process improvement methodologies and software development methodologies

Data Warehouse Architect Resume Examples & Samples

Understand the company’s business goals, IT plans, and architectures and articulate linkage to the proposed data warehouse architecture and application designs
Design and develop the architecture, roadmap, and standards for the enterprise data warehouse ecosystem that will align with Teradata’s business and IT objectives
Design and develop a technical architecture for integration of the data warehouse and analytic ecosystem into the company’s enterprise
Be a trusted advisor to the DW&BIS Program by establishing credibility and expertise in data warehouse technology and Teradata’s solution offerings
Work with Teradata IT project managers and/or solution providers to scope projects and develop statements of work, project plans, and risk assessments
Provide technical thought leadership and actively participate in the design, implementation, and roll-out efforts of new ecosystem components
Make hardware sizing and configuration recommendations
Participate actively in the management of technology providers
Establish effective working relationships with Teradata Product Development, Teradata Alliance Management, Teradata Technology Partners, and Teradata technology vendors
In depth knowledge of new techniques, models, processes, methodologies, and plans within architecture disciplines
Excellent understanding of industry standards and technology trends
Integrates subject matter and industry expertise within a defined area – leveraging Teradata SME’s in company’s consulting organization, as well as external consultants when needed
Develop and maintain strong working relationships with technology providers of the Data Warehouse program
Strong presentation skills required
Strong MS Office skills required
Experience with the ERwin data modeling tool a plus
SQL and Analytic Skills
Hands on experience with relational DBMS, with Teradata experience desired
Good understanding of ETL processes and ETL best practices
Experience/ familiarity with Business Intelligence tools
Familiarity with Hadoop, Aster and Big Data technologies a plus
Excellent teaming and communication skills
Strong consultative, facilitation and consensus building skills
Bachelor’s Degree in Management Information Systems, Computer Science, Computer Information Systems, or equivalent Information Technology discipline
Master’s Degree in MIS, MBA or Data Warehousing / Business Intelligence preferred
15+ years of related Information Technology Management or Data Warehousing – experience with Teradata and/or Teradata Partner products a plus
Our total compensation approach includes a competitive base salary, 401(k), strong work/family programs, and medical, dental and disability coverage

Data Warehouse Architect Resume Examples & Samples

Experience with both Oracle and SQL Server databases
Extensive experience designing, implementing and deploying into production an enterprise data warehouse
Experience understanding data users and data consumers, both system consumers as well as user groups
Experience complying with governmental agency and federal security reporting policies and best practices
Experience designing security at both the schema level and the accessibility level in conjunction with the DBAs
Extensive experience collaborating with the application architects, functional architects, infrastructure architects and database architects
Extensive experience defining data standards and creating data models
Experience in designing and implementing data warehouse for optimal performance and low process overhead
Extensive experience tuning ELT and reporting processes
Experience working with government agencies is required
Experience in both strategic design of data warehouse & the ability to implement the strategy
Excellent communication skills and hands on experience working with the database & warehouse teams

Senior Engineer, Data Warehouse Architect Resume Examples & Samples

As an engineer, the incumbent would be responsible for evaluating, developing, maintaining and testing BI solutions for various analytics projects
Be responsible for building data warehouses, data marts & OLAP solutions
Plan, create, coordinate, and deploy data warehouse and business intelligence solutions
Create best practices for data loading and extraction (ETL framework)
Develop data architecture, data modeling, and ETL mapping solutions and data warehouse consistency
Would have a strong focus on collecting, parsing, managing, analyzing and visualizing large sets of data to turn information into insights using multiple platforms
6+ years of experience as a Data Warehouse Architect / Developer and SQL server
4+ years of data modeling experience, and knowledge of 3NF, Star-Schema and other data
6 + years of experience working in SQL Server, SSIS and SSAS or SSRS
Ability to work with multiple data sources
Ability to develop, execute and analyze Multidimensional expressions (MDX) and DMX queries
Ability to quickly create Analysis Service objects like data source views, dimensions and cubes and do enhancements to existing objects
Experience creating Tabular models is an advantage
Proven ability with SQL Server database design best practices and performance tuning
Demonstrated solid understanding of Data Warehouse design theory, including dimensional data modeling
Significant experience developing logical / physical dimensional models, OLAP processes
Proven ability using SQL Server 2012 (or 2014), SSIS Packages, Procedures, Functions, SQL, and other SQL Server Database Objects
Proven individual contributor and team player with effective communication skills
Experience working collaboratively with Stakeholders, Business Analysts, Project Managers, Designers and DBAs with the common goal of delivering value to the business

Data Warehouse Architect Resume Examples & Samples

5+ years of experience leading DWH implementation efforts
ETL and DWH knowledge
Experience of working on large projects / large and complex systems
Oracle DBA experience Knowledge of Microsoft SQL Server and Microsoft Azure technologies
Hadoop and Big Data experience
Experience with IBM Cognos BI or other business intelligence tools
Knowledge of Agile and iterative methodologies like SCRUM, KANBAN
Experience with UML modelling and business systems analysis (Enterprise Architect)
Experience with in-memory databases, NoSQL, unstructured data processing
At least 7 years of experience in IT industry
At least 5 years of experience as senior DWH developer
English written, spoken level B1

Data Warehouse Architect Resume Examples & Samples

10+ years hands on experience with designing and implementing data warehouse systems
2+ years hands on experience in big data platform (Hadoop, Spark, Hive)
Familiar with programming languages like Java/Python/Scala
Understanding of architectural principles and design patterns for Data Warehouse using frameworks such as Hadoop, Spark, Hive and/or AWS
Knowledge of technical solutions, design patterns, and code deployment for applications in Hadoop and/or AWS
Technology leader in Big data & Cloud platform technologies
Experience building data pipelines and analytics systems on distributed data systems and Cloud, on a large scale in an e-commerce company
Experience building batch, real-time and streaming analytics pipelines with data from various OLTP DBs, event data streams, 3rd party feeds, NoSQL and APIs
Experience with batch & stream processing technologies such Spark, KStreams, Samza etc
Familiar with Clickstream data & analytics
Ability to thrive in a fast-paced environment, and the passion to make a difference

Data Warehouse Architect Resume Examples & Samples

5+ years strong experience in database and data warehousing concepts and techniques. Must understand: relational and dimensional modeling, star/snowflake schema design, BI, Data Warehouse operating environments and related technologies, and ETL, MDM, and data governance practices
Ability to complete the full lifecycle of software development and deliver on time
Ability to work with end-users to gather requirements and convert them to working documents
Strong interpersonal skills, including a positive, solution-oriented attitude
Must be passionate, flexible and innovative in utilizing the tools, their experience, and any other resources, to effectively deliver to very challenging and always changing business requirements with continuous success

Data Warehouse Architect Lead Resume Examples & Samples

Provide Data Warehouse / ETL technical leadership and architect support for IDR enhancements
Provide technical direction to the IDR ETL team
Provides strategic vision regarding the technologies, tools, and processes on a large scale healthcare data warehouse project
Provides oversight and leadership to teams of Developers and Testers to ensure tools, technologies, and processes are implemented in accordance with customer requirements and needs, serves as a key member of project leadership to develop strategic vision for the data warehouse, to assess and recommend improvements and innovations, and to interface with data warehouse clients
Supports capture and proposal efforts to secure new or re-compete contracts, or task order business by developing technical solutions for capture strategy and proposal responses
Contribute to the design, development and implementation of short- and long-term technical solutions through new and existing applications, systems architecture, network systems and applications infrastructure
This shall be considered a KEY position
BS or equivalent + 14 yrs related experience, or MS + 12 yrs related experience

Data Warehouse Architect Resume Examples & Samples

Experience in professional consulting, business intelligence, reporting, metrics development, business process analysis, planning, and new services development
Experience in dimensional data modeling based on transactional systems in production preferably in a contact or call center environment
Proven demonstration of an entrepreneurial mind-set
The ability to execute with efficiency and with quality
Exceptional communication skills with a focus on collaboration across different organizations and a proven history of effecting positive change in work environments
Extensive experience in leadership, consulting, including discovery, solutions definition, strategy, executive presentations, facilitation, documentation, implementation, business process modeling, change management, re-engineering, complex problem solving, technology, analysis and evaluation
Strong understanding of technologies including; enterprise wide systems, web technologies, content management, document management, identity and access management, data warehousing, reporting, dashboards, scorecards
Demonstrated professionalism, both in appearance and conduct
Education or experience equivalent to a four year college degree is required
Seven or more years of professional work history of successful software design and utilization of latest technologies in Microsoft Visual Studio and Business Intelligence; Microsoft’s SQL server and Windows Server environment; SSRS, SSIS, and SSAS
Seven or more years of professional Data Analyst & Reporting writing experience supporting enterprise wide healthcare operations & workforce management functions
Seven or more years of experience with creating cubes and using MDX
Demonstrate project management and organizational skills. Must be able to effectively lead and coordinate cross-functional teams to deliver desired results in the time frame required
Travel requirements up to 10%

Data Warehouse Architect Resume Examples & Samples

Lead the design, development and support of Data Warehouse solutions
Develop Conceptual and physical model
Trains and coaches colleagues in best practices with regard to SQL development
Understand and work with multiple data sources to meet business rules and supports analytical needs
Create SSAS cubes and automate processes for analytical needs
Optimize processes involving large data sets to improve performance
Participates in on-going evolution, improvement, and automation of data warehouse solutions
2+ years of experience as data warehouse architect – leading design and deployment
5+ years of experience working directly with data warehouses
5+ years’ experience on SQL Server Integration Services
5+ years’ experience designing, developing, testing, and supporting of ETL, and OLAP cubes
Advanced SQL Server programming and knowledge of data warehousing best practices
The ability to extrapolate database schema to meet the business needs of the application
Experience in the healthcare industry

Data Warehouse Architect Resume Examples & Samples

Develop relationships with application owners and business partners to understand and translate business requirements into data strategies
Develop and implement strategic data management roadmap
Communicate business requests, project status, and data warehouse solution approaches to management on a regular basis
Work closely with Data Warehouse Developers and BI Solution Architect to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data
Develop ETL procedures to acquire, harmonize, and consolidate the organization’s data assets
Monitor and support ETL processes ensuring integrity and proper integration of all data sources
Implement production fixes, support packs, and enhancements; on-call rotation included
Research and resolve data, procedural, and technical issues with a sense of urgency
Proactively identify, communicate, and implement opportunities for data integration and quality improvements
Develop, adopt, and enforce Data Warehouse and ETL standards and architecture
Develop database design and architecture documentation

Data Warehouse Architect Senior Resume Examples & Samples

Knowledge of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions, and ability to leverage that information in creating customized customer solutions
Knowledge of techniques, roles, and responsibilities in providing technical or business guidance to clients, both internal and external; ability to apply this knowledge appropriately to diverse situations
Knowledge and ability to create models and standards to govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations

Data Warehouse Architect Resume Examples & Samples

Identify data pattern in the source, structured and semi structured data, and transform into dimensional modelling and to design the Extract-Transform-Load (ETL) flows to populate the IMW and data marts
Provide technical leadership and best practices in the design, development and deployment of complex ETL
Help clients to extend the standard data model to their need, and be part of client interaction and customer workshops around data modelling
Proven track record of best practice architecture, design, build and support of DWH and data marts, data models and ETL, which are robust and scalable
Well-developed business understanding and requirements
An analytical mindset
Good communication abilities and stakeholder management skills

Remote Data Warehouse Architect Resume Examples & Samples

5+ years of experience working as a Data Warehouse Architect with expertise in designing and developing data models for enterprise data warehouses both in cloud and on premise. (Models would include star, snowflake, and hybrid)
5+ years of experience working with complex TSQL queries, SSIS and SSAS. Some SSRS experience is required. (designing stored procedures, triggers, tables, extensions)
2+ years of experience working with the Agile methodology

Data Warehouse Architect Resume Examples & Samples

Conduct workshops and business interviews as needed and help develop/update the Data Analytics strategy and roadmap
Architect solutions to enable data discovery, self service, enterprise level dashboards and reports
Review current hardware/software, identify gaps and support development of a solution life cycle strategy
Develop the Enterprise Data Warehouse Architecture document, Collaborate with peers in ETL and BI teams to influence ETL and Business Intelligence Architecture
Develop Logical and Physical Data Models
Design the Enterprise Data Warehouse and appropriate Data Marts
Be the key point of contact and subject matter expert of the Data Warehouse for the requirements, ETL, BI and QA teams
Develop detailed documentation and ensure ongoing business process changes are easily integrated into the Data Warehouse
Develop a strong understanding of source systems, reporting, analytic and other information needs

Data Warehouse Architect Resume Examples & Samples

The Data Warehouse Architect will be responsible for interfacing with project leads to understand business requirements and translate these into the technical foundations to support the NorthShore Enterprise Data Warehouse. This person will design structures such as staging areas, integrated data, data marts, cubes and operational data stores. Deliverables will also include data models developed in Erwin. The person in this position acts independently under general direction and may also provide technical consulting on complex projects throughout the organization. Additionally, the person in this position is expected to instruct, direct and perform code reviews of the work of other programming personnel and be responsible for technical QA
4 year college degree in computer science/data processing or equivalent on the job training
6+ years supporting and developing software applications
4+ years of experience as a Data Architect, Data Modeler with a data warehouse (PLSQL\MSSQL database experience is key, DBA experience not required)
Strong dimensional modeling and star schema design skills
Ability to translate business needs into technical design
2+ years Erwin tool experience required
Experience with Informatica PowerCenter
Experience with reporting tools such as Cognos/Tableau is a plus
1+ year of experience with MS Office; MS Project experience is a plus
Familiarity with Healthcare industry is a plus
Experience and detailed understanding of iterative system implementation, programming, integration, data conversion and testing techniques
Strong verbal and written communication, presentation and customer service skills
Ability to solve highly complex technical and operational problems
Programming skills and the ability to maintain and understand complex applications
Support applications that require high availability (7 x 24)

Data Warehouse Architect Resume Examples & Samples

Considerable knowledge and experience in information management, data warehousing and analytics technologies is required
Considerable knowledge and experience with analysis, design, and development of data warehouses working with large data repositories and/or relational databases is required
Considerable knowledge and experience working with business intelligence tools is required
Considerable knowledge and experience working in Oracle and UNIX environments is required. Knowledge and experience working in SQL Server environments is desirable
Demonstrated exceptional analytical skills
Ability to communicate and translate business needs into solutions; to communicate orally and in writing with both technical and non-technical personnel; to communicate effectively with developers, DBAs, information security, business analysts, project managers and different business areas; to provide training on new techniques and solving technical problems; and to establish and maintain an efficient technology environment
High School Diploma or GED and an equivalent combination of training and experience related to the duties of the position required
Graduation from an accredited college/university with major study in Information Systems, Computer Science or related field preferred
ATTENTION: H1-B Visa applicants – Agency practice disallows sponsorship

Data Warehouse Architect Resume Examples & Samples

This individual will be responsible for developing solutions for our internal teams and establishing processes and measurement protocols
Ability to identify organizational and end-user needs and assist in the development of Data Warehouse projects to meet those needs
Build and support scalable and durable data solutions that can enable self-service analytics using SQL server and Oracle
Implement a Data / Business Intelligence roadmap by working with internal partners from various departments
Provide project oversight of timelines, budgets, and resources in support of roadmap, including outsourced vendors
10+ years of experience with data information management-related components of large complex data solutions, developing data integrations using a variety of ETL tools
Strong technical understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data
Experience with driving the execution and implementation of all aspects of data systems including database design, ETL, performance optimization, reporting and analysis tools
Experience with leading the development of Data Warehouse, Data Marts, ETL, and Business Intelligence solutions. Working knowledge of object oriented programming languages, including C# and the .Net Framework
Experience with one or more BI tools such as Tibco Spotfire , SSRS, Tableau, or Business Objects
Prior experience managing technical staff
Prior experience managing large development projects
Bachelor’s Degree in Computer Science or related field or equivalent combination of experience
5 years supervisory experience

Data Warehouse Architect Resume Examples & Samples

Technical planning resource who will need to develop technical strategies and solutions as it relates to data modeling; Extract, Transform and Loads(ETL); master data identification; data warehouse architecture
Working with solution and system architects (peers) to deliver enterprise class database tier solution and/or integration into custom product development
Completes product technical design and prototyping, database design/development, support and problem remediation
Guide technology directions by recommending specific technologies to pursue around the database tier, suggesting training and staff development activities
Understand database design patterns and enterprise design/development for both packaged and custom solutions
Developing and Testing Microsoft Windows based database systems (Windows 2008/2012 Server, SQL Server 2012 and 2014)
Understand technology roadmap and focus on reduction of technical debt around the database stack
Provides both individual, team, and budget-level tasks and product effort estimates/costs
Document technical designs, using flow charts, class diagrams, sequence diagrams, activity diagrams, data flow diagrams, database schemas, descriptive software component documentation, wireframes
Develops and tests Data Warehouse or Business Intelligence applications based on business requirements and industry best practices
Defines departmental and corporate data warehouse and business intelligence standards
10+ years of experience in a large multi-terabyte data warehouse environment including hands on with both design, build and run of those environments. Dimensional data modeling experience required
Enthusiastic learner with ability to communicate to business in terms that brings clarity to the data warehouse and master data framework
Minimum 10 years DB architecture/design with Microsoft SQL
Experience with delivering enterprise solutions leveraging SQL 2008 R2, SQL 2012 and SQL 2014 versions
Experience with SSIS, SSAS and SSRS preferred
Experience with MDM and Data Governance
Data visualization experience
8+ years hands-on experience with enterprise class Database architecture, focused on transactional environments w/focus around SQL 2012/2014; including redundancy modeling (Disaster Avoidance/Recovery), cross data center high availability, always on, horizontal and vertical scalability, and various forms of data movement (log shipping, replication modeling, Always On, etc.)
8+ years specifically at database architect level (SQL) within large growth company environment
Helpful to understand Software development methodologies around Microsoft Stack: Service Oriented Architecture (SOA), WCF, Caching/Indexing Technologies
Encryption based development via Host Security Modules and adherence to PCI compliance and requirements

Data Warehouse Architect Resume Examples & Samples

Domain blueprint/framework ownership and the associated with PremierConnect Enterprise platform
Establishing guiding principles and design patterns to be used for PCE
Recommending technology choices
Making recommendations for new technologies
Providing coaching, oversight for senior/lead software engineers
Implementing PCE platform vision
Develop and maintain an Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage the enterprise data warehouse
Ensure compliance to the Enterprise Data Architecture by participating in data analysis/design activities and conducting appropriate technical data design reviews at various stages during the development life cycle
Establish and maintain data standards, policies and architectures
Supports the build out of the Data Warehouse and Data Marts
Capture and maintain metadata, creating business rules for the use of data
Hands-on experience with Hadoop technologies. Hive, Spark, Impala, and other technologies are very relevant
Strong background in ETL tools, such as DataStage and Ab Initio
In depth performance diagnostic and troubleshooting in data platforms
Data Warehouse, Business intelligence experience is key
Familiarity with relational databases (prefer Oracle/DB2)
We have a Java based, open source development tech stack. Any related experience would be a plus
10+ years of Data Warehouse, ETL or Business intelligence experience

Data Warehouse Architect Resume Examples & Samples

Assesses and effectively manages all of the risks associated with their business objectives and activities to ensure activities are in alignment with the bank's and unit's risk appetite and risk management framework
Knowledge of and the ability to utilize appropriate database structures to organize and store data in a particular manner
Knowledge of how to collect data from different information sources and distribute them to users; ability to use this information to simplify information systems and make sound business decisions
Knowledge of and ability to design and improve organizational IT structures and blueprints in order to better support business operations and efficiently achieve organizational objectives
Knowledge of and the ability to identify, create and document activities, tasks, processes and data requirements for a particular system under design
Knowledge of, and ability to use strategies and skills to enlist others in setting, embracing and achieving objectives
Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply this knowledge appropriately to diverse situations
Knowledge of methods and techniques to elicit, analyze and record required business functionality and non-functionality requirements; ability to analyze these requirements to ensure the success of a system or software development project

Data Warehouse Architect Resume Examples & Samples

Design and support the database and table schemas for new and evolving sources of data being brought into the data warehouse
Create and support the SQL Server Analysis Services cubes to help with query performance
Follow the design principles and best practices defined by the team for data warehousing techniques and architecture
Participate in an on-call rotation and in production code pushes after regular business hours
Design data models in SQL Server environment

Data Warehouse Architect Resume Examples & Samples

Translate business processes and requirements into conceptual, logical and physical data models
In collaboration with multiple delivery teams ensure consistency and adherence to CHRISTUS Health and industry standards
Translate non-technical requirements into key concepts that form the foundation for data model design to meet the analytics needs within CHRISTUS Health
Translate non-technical requirements into summary or aggregate data model designs to meet the analytics needs within CHRISTUS Health
Engage a wide variety of audiences, both technical and non-technical in a collaborative results-oriented manner
Follows all ITIL processes related to change, incident and problem management
Utilizes approved standard tools for all work completed for data modeling
Bachelor Degree in Computer Science, MIS or related field
Demonstrated ability to work and communicate effectively with both technical and business audiences
Ability to develop effective working relationships across the organization
Exceptional analytical, conceptual and problem solving abilities
Knowledge of Healthcare data
Knowledge of all data formats
A minimum of 3 years of modeling experience with 7 years of progressive experience in IT or Healthcare
Experience using SQL
Advanced experience using Erwin or similar tool

Microsoft Business Intelligence Data Warehouse Architect Resume Examples & Samples

Bachelor’s degree in Computer Science, Business Administration, or related discipline; required
5-7 years of related experience; required
Creativity and ability to think outside the box, taking initiative in moving technical ideas forward with clarity
Strong project management skills
Ability to handle high pressure situations while still being attentive to the detail and excellent work product required
Comfortable dealing with ambiguity
Able to react quickly to an ever-changing environment and ability to balance several projects at once
Willingness to travel at least 30% within the US and potentially periodic international trips

Senior Data Warehouse Architect Resume Examples & Samples

Broad exposure to all of Teradata offerings (Data Mover, Unity Director, Listener etc.)
Deep understanding of our core Teradata technology
Thorough understanding of Teradata’s logging data – ResUsage, DBQL, TDWM and so forth
Should have minimum of 8 - 10 years of IT experience in Data Warehousing and Data Integration
Have at least 8 - 10 years with the Teradata RDMS. A knowledge of Oracle or IBM DB2 RDBMS is a plus
Successfully completed development work on multiple end-to-end Teradata EDW projects
Should have acted in the role of Architect or Technical Lead role on at least 3 projects
Experience or knowledge with respect to Logical, Physical, and Semantic Data Modeling
Working knowledge of the Teradata DBA role on projects and ability to perform DBA tasks when needed
Very clear understanding of architecting and implementing an optimal solution from a performance perspective
Ability to performance tune the solution
Should be able to work independently or manage a small to medium sized project team
Should be able to create technical documentation and manage the maintenance process of this document throughout the project
Ability to create ETL Design Documents and Mapping Specification Documents a plus
Ability to understand complex Data Models and make modifications if necessary
Should have experience of Unit Testing and some basic idea of other testing practices i.e., SIT, Functional Testing etc
Experience in creating reusable templates/components for faster implementation
Have at least 8 years or more with the Teradata RDMS. A knowledge of Oracle or IBM DB2 RDBMS is a plus
Sufficient experience working with UNIX & Shell Scripting
Strong SQL programming and Tuning skills
Good writing/documentation skills
Experience in development experience using On-Site/Off-Shore engagement models
Experience in Teradata development
Good communication skills (English: Written and Verbal)
Good Executive presence
Good presentation and overall “front-of-room” skills
Flexibility in terms of location and work timings
Proactive and focused on results and success; conveys a sense of urgency and drives issues to closure
Should be a team player and leader, flexible, hardworking, self-motivated and have a positive outlook with the ability to take on difficult initiatives and challenges
Ability to work in a dynamic and collaborative team environment
Understand development management activities like development estimations and task management
Exhibit Leadership qualities
B.S. / M.S. in Computer Sciences, I.T, Engineering or equivalent
Teradata Certifications (particularly Teradata Certified master) a big plus
Certifications in an ETL or Data Integration tool such as Informatica or DataStage a big plus

Data Warehouse Architect Resume Examples & Samples

Ability to organise and leverage large and complex data sets
Strong technical skills with all data warehousing technologies (e.g., ETL, ODS, DBMS, BI)
Microsoft SQL server
Strong experience of requirements analysis, modelling and producing fit for purpose visualisations
Modelling of transactional or analytical systems
Master data management
Ability to support and build data based applications
Knowledge of BI and analytics, as well as of structured data, such as entities, classes, hierarchies, relationships and metadata
Conceptual, logical and physical modelling for rationalising data objects
Good leadership and communication skills
Able to lead a design and lead teams
Working in an cloud based environment
SQL Azure
Working in an Agile environment
Working with big data tools such as Hadoop, Spark
Worked in message based data warehouse system

Data Warehouse Architect Resume Examples & Samples

Works with other team members and business stake-holders to translate business requirements into actionable deliverables that reliably and accurately produce the data assets required for the business
Provides the design and architecture, and participates in the design and build of all necessary database platforms and extract-transform-load processes
Skilled at integrating disparate sources of data, conducts software and data validation testing, and provides on-going support and enhancements for production applications
Responsible for creating and maintaining adequate documentation of all data integration applications
Possess strong leadership skills and a proven track record for managing large and complex initiatives and delivering positive results
Proven ability to build and contribute to teams that are exceptionally customer-oriented, deliver business value and are well respected within the organization
Ability to translate and organize goals/objectives into actionable plans, projects and committed time frames, and then manage the effort, communicate status and mitigate risks and issues
Demonstrated ability to perform effective risk planning and mitigation
Ability to create technical and business documentation including white papers, knowledgebase articles, system diagrams, workflow diagrams, and presentations
Demonstrated ability to develop metrics and reporting frameworks to measure efficiency and effectiveness, facilitate appropriate resource allocation, and increase the maturity of programs
Ability to adapt to changing working conditions and work assignments, to be open, and motivated to learn and adapt new ideas and concepts, and to work independently or as part of the team to work on multiple tasks
Ability to multi-task and provide deliverables within fixed timelines and under pressure, as well as the ability to work well in a demanding, dynamic environment and meet overall objectives
Understanding of systems analysis, systems architecture, and systems engineering principals such as TOGAF - The Open Group Architectural Framework, Zachman/Taxonomy, Federal Enterprise architecture, or Gartner Methodology
Working knowledge of the principals of Systems/Software Development Life Cycle (SDLC)
Demonstrated experience with fundamentals, principals, and processes related to change control for information systems
Knowledge of testing fundamentals, the creation of test plans, and processes to ensure the identification, tracking, and remediation of bugs, errors, and defects
Experience supporting software and hardware for business use, analyzing problems and assisting customers with issue resolution, and exercising best practices to monitor and conduct preventive and routine maintenance on business systems
Understanding of IT infrastructure components including desktop/server-class hardware, software, network and telephony
Demonstrated understanding of information system security fundamentals and principals, including security protocols, encryption and access management to ensure adherence to regulatory/compliance requirements
Working knowledge of basic analytics/statistical principles, and the ability to synthesize complex information into an easy to understand manner

Data Warehouse Architect Resume Examples & Samples

At least 5 years experience with tools, facilities and techniques for managing and administering data
Logical data modeling
Business assessment
Requirements analysis
System testing tools
System development life cycle in an agile environment
Modeling: data, process, events, objects
IT quality assurance
Technical troubleshooting
MS SQL Server, SSIS, SSRS
Technical Leadership
Strong communication skills with all levels of technical, business, and management teams
Mortgage or financial industry experience, preferred
Experience working with a BI Universe/Report Development team
Experience working with Kalido or Magnitude DIW software

Data Warehouse Architect Resume Examples & Samples

Architect of an end to end Agile Dev Ops Squad supporting a highly complex Information Warehouse
Designing business solutions by working directly with the Technical Owner or Product Owner and or other stakeholders
Utilize multiple approaches to facilitate Discovery: Modeling, Lean, Agile Design Thinking, etc
Analyze impact of proposed solutions across the business to develop Epic and Story details
Focus on the elements required to manage all aspects of business requirements through logical and physical design
Negotiate to define approaches and goals
Demonstrated organization and communication skills, especially with management and executives
Strong work ethic, and strong eagerness to learn
5-7+ years’ experience in Data Warehousing Architecture
Technical skill and or working knowledge of MVS, PLI, JCL, DB2, SQL, QMF, SCLM
Demonstrated dependency management, change management and problem management
Experience in working in an Agile environment and in a Continuous Integration and Continuous Delivery, Agile metrics
Automated testing
Java, XML, User Interfaces, Webservices, C++
Application business controls compliance, ASCA and SoX

Data Warehouse Architect Resume Examples & Samples

Accountability for the integrity of the WellStar data warehouse
Hands on with data modeling, ETL, development of staging, EDW, and presentation layer for new and evolving sources of data being brought into the data warehouse
Ensures consistency across projects and platforms
Research and lead the development of technical solutions taking business requirements and translating them to technical specifications
Develop current to future state architecture road maps. Align and promote enterprise data warehouse technology principles and strategy. Establish, maintain and apply architecture standards, disciplines and principles. Use appropriate design techniques and methodologies to translate project requirements into detailed designs, consistent with platform strategy and road map. Design external system interface architecture that includes appropriate application of techniques and standards
Maintain deep expertise in architectural modeling, frameworks, emerging technologies, and best practices. Mentor and develop less experienced technical staff. Recommend new procedures and processes to drive desired results on diverse projects. Perform industry research with external parties and maintain networks amongst peers
Develop and communicate governance parameters that take into operational stakeholders' interests and processes with measurable results. Develop and build strong relationships within and across the lines of business and use effective communication skills to influence and accomplish strategic application architecture objectives
Provide technical leadership in both business-as-usual and crisis conditions
Experience with performance tuning, query tuning, troubleshooting and driving problem resolution working in a team environment
Strong scripting skills (PowerShell, Python, etc.)
Familiar with infrastructure technologies (servers, hypervisors, networking, operating systems, web and application technologies) in a predominantly Microsoft-focused environment
Skilled at handling multiple competing priorities while working on multiple complex highly visible projects
Minimum of 10 years of experience in IT systems or applications development  Experience with end-user facing tools such as Qlikview, or Tableau
Experience building data warehouses and BI solutions 
Experience with data cleansing and data quality approaches 
Understanding of the whole ecosystem in different systems and the presentation layer  * Experience with the Epic Caboodle data warehouse model a plus
Strong scripting skills (PowerShell, Python, etc.) 
Skilled at handling multiple competing priorities while working on multiple complex, highly visible projects

IT Data Warehouse Architect Resume Examples & Samples

Retrieve and analyze data using Microsoft SQL Server, Analysis Services, Integration Services and other data management systems
Lead the strategic design and maintenance of business intelligence solutions
Work with business analyst team and/or directly with end users to develop and refine functional requirements for new systems
Write SQL/MDX/XMLA queries to support business with ad hoc data requests
Establish and document best practices for systems development life-cycle for business intelligence solutions, including requirements gathering, design, development, testing and configuration management
Support cross-functional teams on the day-to-day use and operation of business intelligence solutions
Automate reports and metrics creation process
Coordinate and perform in-depth tests, including end-user reviews
Assist in conducting research on software and hardware products to justify recommendations and to support purchasing efforts
Participate and contribute as a positive role model to Allied Universal's IT Department and to the organization as a whole
Train and support end users as required
Complete special projects as assigned
Overtime to meet project deadlines
5+ years with the Microsoft BI stack (SSRS, SSAS, SSIS)
Strong experience with SharePoint Server and BI features (PerformancePoint, PowerPivot, Power View, Power BI is a plus)
Strong experience with Microsoft Excel for ad-hoc analysis and reporting
Experience with Multidimensional Expressions (MDX) is required
Experience with Data Analysis Expressions (DAX) is preferred
Some exposure to other BI tools such as Qlik, Tableau, Oracle, MicroStrategy, etc. preferred
Strong time management, project management and analytical skills
Ability to make decisions and work independently
Must possess excellent communications skills

Data Warehouse Architect Resume Examples & Samples

Architect solutions for key business initiatives ensuring alignment with future state analytics architecture vision
Work closely with the project teams as outlined in the Agile methodology providing guidance in implementing solutions at various stages of projects
Roll up your sleeves and work with project teams to support project objectives through the application of sound architectural principles
Develop and validate that the proposed solution architecture supports the stated & implied business requirements of the project
Review technical team deliverables for compliance with architecture standards and guidelines
Adopt innovative architectural approaches to leverage in-house data integration capabilities consistent with architectural goals of the enterprise
Create architectural designs for different stakeholders that provide a conceptual definition of the information processing needs for the delivery project
Relevant Bachelor's degree or equivalent experience
10+ years in the IT profession
5+ years of data warehouse architecture experience
5+ years of experience with creating logical / physical data models
1+ years of experience with Big Data Technologies (Hadoop, Pig, Hive etc.)
Knowledge of big data technologies and capabilities
Experience with lead role in Java development
Experience with Meta Data tools and techniques
Experience with ELT tools such as Talend

Principal Data Warehouse Architect Resume Examples & Samples

10+ years of ETL/DW Architecture and Development
Carries an active DoD Clearance, or ability to obtain one
Expert level Data Mining & Modeling
Well versed in two or more DB Technologies (including AWS)
SAP and GIS experience ideal but not required
Previously architected Big Data solutions
Bachelors in Computer Science, Management of Information Systems or similar preferred

Download Data Warehouse Architect Resume Sample as Image file

Related Job Titles

Data Warehouse Developer Resume Sample

Warehouse Manager Resume Sample

Data Warehouse Engineer Resume Sample

Data Warehouse Resume Sample

Data Warehouse Consultant Resume Sample

Data Warehouse Manager Resume Sample

Warehouse Operations Manager Resume Sample

Data Warehouse Analyst Resume Sample

Associate, Warehouse Operations Resume Sample

Warehouse Receiving Resume Sample

Warehouse Laborer Resume Sample

Shipping / Warehouse Resume Sample

Browse More

Data Warehouse Architect Resume Samples

The Guide To Resume Tailoring

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

Resume Builder

15 Data Warehouse Architect resume templates

Read our complete resume writing guides

How to Tailor Your Resume

How to Make a Resume

How to Mention Achievements

Work Experience in Resume

50+ Skills to Put on a Resume

How and Why Put Hobbies

Top 22 Fonts for Your Resume

50 Best Resume Tips

200+ Action Words to Use

Internship Resume

Killer Resume Summary

Write a Resume Objective

What to Put on a Resume

How Long Should a Resume Be

The Best Resume Format

How to List Education

CV vs. Resume: The Difference

Include Contact Information

Resume Format PDF vs Word

How to Write a Student Resume

Big Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Senior Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Enterprise Data Warehouse Architect Resume Examples & Samples

Senior Data Warehouse Architect / Developer Resume Examples & Samples

ETL / Data Warehouse Architect Designer Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Microstrategy Data Warehouse Architect Resume Examples & Samples

Senior Data Warehouse Architect Resume Examples & Samples

Big Data / Data Warehouse Architect Resume Examples & Samples

VP-global Operations Risk Technology Lead Database Modeler & Data Warehouse Architect Resume Examples & Samples

Big Data / Data Warehouse Architect Melbourne Resume Examples & Samples

Research Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Public Sector Oracle Obiee Data Warehouse Architect Manager Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Senior Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Senior Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect / Team Lead Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

EIM Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect / Senior Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Senior Engineer, Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

Data Warehouse Architect Resume Examples & Samples

How to Make
a Resume

50 Best
Resume Tips

200+ Action
Words to Use

Internship
Resume