Business Intelligence QA Analyst I

Full Job Description

Title: Business Intelligence QA Analyst (Data Integration)

Location: Malvern, PA (Hybrid 3 days onsite each month, 2 nd full week of the month on Tuesday, Weds, and Thursday and then the rest of the work will be remote. Onsite could become more frequent in the future)

Duration: 3-month contract with strong possibility of an extension

This QA Analyst will be ensuring that data is moving efficiently from an application to a Data Warehouse and focus on improving the information going from the application to the Data Warehouse. Areas that this BI QA Analyst will support will include Data Warehousing, Reporting (the reporting layer is Cognos and Tableau), and Analytics. Duties will include the following:

Review requirements and design documents with developers and quality assurance manager to confirm expected functionality with technical and business needs

Implementation, evaluation, and documentation of the developed test cases and scenarios

Determine test environment and test data requirements, often in concert with integrated systems' owners

Must be able to communicate with leads regarding project readiness, status, and potential risks.

Document, quantify, and elevate risks as appropriate

Provide statistical reporting and analysis as necessary

Tracks and coordinates defect resolution and retesting, quantifying and mitigating risk accordingly

Enthusiastically collaborates with business partners to ensure Client Mission and Core Values are fulfilled

Consult with clients and teammates to identify all facets of an issue and generate a solution

Understand potential impacts to processes and systems across organization and factors these into solution

Participate in discovery meetings, provide estimates, analyze, and validate project requirements and technical specifications, perform impact analysis and document key issues.

Develop the testing strategy and manage the testing effort

Evaluate data changes and anomalies against previous tends; and provide guidance to resolve variances

Conduct peer reviews of other analysts' work to assure testing meets specifications

Resolve issues and develop benchmarks for testing data and provide metrics reporting on test execution and defects

Participate in testing including Functional Testing, Results validation, Regression Testing, System, Integration Testing, Automated Testing and User Acceptance Testing

Communicate with data warehouse team (business analysts, data modelers and developers) regarding status, issues, and risks on a timely basis.

Identify, mitigate, and drive project issues and risks to resolution

Analyze data trends, draw conclusions, and recommend direction

Develop algorithms for capturing data changes and trends to facilitate continuous monitoring of data quality

Establish validation benchmarks and automated processes for data quality improvements for the weekly/monthly validations and data quality checks to ensure data is accurate for analytics

Develop trending reports and data quality metrics for reporting

Provide staff mentoring and guidance to foster a strong team atmosphere with an eye to customer service

Required Technical Skills and Expertise:

Minimum of 2 years of experience supporting the testing efforts affiliated with Business Intelligence and Data Warehousing efforts

Knowledge of data mining, statistical analysis, or healthcare data analytics

Experience with Informatica PowerCenter, Tableau, Cognos, and Anaplan

Skilled in developing algorithms for capturing data changes

Strong experience in writing SQL statements (DML/ DDL) and must have familiarity at the application server level

Must have backend date experience/knowledge of relational databases - can navigate and extract data

Ability and experience navigating in a Linux and a Unix session

ETL experience

Integration Testing experience

Able to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.

Ability to thrive in a very agile environment  - need to be nimble in juggling multiple projects and acting as a project manager and coordinator over their duties, with ability to quickly pivot as the priorities need to be readjusted.

Assimilates information quickly, communicates complex requirements and issues clearly and concisely.

Experience working with development team from the initial development of business requirements, through all the Agile/Scrum steps and providing on-going maintenance and support.

Knowledge of Software testing processes and automated tools, with an ability to apply software testing methods and techniques in a business intelligence environment.

Excellent critical thinking, negotiation, and problem-solving skills.

Required Soft Skills:

Ability to effectively, and professionally, communicate, both orally and in writing, while also articulating and translating technical language to non-technical customers.

Capable of influencing at all levels across the company within span of control.

Exemplifies teamwork and serves as role model, while also successfully facilitating collaboration across multiple functions, departments and levels.

Unquestionable ethics & integrity is pertinent.

Track record of consistently driving projects to completion and taking accountability for work and results, as well as confronting tough issues and situations.

Demonstrates and promotes creativity and innovation.

Proactively seeks out alternative solutions to business problems.

Desired Skills and Expertise:

Prior working knowledge and validation of IBM UnifiedData Model for Healthcare

Cloud proficiency would be a big plus (understanding how to refactor and rewrite for the cloud and big data analytics would be helpful)