|Friday, January 12th, 2024
|St. Louis, MO
|Over 1 year
|Data Quality, SQL, Healthcare
Data Analyst with healthcare
St. Louis, MO
Amitech Solutions is currently looking for a Data Quality Analyst in a data warehouse environment to manage and develop Data Quality (DQ) Programs in St. Louis.
The Data Quality Analyst is responsible for helping to ensure that data in the data warehouse is fit for purpose and meets the data quality and accuracy requirements of the Organization. The Data Quality Analyst is an expert in understanding the need for data quality and accuracy and how to apply Data Quality tools and techniques to monitor and support high quality of data in the data warehouse and analytics environment. Skills: Data Quality, Master Data, Reference Data, Data Profiler, DB2, Data Warehouse, EDW, Business Intelligence, BI, MDM, SQL, Healthcare Domain knowledge
Data Quality Analyst
Conduct data profile and collects metrics in support of continual data improvement
Review data staged and loaded into the data warehouse for reporting data quality metrics
Perform problem investigations, identifies data related issues, and recommends applicable solutions
Recommend maintenance enhancements to data acquisition processes to improve the quality of data warehouse assets
Make recommendations to operational and external systems support staff for enhancing to systems-of- record to improve operational data quality
Review referential integrity and entity resolution of data loaded into the data warehouse and other BI data stores
Contribute to database design, security, data storage, and data management initiatives
Develop and promote standardization in support of improvement of data quality
Help drive organizational agreement on definitions, business rules and permissible domain values for enterprise-shared data
Identify master data sources and unique identifiers for master data
Assure accuracy of master data elements and timeliness of updates
Record data quality issues identified during the analysis phase to the appropriate data owners for corrective action.
Perform Data Profiling of Data Quality (DQ) targeted source data, and reporting of results.
Assist with data discovery and perform data quality profiling.
Use advanced SQL skills to develop SQL queries to better understand what data exists in a file or table, what contents look like in each field, etc.
Perform Data Quality (DQ) Cleansing based on DQ profiling results.
Assist with testing - may provide help to create data scenarios in input files and more likely will assist with reviewing and analyzing test results. May assist the ETL team during unit testing, may help the BA's and QA tester during their internal (system) testing, and may even provide help during User Acceptance Testing.
Perform Metadata documentation for the business information requirements.
Advanced SQL programming skills
Advanced Excel experience, but also proficiency with applications including MS Word, PowerPoint, SharePoint, Visio
Expertise with detail-oriented work
Data Cleansing experience
Data Profiling experience
Previous experience with Data Quality tracking processes/systems and tools, such as SPSS Modeler, DataFlux, Infosphere Quality Stage, Informatica Data Quality, etc.
Detailed knowledge of concepts and principles specific to data quality, master data, reference data, entity resolution, and data warehouse architectures/environments
Hands-on knowledge of relational and dimensional data models
Ability to investigate and integrate information from varying sources and highlight inconsistencies
Excellent written and verbal communication skills - will work with multiple analysts and potentially business users to ask questions
Effective problem solving and analytical skills
Experience with and demonstrated understanding of SDLC
Bachelor’s Degree (preferably in MIS, Business Intelligence, Data Quality, Mathematics, or Computer Science)
Health Insurance data, terminologies, and processes
Statistical analysis tool experience
BI tools and key data warehouse principles
MS Access experience
SQL Svr knowledge
About Amitech Solutions:
Amitech Solutions is a leading provider of business intelligence, business analytics, data warehousing, data integration, IT consulting and Outsourcing services.
Amitech Solutions, founded in 1999, is a management and technology consulting firm headquartered in St. Louis MO. Amitech Solutions collaborates with clients across different industries to increase business performance and operational efficiency by developing and deploying customized solutions to meet their unique needs.
Our customers depend on us for deep industry knowledge coupled with expertise in data warehousing, big data, business intelligence, information management, and enterprise solutions technologies to solve their pressing challenges.
Browse IT Jobs by location:
To search for remote jobs, enter optional keywords followed by Remote.
To search for remote jobs in a specific country, add that country. For example, Remote UK.
Enter Silicon Valley or
Alberta – 11 jobs
British Columbia – 10 jobs
Manitoba – 0 jobs
New Brunswick – 0 jobs
Newfoundland and Labrador – 0 jobs
Northwest Territories – 0 jobs
Nova Scotia – 0 jobs
Nunavut – 0 jobs
Ontario – 13 jobs
Prince Edward Island – 0 jobs
Quebec – 0 jobs
Saskatchewan – 0 jobs
Yukon – 0 jobs
England – 59 jobs
Northern Ireland – 0 jobs
Scotland – 0 jobs
Wales – 0 jobs
Alabama – 2 jobs
Alaska – 1 job
Arizona – 4 jobs
Arkansas – 14 jobs
California – 100 jobs
Colorado – 16 jobs
Connecticut – 8 jobs
Delaware – 2 jobs
District of Columbia – 15 jobs
Florida – 31 jobs
Georgia – 13 jobs
Hawaii – 2 jobs
Idaho – 2 jobs
Illinois – 14 jobs
Indiana – 9 jobs
Iowa – 8 jobs
Kansas – 1 job
Kentucky – 4 jobs
Louisiana – 4 jobs
Maine – 0 jobs
Maryland – 11 jobs
Massachusetts – 43 jobs
Michigan – 6 jobs
Minnesota – 11 jobs
Mississippi – 0 jobs
Missouri – 5 jobs
Montana – 0 jobs
Nebraska – 1 job
Nevada – 1 job
New Hampshire – 1 job
New Jersey – 48 jobs
New Mexico – 2 jobs
New York – 152 jobs
North Carolina – 17 jobs
North Dakota – 0 jobs
Ohio – 18 jobs
Oklahoma – 2 jobs
Oregon – 26 jobs
Pennsylvania – 22 jobs
Rhode Island – 3 jobs
South Carolina – 4 jobs
South Dakota – 0 jobs
Tennessee – 3 jobs
Texas – 48 jobs
Utah – 8 jobs
Vermont – 0 jobs
Virginia – 19 jobs
Washington – 31 jobs
West Virginia – 0 jobs
Wisconsin – 5 jobs
Wyoming – 0 jobs
Our commitment to job seekers
Job seekers, we're committed to making your job search experience a breeze. Please, note the following four things:
- We never ask you to register or fill out an application form with a million questions. Everything is in your resume, and if job posters have questions, they can and should follow up with an interview. That's what an interview is for!
- We never direct you to various third-party websites or Applicant Tracking Systems (ATS) where you have to register or fill out the same huge application forms again and again and again
- We use Ajax to submit your resume, and here's the zest of our website
- By default, we save your application information in local storage. If your cover letter is generic enough, you'll save a few keystrokes when you apply for another job!
It's extremely easy to submit your resume to multiple jobs on our website! Please, check us out and help spread the word about us!
Our domain name is easy to remember. Those who know C++, C# or Java will easily recognize the static keyword in our company name.
Now, if you're really brave, we encourage you to read about some serious problems this website addresses. These problems plague all niche job boards out there as well as the big guns in the recruitment industry. This is the most important part! Please, read it!