Data Warehouse Analyst Resume Samples
4.5
(105 votes) for
Data Warehouse Analyst Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the data warehouse analyst 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.
BW
B West
Bettye
West
48867 Martin Estates
New York
NY
+1 (555) 866 2722
48867 Martin Estates
New York
NY
Phone
p
+1 (555) 866 2722
Experience
Experience
Los Angeles, CA
Data Warehouse Analyst
Los Angeles, CA
Tromp-King
Los Angeles, CA
Data Warehouse Analyst
- Support report development for general, financial, clinical and case management, Managed Care, and Health Care and payment Reform purposes
- Organize workload and work independently with little supervision
- Assists with data warehouse development and enhancement
- Provide technical and systems design expertise in the development of new and maintenance of existing databases
- Provide front line support within a network environment of clients interfacing with server, internet, and PC based business intelligence system
- Manage key department business intelligence applications and data warehouse acting as the technical liaison for data warehouse / business intelligence issues
- Collaboratively support other IT team members to help design, develop and implement business intelligence applications
Los Angeles, CA
Data Warehouse Analyst Senior
Los Angeles, CA
Fahey Inc
Los Angeles, CA
Data Warehouse Analyst Senior
- Work closely with project managers, business users, and IT teams
- Provides data analysis and recommendations for the correction, enhancement and/or development of ad-hoc and canned end-user reports
- Provides design support for the development of business intelligence solutions
- Perform monitoring, optimization and refinement of ETL solutions
- Perform T-SQL coding and quality assurance
- Researches tools, frameworks and mechanisms for data analytics
- Performs analysis for a wide range of requests using data in different formats and from various platforms
present
New York, NY
Senior Data Warehouse Analyst
New York, NY
Gottlieb-Treutel
present
New York, NY
Senior Data Warehouse Analyst
present
- Supports development and improvement of other tools for the Sales and Product Management organizations
- Creates documentation and provides continuous training to end users
- Design and develop complex mappings using variety of complex transformations
- Drives improvement in maintenance of product configurators by end users
- Maintains and optimizes the EMEA Access databases for price management, special pricing requests and annual net price reviews
- Runs price/cost data collection and loading operations that populate the databases and provides integrity checks on the data used
- Documents tasks for end-user, technical, and managerial review to ensure high quality
Education
Education
Bachelor’s Degree in Area
Bachelor’s Degree in Area
Iowa State University
Bachelor’s Degree in Area
Skills
Skills
- Knowledge of basic programming concepts and systems implementation
- Familiarity with Microsoft Visual Studio, SQL Server Reporting Services, and Team Foundation Server highly desirable
- Knowledge of SQL language
- Strong T-SQL skills
- Good understanding of SQL Database and data warehouse design principles (e.g. facts, dimensions)
- Demonstrated ability and understanding of Oracle SQL Plus, PL/SQL, SQL Loader
- Demonstrated experience/proficiency in data analysis
- Hands-on experience with Quality Assurance Documentation System (QADS)
- Hands-on knowledge with TeamCenter e-Cubed report builder
- Software development lifecycle to include ability to read, interpret, and write eXtensible Markup Language (XML)
15 Data Warehouse Analyst resume templates
Read our complete resume writing guides
1
Birst Data Warehouse Analyst Resume Examples & Samples
- Technical knowledge of BIRST reporting platform is a must
- Ability to interact with business managers to understand business requirements, document them and provide an optimal solution
- Techno functional knowledge of other analytics platforms like OBIEE, SAP BW, Business objects is a plus
- Functional knowledge of common business processes like Sales, Customer support and service is required
- Techno-functional knowledge of Sales Force (Sales Cloud, Service Cloud) is preferred
2
Data Warehouse Analyst Senior Resume Examples & Samples
- Provides design support for the development of business intelligence solutions
- Develops visually informative dashboards and customized reports based on business requirements
- Researches tools, frameworks and mechanisms for data analytics
- Designs and delivers end-user training and training materials
- Supports IT goals and objectives by being a proactive member of the Data Services team
3
Data Warehouse Analyst Resume Examples & Samples
- Participates within a multidisciplinary team to collect and interpret business requirements into optimum BI solutions to meet needs
- Performs analysis for a wide range of requests using data in different formats and from various platforms
- Performs quality reviews of new and existing reports
- Provides input to standards, policies and procedures for BI tools and systems
4
Data Warehouse Analyst Senior Resume Examples & Samples
- Designs and helps implement a new reporting infrastructure based on data warehouse principles and methodologies
- Experience configuring/setup of reporting suites (similar to Pentaho, Tableau, etc.)
- Demonstrates proficiency in the following technical skills
- MS Excel
- Very strong SQL and data reporting experience
- Strong relational data modeling
- Experience with data warehouse concepts and methodologies, including ETL
- Familiar with MS Access
- Processes large amounts of financial and other data: facts, figures, and number crunching. Ability to see through the data, analyze it to find trends and conclusions. Has good understanding of generally accepted accounting principles
- Translates ad-hoc requests for data into a report based on business rules. Quickly learns cross-functional business processes to facilitate requests
- Focuses on details to ensure results are not only accurate, but also answers the correct question
- Provides data analysis and recommendations for the correction, enhancement and/or development of ad-hoc and canned end-user reports
- Develops data and process specifications that satisfy high level business requirements using excellent inquiry and communication skills
- Demonstrates initiative and problem solving skills
- Creates and delivers user documentation to ensure proper use of changed and newly implemented solutions
- Documents technical data definitions and other functional requirements for reports
- Excels in written and verbal skills
- Works independently with strong planning, time management, and organizational skills
- Identifies indicators of potential problems/issues and alerts the team with a recommended courses of action
- Understands and communicates data flow between systems
5
Data Warehouse Analyst Senior Resume Examples & Samples
- Primary responsibility to lead the integration, data cleansing, governance, and usage of data to support the Civitas Application
- Participates in all phases of data warehouse implementation. Identifies pertinent issues and prepares comprehensive design specifications for database design, testing, conversion, and implementation
- Translates and documents the results of requirements gathering into a standard format to be used to create the appropriate Business Intelligence (BI) solution
- Analyzes user data to determine business rules and creates data models
- Develops and delivers BI solutions
- Works with end user to gather reporting requirements
- Implements and supports Business Objects/Tableau and other reporting applications
- Develops strategies and updates the data warehouse in response to changes in reporting requirements
- Applies industry standards to the technical architecture of a Business Intelligence solution (Stars, Cubes, Extract Transform and Load (ETL)) to solve business problems or increase business efficiency
- Identifies and recommends methods to normalize and maintain data from disparate systems. Works with other internal UIT teams and external systems support staff to understand the source systems used for the warehouse
- Troubleshoots data warehouse software. Develops and maintains tools to optimize data quality and access
- Collaborates with users and negotiates to identify and develop additional data sources for the data warehouse consistent with business rules and customer needs
- Coordinates with Data Warehouse Architects to create and support Business Intelligence environment. Identifies and works with appropriate staff to resolve technical issues
- Conducts and attends team meetings, and communicates (verbally and in writing) team and project issues to appropriate staff and customers. Presents findings, recommendations, and specifications both verbally and in writing
- Participates as a team member on data warehouse projects
6
Data Warehouse Analyst Resume Examples & Samples
- Analyze current Encounter data submission process
- Document current Encounter data submission process
- Provide gap analysis of current Encounter data submission process
- Identify remediation of Encounter submission process gaps
- Implement strategic goals for Encounter data on-going quality intiatives
- Provide on-going oversight of data submissions
- Support Health Care Reform reporting initiatives, in a combined technical programmer and business analyst capacity
- Support analytic requirements gathering efforts for ongoing MassHealth Data Warehouse reporting, specifically for the new reporting needs related to Health Care and payment reform
- Communicate business requirements to Cognos and Oracle developers and work with them to expose problems, identify timely solutions, and communicate options, including their feasibility and timeframes, back to the business community
- Support report development for general, financial, clinical and case management, Managed Care, and Health Care and payment Reform purposes
- Support on-going development of cost, utilization and other reporting metrics, including collaboration with business program managers for MCO and MMIS source data
- Communicate progress or impediments to progress to users and management
- Review technical documents and test plans, test results and coordinate implementation activities with end-users and MassHealth Data warehouse
- Support internal and external (e.g., cross agency collaboration) requests for data extracts
- Organize workload and work independently with little supervision
- Provide ad hoc and project-based reporting analysis and development as needed by the EOHHS data warehouse
- Ability to think independently and serve as both technical data analyst/ programmer as well as business analyst
- Strong SAS and/or SQL skills required on a Windows and/or Unix platform; any other programming skills a plus
- Experience with data manipulation for analytic purpose, specifically in the health care field
- Knowledge of Medicaid terminology, structures and programs
- High level communication skills including the ability to express findings and recommendations clearly to end users and several levels of management, both verbally and in writing
- Ability to gather and analyze operations through interview and observation
- Ability to manage multiple ongoing and short term projects
- Education, licensure and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines
7
Data Warehouse Analyst Resume Examples & Samples
- Microsoft Excel and macros
- Microsoft VBA
- Analyze user requirements to derive software design and performance requirements
- Design and code new software or modify existing software to add new features
- Debug existing software and correct defects
- Application design and development, to include back-end relational database architectures and full lifecycle software development
8
Data Warehouse Analyst Resume Examples & Samples
- Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule
- Bachelor's degree in related field
- 1-2 years experience in data analysis, data modeling, and working with automated data warehouse systems
- Any combination of education and experience, which would provide an equivalent background
- Experience in SQL, GQL, SAS, Business Objects preferred
- Good analytical and problem-solving ability required
- Strong PC and communication skills required
9
Data Warehouse Analyst Senior Resume Examples & Samples
- Design, develop, test and implement ETL packages using SSIS
- Develop ETL processes to maintain data warehouses, operational data stores, data marts
- Maintain and support ETL environments (including development, test and production)
- Perform monitoring, optimization and refinement of ETL solutions
- Perform T-SQL coding and quality assurance
- Document all work and processes
- Work closely with project managers, business users, and IT teams
- Maintain an in-depth knowledge of current and emerging technologies and standards
- Ad-hoc data requests
10
Senior Data Warehouse Analyst Resume Examples & Samples
- 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
- Effectively collaborate with both technical and non-technical staff; translate business needs into technical requirements and ensure that requirements conform to overall objectives and specifications
- Full understanding of the CMS capitation model and the required datasets that support it
- Experience documenting detailed requirements, design documents, and workflows in support of BI or sophisticated reporting capabilities
- Ability to build trust and create a strong working relationship with business customers
- Ability to extract and manipulate data from multiple data sources using MS SQL
- Experience with contemporary Software Development Lifecycle (SDLC) methodologies such as Agile
- Experience with data quality and profiling tools
- Working knowledge of Data Warehouse and reporting terminologies, ETL tool skills a strong plus
- Demonstrated self-direction with excellent organizational, analytical, writing, problem solving and interpersonal skills
- Provide quality assurance testing after development is complete to ensure that business requirements have been met
- Develop standard testing scripts to facilitate testing of business requirements
- Obtain detailed understanding of the company’s core transactional systems (EPIC, GE/IDX Centricity Business, Next Gate EMPI, Allscripts Touchworks, and NextGen)
- Work closely with business customers to understand and document their requirements for data warehouse development team
- Mentor junior team members on business concepts
- Develop documentation to support ongoing maintenance and upkeep of processes
- Autonomous individual with strong design, analytic skills and problem solving skills
- Ability to communicate, both verbally and in writing, clearly and concisely in Standard English to providers and staff from a wide variety of cultural and socioeconomic backgrounds
- Task-oriented
- Ability to work in a fast-paced team-oriented environment
11
Senior Data Warehouse Analyst Resume Examples & Samples
- Designs and writes SQL scripts, stored procedures, and user defined functions
- Responsible for entire ETL process of transforming, cleaning, and standardizing data and metadata so it can be loaded into a data warehouse or data mart
- Builds data warehouse infrastructure including complex data models and strategic data sets and databases
- Specifies the creation of content in support of internal and external customers for data and information
- Interacts with company leadership as required to facilitate the development of strategic data sets for the organization
- Ensures the reliability and timeliness of the data warehouse systems and underlying technologies
- Develops solutions to streamline business processes to achieve departmental and company-wide goals more effectively and efficiently
- Communicates status, problems, resolutions, etc. on projects and assignments
- Contributes skills and knowledge to other database and reporting projects as determined by management
- Directs the work of other staff and serves as a mentor to junior staff
- Specialization with related databases, architecture and implementation of data models and database designs, data access and table maintenance codes
- Understanding of data warehouse methodology
- Demonstrated achievement in building a research and analysis function
12
Data Warehouse Analyst Resume Examples & Samples
- Solves routine problems largely through precedent and referral to general guidelines
- Interacts within own team and with direct supervisor
- Receives detailed to moderate level of instruction on daily work tasks and detailed instruction on new assignments
- Individual contributor as a part of a team, with a predetermined, focused scope of work
- Supports database and data warehouse for day-to day operations
- Assists with data warehouse development and enhancement
- Communicates to business owners and client representatives to collect business requirements and develops data warehouse technical design documents
- Desire to work in an information systems environment
- Strong T-SQL skills
- Required experience in Microsoft SQL Server development or support
- Required experience in Microsoft SSAS development or support
- Required experience in ETL (SSIS) development or support
- Good understanding of SQL Database and data warehouse design principles (e.g. facts, dimensions)
- Experience with Microsoft SSRS, SAS, IBM Cognos, DataStage and DB2 is an asset
- Experience with cloud technologies is an asset
- Certificates in Microsoft Business Intelligence and database technologies is a plus
13
Data Warehouse Analyst Senior Resume Examples & Samples
- Exceptional MS Excel & Access Database skills
- Detailed orientated; able to manage, manipulate and analyze large batches of multiple product data
- Capability to multi-task and prioritize daily activities along with the programs activities
- Must be able to lift 40lbs
- Must be able to work daily in a non-environmentally controlled area (hot in summer time, cold in wintertime)
- Candidate must be able to obtain and maintain a Secret Clearance as well as TSA clearance for warehouse
- Experience in warehouse operations to include parts cataloging/stocking
- Ability to work independently and make clear, rational decisions
- Familiarity with freight forward and related logistics concepts of operation
- Experience in using aviation ground support equipment
- Familiarity with pilot flight equipment
14
Data Warehouse Analyst Resume Examples & Samples
- Gather, analyze and vet data requirements
- Design target data structures (data models) in compliance with the corporate data architecture
- Design, develop, implement and maintain data provisioning processes and documentation
- Participate in design architecture sessions at the discretion of the BI Solution Architect
- Define data extraction, transformation and population methods
- Conduct data quality assessments and produce detail assessment reports
- Resolution of data quality issues
- Develop and deliver information consumer training specific to the data content and retrieval methods
- Assist information consumers with the interpretation and use of data content and data products
15
Senior Data Warehouse Analyst Resume Examples & Samples
- Maintains and optimizes the EMEA Access databases for price management, special pricing requests and annual net price reviews
- Runs price/cost data collection and loading operations that populate the databases and provides integrity checks on the data used
- Creates documentation and provides continuous training to end users
- Supports pricing team in customization and full implementation of the enterprise quoting tool (C360 Power quote) for all regions and product groups
- Works with the Global Hydraulic front-end IT teams to develop new integrated solutions for pricing management covering local EMEA needs
- Drives improvement in maintenance of product configurators by end users
- Maintains customer database, improve and monitor account data health in ERPs and other Eaton systems (C360, Eloqua)
- Supports development and improvement of other tools for the Sales and Product Management organizations
- Minimum 5 years of experience in database technologies, especially SQL or Microsoft Access
- Advanced knowledge of Excel is a must
- Strong interpersonal skills demonstrated by facilitation, collaboration and resolution of issues
- Above average business acumen
- Strong analytical and problem solving skills. Ability to structure complex information
- Good understanding of financial fundamentals (pricing and costing) and experience in table and report design
- Ideally, experience with Microsoft SQL server, PL/SQL, Oracle client 11g, VBA coding
- Previous experience with MfGPro would be an advantage
- Master of Science or equivalent technical degree
16
Data Warehouse Analyst Resume Examples & Samples
- 3+ years of experience in similar role
- Experience with project delivery methods and practices, understanding of IT development cycles and project management types
- Industry experience from one or more core industries
- Knowledge of DWH/BI concepts, architecture principles, advocated positions, design patterns, and implementation alternatives
- Experience with database systems such as Teradata, Oracle or MSSQL in similar position (analysis, database objects design, reports creation, source-to-target mappings)
- Good SQL knowledge
- Fluent Czech/Slovak language + English language on communicative level
17
Senior Data Warehouse Analyst Resume Examples & Samples
- Drive strategic projects to create opportunity for data driven decision making. For example, identifying areas where existing data may be insufficient then researching and crafting a plan for improvement
- Manage tactical improvements to a complex data infrastructure. For example, overseeing a project to centralize and standardize similar data coming from different sources
- Forensic data investigation—investigating and diagnosing often complex data interaction issues
- Effectively communicate business requirements to technical stakeholders and technical requirements to business stakeholders with ease
- Work with people in a variety of functions across the business to satisfy their data and reporting needs—analytics, product, engineering, sales, finance, business development and marking
- 3+ years in an analytical or business intelligence role
- Bachelor’s degree in a technical or business related field
- Strong SQL and data skills—both querying as well as data modeling with large, complex datasets
- Knowledge of basic application development and programming practices a plus
- Excellent problem solving and analytical skills and a desire to work independently to proactively solve a variety of problems in a fast-paced environment
- Ability to communicate effectively with people at all levels and across multiple functions
- LI-DB2-V
18
Data Warehouse Analyst Resume Examples & Samples
- Your team mates
- Turning user stories into valuable products
- Preparation of functional design and specifications
- Feedback and validate information
- Dimensional data modelling and data mapping
- Write and validate test cases
- Experience of data warehousing, and knowledge of ETL processes and tooling
- Documentation skills: writing/reviewing functional/technical designs
- Experience of data modelling (Kimball)
- Knowledge of SQL language
- Preferably experienced with Asset Management processes
- Agile/SCRUM experience
19
Lead Data Warehouse Analyst Resume Examples & Samples
- Leads project requirements reviews and initial analysis of available data
- Leads or reviews the design of application data structures using data modeling tools and insures data designs follow enterprise and data domain standards and processes
- Gives direction to and participates with project teams in the implementation of processes which result in a high degree of data quality and integrity; and assists in the resolution of data quality issues
- Insures data is properly classified for security purposes and insures data security designs meet enterprise standards
- Coordinates construction of the database and database objects with the database administrators
- Participates in the design and implementation of processing related to data archiving, retention and purging; data backups; and data recovery
- Demonstrated experience designing and/or developing applications using relational databases and a knowledge of SQL
- Basic project management skills
- Preference will be given to individuals with one or more of the following areas of experience
- Birst development experience
- HANA modeling experience
- Business intelligence
- SAP functional or technical knowledge
- Formal data modeling or data architecture
- Data warehouse design, development, or operations
- Oracle, MS SQL Server, or other technical certifications
- Self motivated, self-starter, and an ability to effectively train and mentor others
- Bachelor's degree in Information Systems, Computer Science, Engineering or equivalent work experience
- Preference given to individuals with Greenbelt and DFSS certifications
20
Senior Data Warehouse Analyst Resume Examples & Samples
- Work collaboratively with business and technology stakeholders to define, document and analyse reporting and analytical requirements
- Design and document robust and practical data warehouse models
- Produce data mapping specifications to hand off to an offshore development team
- Act as SME for the Enterprise Data Warehouse and its underlying technologies (Informatica and Netezza) providing support to end users and stakeholders, plus the wider development and test teams
- Review and sign off 3rd party delivered DWH artifacts, ensuring tables and code meets specification and conforms to EDW standards and best practices
- Work closely with the Change Management, Solution Design and Data Architecture functions to assess upcoming strategic programmes and ensure reporting/data requirements are being adequately captured
- Extensive experience in data warehouse architectures and concepts
- Data modelling experience (Kimball, Inmon)
- Data integration experience with Informatica
- Data warehouse appliance experience (preferably Netezza)
- In-depth SQL knowledge with experience interrogating data from large relational databases
- Understanding of software development lifecycles
- Familiarity with a wide range of BI reporting tools in order to appreciate how data warehouse designs can be best exploited depending on the toolset
- Track record of working in a collaborative, team based environment
- Excellent written and verbal communication skills, able to present results of analyses to senior stakeholders
- Qualitative and quantitative analytical capabilities
- Confident self starter, with attention to detail
- Demonstrable experience in a similar role (ideally in a Telco)
- Expertise in SQL, Excel
- Some knowledge of Business Objects and/or QlikView preferred
21
Data Warehouse Analyst Resume Examples & Samples
- Knowledge of basic programming concepts and systems implementation
- Hands on Cognos experience
- Strong communication skills to convey reporting requirements and deliverables to management, staff, and vendors
- The ability to manage multiple projects involving many vendors and staff members
- Ability to interface effectively with all levels and across organizational lines
- Architecture, development and support of complex database designs, including data warehouses
- Collects, analyzes, interprets, and summarizes data in preparation for generation of statistical and analytical reports
- Assist in design, programming, and implementation of systems interfaces between distributed information systems and corporate information systems
- Field support questions or problems and provide resolution or refer to vendor and log all issues and requests for tracking
- Solicit feedback from users on changes or enhancements needed
- Ensure data standards are set and met across the organization
- Communicate the details, requirements and status of all current and planned projects
- Liaison to business owners of projects
- Facilitate interview and group sessions to obtain business requirements and participate in definitions of business rules and data standards
22
Business / Data Warehouse Analyst Resume Examples & Samples
- 1 year of experience with hands–on business and data analyses in data warehousing
- Experience with Toad or SQL
- Experience in working with well in a team environment
- Experience with full life–cycle project development, requirements, design, testing, rollout, and implementation from a business analysis perspective
- Ability to write detailed requirements, meeting minutes, and data mapping documentation based on business rules provided by clients using internal templates
- Possession of excellent oral and written communication skills to organize and participate in information–gathering and validation sessions to gain insight into systems, processes, and data and to liaise with the subject matter experts throughout project life–cycle
- Possession of excellent interpersonal, organization, time management, and leadership skills
23
Marketing Data Warehouse Analyst Resume Examples & Samples
- Bachelor's degree in Marketing, Quantitative Analysis or related field , required
- Proficiency in Microsoft office programs including Word, Excel, Access and PowerPoint, required
- Proficiency in data analysis and data quality software including, Business Objects and Data Flux, preferred
- Ability to query/join/transform data in a relational database, interpret the data, analyze results and provide analysis in an actionable form, preferred
- Strong analytic skills with experience creating large data sets, spreadsheets and doing independent analysis,required
- Minimum of 3 years experience in data analysis, preferred
- Prior experience in Marketing, Market Research or Database Marketing preferred
24
Data Warehouse Analyst Resume Examples & Samples
- Strong SAS skills required
- Strong MS Office skills required - Word, Outlook, Excel
- Experience in SQL, GQL, Business Objects preferred
- Familiarity with medical coding preferred
25
Data Warehouse Analyst Resume Examples & Samples
- Advanced experience with Excel and Access
- Procurement / Supply chain experience
- Able to brief small or large groups
- Candidate must be able to obtain & maintain a secret security clearance. This requires US citizenship
- Aircraft, support equipment, training devices, maintenance experience
- Understanding of ALIS and Global Sustainment
- F-35 program knowledge / experience
- Degree in Supply Chain Management or Business
26
Data Warehouse Analyst Asc Resume Examples & Samples
- Good analytical, critical thinking, and problem solving skills
- Some experience with Microsoft Office suite and business intelligence applications
- Completed course work in business intelligence, data analytics, or information systems disciplines
- Completed some course work in the following areas – statistics, management science, database management, mathematics, or communications
- Able to work in multi-faceted, diverse environment
27
Data Warehouse Analyst Resume Examples & Samples
- Partner with business colleagues and data owners to identify, understand and define critical data elements, write complex queries to extract and analyze Authentication, Access, Risk factor, Account & Transactional data
- Identify and ensure implementation of the best approaches for tracking and resolving data quality issues
- Perform Data quality analysis, document and maintain source to target mapping
- Perform Data extracts, assessments from various platforms/sources such as Hadoop/Hive, Oracle, and Teradata etc
- Define and maintain Data Quality Controls based on data profiling results
- Define and communicate business rules and terms governing use of the data perhaps including security and data lifecycle management
- Work with our Data Quality IT Partners for Dashboard monitoring
- BA/BS
- Five to ten years of experience dealing with large scale data analysis and management preferably financial services
- Strong technical and business skills
- Experience with SQL, Hadoop, Hive, Oracle, Teradata, Excel, Visio, Tableu
- Experience using tools SQL developer, toad etc
- Experience with identifying critical data elements, Data quality and data governance techniques
- Quick learner and able to glean insights from the data
- Demonstrated oral and written communication skills
- Kafka and Splunk preferred
- Experience with data quality concepts, best practices and tools
- Familiarity with Financial services products such as brokerage, Mutual funds and retirement products
- Experience with Fraud prevention and management; demonstrated knowledge of data structure, data systems/tools and related software and data management policies and practices in a complex organizational environment preferred
- Deep understanding of how data supports business strategy, is used within business processes and its impact
- Communication and conflict resolution skills to help reconcile the different points of view and requirements that clash during cross-team and cross-organization efforts
- Effective time management, including planning and decision-making, identifying priorities and bringing projects to successful completion in a timely manner; and maintaining a focus on high standards and quality
28
Epic Data Warehouse Analyst Caboodle Resume Examples & Samples
- Collaborates with users, vendors and technical staff regarding software and hardware timelines
- Monitors deployment process through to completion
- Tracks project deliverables with appropriate assistance from technical staff
- Keeps the project management staff informed on progress and potential delays
- Assists Project Coordinators with budget development
- Initiates project tracking
- Creates and evaluates documentation ensuring that assigned documentation and project components are completed successfully within the established budgets and deadlines
- Interprets and organizes data within department guidelines for timely project completion
- Collects and documents current status of information
- Keeps Project Coordinators and/or Supervisor apprised of project status and documentation changes as required
- Collaborates with management, project team and technical staff to communicate impact of new installations on all affected areas
- Ensures appropriate steps have been taken to prepare areas
- Assists Project Coordination staff in maintaining procedure manuals for user and technical staff reference
- Reviews, researches and recommends hardware/software site informational needs
- Includes interpretation of data from multiple sources
- Working with internal project team, prepares and documents department equipment and software requests
- Provides assistance with data collection and hardware/software evaluation
- Assists with documenting equipment and software problems
- Under direction from Project Coordinator, conducts vendor follow-up for equipment and software
- Creates and edits work plan facility maps and equipment spreadsheets used by deployment team members
- 3-5 years of Epic Cogito expertise
29
Data Warehouse Analyst Resume Examples & Samples
- Bachelor’s Degree in Software Engineering, Computer Science, Data Science, or Information Sciences
- Three years of experience in a data warehousing role
- Masters Degree in Software Engineering, Computer Science, Data Science, or Information Sciences
- Excellent communication skills with clients, senior managers and executives
- Self-starter with ability to work in a team environment
- Strong problem-solving ability with a high attention to detail
- Demonstrated ability to manage multiple tasks simultaneously and complete work within allocated time frames
- Strong PC skills with experience using Microsoft Office applications
- Experience in reading/evaluating/interpreting code
- Experience with cloud computing
- Experience with SAP Hana and Hadoop ecosystem (eg. HBase, Spark, Impala, Pig, Hive, etc.)
- Experience with NoSQL database technologies (e.g., MongoDB, Cassandra, CouchDB)
- Experience with statistical analysis software (e.g. R, SPSS, SAS, RapidMiner)
- Experience with Python, SCALA, PHP, Java, Ruby
30
Data Warehouse Analyst Resume Examples & Samples
- Experience with requirements analysis and management
- Demonstrated strong management consulting qualities (need ability to multi-task, deliver quality work products, anticipate client needs, etc.)
- Interest in data management/data warehousing technical projects
- Tableau Desktop skills are a plus
- Tableau Server skills are a plus
- SQL Server skills are a plus
- SAP BusinessObjects skills are a plus
- JIRA skills are a plus
- Ability to obtain and maintain certain job-related certifications if no job-related advanced degrees
- Ability to communicate clearly in writing and verbally
31
Data Warehouse Analyst Resume Examples & Samples
- Works with team to create datasets and data interfaces for high-level analytics
- Analyzes, interprets, and translates business requirements into specific technical requirements. Designs and develops solutions when necessary
- Maintains data standards, enforces standard development protocols, and analyzes requirements to ensure technical and standard operating procedure impacts are considered. Develops and coordinates test plans
- Ensures data quality and enforce standards and procedures
- Limits the number of non-standard solutions and escalates with proper documentation when necessary
- Communication and collaboration skills
- Experience in database management, administration, and development, with a significant percentage working with SQL Server
- Experience with SQL Analysis Services, data warehousing, SharePoint and Spotfire
- Familiarity with Microsoft Visual Studio, SQL Server Reporting Services, and Team Foundation Server highly desirable
- Ability to work with a multi-disiplinary team
- Bachelor Degree preferably in Computer Science, Mathematics or related field
- 2 years’ experience with SQL Server and SQL Integration Services
32
Data Warehouse Analyst Resume Examples & Samples
- Bachelor's degree in computer science, social science, biological science, mathematics, or related field -or-equivalent combination of education and experience
- 5 years of experience with SQL or other programming languages
- 7 years of experience in an analysis or research in a health services, healthcare utilization, or quality assessment environment
- Formal training in and experience with the techniques of CQI/TQM and statistical process control methodology
- Master’s degree in an industry related field
- Experience working with medical claims data, including measuring cost, utilization, and quality of care concepts
33
Senior Data Warehouse Analyst / Developer Resume Examples & Samples
- Working with the various functional and technical teams is responsible for data design, warehouse data architecture, metadata and assisting with the data integration layer’s repository creation
- Designs and assists in developing complex data migration processes for the data warehouse
- Works with the customer data warehouse counterparts to review data loaded into the data warehouse for accuracy
- Provides recommendations regarding technology alternatives for the Enterprise Data Warehouse and Data Integration Layer
- Assists in troubleshooting and tuning data warehouse data and processes
- Develops, maintains, and supports complex enterprise data warehouse systems and corresponding data marts
- Creates new or enhanced components of the data warehouse
- NACI clearance or equivalent required
- Oracle Data Integrator experience
- Logical data modeling experience
- Physical data modeling experience
- Master data management experience
- Data warehousing experience
- Oracle and/or SQL Server experience
- Data analysis experience
- Understanding Point of Sale data (e.g., Retail)
- ERwin experience
- Program design and development experience
- APIs experience
- Experience creating complex SQL statements
- U.S. citizenship may be required. Ability to work in the United States indefinitely required
- Ability to obtain and maintain firm independence and abide by firm ethics requirements
- Meet or exceed continuing professional education (CPE) requirements
34
Data Warehouse Analyst Resume Examples & Samples
- Assists in providing timely and accurate user support for all aspects of data warehouse and CRM usage, maintenance and integration. As such must have a detailed knowledge of how the systems work, the data available and the functionality of the data access tool. (25%)
- Assists in verifying the integrity of the data warehouse and CRM, with each “load”, through the use of audit queries and investigates any irregularities ensuring that they are resolved, explained or escalated. (25%)
- Responsible for the daily maintenance, monitoring, reporting and troubleshooting of in-house selection programs, queries, stored procedures and list creation using data from various mainframe, web and external systems & sources. (20%)
- Assists and actively participates in training users on the data warehouse, CRM and their respective access tools. (20%)
- Assists in the creation and maintenance all user documentation and metadata, ensuring that it is adjusted to reflect a changing environment. (10%)
- University or College degree in Business or a related discipline
- Minimum one year experience working in a data warehouse environment
- 1 – 2 years of experience with SQL and other database languages
- Knowledge of Business Objects an asset
- Excellent analytical and interpersonal skills
35
Senior Data Warehouse Analyst Resume Examples & Samples
- Uses, protects, and discloses DMG patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards
- A minimum of three years of experience with Microsoft SQL Server including database design and writing SQL scripts
- Hands on experience with integration tools such as SSIS
- Strong background in Business Analysis including supporting the design of new Production systems or system enhancements to existing systems
- Healthcare industry experience highly desired
36
Data Warehouse Analyst Resume Examples & Samples
- Bachelors’ Degree in Computer Science, Engineering, Business or a related field
- Demonstrated knowledge with one or more business intelligence tools (e.g. Teradata, Unica, SAS, and Cognos) and ETL tools (e.g. Informatica)
- Obtains and maintains at least one or more applicable gaming licenses in multiple jurisdictions as required
37
Senior Data Warehouse Analyst Resume Examples & Samples
- Review and analyze ETL/Data Quality requirements, create design documents based on business requirement and function requirement documents
- Design and develop complex mappings using variety of complex transformations
- Profile data using to resolve inconsistencies in data and to help Data Analysts document the findings
- Build metrics and rules to standardize the data
- Troubleshoot, optimize and tune ETL processes
- Create, execute and document unit test plans based on system and validation requirements
- Ensure that all data intensive processes are optimally distributed across the layers of the overall processing environment to achieve maximum throughput
- Establishes and enforces data standards to meet IT requirements and business needs
- Assists in several components of the overall architecture of the data warehouse system
- Documents tasks for end-user, technical, and managerial review to ensure high quality
- Provide off hour production support, as needed
- 5 + years of experience on a data warehouse team with strong understanding of ETL processes and standards
- 5 + years of experience with Oracle development including high level of expertise in SQL, stored procedures, indexes, partitioning and database tuning
- 3+ years or more of UNIX or Windows scripting experience
- Experience in working with Data Quality Management tools
- LI-JC1
38
Data Warehouse Analyst Resume Examples & Samples
- Analysis and decision making related to data accuracy and program processes relevant to support aircraft DD250 and delivery, Non-Aircraft equipment delivery, or operational site standup and sustainment operations
- Support reviews, processing, and pursue approval for delivery of F-35 SDP to support aircraft or equipment deliveries and site operations or JSF site standup to include, but not limited to
- Perform data modeling/mapping/mining and Extraction, Transformation and Loading(ETL) activities
- Apply data quality forensics and participate in assessments of SDP and/or Supplier data submissions
- Support coordination with assigned users, application teams, and Suppliers, to understand issues and needs; prioritizing, determining solutions, and implementation of Action Requests (AR) resolution
- Support the logical and systematic conversion of customer or product requirements into total systems solutions that acknowledge technical, schedule, and cost constraints
- Experience in one or more of the following
- Sustainment Data Build (SDB) – including As-Delivered BOM
- Sustainment Parts Information Record (SPIR)
- Joint Technical Data (JTD)
- Logistics Reference Data
- Hands-on experience using ALGS Data Quality & Integration Management methodologies such as the Electronic Equipment Logbook (EEL)
- Reference & Initialization Data
- Working experience using F-35 ALIS applications (i.e. CMMS and CRM)
- Experience with LM Enterprise Logistics Systems TeamCenter (PDM/LDM) to review and verify Design and Logistics Data
- First-hand experience using F-35 ATLAS application to extract and verify logistics data
- Development of Aircraft/Aviation System Bills-of-Material (BOM)/Structures
- Reading, Writing, and Applying Structured Query Language (SQL) to extract, process and manipulate data
- Software development lifecycle to include ability to read, interpret, and write eXtensible Markup Language (XML)
- Hands-on knowledge with TeamCenter e-Cubed report builder
- Hands-on experience with Shop Floor Manager (SFM) System
- Hands-on experience with Quality Assurance Documentation System (QADS)
- Production Planning and/or Shop Floor Operations related to data
39
Senior Enterprise Data Warehouse Analyst Resume Examples & Samples
- Works with internal business and external vendor constituents to conduct analytic assignments in support of requested business solution(s). Develops, documents and publishes business requirements, associated business rules and data standards, and technical specifications for requested solutions. Develops design recommendations commensurate with the scope, nature and complexity of requested solution, ensuring recommendations comply with corporate architectural standards and federal and state regulations and/or mandates pertaining to the privacy and security of HPHC’s core data assets. Facilitates review of design with governing committees as necessary
- Plans, develops and implements solution designs of significant scope and complexity. Solutions may include application or extract program code, production reports, analytic finding reports, and the ad hoc identification of core dataset contaminants. Independently develops solutions of manageable scope and complexity. Leads team of junior analysts to fulfill components of solutions with significant scope and complexity
- Leads quality assurance (QA) testing for developed solutions, and participates with business requesters in their user acceptance testing once QA testing is successfully completed. Develops test strategies, plans, scripts and executes test procedures to ensure compliance of developed solution with documented specifications. Reports test results to project stakeholders
- Develops documentation of corporate information and data management standards, policies and procedures. Delivers training programs for IT and business personnel to ensure these standards, policies and procedures are well understood and adhered to by HPHC staff in accordance with regulatory requirements
- Collaborates with business content owners and technical team members to maintain core reference domain content via the Reference Table Utility (RTU) needed to support solutions. Monitors core dataset quality thresholds to identify dataset content issues that require resolution. Initiates and manages constituent-specific data remediation projects to resolve prioritized issues in collaboration with key business stakeholders and participants in data clean-up projects
- Monitors production processes of previously implemented information management solutions to proactively achieve error-free performance standards. Performs analysis to establish root cause(s) of identify issues, proposes means to resolve issues, and develop and ultimately implement necessary modifications, as needed. Makes appropriate changes to documentation, technical solutions, and prioritized data content errors
- Works with business stakeholders and external constituents to clarify and fulfill ad hoc analytic assignments of HPHC information assets. Translates business questions into analytic queries of content available within HPHC’s technical infrastructure (inclusive of operational applications and analytic databases), using SAS, SQL Navigator or comparable database querying languages
- Develops mastery of HPHC’s data warehouse, the Enterprise Data Warehouse (EDW), and participates in a user adoption program designed to expand the use and confidence in the EDW as the source for all future HPHC analytic and reporting solutions. Functions independently to fulfill information management requests within the EDW, and establishes end-user confidence in developed solutions by serving as a proponent of developed solutions among data analysts working within HPHC’s business units
- Will be responsible for all aspects of SAS application, server, user, and SAS platform administration, including implementation, configuration, upgrade, maintenance, coordination, problem resolution, testing, usage and performance monitoring and the design / development of SAS system infrastructure. Will also provide subject matter expertise, as needed, for SAS application developers and analysts
40
Data Warehouse Analyst Resume Examples & Samples
- 3+ years related experience
- Demonstrated experience/proficiency in data analysis
- Demonstrated skills working with relational databases
- Demonstrated ability and understanding of Oracle SQL Plus, PL/SQL, SQL Loader
- MS Access and Excel experience with demonstrated ability to utilize such software for business needs
- Ability to think analytically and logically to offer solutions to complex needs and for issue resolution
- Demonstrated understanding of customers' business processes, direction, strategies and practices
- Work independently under supervision
- Strong team play
- Understanding of EDI mapping is a plus
- Understanding of basic Unix skills is a plus
41
Data Warehouse Analyst / Developer Resume Examples & Samples
- 2-5 years experience with SQL, Oracle, ETL, and Data Warehousing
- 2-5 years Relevant Technical or Business work experience
- Fast paced work environment
- Desire to be self motivated
- Exceptional communication, planning, and organizational skills
- Adept at problem solving
- Oracle Database experience
- Data Warehouse experience
- Knowledge of data warehousing concepts(dimenions, facts, hierarchies, etc)
- Experience with SQL, SQL Loader, PL/SQL, and developing/reviewing complex queries
- Experience with ETL (Extract, Transform, Load) applications and tools and developing/reviewing complex ETL
- Informatica experience is a plus
- Write design docs, test plans and other supporting documentation
- Perform critical thinking and data analysis
- End-to-end Project management
- Experience in the Agile Lifecycle Methodology
- Source Control Programs
- Server application installation and configuration
- Command Line (DOS and Unix)
- Mainframe familiarity
42
Data Warehouse Analyst Resume Examples & Samples
- The Data Warehouse Analyst will provide detailed analysis, design, tuning, testing, implementation and documentation of the data warehouse and business intelligence systems
- Manage key department business intelligence applications and data warehouse acting as the technical liaison for data warehouse / business intelligence issues
- Provide front line support within a network environment of clients interfacing with server, internet, and PC based business intelligence system
- Work closely with business stake holders to further enhance the data warehouse / business intelligence environments to meet operational objectives
- Collaboratively support other IT team members to help design, develop and implement business intelligence applications
- Design and build ETL workflows resulting in either a systems integration and / or business intelligence source table from multiple data sources
- Provide technical and systems design expertise in the development of new and maintenance of existing databases
- Utilize the ETL system to manage data warehouse accuracy, quality and integrity
- Design, build and publish business intelligence reporting and / or dashboards across various platforms including SharePoint, email, excel, etc
- Responsible for data warehouse / business intelligence quality testing, stakeholder approval and user acceptance testing
- Test, install and deploy all databases and stored procedures to production servers
- Manage database and business intelligence application security and user logins
- Must maintain strict quality control over data analysis and information delivery in a fast paced environment
- Bachelor’s Degree in related field highly desired
- Experience with SQL server and ETL systems such as SSIS required
- Knowledge of CloverETL a plus
- At least 3-5 years of hands on Data Warehouse / Business Intelligence experience required
- Familiar with Windows 7 and Microsoft Office 2007/2010
- Knowledge of Salesforce or NetSuite is a PLUS
- Certifications are a PLUS
- Friendly presence and helpful attitude; good interpersonal skills and ability to work well with others
- Ability to provide support over the phone or in person while always maintaining a professional demeanor
- Good problem solving skills; ability to visualize a problem/situation and think abstractly to solve it
43
Data Warehouse Analyst Senior Resume Examples & Samples
- Analyzes more complex business user needs, documents information requirements, facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed
- Ensures proper data definitions, ownership, use and integrity of data
- Supports the validation and testing of data structure design, definitions and mapping, including business rules
- Facilitates calls with business stakeholders to discuss data requirements
- Delivers quality results while working on multiple project assignments
- Instructs, directs and reviews work of less experience data warehouse analysts
- Maintains information policies and procedures to support current and future data information needs
- Completes metadata assessment and reviews feedback to determine changes needed
- Collaborates with IT resources on the creation and maintenance of the content of the data warehouse, establishes and maintains strong knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues, completes metadata assessment and reviews feedback to determine changes, ensures that data definitions are clear and current, and communicates changes to data definitions to all users
- Experience in Teradata SQL, SQL, SAS, Business Objects, and OLAP preferred
- Excellent analytical, communication, problem-solving, and planning and organizational skills required
- Demonstrated ability to lead and plan complex, large-scale projects required
- Healthcare data knowledge for all data types
- Methodologies: Rational, Agile and Waterfall
- Business process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD/JRP Sessions, Gap Analysis and Impact Analysis
- Prefer knowledge/background in the following subject areas - Medical and Specialty Claims
- Finance and Revenue
- Membership and Eligibility
- Products, Broker
- Chart of Accounts
- Provider
- Capitation
- Utilization Management
- Case Management
- Disease Management
- Laboratory Results
- Health and Wellness Data/Survey
- Must have experience working in a Teradata environment
- Working in a virtual environment
- Detail-oriented with strong organizational and time management skills
- Ability to manage competing priorities in a fast-paced environment
44
Data Warehouse Analyst Resume Examples & Samples
- Ability to gather and document business requirements from customers
- Ability to gather and research source system field requirements, write sql transformation logic from the source fields and map to destination tables/fields
- Ability to identify and document workplan steps required to execute small projects such as file extracts
