Data Warehouse Engineer Resume Examples

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.

Not exactly what you are looking for? Check our complete library of over 1000+ resume samples

Rate This Template:

Featured in:

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

Data Warehouse Engineer Resume Samples

No results found

Candidate Info

27

years in workforce

1

year at this job

BA

Mis Equivalent

It To Material Management

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

11

years in workforce

2

years at this job

BS

Business

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

5

years in workforce

5

years at this job

BS

Applied Sciences

MA

Computer Applications

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

9

years in workforce

9

months at this job

AA

Information Services And Science

BA

Information Science

MA

Information Management Systems

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

Load More

More Data Warehouse Engineer
Resumes

Data Warehouse Engineer Resume Success Stories

More Jobhero Resources

^*The names and logos of the companies referred to above are all trademarks of their respective holders. Unless specifically stated otherwise, such references are not intended to imply any affiliation or association with JobHero.