Data Warehouse Analyst Job Description
Data warehouse analyst
provides clear documentation on the data requirements, data architecture, database design, data definitions, data audits, technology stack, data security, roadmap and development plan, etc.
Data Warehouse Analyst Duties & Responsibilities
To write an effective data warehouse analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehouse analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Peer review Informatica mappings, SQL code, etc to ensure the delivery meets the Business requirement
Experience configuring/setup of reporting suites (similar to Pentaho, Tableau)
Serve as liaison between IT and business end-users
Identify opportunities for eliminating or streamlining manual reporting processes
Write business, functional and technical requirements documents, test plans and implementation plans
Perform data analysis based on User queries and issues and identify root causes
Constantly examine quality processes for inefficiencies and makes improvements
Convert Business requirements into functional / technical specifications
Participate in agile daily scrums, sprint planning and sprint retrospective activities
Demonstrate ability to understand and work effectively within complex IT environment containing, multiple development and testing environments, sharing of environment with multiple teams
Data Warehouse Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Warehouse Analyst
List any licenses or certifications required by the position: PMI, CBAP, PMP, CPQ, ISTQB, ISEB, DFSS, SQL, MS, CBIP
Education for Data Warehouse Analyst
Typically a job would require a certain level of education.
Employers hiring for the data warehouse analyst job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Collage Degree in Computer Science, Education, Business, Information Systems, Engineering, Technical, Information Technology, Business/Administration, Management Information Systems, Finance
Skills for Data Warehouse Analyst
Desired skills for data warehouse analyst include:
Capabilities
Definitions
Data integrity issues
Data warehouse data structure design
SQL
Tableau
Communicates changes to data definitions to all users
Completes metadata assessment and reviews feedback to determine changes
Ensures that data definitions are clear and current
Application and database tuning
Desired experience for data warehouse analyst includes:
Requires strong analytical, attention to detail, organizational and problem solving skills the ability to effectively work with management, peers, and staff
7+ years of progressive responsibilities in IT
5+ years Business Objects and ETL/DataStage development experience
Proficient with Business Objects BI 4
Proficient with including metadata, reports and dashboards
Expertise in transforming requirements into optimal Business Objects Reports/Universes
Data Warehouse Analyst Examples
1
Data Warehouse Analyst Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of data warehouse analyst. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for data warehouse analyst
- Ability to quickly grasp problems and issues and communicate effectively with other team members in multiple locations
- Relevant experience of Finance sector would be a plus
- Work with subject matter experts, define business requirements, business rules, and produce documentation that is client facing technical documentation used by developers
- Primary point of contact working with stakeholders to understand their systems, processes, and business needs
- Map sources to targets using a variety of tools, including BusinessObjects Data Services/BODI
- Translates ad-hoc requests for data into a report based on business rules
- Participates in all phases of data warehouse implementation
- Identifies and recommends methods to normalize and maintain data from disparate systems
- Troubleshoots data warehouse software
- Conducts and attends team meetings, and communicates (verbally and in writing) team and project issues to appropriate staff and customers
Qualifications for data warehouse analyst
- 4+ years experience in business analysis, operations support, software development, project management, or other directly related experience
- Coordinate development with off shore team
- Experience in prioritizing and managing multiple requests or requirements to meet corporate business objectives
- Technically proficient in software including MS Word, Excel, & Visio
- Design skills necessary to create and execute moderately complex test plans
- Analytical skills necessary to perform analysis as part of business assessment projects
2
Data Warehouse Analyst Job Description
Job Description Example
Our company is searching for experienced candidates for the position of data warehouse analyst. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data warehouse analyst
- Maintain an understanding of innovative IT product capabilities, marketplace and business opportunities
- Programs data edit checks used in execution of clinical data cleaning plans
- Programs data review tools used for clinical data review
- Acts as technical resource for other functions within DSS
- Supports ad-hoc and project-specific requests
- Changes data models and structures in support of post-production change activities
- Actively collaborates with other DSS functions
- Identifies and executes needed updates to design specifications, clinical trial application interfaces, data models and data structures
- Escalates data model, data structure and/or database issues to Data Analyst, Testing Specialist, Statistical Programmer and/or Statistician
- Understanding of Teradata/ Oracle Business Intelligence/ Hadoop Access Request process and monitors all requests ensuring appropriate manager and Data Steward Approval is in place before granting access
Qualifications for data warehouse analyst
- Ability to work with multi-tier software systems, and use a combination of command-line and client-based tools for test case development and execution
- Business Analysis - Take direction from the Lead BA/Architecture or Analysis committees to review and enhance the functional design
- Managing Product & Solution Complexity – Work with technology and business teams to identify options for addressing business requirements, technology limitations
- Associates Degree in Information Technology Field or equivalent work experience is required
- Able to document functional & non-functional requirements
- Must have experience of analyzing large data sets
3
Data Warehouse Analyst Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of data warehouse analyst. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data warehouse analyst
- Ability to work well under pressure to meet targets and deadlines
- Participate in workshops with client’s stakeholders to validate business requirements & functional specifications
- Uses, protects, and discloses patients protected health information (PHI) in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards
- Help define the business requirements and functional specifications for the development of the Data Warehouse (DWH) platform
- Collaborate with technology teams to integrate source systems with the data warehouse
- Create technical designs, develop, test and implement DWH/ETL (Extract, Transform & Load) and BI solutions
- Support DWH/ETL solutions and operations
- Develop and maintain logical and physical data models for enterprise data architectures (relational & multidimensional)
- Provide guidance and support to developers
- Design and build all data warehouse environments, and analytic databases
Qualifications for data warehouse analyst
- Must submit your application for employment through COS (internal
- Experience in working on projects with demanding timelines and be able to handle multiple work streams
- Strong communication skills as the individual will need to work closely with clients, users and managers
- Knowledge of medical claims data including claim, member, provider, clinical
- Seeking a thought leader who is passionate about business analysis, product development and delivery
- This position will be accountable for capturing requirements analyzing how business processes work within an organization and provides change leadership improvement methods to produce lasting changes resulting in quantifiable business results improvements
4
Data Warehouse Analyst Job Description
Job Description Example
Our company is hiring for a data warehouse analyst. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data warehouse analyst
- Develop test plans and design test cases
- Collaborate with stakeholders to clarify project requirements and business objectives and acquire commitments
- Decompose business problems quickly and work with the project team to determine the root cause and provide solution alternatives
- Derive a detailed understanding of the stated business problem and objectives and work with the stakeholder and technical team toward resolution to achieve the objectives
- Plan and facilitate requirements gathering utilizing focus sessions, one-on-one interviews, and job shadowing
- Utilize advanced modeling techniques to develop high-level system narratives, presentations, storyboards, use cases and user interface prototypes
- Work with QA team to develop system test plans, ensure software quality assurance (SQA)
- Work with stakeholders to gather prioritized requirements, establish scope, select appropriate analytical methodologies, and set expectations for reporting or analysis deliverables, in order to successfully address business issues
- Develop best practices for data loading and extraction into and out of the data warehouse
- Plan, design, schedule and coordinate data warehouse analysis, design, development, and deployment
Qualifications for data warehouse analyst
- Minimum 2-5 years of experience in analytics, reporting and data warehousing
- Techno-functional knowledge of areas like SAP, Workday and related analytics for a software oriented business is desirable
- A bachelor’s degree in engineering or master’s degree in statistics, or mathematic is preferred (a degree in Finance or business is acceptable)
- Person should be able to work on site in San Jose, CA
- Bachelor’s degree in IT or related technical field of study
- 3+ years of Experience in creating technical specification creating and executing detailed test plans
5
Data Warehouse Analyst Job Description
Job Description Example
Our company is looking to fill the role of data warehouse analyst. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for data warehouse analyst
- Investigates, designs, and implements business solutions and major upgrades or enhancements to existing solutions
- Assists in complex data analysis and translates business needs into Warehouse/ Business Intelligence solutions
- Seeks to understand user's business activities
- Participates in and occasionally leads the presentation of the results of analysis to development, users, and other analysts as necessary
- Writes both business and technical documentation that is appropriate to support the development and end user community
- Contributes to project plans as requested by project managers or director
- Assists internal management in establishing project priorities and in allocating service delivery resources
- Trains peers in the use of new tools, languages, and procedures
- Assists with data training to ensure the end users of the Warehouse and the BI platform fully understand all components
- Work with business stakeholders and the Data Warehouse development team through all phases of the Software Development Life Cycle
Qualifications for data warehouse analyst
- 1-2 Years Experience with a procedural programming language, preferably VBA
- Experience with Star Schema/Dimensional Modeling design and implementation of ETL processes
- Experience with designing Dashboards
- Microsoft DAO/ADO
- Experience with Kimball Group Data Warehousing techniques
- Microsoft PowerPivot/DAX Formula Language