iSpace
Business Intelligence QA Analyst I
iSpace, United, Pennsylvania, us, 15689
Title: Business Intelligence QA Analyst (Data Integration)Location: 100% remoteDuration: September 2024 - December 31, 2024 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 needsImplementation, evaluation, and documentation of the developed test cases and scenariosDetermine test environment and test data requirements, often in concert with integrated systems' ownersMust be able to communicate with leads regarding project readiness, status, and potential risks.Document, quantify, and elevate risks as appropriateProvide statistical reporting and analysis as necessaryTracks and coordinates defect resolution and retesting, quantifying and mitigating risk accordinglyEnthusiastically collaborates with business partners to ensure Client Mission and Core Values are fulfilledConsult with clients and teammates to identify all facets of an issue and generate a solutionUnderstand potential impacts to processes and systems across organization and factors these into solutionParticipate 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 effortEvaluate data changes and anomalies against previous trends; and provide guidance to resolve variancesConduct peer reviews of other analysts' work to assure testing meets specificationsResolve issues and develop benchmarks for testing data and provide metrics reporting on test execution and defectsParticipate in testing including Functional Testing, Results validation, Regression Testing, System, Integration Testing, Automated Testing and User Acceptance TestingCommunicate 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 resolutionnalyze data trends, draw conclusions, and recommend directionDevelop algorithms for capturing data changes and trends to facilitate continuous monitoring of data qualityEstablish validation benchmarks and automated processes for data quality improvements for the weekly/monthly validations and data quality checks to ensure data is accurate for analyticsDevelop trending reports and data quality metrics for reportingProvide 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 effortsKnowledge of data mining, statistical analysis, or healthcare data analyticsExperience with Informatica PowerCenter, Tableau, Cognos, and AnaplanSkilled in developing algorithms for capturing data changesStrong experience in writing SQL statements (DML/ DDL) and must have familiarity at the application server levelMust have backend date experience/knowledge of relational databases - can navigate and extract datbility and experience navigating in a Linux and a Unix sessionETL experienceIntegration Testing experienceble to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.bility 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.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 Unified Data Model for HealthcareCloud proficiency would be a big plus (understanding how to refactor and rewrite for the cloud and big data analytics would be helpful)
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 needsImplementation, evaluation, and documentation of the developed test cases and scenariosDetermine test environment and test data requirements, often in concert with integrated systems' ownersMust be able to communicate with leads regarding project readiness, status, and potential risks.Document, quantify, and elevate risks as appropriateProvide statistical reporting and analysis as necessaryTracks and coordinates defect resolution and retesting, quantifying and mitigating risk accordinglyEnthusiastically collaborates with business partners to ensure Client Mission and Core Values are fulfilledConsult with clients and teammates to identify all facets of an issue and generate a solutionUnderstand potential impacts to processes and systems across organization and factors these into solutionParticipate 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 effortEvaluate data changes and anomalies against previous trends; and provide guidance to resolve variancesConduct peer reviews of other analysts' work to assure testing meets specificationsResolve issues and develop benchmarks for testing data and provide metrics reporting on test execution and defectsParticipate in testing including Functional Testing, Results validation, Regression Testing, System, Integration Testing, Automated Testing and User Acceptance TestingCommunicate 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 resolutionnalyze data trends, draw conclusions, and recommend directionDevelop algorithms for capturing data changes and trends to facilitate continuous monitoring of data qualityEstablish validation benchmarks and automated processes for data quality improvements for the weekly/monthly validations and data quality checks to ensure data is accurate for analyticsDevelop trending reports and data quality metrics for reportingProvide 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 effortsKnowledge of data mining, statistical analysis, or healthcare data analyticsExperience with Informatica PowerCenter, Tableau, Cognos, and AnaplanSkilled in developing algorithms for capturing data changesStrong experience in writing SQL statements (DML/ DDL) and must have familiarity at the application server levelMust have backend date experience/knowledge of relational databases - can navigate and extract datbility and experience navigating in a Linux and a Unix sessionETL experienceIntegration Testing experienceble to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.bility 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.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 Unified Data Model for HealthcareCloud proficiency would be a big plus (understanding how to refactor and rewrite for the cloud and big data analytics would be helpful)