Data Analyst II (Full-time, Remote)
About Us
Integrity Management Services, Inc. (IntegrityM) is an award-winning, women-owned small business specializing in assisting government and commercial clients in compliance and program integrity efforts, including the prevention and detection of fraud, waste and abuse in government programs. Results are achieved through data analytics, technology solutions, audit, investigation, and medical review.
At IntegrityM, we offer a culture of opportunity, recognition, collaboration, and supporting our community. We thrive off of these fundamental elements that make IntegrityM a great place to work. Our small, flexible workplace offers an exceptional quality of life and promotes corporate-driven sustainability. We deliver creative solutions that exceed goals and foster a dynamic, idea-driven environment that nurtures our employees’ professional development. Large company perks…Small company feel!
In this role, the Data Analyst II will provide data engineering, analytics, and production support services through the design, development, maintenance, and optimization of Snowflake-based data solutions, ETL/ELT pipelines, reporting and advanced analytics. The Data Analyst II will support data integration, data warehousing, and cloud-based data engineering initiatives while working independently and collaboratively with project stakeholders to develop high-quality, data-driven solutions.
Job Responsibilities:
Business Analysis and Data Modeling
- Design, develop, maintain, and optimize ETL (Extract, Transform, Load) processes to support data integration, validation, reporting, and analytics requirements.
- Conduct routine and advanced business analysis using statistical techniques, data mining, and explanatory or predictive modeling to support operational and strategic decisions.
- Build and apply complex analytical models and data solutions using tools such as Python, Snowflake, Databricks R, SQL and SAS to address project-specific requirements and support operational decision-making.
- Research industry best practices and contribute to the development of data-driven solutions and actionable recommendations for improving business operations.
- Write, troubleshoot, and optimize complex SQL queries, stored procedures, views, and data pipelines across relational and cloud-based data platforms.
- Perform data profiling, cleansing, transformation, reconciliation, and quality assurance activities to ensure the accuracy and integrity of analytical datasets.
- Design, develop, and support data pipelines utilizing Snowflake features including Streams, Tasks, Time Travel, Snowsight Notebooks, and Streamlit applications.
- Monitor, troubleshoot, and resolve production data issues, conducting root cause analysis and implementing corrective actions.
- Develop and maintain automated data ingestion, validation, auditing, and reconciliation processes to ensure data integrity and reliability.
- Support CI/CD deployment activities, release management, and process automation initiatives.
- Collaborate with cloud engineering teams to support solutions leveraging AWS services including S3, Glue, and Airflow.
Client Engagement and Reporting
- Collaborate with internal and external clients to gather analytical requirements and deliver ad hoc reports and data products that meet defined objectives.
- Interpret business data and translate findings into clear, meaningful insights for diverse audiences, including technical and non-technical stakeholders.
- Collaborate with business users, data engineers, and technical stakeholders to define data requirements and implement scalable data ingestion, transformation, and reporting solutions.
Collaboration and Communication
- Participate in team projects and brainstorming sessions to evaluate methodologies and study designs that support program goals.
- Communicate analytical methods and results clearly, ensuring procedures and outcomes are well understood by both technical teams and end users.
- Research best practices and supports developing the solutions and recommendations for the current business operations.
- Performs routine business analysis using various techniques (e.g. statistical analysis, explanatory and predictive modeling, data mining).
Requirements
Job Qualifications:
- 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.
- Possesses 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, with hands-on experience developing solutions within Snowflake environments including Snowsight Notebooks, Streamlit applications, data pipelines, and cloud-based data engineering workflows.
- Strong SQL proficiency, including development and optimization of complex queries, joins, views, stored procedures, and data validation to support reporting, analytics, and data warehousing initiatives.
- 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 development including 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 working 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.
- Responds to tasks or requests in a cooperative and timely manner.
- Demonstrates adaptability to change and initiates or identifies change when necessary.
- Ability to communicate effectively in writing and orally conveying results in concise yet non-technically language to a variety of different audiences.
- Work collaboratively with team members to meet the needs of the organization.
- Willingness to work collaboratively with team members on multiple tasks concurrently.
- Independently can make good judgments and decisions without a high degree of supervision.
- Detail-oriented and able to work under deadlines.
- Ability to take initiative, to maintain confidentiality, to meet deadlines, and to work in a team environment.
- Ability to report work activity on a timely basis.
- Ability to multitask and prioritize assignments while meeting deadlines.
Additional Requirements:
- 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.
Benefits
This position is eligible for the benefits applicable to full-time regular employees, such as: 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, and educational benefits.
U.S. remote annual salary range: $55,000-$75,000/annual
For candidates in jurisdictions requiring range disclosure, this is the good-faith range for this role; final pay may vary by work location and job-related factors such as skills, experience, location, and internal equity. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
IntegrityM is an Equal Opportunity Employer and we do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, and gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.
Skills
- AI
- Airflow
- Analytics
- Automation
- AWS
- Azure
- CI/CD
- Cloud
- Corrective Action
- Data Analytics
- Data Engineering
- Data Governance
- Data Ingestion
- Data Mining
- Data Modeling
- Data Pipelines
- Data Quality
- Data Science
- Data Warehousing
- Databricks
- ELT
- ETL
- Machine Learning
- Model Deployment
- Predictive Modeling
- Python
- Root Cause Analysis
- S3
- SAS
- Snowflake
- SQL
- Statistics
- Streamlit
As published by workable · 20 questions
Basics
First name, Last name, Email, Headline, Phone, Address, Photo, Is your Age Under 18? (This information will be used to comply with child labor laws and regulations), Will you now or in the future require sponsorship for employment visa status (e.g., H-1B visa status)?, Education, Summary, Resume, Please provide your salary rate requirements., Please provide your start date timeframe., How or by whom were you referred to us?, Were you ever employed by IntegrityM Inc., or any other related companies? If so, what was the company's name?, Are you currently subject to any restrictive covenant provisions (e.g., non-compete, non-solicitation, confidentiality agreements) or employment agreements?, Please explain any gaps in your employment history:, Have you ever been discharged or forced to resign? If Yes, please explain., Did you receive any discipline in your last 12 months of active employment with your previous employer?, State any additional information you feel may be helpful to us in considering your application. This could include any specialized training or courses you have completed that will aid in evaluating your qualifications for the position you are seeking. (Example: If applying for a clerical position, note training such as word processing, typing, calculator, computer, hardware, software, etc.) Please include grade or other indicator of achievement, such as words per minute typed., Please list at least three people within the last 7 years we may contact with reference to your application. One should be from a former manager/supervisor, and two from a co-worker, client, vendor, mentor; please do not include relatives. References will not be contacted before an offer is made., NOTE: Complete this section only if you are a student with no employment history. Please list at least three current or former professors we may contact with reference to your application., Will you be able to plug in a hardwired connection with an Ethernet cord?, Cover letter, I understand that Integrity Management Services, Inc. (hereinafter referred to as the Company) requires certain information about me to evaluate my qualifications for employment and to conduct its business if I become an employee. Therefore, I authorize the Company to investigate my past employment, educational credentials, and other employment-related activities. I agree to cooperate in such investigations and release those parties supplying such information to the Company from all liability or responsibility with respect to information supplied. I agree that the Company may use the information it obtains concerning me in the conduct of its business. I understand that such use may include disclosure outside the Company in those cases where its agents and contractors need such information to perform their functions, where their company’s legal interests and/or obligations are involved, or where there is a medical emergency involving me. I understand, however, that the Company intends to protect the confidentiality of personal information it obtains concerning me to the extent required by law. I agree that I will not disclose or use while interviewing with or employed with Integrity Management Services, Inc. any confidential or proprietary information of others, including any former employer. I consent to and authorize the Company to complete any post-offer background investigation and/or physical evaluations that the Company may require including testing for illegal or unauthorized substances. I understand that any offer of employment is contingent upon my successful passing of the background investigation and/or the physical evaluation requirements. I understand that my employment with the Company would not be for any fixed period of time and that, if employed, I may resign at any time, for any reason, or the Company may terminate my employment at any time for any reason in the absence of a specific written agreement to the contrary. I understand that my employment-at-will status may not be modified or changed except in writing and signed by a duly authorized officer of the Company., If selected, we have a background screening process consisting of an education, employment, credit, criminal, and a drug test. Will you have any issues with providing this information after receiving an offer of employment?, Have you physically resided in the United States continuously for the past three (3) years? Please answer ‘No’ if you lived outside the United States at any time during this three-year period.
Pick from a list (20)
- Minimum of a Bachelor’s Degree or a related discipline, or in another relevant field in health-related, scientific, or public policy/business discipline with extensive quantitative methods/statistical coursework.
- Possesses at least 3 years of relevant experience in data analytics, SQL development, ETL processes, reporting, business intelligence, or related data management functions.
- Strong proficiency in Python, R, SQL, and SAS, with experience utilizing cloud-based data platforms such as Snowflake and Databricks to support data analysis, project requirements, reporting, automation, and operational decision-making.
- 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.
- Strong SQL proficiency, including writing complex queries, joins, views, and stored procedures; performing data validation and performance optimization; and supporting data warehousing, reporting, and analytics initiatives.
- Knowledge of intermediate data analysis techniques, including data profiling, trend analysis, statistical methods, and data quality assessment.
- Responds to tasks or requests in a cooperative and timely manner.
- Demonstrates adaptability to change and initiates or identifies change when necessary.
- Ability to communicate effectively in writing and orally conveying results in concise yet non-technically language to a variety of different audiences.
- Work collaboratively with team members to meet the needs of the organization.
- Willingness to work collaboratively with team members on multiple tasks concurrently.
- Independently can make good judgments and decisions without a high degree of supervision.
- Detail-oriented and able to work under deadlines.
- Ability to take initiative, to maintain confidentiality, to meet deadlines, and to work in a team environment.
- Ability to report work activity on a timely basis.
- Ability to multitask and prioritize assignments while meeting deadlines.
- 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.
- Have you physically resided in the United States continuously for at least the past three years?