Browse
Employers / Recruiters
Negotiable
Full-time
Continue
By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.
 
Duration: 6 months contract
Job Description:
·  Knowledge in data access, use of database tools, data modeling concepts, data mapping, database analysis, primary keys, indexing, data integrity issues, metadata, dataflow and project management.
·  Strong interpersonal and communication skills are a must as this position involves collaboration with teams across the organization and external resources.
·  The chosen individual will be a self-motivated and self-directed analyst to drive the design and development of data analytics tools and reports.
·  This position requires excellent data analysis skills and a big-picture perspective.
·  Candidate must demonstrate strong analytical skills and experience working to develop, implement and interpret complex data and processes(i.e. provider profiles, statistical utilization analyses, NSF/ANSI file specifications, HIPAA legislation.
 
Test Planning
·  Build Data Quality and Reporting specific Test Plans
·  Establish SLA's and standards of performance with the users
·  Define appropriate standards, workflows, audit requirements, etc…
 
Extraction Validation and Data Transformation Validation
·  Data Model Validation
·  Source Extraction Logic Validation
·  Referential Integrity
·  Load validation – check business rule logic for one-time and incremental
 
Report Validation
·  Layout validation
·  Report data validation (SQL against DB to compare)
·  Navigation through Drill Up, Drill Down
·  Compatibility on multiple browsers
·  CSS Validation, where applicable /Web testing: Functionality testing.  Ensure web formatting/ styling testing (CSS)/ html
·  Security – right people only see the right stuff
 
Performance
·  Batch Job performance
·  Report Job performance
·  Responsiveness of the reports interactively
 
Automation
·  Work with QMO Automation team to build automation scripts (or have them built)
 
User-acceptance testing
·  Coordinate user acceptance testing
 
Responsibilities:
·  Responsible for defining and implementing a data quality methodology and standards required for the program.
·  Act as the primary liaison between business team and developers for data quality issues, opportunities.
·  Assist and coordinate assessments and implementations of data quality standards and solutions.
·  Manage and execute the creation and distribution of data quality reports.
·  Work with development team to correct data quality errors.
·  Determine root cause for data quality errors and make recommendations for long-term solutions.
·  Develop process improvements to enhance overall data quality.
·  Participate in reviews of data models, data mapping documents, and ETL design and coding.
·  Develop complex SQL queries for querying data against different databases and source files for data verification process such as checking for duplicates, null values, truncated values and ensuring correct data aggregations.
·  Develop scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
·  Communicate defects identified in testing environment to the developers and ensure they are documented using the agreed upon defect tracking tool.
·  Manage scope to ensure that perceived defects are actually requirement defects and not something that would be 'nice to have, but we forgot to ask.
 
Skills and Comfort areas:
·  Establish/implement/ensure data quality and best practices
·  Plan/coordinate testing environments & infrastructure
·  Plan/develop automated frameworks to adhere to data quality.
·  Plan and create test data sets/scenarios, including the creation of flat files and excel sheet to use as data sources.
·  Identify and mitigate risks/issues related to data quality.
·  Ensure alignment of data quality/test plans to business case/value
·  Develop, document and implement risk mitigation plans specific to QA
·  Design processes for reporting and communicating the data/report QA status
·  Execute test status reports and communicate to appropriate audiences
·  Communicate potential issues to appropriate audiences
·  Document test results and ensure adherence to test reporting standards
·  Ensure compliance with applicable data quality standards and best practices
·  Extensive experience in developing SQL scripts to validate ETL processes, source, staging, data warehouse, and data marts tables and reports data for backend database testing.
·  Perform data analysis of ETL processes by writing complex SQL queries to validate reports against the database. Including performing Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
·  Interact with Business users  and developers to understand the functional requirements including test source data preparation, writing test cases to test data completeness, data transformations, data quality, data aggregations− match aggregated data against staging tables and/or ODS, and granularity of data is as per specifications, providing feedback to designers and developers.  
 
Position Requirements:
  • Formal Quality Assurance (QA) experience and utilization of typical testing tools and processes.
  • Excellent SQL skills, including defining, executing, and interpreting complex/nested SQL queries.
  • Excellent communication and interpersonal skills required.
  • Experience with Webfocus/ Tableau or some other some data reporting plaform(s) desired
  • Experience with Data profiling tools like Information Analyzer or other tools like query surge a plus.
  • Experience in an Agile/ SCRUM development environment/process.
  • Proficient with JIRA for defect tracking defects and reporting.
  • Good data analysis and debugging skills
  • Experience in data and BI testing with strong data analysis, SQL & data analytical skills.
  • Strong knowledge on ETL and BI processes preferred.

Last updated on Sep 28, 2018

See more

More jobs at ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo

Analyzing

Stamford, Connecticut

 · 

30+ days ago

Dallas, Texas

 · 

30+ days ago

Atlanta, Georgia

 · 

30+ days ago

Hanover, New Jersey

 · 

30+ days ago

New Hartford, New York

 · 

30+ days ago

More jobs like this

Analyzing
Senior Software Engineer, Support Tools (Full Stack)
Keeper Security ·  Password manager and cybersecurity solutions

Remote

 · 

30+ days ago

Test
G
Grapevine ·  Influencer marketing platform for YouTube

Boston, Massachusetts

 · 

30+ days ago

Remote

 · 

30+ days ago

Remote

 · 

30+ days ago

test
S
shib

Portland, Oregon

 · 

30+ days ago

Oracle Financial - Application Developer Consultant Sr
R
rsjdnwc9jel4i3xyjsm3m8vnhrmayk037bphn44zg3i1bl3dcjtqhqlclsisinpr

Glen Allen, Virginia

 · 

30+ days ago

Application Developer 1
Lakepointe ·  Healthcare services

Rockwall, Texas

 · 

30+ days ago

Informatica Developer
B
b8jdnwfetm91aeh4xxktytk2xff310011dbi7c94iwf3w4g8qka7cjkc4daepyd7

Washington, District of Columbia

 · 

30+ days ago

Boston, Massachusetts

 · 

30+ days ago

Remote

 · 

30+ days ago

Developed by Blake and Linh in the US and Vietnam.
We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord
Changelog
🚀 LaunchpadNov 27
Create a site and sell services based on your resume.
🔥 Job search dashboardNov 13
Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.
🫡 Cover letter instructionsSep 27
New Studio settings give you control over AI output.
✨ Cover Letter StudioAug 9
Automatically generate cover letters for any job.
🎯 Suggested filtersAug 6
Copilot suggests additional filters above the results.
⚡️ Quick applicationsAug 2
Apply to jobs using info from your resume. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.
🧠 Job AnalysisJul 12
Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status