Title: Business Intelligence QA Analyst (Data Integration)
Location: Malvern, P (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. reas 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
nalyze 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 dat bility and experience navigating in a Linux and a Unix session
ETL experience
Integration Testing experience
ble to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.
ssimilates 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: bility 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)
