Data Warehouse Engineer Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

Data Warehouse Engineers provide daily support to data warehouses and recommend data warehousing techniques. A well-written resume sample in the field should focus on duties like identifying business needs, finding ways to improve data accuracy and organization, ensuring data security, troubleshooting performance issues, and maintaining best data warehousing practices. The ideal candidate will showcase the following skills in his or her resume: technical abilities, knowledge of data warehousing, analytical thinking, good interpersonal skills, and computer proficiency. Most Data Warehouse Engineers hold at least a Bachelor's Degree in information technology.

Find out what is the best resume for you in our Ultimate Resume Format Guide.

1

Sr. Data Warehouse Engineer in Consulting Role

  • Converted and redesigned 45 packages for project deployment. New ETL control flows; modular and audited data flows and transforms. Rewrote T-SQL in lookups to end transaction blocking and reduce memory use. Wrote T-SQL for incremental data extraction. Optimized run time by 89%.
  • Reduce size of database by factor of 4 to reduce SSAS bottlenecks from DW loads and MDX queries.
  • Rewrote Revenue by Employee packages to balance employee counts; measure group and hierarchies merged with GL database. Used windows functions for product, sales and customer packages.
  • CAO proposal; to produce Cash statement by direct means; subtract COGS from Receivables.
  • Resolved 1.5% variance between Sale and General Ledger reporting through forensic analysis of SSIS packages. Tabular T-SQL data model with PowerPivot DAX functions to filter and Calculate.
Candidate Info
27
years in
workforce
1
year
at this job
BA
Mis Equivalent
It To Material Management
2

Data Warehouse Engineer

Provided production support and new development for existing SQL Server 2008 R2 data warehouse.

  • Designed tables, complex ETL mappings and workflows in Informatica and SSIS to integrate new billing system into existing data warehouse.
  • Developed Reports in Business Objects XI 3.1, SSRS and Microsoft Excel.
  • Provided production support, product enhancements and bug fixes to SSAS multidimensional cube.
  • Created processes, procedures and tools to validate data post ETL.
  • Lead project to create reusable transformations, mapplets and mappings in Informatica to create consistency in the application of business rules.
  • Worked on project to reduce the number of staging and transformation layers between source data and reporting.
Candidate Info
11
years in
workforce
2
years
at this job
BS
Business
3

Data Warehouse Engineer

  • Designed and implemented Data warehouse business Intelligence system for Visa corporate, which helps to forecast the complete business.
  • Physical and Logical Database designing and modeling experience.
  • Backup/Restore databases, Monitor, and optimize databases.
  • Data Modeling, ETL and data mapping across projects.
Candidate Info
5
years in
workforce
5
years
at this job
BS
Applied Sciences
MA
Computer Applications
4

Data Warehouse Engineer / Systems Engineer III

  • Constructing, deploying, maintaining operational data stores through data engineering functions including data extract, transformation, loading, integration in support of enterprise data infrastructures, data warehouse, operational data stores and master data management
  • Enabling BI and advanced analytics solutions utilizing the Microsoft stack (SSMS 2012, SSIS, SSRS, SSAS, MDS, Visual Studio and Excel Services)
  • Implementing concepts of programming and database concepts such as data structures, error handing, data manipulation and I/O processing
  • Developing OLAP solutions by creating cubes using data from data marts/data warehouse for deeper and faster data analysis
  • Programming views, stored procedures, and functions, and reviewing query performance, optimizing code and monitoring overall data warehouse performance
  • Enforcing data quality, integrity and reliability and creating solutions throughout the data warehouse by designing, maintaining and promoting proper data governance and database efficiency
  • Fluency in file processing concepts (flat file, archive file, XML, etc.) and data integration• Investigating and troubleshoot coding errors and data flow failures
  • Creating enhancements to existing data model and related platforms
  • Ensuring security of data warehouse containing PHI
  • Documenting and governing the life cycle of data, including source-to-target mappings, data dictionaries, transformations, and data quality and business rules
Candidate Info
9
years in
workforce
9
months
at this job
AA
Information Services And Science
BA
Information Science
MA
Information Management Systems

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!