Data Analyst II (Full-time, Remote)

This is a Fully Remote Job About Our Client:The organization operates in the compliance and program integrity sector, assisting government and commercial clients in preventing and detecting fraud, waste, and abuse in government programs. It delivers results through data analytics, technology solutions, audit, investigation, and medical review. As a women-owned small business, this team values a collaborative culture with opportunities for professional development and sustainability. About the Opportunity:The DATA ANALYST II role involves providing data engineering, analytics, and production support by designing, developing, maintaining, and optimizing Snowflake-based data solutions and ETL/ELT pipelines. This position supports data integration, warehousing, and cloud-based engineering initiatives, working independently and with stakeholders to deliver high-quality data-driven solutions that inform operational and strategic decisions. Responsibilities:Design, develop, maintain, and optimize ETL processes for data integration and analytics.Perform routine and advanced business analysis using statistical techniques and predictive modeling.Build and apply complex analytical models with Python, Snowflake, Databricks, R, SQL, and SAS.Research best practices and recommend improvements to business operations.Write and optimize complex SQL queries, stored procedures, and data pipelines.Conduct data profiling, cleansing, transformation, and quality assurance.Develop and support Snowflake data pipelines using features like Streams, Tasks, and Time Travel.Monitor and troubleshoot production data issues with root cause analysis.Automate data ingestion, validation, auditing, and reconciliation processes.Support CI/CD deployment, release management, and process automation.Collaborate with cloud engineering teams on AWS services including S3, Glue, and Airflow.Engage with clients to gather requirements and deliver reports and data products.Translate business data into clear insights for technical and non-technical audiences.Participate in team projects and communicate analytical methods and results effectively. Requirements:Bachelor’s degree in a related discipline such as health, science, public policy, business, data science, statistics, or similar.Minimum of 3 years’ experience in data analytics, SQL development, ETL/ELT, reporting, business intelligence, or data engineering.Proficiency in Python, R, SQL, and SAS, with experience in Snowflake environments and cloud-based data workflows.Strong SQL skills including complex query development and optimization.Experience with ETL/ELT processes in cloud platforms such as Snowflake, Databricks, Azure, or AWS.Familiarity with Snowflake features like Streams, Tasks, Time Travel, Snowsight Notebooks, and Streamlit applications.Experience supporting production environments and resolving data incidents.Understanding of data warehousing concepts and dimensional modeling.Experience with AWS services such as S3, Glue, and Airflow.Knowledge of CI/CD, source control, and release management processes. Pay Range and Compensation Package:The pay range and compensation package for this role will be determined based on the candidate's experience, skills, and other relevant factors. Equal Opportunity Statement: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin. Note:TalentHop is a recruitment partner of this role. Please note that all employment decisions, including candidate assessment, interviews, hiring, compensation, and employment terms, are made exclusively by the hiring employer.