183 applicantsPosted by Agency

Company

Mastech Digital · 1 day ago

Healthcare Business Analyst

Tennessee, United States

Contract

Remote

Mid Level

Maximize your interview chances

Information Technology

Growth Opportunities

H1B Sponsor Likely

Insider Connection @Mastech Digital

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Recent Healthcare experience is mandatory.

Data analyst who has strong healthcare knowledge around medical/Rx claims and pharmacy and Clinical/CMS data.

Strong SQL background.

Experience working in the data warehouse & database technologies (Required)

Experience working with various healthcare software (e.g., EMR, EHR, Population Health Management, Practice Management) (Required)

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Perform internal user acceptance testing (UAT) of conformed layer tables and Enterprise Data Warehouse objects modeled in STAR and Snowflake schema design.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Healthcare experienceMedical claims knowledgeRx claims knowledgeClinical/CMS data knowledgeSQLMS SQL ServerT-SQL QueriesData warehouse technologiesHealthcare softwareSSISDynamic-queriesComplex joinsStored ProceduresEMR softwareEHR softwarePopulation Health ManagementPractice Management softwareTriggersUser-defined FunctionsCursorsUser acceptance testingSTAR schema designSnowflake schema design

Required

Recent Healthcare experience is mandatory.

Data analyst who has strong healthcare knowledge around medical/Rx claims and pharmacy and Clinical/CMS data.

Strong SQL background.

Experience working in the data warehouse & database technologies.

Experience working with various healthcare software (e.g., EMR, EHR, Population Health Management, Practice Management).

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Perform internal user acceptance testing (UAT) of conformed layer tables and Enterprise Data Warehouse objects modeled in STAR and Snowflake schema design.

Company

Mastech Digital

Glassdoor

4.1

Mastech Digital provides IT associates in digital and mainstream technologies, Digital Transformation Services around Salesforce.com and SAP

Founded in 1986

Pittsburgh, Pennsylvania, USA

1001-5000 employees

http://www.mastechdigital.com/

H1B Sponsorship

Mastech Digital has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (398)

2022 (900)

2021 (896)

2020 (594)