Data Warehouse Analyst Resume Sample
Paula Stokes
907 Nikolaus Crescent,
Phoenix,
AZ
+1 (555) 625 4727
Work Experience
Senior Data Warehouse Analyst
01/2017
-
PRESENT
San Francisco, CA
- Consistently exhibits behavior and communication skills that demonstrate HealthCare Partners’ (HCP) commitment to superior customer service, including quality, care and concern with each and every internal and external customer
- Uses, protects, and discloses HCP patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards
- Obtain detailed understanding of the company’s core transactional systems (EPIC, GE/IDX Centricity Business, Next Gate EMPI, Allscripts Touchworks, and NextGen)
- Uses, protects, and discloses DMG patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards
- Business Analysis or related technical experience
- Full Microsoft Business Intelligence Stack (SSIS, SSRS, SSAS)
- Strong experience of SQL Server 2008/2012/2014/2016
- Experience with 2013/2016 SharePoint Server
- Demonstrated ability to meet deadlines, balance multiple priorities, and ensure quality standards based on an Agile Development process
Data Warehouse Analyst
06/2010
-
11/2016
Detroit, MI
- Strong ability to explain advanced data concepts to fellow developers as well as non-technical end users
- Programs or configures data models and structures, business intelligence rules, and applications according to design specifications and departmental standards
- Works with customers to assist in establishing test plans and data; validation of program/reporting functions; and preparation of necessary forms and documentation for implementation
- Provides expertise in the data structures of one or more types of systems and software such as GE Centricity Business, All scripts, PeopleSoft HCM, FMS or Campus Solutions
- Coordinates with IT management, systems analysts, users and other IS technical providers to ensure that client requirements are accomplished
- Progressively responsible data warehouse or ETL development experience, with at least 2 of those years in a role with significant data analysis or report development responsibilities
- Experience transforming large, complex, unstructured data into denormalized star or snowflake schemas
Data Warehouse Analyst / Developer
02/2005
-
03/2010
New York, NY
- Working knowledge of leading data warehouse methodologies such as Kimball or Inmon
- Experience with higher education data such as student, faculty, HR and finance
- Experience with institutional research, including state and federal reporting such as IPEDS, and national surveys
- Background in PeopleSoft, Tableau, SAP Business Objects Web Intelligence, or similar systems and BI Tools
- Expert SQL skills, experience in Oracle Database 12c and Oracle SQL Developer
- Experience in institutional research, including state and federal reporting such as IPEDS, and national surveys
- Progressively responsible data warehouse development experience, with at least 2 of those years in a role with significant data analysis or report development responsibilities
- Efficient data mining and data extraction from the various databases to meet reporting and business intelligence needs
- Filter and "clean" data by reviewing data sets and correct problems when necessary
Education
University of Wisconsin-Richland
1999 - 2004
Bachelor's Degree in Computer Science
Professional Skills
- Excellent communication skills, organizational skills and ability to collaborate
- Strong data analysis skills. Hands on experience on managing data; that is, data analysis, data standardization, data clean up, and data consolidation
- Strong analytical and problem-solving ability required. Strong PC and communication skills required
- Strong interpersonal skills and comfort interacting with and briefing senior leaders and specialists
- Strong technical skills in Microsoft Excel and Business Objects reporting applications
- Excellent people skills, working within a team and with customers, relationship management
- Strong communication skills, written, verbal, and presentation both internally and externally, with customer
How to write Data Warehouse Analyst Resume
Data Warehouse Analyst role is responsible for microsoft, sql, excel, software, reporting, analysis, database, oracle, payroll, integration.
To write great resume for data warehouse analyst job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Data Warehouse Analyst Resume
The section contact information is important in your data warehouse analyst resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Data Warehouse Analyst Resume
The section work experience is an essential part of your data warehouse analyst resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous data warehouse analyst responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular data warehouse analyst position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Data Warehouse Analyst resume experience can include:
- Experience eliciting, documenting and validating data requirements
- Experience facilitating information-gathering and validation sessions
- Proven experience with T-SQL and UNIX shell scripting
- Strongly desired - Real time Experience in the following GCP products - Big Query, Data Flow, Airflow
- Strongly desired - Real time Experience GCP Data Engineering project implementations
- Proven experience working with both business and technical stakeholders to define technical solutions to business needs
Education on a Data Warehouse Analyst Resume
Make sure to make education a priority on your data warehouse analyst resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your data warehouse analyst experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Data Warehouse Analyst Resume
When listing skills on your data warehouse analyst resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical data warehouse analyst skills:
- Self-starter with strong time management and prioritization skills
- In-depth experience documenting technical specifications with demonstrated experience using standards such as IEEE
- Strong problem solving skills – Ability to handle confidential data
- Excellent technical and general communication skills, both oral and written
- Possession of excellent interpersonal, organization, and time management skills
- Demonstrate expert Oracle SQL skills
List of Typical Experience For a Data Warehouse Analyst Resume
1
Experience For Senior Data Warehouse Analyst Resume
- Proven ability to work effectively within a multi-function and diverse team environment to integrate and deliver data
- Understanding of SQL Server query development with demonstrated experience in data profiling and SQL report creation
- In-depth knowledge of SQL Server query development with demonstrated experience in data profiling and SQL report creation
- Strong experience with ETL development applications, including SSIS
- In-depth knowledge of the software development life cycle with demonstrated experience in unit, integration and regression testing of deliverables
- Proven experience using SQL, SAS, OLAP, Business Objects or equivalent for quantitative/qualitative analysis
- Experience with programming utilizing SQL/PLSQL, SAS or other analytical programming language
- Data architecture, data modeling, Complex ETL mappings, design and development experience using SQL and SSIS
2
Experience For Data Warehouse Analyst Senior Resume
- SQL server experience (writing queries, reporting, etc.)
- Develop technical and functional test plans and scripts to validate the successful design, development and implementation of system and reporting deliverables
- Hands on experience of using SQL server native ETL tool and non SQL server ETL tool
- Hands on experience in Report design/development in Data Warehousing/Business Intelligence implementations
- Hands on experience in relational and non-relational data modeling
3
Experience For Senior Data Warehouse Analyst / Developer Resume
- Strong management consulting qualities (ability to multi-task, deliver quality work products, anticipate client needs, etc.)
- Experience with reporting & data visualization (knows SQL, has worked with tools such as BObj, MicroStrategy, OBIEE, Tableau, etc.)
- Hands-on experience using Data Quality & Integration Management methodologies such as the Electronic Equipment Logbook (EEL)
- Experience with higher education data, including HR and financials
- Work experience with databases and financial reporting background
- 2 or more yrs experience working with health care data, eligibility, medical and pharmacy claims, provider, Utilization and Case Management dates
- Ystems analysis experience working on application development and/or delivery projects in full lifecycle development environments
4
Experience For Data Warehouse Analyst / Developer Resume
- Consolidate data from various sources and summarize results in a clear and concise manner
- Be able to prioritize workload and manage multiple deliverables
- Strong knowledge of MS SQL Server, SSAS, and SSRS
- Experience with ETL development in database environments (SQL Server)
- Create, maintain and advocate for strong data dictionary, requirements, design and process documentation
- Experience with database management system software (e.g. SQL Server)
- Strong willingness to learn new technologies and lead change
5
Experience For Epic Data Warehouse Analyst Caboodle Resume
- Experience in project management and Kaizen methodologies are considered an advantage
- Extraction and validation of data from external systems
- Experience in information technology
- Experience in Data Platform solutions
- Experience with PeopleSoft, Informatica ETL, SAP Business Objects Web Intelligence, Tableau, or similar systems and BI Tools
- Data warehouse/data marts experience
- Medical, Pharmaceutical, Symmetry Grouper experience
- Related business experience
6
Experience For Lead Data Warehouse Analyst Resume
- Experience on a data warehouse team as an analyst or developer/architect
- Hands on experience with managed care administrative and clinical data files (Eligibility, Capitation, Claims/Encounters, Referrals, Pharmacy, Lab results)
- Data/business analyst experience in healthcare
- Hands on experience with integration tools such as SSIS or Informatica
- Willingness to operate at functional solution level, and hands on
7
Experience For Senior Enterprise Data Warehouse Analyst Resume
- Understanding of transactional data & flows across systems, data mapping and management reporting for Operations community
- Performing Configuration Management of data (Post-Delivery MODs/TCTD)
- Working knowledge of brokerage services
- Assist in troubleshooting and tuning data warehouse data and processes,
- Serve as a leader in researching and adopting new tools and technologies
- Help design data models that simplify reporting and support front-end BI reporting tools
- Assist with leading integration activities in aligning key operational metrics
- Performs project-based data modeling work. Identifies and estimates Data Modeling tasks for Project Managers. Identifies needs for data resources in Projects
- Interface across departments internally, including Operations, Manufacturing
8
Experience For Marketing Data Warehouse Analyst Resume
- Test and verify tracking for new product features from the live site all the way downstream to reporting
- Analyze and make recommendations for improved data quality and reporting system automation; database creation if applicable
- Complete ad-hoc reporting requests when needed
- Performs quality review of new and existing reports
- Provide reporting support for various Business Object universes
9
Experience For Business / Data Warehouse Analyst Resume
- Design and assist in developing complex data migration processes for the data warehouse,
- Provide recommendations regarding technology alternatives for the Enterprise Data Warehouse and Data Integration Layer,
- Develop, maintain, and support complex enterprise data warehouse systems and corresponding data marts, and
- Create best practices for data loading and extraction and query optimization
- Design data models to support front-end BI reporting tools, such as Tableau
- Extrapolate data patterns by leveraging technical and mathematics algorithms
10
Experience For Data Warehouse Analyst Asc Resume
- Carry out, share, and guide other team members in the practical application of data warehousing tools, concepts and best practices
- Database modelling & data warehouse architecture
- Knowledge of logical and physical data modeling
- Migration/sharing of data across systems
- Report generation and troubleshooting
- Develops integrated solutions by discerning key aspects of client’s business requirements
- Database Programming (SQL queries, MDX queries, store procedures)
- Maintenance and support Data warehousing application
List of Typical Skills For a Data Warehouse Analyst Resume
1
Skills For Senior Data Warehouse Analyst Resume
- Prior work experience in banking, finance, and/or tax credit investments
- Experience required in healthcare/data warehouse or directly related experience required including
- Strong hands-on experience with data mapping and/or SQL
- Desirable Additional Skills
- Effectively and easily communicate business requirements to technical stakeholders and technical requirements to business stakeholders
- Experience designing and documenting ETL processes and tuning ETL performance
- Experience with global reporting environments including multiple currencies, local reporting differences, or similar scenarios
- Experience in previous FP&A, Accounting, or IT/Finance role, including impact to reporting systems
2
Skills For Data Warehouse Analyst Senior Resume
- Experience working in a business-facing environment, preferably in a Business Intelligence and Data Warehousing capacity
- Experience in data analysis, data modeling, and working with automated data warehouse systems
- Extensive experience with logical data modeling, business intelligence, requirements analysis, system testing tools, and system development life cycle
- Experience in healthcare data analysis, business requirements, data modeling, and working with automated data warehouse systems
- Experience writing complex queries in Oracle, Splunk, using hive/Hbase/hue to access data from Hadoop
- Experience of working in atleast one Salesforce integration (e.g., CPQ, Service, Field Service Lightning, Sales etc)
- Three (3) years of experience with Microsoft SQL Server or Oracle including database design and writing SQL scripts
3
Skills For Senior Data Warehouse Analyst / Developer Resume
- Experience working with military customer
- Relevant US military aviation operational experience with understanding of US and Foreign Military applications of Integrated Logistics Support
- Experience with computer hardware, software and programming
- Experience working in an Agile, Scrum environment
- Strong analytical and problem-solving ability required
- Experience implementing Markit EDM and/or Eagle PACE
- Experience in data warehousing
- Min. 1 year of experience in implementing projects in the field of DWH / MIS / BI as a system / business analyst
4
Skills For Data Warehouse Analyst / Developer Resume
- Experience dealing with large scale data analysis and management preferably financial services
- Experience using tools such as SQL developer, Toad etc
- Experience identifying critical data elements, knowledge of Data quality and data governance techniques
- Experience in management reporting systems
- Experience in Microsoft Data Integration Tools – SSIS, SQL Server Programming, SSRS
- Experience in any one of the reporting tools like SSRS, Qlickview, Tableau is preferable
5
Skills For Epic Data Warehouse Analyst Caboodle Resume
- Good understanding in any of PowerShell, C#, Python, Java
- Solid understanding of Unix
- Create strong working relationships with business partners
- Strong knowledge of the role of a Data Governance program in particular for data warehousing and for the business in general
- Establish and maintain effective and collaborative working relationships with individuals at all levels
- Clinical or ERP data warehouse implementation and support experience is highly desirable
6
Skills For Lead Data Warehouse Analyst Resume
- Experience with SQL Server and SQL Integration Services
- Two years of progressive Information Technology experience
- Experience with hands-on business and data analysis
- 5+ advanced to senior level experience with Toad and/or SQL
- Informatica experience beneficial
- Fixed income, Commercial Mortgage Loan or Derivatives experience
- Create complex SQL statements experience
- Excellent oral, written, and communication in English
- Very good knowledge of SQL and relational databases
7
Skills For Senior Enterprise Data Warehouse Analyst Resume
- Demonstrate passion for your work
- Understanding of transactional data & flows across systems, data mapping and hierarchy concepts, and management reporting for Finance community
- Working understanding of the use cases for big data environments and tools in a data warehouse ecosystem
- Working knowledge of banking services
- Understanding of regulatory framework applicable to financial services and banking industries
- Working knowledge of data warehousing, data marts, and implementation projects
- Understanding of Point of Sale data (e.g., Retail)
- Establishing the framework for data quality and reliability
8
Skills For Marketing Data Warehouse Analyst Resume
- Constructing the data architecture to establish a 21st century institutional data warehouse
- Understanding of data visualization, dashboard and infographic tools (e.g., Tableau, Qlik, SAS BI)
- Interfacing with IT team and business partners
- Support coordination of reporting systems setup, mapping of financial hierarchies, testing, training, and communication
- Capable of championing data governance principles, developing and overseeing data governance policies and leading data governance activities
9
Skills For Business / Data Warehouse Analyst Resume
- Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support
- Create reports using Tableau Desktop (publishing to Tableau Server), SAP BusinessObjects, and by querying database (Access, SQL Server)
- Perform requirements gathering, analysis, and tracking using agile lifecycle management tool
- Knowledge in at least one LSG reporting system including: EDW/Cognos, HFM, FDM, CMR/Essbase, Hyperion Planning, Oracle JDE/E1, SAP, or similar systems
- Exposure to data modeling and maintaining data models
- Data extraction, transformation, and loading (ETL) processing
- Support end user trouble-shooting and training
10
Skills For Data Warehouse Analyst Asc Resume
- Responsible for coordinating and monitoring the utilization of resources allocated to assigned tasks and IT project related deliverables
- Propose and create processes for capturing and maintaining metadata. Recommend ways to reduce manual work and recover efficiency
- Demonstrable understanding of data warehouse design and data modeling methodologies at an enterprise level
- Eliciting and managing business and technical requirements, use cases, and/or user stories
- Using Rational Tools such as Requisite Pro, JIRA or equivalent requirements tracking tool to maintain requirements and trace relationships
- Knowledge of the specificity of the banking sector (operating and business model)
- Practical knowledge of modeling methodologies for analytical data repositories (including Snowflake, Star-Schema)
- Sound understanding of Data Warehouse best practices, relational structures and data warehouse and reporting techniques
List of Typical Responsibilities For a Data Warehouse Analyst Resume
1
Responsibilities For Senior Data Warehouse Analyst Resume
- Create and maintain reports to support the TeamMate executive team; ensure the accuracy of the analysis and be able to effectively communicate results to business leaders
- Effectively manage multiple priorities and meet agreed upon work deadlines
- Strong customer service skills, with the ability to meet with and document customer requests and deliver accurately and timely on requests
- Excellent analytical, logical, and mathematical skills
- In-depth knowledge of database and data warehouse design concepts with demonstrated experience in Bill Inmon or Ralph Kimball data warehouse approach
- Strong experience with a report development application, such as SSRS
- Effectively communicate complex technical issues to technical and non-technical audiences, make presentations and write technical specifications
2
Responsibilities For Data Warehouse Analyst Senior Resume
- Develops and prepares reports that efficiently and effectively fulfill the agreed upon requirements
- 1+ Experience working on data exchange or reporting requests
- Extensive experience using Tableau and Tableau Data Prep or other similar tools
- Operate in a highly iterative agile development environment, delivering significant new functionality every week
- Experience with data integration software (e.g. SAS Data Integration Studio)
- Demonstrated ability to lead and plan projects required
3
Responsibilities For Senior Data Warehouse Analyst / Developer Resume
- Experience with BI platforms, especially WebFocus, SAP, Business Objects
- Experience with data cubes and ETL processes
- Documents data warehouse business rules for collection, aggregation, standardization and validation of data via documented standards and guidelines
- Two years of previous experience
- Mainframe experience, knowledge of COBOL copybooks and TSO
- Working knowledge of Relational DBMS development using PL/SQL (Oracle) or T-SQL (Microsoft SQL Server)
- Develop BI solutions using industry standard tools including Crystal Reports, SSRS/SSAS, SQL, Tableau, Essbase, Board MIT, Data Warehousing
- Conducts data profiling to understand data relationships, and recommends conforming logic
- Write SQL queries supporting business needs as required
4
Responsibilities For Data Warehouse Analyst / Developer Resume
- Monitor performance and integrity of reporting and data management systems
- Utilizing healthcare informatics
- Working in a Fact-Dimensional Data Warehouse environment
- Develop lasting relationships with great people in all aspects of the entire organization
- Have the opportunity to build a long term and satisfying career
- Teamwork and enthusiasm for agile way of working
- Transform a business requirement into a functional design including data mappings
- Subject matter expertise in data warehousing, database structures and data analysis
- Use internally developed tools to create new or enhance existing ETL workflows
5
Responsibilities For Epic Data Warehouse Analyst Caboodle Resume
- Work in one of the world's largest IT consulting companies
- Generous benefits package (including private medical care, lunch vouchers, sports passes)
- Clear understanding of the challenges that scale and heterogeneous source environments pose
- Data quality assessment (on both originating source and transformed target)
- Transformation process design leveraging ETL tools
- Create an organized and structured library of reports for historical reference
- Participates within a multidisciplinary team to collect and interpret business requirements into optimum BI solutions to meet business needs
6
Responsibilities For Lead Data Warehouse Analyst Resume
- Implement research in support of strategies that can be used by program management to target key need areas. Translate information into working documents/ reports for support use
- Provide support for fixed income, commercial real estate and derivative data warehouses
- Implement solutions that enhance, streamline and automate the management of our data warehouse systems
- Review code and system interfaces and extracts to handle the migration of data between systems/databases
- Coordinate work with onshore & offshore developers
7
Responsibilities For Senior Enterprise Data Warehouse Analyst Resume
- Trouble-shoot and run root cause analysis of application problems
- Ensure data consistency as data moves across the enterprise
- Collaborate with IT Infrastructure support teams
- Experience related to managing extract load and transformation (ETL) processes by handling large volume of data transformations over Oracle data warehouse/ data marts
- Working with the various functional and technical teams responsible for data design, warehouse data architecture, metadata and assisting with the data integration layer’s repository creation,
8
Responsibilities For Marketing Data Warehouse Analyst Resume
- Strong knowledge of one or more Business Intelligence toolsets, preferably MOLAP (Microsoft SSRS etc.)
- Work with data warehouse customer counterparts to review data loaded into the data warehouse for accuracy,
- Create new or enhanced components of the data warehouse
- Develop software solutions for safety and security applications through periodic software releases utilizing Microsoft technologies such as SQL Server, SharePoint, .Net Framework, Reporting Services (SSRS), SSIS and ETL
- Perform SQL Server database administration in redundant infrastructure, data analysis, develop relational data models and OLAP models by safety subject areas to support reporting and business intelligence needs
9
Responsibilities For Business / Data Warehouse Analyst Resume
- Design and size SQL server databases and data warehouses or supporting development, test and production regions
- Provide database administration production support as needed
- Install, configure SQL server database in clustered/highly available environment
- Facilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long-term needs of business customers
- Design, build, and maintain UNIX shell script processes
- Build relational database objects
10
Responsibilities For Data Warehouse Analyst Asc Resume
- Write sql procedures and scripts to carry out data audits and manage data cleanup
- Develop and maintain ETL processes
- Collaborate with leadership, IT, and internal analysts and external offices
- Positions in this function are responsible for the management and manipulation of mostly structured data, with a focus on building business intelligence tools, conducting analysis to distinguish patterns and recognize trends, performing normalization operations and assuring data quality
- Roles in this function could partner with stakeholders to understand data requirements and develop tools and models such as segmentation, dashboards, data visualizations, decision aids and business case analysis to support the organization
Related to Data Warehouse Analyst Resume Samples
Data Warehouse Architect Resume Sample
Work Experience
• Knowledge of multiple, diverse technologies and processing environments required
• Supports new data warehouse development, ensuring consistency and integration with existing data warehouse structure
• Translates business requirements into technical architecture vision and im...
Professional Skills
• Strong SQL querying skills including store...
• Strong BI architecture database skills fro...
• Proven BI skills with ETL (SSIS) developme...
Data Warehouse Developer Resume Sample
Work Experience
• Leads or acts as chief technical contributor to translation of business requirements to technical specifications
• Leads or acts as the chief technical contributor in the design of new applications or enhancements including integration of purchased solutions in accordance with Enterprise wide strat...
Professional Skills
• Strong systems/process orientation with de...
• A positive self-starter with a solid work ...
• Excellent written and verbal communication...
Data Warehouse Manager Resume Sample
Work Experience
• Work with Operational Support team to ensure SLA’s technical goals and objectives are being enforced and met
• Align production support to business demands while ensuring customer satisfaction to the agreed upon support contract
• Provide management oversight for end-to-end p...
Professional Skills
• Excellent spoken, listening and written co...
• Excellent prioritization skills with the a...
• Strong skills in planning and project exec...
Inventory / Material Resume Sample
Work Experience
• Receives, stores and issues materials, supplies and merchandise. Compiles and verifies stock records against source documents. Ships end products. Loads, unloads and moves materials within and outside the plant. Performs tasks with minimal supervision
• Unloading/handling, opening/sorting packages,...
Professional Skills
• To support, execute and assist in the deve...
• To implement and execute Standardized Proc...
• Experience in Inventory analysis, systems ...
Inventory Logistics Resume Sample
Work Experience
• Using Bard’s ERP system(s) and other service management systems, manages the S&R repair parts, component, and accessories inventory for U.S. service operation
• Maintain awareness and comply with Bard’s Quality Management System, specific Quality policies, and any applicable laws and regulation...
Professional Skills
• Responsible, hardworking and motivated wit...
• Work independently and with strong initiat...
• Able to work in a fast paced environment a...
Sales / Warehouse Resume Sample
Work Experience
• Assist in TWW’s banking including deposits, reconcile to EOD report, confirm check and cash balances, process of credit cards and other
• Sells industrial, medical and specialty gases, welding supplies and related equipment to customers
• Advises customer on equipment and mat...
Professional Skills
• Strong interpersonal skills including sale...
• Proven success in sales and providing exce...
• Capable of working in a fast paced environ...