Data Warehouse Consultant Resume Samples

The Guide To Resume Tailoring

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

A Labadie

Angeline

Labadie

6014 Elise Drives

Philadelphia

+1 (555) 319 1707

6014 Elise Drives

Philadelphia

Phone

p +1 (555) 319 1707

Experience Experience

San Francisco, CA

Data Warehouse Consultant

San Francisco, CA

Hintz LLC

San Francisco, CA

Data Warehouse Consultant

Participate in performance, integration and system and user testing
Our Consultants enjoy the flexibility and autonomy to choose the client projects that interest them, while continuing to build professional relationships within our global community of Consultant and business professionals. We offer a comprehensive compensation and benefits package including health and life insurance, a 401(k) savings plan which includes a discretionary company match, employee stock purchase plan, paid personal time off program, professional development and certification courses
Work with all Teradata Solutions including Teradata, Teradata Aster, Hadoop, and Applications
Strong process improvement background
Participate in task related with: database modeling and design, logical/physical modeling, ETL including data sourcing and transformation, solution development and tuning. UNIX shell scripting and Advance SQL
Evaluate access paths for data which spans multiple deployed technologies; provide recommendations for optimizations in accessing these heterogeneous relationships
Be responsible for planning and undertaking own professional development

Detroit, MI

BI Data Warehouse Consultant

Detroit, MI

Lesch-Collins

Detroit, MI

BI Data Warehouse Consultant

Manage various resources to ensure their work items are aligned with business priorities and value is provided with attention to committed deadlines
Stay abreast of current and future reporting/business intelligence technologies
Consult with business and IT leaders
Troubleshoot information and system issues
Ensure timely month end close
Work well under pressure to meet deadlines and manage business expectations
Provide thought leadership in improving data quality and develops specific metrics for quality reviews of data

present

New York, NY

Data Warehouse Consultant ETL Islamabad

New York, NY

Denesik Group

present

New York, NY

Data Warehouse Consultant ETL Islamabad

present

ETL development using native and 3rd party tools and utilities
Design and develop procedures for the integration of data warehouse solutions in an operative IT environment
Write and optimize complex SQL and shell scripts
Performing data warehouse ETL development tasks for large projects (ETL development, stored procedures development, SQL optimization)
Develop and manage data models and associated metadata for the enterprise
Develop strategies for data acquisitions, management, governance, use, and retention of data assets
Perform work on time, within scope and with high customer satisfaction

Education Education

Bachelor’s Degree in Computer Science

Adelphi University

Bachelor’s Degree in Computer Science

Skills Skills

Has ability to perform/drive resolution of problems on individual products
Good communication (written and oral) and interpersonal skills
Able to communicate broad and specific concepts with team and to peers
Able to produce documentation for use by team and customer
Ability to work flexibly in a rapidly changing environment
Ability to prioritize assignments, handle shifting deadlines and work independently as well as in a team environment
Appreciated general business knowledge in any particular industry
Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives
In depth knowledge of facilitation and conflict resolution processes
In depth knowledge of the ERwin and/or Embarcadero data modeling tool

Create a Resume in Minutes

3 Data Warehouse Consultant resume templates

Read our complete resume writing guides

Data Warehouse Consultant Resume Examples & Samples

3 – 5 years of technical experience and a Bachelor of Arts/Science or equivalent degree in computer science or related area of study; without a degree, two additional years of relevant professional experience (5-7 years in total)
Has sufficient depth and breadth of technical knowledge to be individually responsible for the implementation of a specific deliverable. Able to contribute to the design for deliverables
Has ability to perform/drive resolution of problems on individual products
Able to communicate broad and specific concepts with team and to peers
Able to produce documentation for use by team and customer

Data Warehouse Consultant Resume Examples & Samples

Bachelor of Science/MS/PhD Degree in Computer Science, Engineering, Finance or Related Field (or equivalent experience)
6 years of experience developing SQL stored procedures, performing optimization and query tuning, and designing databases
Excellent understanding of VLDB performance aspects, table partitioning, sharding and high availability concepts
Solid understanding of Kimball data warehousing methodologies, various stages of ETL and data modeling
Experience working with MPP systems, additional experience with Hadoop stack a plus
Familiarity with BI tools like Cognos/Tableau/QlikView a plus

R&D Data Warehouse Consultant Resume Examples & Samples

5+ years of data warehousing experience
Experience with MS SSIS and strong skills in MS SQL Server stored procedures
Solid understanding of database concepts and data warehousing methodologies & best practices
Familiarity with Linux (Red Hat Enterprise Linux) & SAS Administration
Knowledge of Hadoop ecosystem - HDFS, Hbase, Hive, Sqoop, Spark etc
Knowledge of SAS DataFlux and Cisco Tidal Enterprise Scheduler a plus
Understanding of BI Reporting Tools (QlikView etc.) a plus
Experience working within agile methodologies a plus

Data Warehouse Consultant Resume Examples & Samples

Provide development and ongoing software support and issue resolution
Build a standards-driven, scalable, secure and dynamic portal for the information delivery of specific based applications
Partner with other business areas within Humana to understand application requirements and develop programming specifications for development staff
Develop enhancements, resolve issues, coordinate testing of statement releases and oversee regular production efforts including data extracts, data warehouse feeds and printing
Bachelor’s Degree in Computer Science, Information Technology or a related field
3 years of experience with Oracle, Informatica, PL/SQL
Knowledge of relational databases, legacy systems integration, mainframes and design patterns
DB Modeling Experience
Strong process improvement background
Strength in managing multiple priorities and/or projects by using appropriate methodologies and tools
Strong attention to detail and excellent organizational skills
Understanding of Business Intelligence and Analytics
Experience with SAS, R, Python, Hadoop, Analytical Appliances like IBM Netezza, Oracle
Experience with Data Mining and Predictive Analytics
Experience in evolving/managing technologies/tools in a rapidly changing environment to support business needs and capabilities
Data Warehouse or DBA expertise
Experience in tools like QlikView, Oracle BI, Microsoft SSRS, Splunk

BI Data Warehouse Consultant Resume Examples & Samples

Identify Information solutions, communication requirements, and deliver with a clear line of sight to business goal
Partner with business users as a subject expert to find needed information
Ensure process are developed are reliable
Consult with business and IT leaders
Manage various resources to ensure their work items are aligned with business priorities and value is provided with attention to committed deadlines
Assist in Reporting of business unit, customer and product performance reports and assist in establishment of new models as needed
Stay abreast of current and future reporting/business intelligence technologies
Troubleshoot information and system issues
Engaging with other IT partners to meet business needs including collaboration with offshore Hyperion support, OBIEE/Data Warehousing teams and other IT teams
Ensure timely month end close
May require occasional travel to other office locations on occasion
Bachelor Degree in Business or Technology required
Minimum of 7 years of experience in Finance, Business Intelligence, or Data Warehouse management required
Should be very capable in writing SQL, working within database, and building reports, and coordinating with ETL developers
Extensive Experience with two or more of the following Essbase, Hyperion Planning, OBIEE, Spotfire , Tableau
Experience with relational databases and dimension modeling
Experience across all stages of SDLC
Experience working on an offshore/onsite hybrid staffing model
Ability to work collaboratively across technical and functional teams

Data Warehouse Consultant Resume Examples & Samples

Learn how to Implement Teradata on premises, in the Cloud (proprietary, Amazon Web Services, and Microsoft Azure), or hybrid configurations
Prepare for and achieve certification on the most recent releases of Teradata and our various Cloud alternatives
Learn how to help future-proof the Clients analytical environment because as their business need changes, the database platform will be able to change as needed
Incorporate data gravity into efficient environment-wide architecture by minimizing data movement and duplication (e.g., co-locate analytical system and source data generating systems)
Receive focused training and project experience to improve your client-facing, consulting capabilities
Bachelor's Degree or experience in lieu of
3 - 10 years of recent experience in development and implementation of Data Warehouses
Professional Consulting Experience
Excellent oral and written communication skills and presentation abilities
Familiarity with Project Management Practices
Ability to work effectively in a virtual environment
Travel up to 100% of the time
Solid Data warehouse Background – Teradata, Oracle, DB2 or MS SQL. Teradata exposure is highly valued
Exposure to Large Data warehouse implementations
Unix/Linux Scripting Skills
Solid Exposure to Modeling tool (e.g. ERWIN)
Experience with BI tools (e.g. Business Objects)
Exposure to ETL tools (e.g. Informatica, DataStage or Ab Initio)
Programming Skills (i.e. C, C++ Shell, Scripting, JAVA, JCL, etc.)
Exposure to AWS and/or Azure Cloud
Big Data Development skills (i.e. Hadoop or Map Reduce)

Data Warehouse Consultant Resume Examples & Samples

Learning how to Implement Teradata on premises, in the Cloud (proprietary, Amazon Web Services, and Microsoft Azure), or hybrid configurations
Preparing for and achieve certification on the most recent releases of Teradata and our various Cloud alternatives
Learning how to help future-proof the Clients analytical environment because as their business need changes, the database platform will be able to change as needed
Incorporating data gravity into efficient environment-wide architecture by minimizing data movement and duplication (e.g., co-locate analytical system and source data generating systems)
Receiving focused training and project experience to enhance your client-facing, consulting capabilities
5 - 10 years of recent experience in development and implementation of Data Warehouses

Data Warehouse Consultant Resume Examples & Samples

Design the data layer from source to warehouse or data lake up to application layer
Ensure data is structured to meet functional and technical requirements
Develop strategies for data acquisitions, management, governance, use, and retention of data assets
Provide thought leadership in improving data quality and develops specific metrics for quality reviews of data
Attributes of our global professionals include: a dedication to client service, the ability to think in complex and ever changing situations, strong communication skills and the ability to solve problems, execute and transfer knowledge
Strong understanding of data modeling (Conceptual, logical and physical)
Experience in data integration/ ETL development
Strong understanding of data integration, data security, and data privacy
Strong understanding of usage of data in Data Warehouses, Data Lakes and analytics
Knowledge of technologies such as Oracle Database, SQL Server, DB2, ERWIN, HANA, Data Integrator, OLAP
Prefer experience with Hadoop, Cloudera, Hortonworks, Pivotal, HANA, Spark, Storm, Flume, MongoDB, Kafka or Exadata
Previous experience in consulting is a plus

Data Warehouse Consultant Resume Examples & Samples

Design and normalize the logical data model to third normal form
Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community
Prepare fully refined data models in accordance with the guidelines/conventions of Integration DEFinition (IDEF) or equivalent methodology
Develop and manage data models and associated metadata for the enterprise
Work with all related consultants to design and document semantic models
Work with consultants to translate LDMs and Semantic Models into their physical representations
Enhance new and existing logical models with entities to represent client specific key models
Work with ETL consultants to map source system data to Teradata, Teradata Aster, and Hadoop physical models
Maintain and publish project business rules and the associated enterprise data dictionary
Evaluate access paths for data which spans multiple deployed technologies; provide recommendations for optimizations in accessing these heterogeneous relationships
Work with all Teradata Solutions including Teradata, Teradata Aster, Hadoop, and Applications
In depth knowledge of business processes and business information models
In depth knowledge of data modeling methodologies and techniques
In depth knowledge of the ERwin and/or Embarcadero data modeling tool
Understanding of one or more business areas and industries: Telecom, Retail, Manufacturing, Financial etc
In depth knowledge of facilitation and conflict resolution processes
Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives
Understanding of the Teradata Reference Information Architecture and the Unified Data Architecture would be an advantage
Work with the appropriate project management methodology (Agile or Waterfall) based upon customer and project requirements

Data Warehouse Consultant ETL Islamabad Resume Examples & Samples

Write and optimize complex SQL and shell scripts
ETL development using native and 3rd party tools and utilities
Design and develop procedures for the integration of data warehouse solutions in an operative IT environment
Create and maintain technical documentation that is required in supporting solutions
B.S. / M.S. in Computer Sciences, Software Engineering, Computer Information Systems
Database development and SQL experience of at least 2 years
Strong RDBMS concepts and SQL development skills
Knowledge of data modeling and mapping (Preferred)
Good Data warehouse & ETL concepts (Preferred)
Hands-on experience of EDW development especially in ETL area (Highly Preferred)
Understanding of one or more business areas and industries: Telecom, Retail, Manufacturing, Financial etc. (Preferred)
Good communication and analytical skills
Ability to work in a dynamic and collaborative team environment, demonstrating excellent interpersonal skills

Data Warehouse Consultant Resume Examples & Samples

Deliver high level consulting services related to the Teradata platform
Capture technical and functional requirements
Participate in task related with: database modeling and design, logical/physical modeling, ETL including data sourcing and transformation, solution development and tuning. UNIX shell scripting and Advance SQL
Participate in performance, integration and system and user testing
Understand and been able to manage DWH integration with analytical ecosystems, including new technologies
Perform work on time, within scope and with high customer satisfaction
Understand professional behavior at a client site
Builds relationships with clients, both business and IT
Be responsible for planning and undertaking own professional development
Pursue Teradata certification in field of expertise
A deep knowledge of SQL programming is required
Applicants are required to refer if they have experience or not in these technologies and the level of it: Data Base (TERADATA, Aster, ORACLE, IBM DB2 or Netezza, SQL Server, Hadoop, etc..); Business Intelligence domain (SAP Business Objects, MicroStrategy, Tableau, Qlick View, Microsoft BI, OBIEE,..); ETL area (SAP Data Services, IBM DataStage, Informatica PowerCenter,...) or analytics (SAS, R, Python, Scala, analytics models, …)
Hands-on experience applying modeling techniques to actual business solutions
Experience in designing, developing, and implementing relational databases
Testing a Data Warehouse - Ability to prepare for, administer, and validate the results of unit, vendor, component integration, system acceptance, deployment readiness, and user acceptance testing to ensure conformance to business, functional and quality requirements
Appreciated general business knowledge in any particular industry
Business needs analysis - ability to define client's requirements within the context of their business
Ability to prioritize assignments, handle shifting deadlines and work independently as well as in a team environment
Ability to work flexibly in a rapidly changing environment
Good communication (written and oral) and interpersonal skills
Work well under pressure to meet deadlines and manage business expectations
Information Technology (IT) related degree or equivalent
Willing to travel nationwide as required
Any successful candidate will be required to be fluent in Spanish and with a good level of English (both written and spoken)

Data Warehouse Consultant Resume Examples & Samples

Claims, Provider, Membership, Product, Chart Of Accounts, Revenue and Capitation in the Enterprise Data Warehouse and Legacy Data Warehouses
Perform high level triage and communication to the business community as required
Recommends and provides improvements to existing production processes based on team root cause analysis for EDWard and downstream impacted areas
Develop user communications for Analytic Resource Center (ARC)
Adhere to Analytic Platform goals set annually based on monthly metric reporting
Production Lights On Support of our Reporting and Data Triage Tools (RIM and DIM)
Strong working knowledge required in Microsoft DOT NET, Java Scripting, SQL Server SQL
Requires BA/BS in related field and 6-8 years experience in C#, Microsoft ASP.NET, External Java Scripting programming languages, data analysis, data modeling, and working with automated data warehouse systems, or any combination of education and experience, which would provide an equivalent background
Requires experience with Teradata and relational databases, knowledge of query tools, and statistical software is required
Requires working knowledge of Visual Studio 2013, SQL Server coding platforms
Requires working knowledge of SQL including complex queries, building stored procedures, and developing involved reports preferred
Strong effective communication skills required to work with multiple stakeholder groups at various levels, both internally and externally
Client management experience and Data Warehouse Membership Data Mining experience strongly preferred
Managed health care industry experience preferred
Strong analytical, organizational and problem solving skills
Experience with programming languages and various statistical programs in addition to general knowledge of major components of managed care operations required
Excellent oral and written communication skills required
Demonstrated ability to lead and plan large-scale projects required