Data Analyst II

Integrity Management Services, Inc.

. Design, develop, maintain, and optimize ETL processes for data integration, validation, reporting, and analytics.

Posted 10/2/2026full-timeRemote • Virginia • United StatesMid-LevelSenior💰 $55,000 - $75,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing ETL processes, data integration, and analytics using Python, SQL, and Snowflake. Proficient in statistical analysis, data modeling, and cloud-based data engineering, with a strong focus on delivering actionable insights and maintaining data quality.

Highest-signal resume keywords

ETL Process DevelopmentPython ProgrammingSQL Query OptimizationSnowflake Data SolutionsData Quality Assurance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL ProcessesData IntegrationStatistical AnalysisData ModelingSQL DevelopmentPythonRSASData ProfilingData Cleansing

Soft Skills

Effective CommunicationCollaborationProblem-SolvingTime ManagementPrioritization

Tools & Technologies

SnowflakeDatabricksAWSS3GlueAirflowStreamlitSnowsight NotebooksCI/CDData Pipelines

Industry Keywords

Data AnalyticsBusiness IntelligenceData GovernanceHealthcare DataMedicaid Claims Data

Tech Stack

Tools & technologies

AirflowAWSAzureCloudETLPythonSQL

About the role

Key responsibilities & impact

Design, develop, maintain, and optimize ETL processes for data integration, validation, reporting, and analytics.
Conduct business analysis using statistical techniques, data mining, and explanatory or predictive modeling.
Build analytical models and data solutions using Python, Snowflake, Databricks, R, SQL, and SAS.
Research industry best practices and develop actionable recommendations for business operations.
Write, troubleshoot, and optimize complex SQL queries, stored procedures, views, and data pipelines.
Perform data profiling, cleansing, transformation, reconciliation, and quality assurance.
Design, develop, and support Snowflake data pipelines using Streams, Tasks, Time Travel, Snowsight Notebooks, and Streamlit applications.
Monitor and resolve production data issues, perform root cause analysis, and implement corrective actions.
Develop automated data ingestion, validation, auditing, and reconciliation processes.
Support CI/CD deployment, release management, and process automation.
Collaborate with cloud engineering teams on AWS solutions using S3, Glue, and Airflow.
Gather analytical requirements from internal and external clients and deliver ad hoc reports and data products.
Translate business data into clear insights for technical and non-technical stakeholders.
Collaborate with business users, data engineers, and technical stakeholders to implement scalable data solutions.
Participate in team projects and brainstorming sessions supporting program goals.
Communicate analytical methods and results clearly.

Requirements

What you’ll need

Minimum of a Bachelor’s Degree or a related discipline, or in another relevant field in health-related, scientific, public policy, business, data science, statistics, or a scientific discipline with extensive quantitative methods/statistical coursework.
At least 3 years of relevant experience in data analytics, SQL development, ETL/ELT processes, reporting, business intelligence, data engineering, or related data management functions.
Strong proficiency in Python, R, SQL, and SAS.
Hands-on experience developing solutions within Snowflake environments, including Snowsight Notebooks, Streamlit applications, data pipelines, and cloud-based data engineering workflows.
Experience designing, developing, maintaining, and troubleshooting ETL/ELT processes and data integration workflows within cloud-based environments such as Snowflake, Databricks, Azure, AWS, or similar platforms.
Experience with Snowflake Streams, Tasks, Time Travel, Snowsight Notebooks, and Streamlit application development.
Experience supporting production environments, resolving data incidents, and performing root cause analysis.
Strong understanding of data warehousing concepts, large-scale data processing, and dimensional data modeling.
Experience utilizing AWS services such as S3, Glue, Airflow, or similar cloud-based data engineering tools.
Knowledge of CI/CD processes, source control, release management, automated deployments, and process automation.
Experience implementing data governance, monitoring, auditing, and data quality controls.
Experience with healthcare or Medicaid claims data is highly preferred.
Experience with AI/ML tools, frameworks, or model deployment is preferred.
Knowledge of intermediate data analysis techniques, including data profiling, trend analysis, statistical methods, and data quality assessment.
Must pass post hire background screening checks.
For remote work, required to have wired and/or wireless internet access.
Ability to obtain security clearance, if required by Client/Contract.
Ability to communicate effectively in writing and orally to a variety of audiences.
Ability to work collaboratively, independently, manage multiple tasks, prioritize assignments, maintain confidentiality, and meet deadlines.

Benefits

Comp & perks

Vacation
Sick leave
Paid holidays
Health insurance
Dental insurance
Vision insurance
Short- and long-term disability
Life insurance
Employee assistance plan
401(K) retirement plan
Educational benefits
Remote work