The Data Analyst II is a highly skilled analytics professional responsible for designing, implementing, and managing complex data analyses and reporting processes. They independently lead data projects, provide strategic insights, and collaborate with cross-functional teams to deliver business-impacting solutions. With advanced technical skills, domain expertise, and a solid understanding of business requirements, they ensure stakeholders receive meaningful, actionable insights to drive decision-making.

• Data Analysis and Reporting: Lead the development of high-quality visual insights and reports for executive-level presentations.
• Client Interaction: Act as a liaison between technical teams and non-technical stakeholders, managing client relationships and ensuring satisfaction.
• Project Management: Lead projects, ensuring deliverables meet expectations and managing timelines and resources.
• Mentoring and Coaching: Mentor junior team members, providing guidance and support to help them grow.
• Learning and Development: Stay updated with industry trends and advancements through continuous learning and professional development.

Knowledge, Skills and Experience

Education/Degree Requirements/Certifications

• A bachelor's degree in a relevant field such as Data Science, Statistics, Computer Science, or a related discipline is preferred.

Experience

• 4-6 years of experience in data analysis, data management, or a related field. Experience with SQL, data wrangling, and data visualization is preferred. (On-the-job training will be provided to help the Data Analyst II develop their technical and business skills. Continuous learning and professional development opportunities will be encouraged to keep up with industry trends and advancements).

Knowledge

• Knowledge in designing, implementing, and managing complex data analyses and reporting processes.

• Independently lead data projects, provide strategic insights, and collaborate with cross-functional teams to deliver business-impacting solutions.

Skills

• SQL (Required): Ability to design and implement complex database schemas, use advanced SQL features like CTEs and window functions, and perform query optimization for large datasets.

• Data Wrangling (Required): Ability to automate data cleaning processes, handle large datasets efficiently, and use advanced techniques such as feature engineering and data normalization.

• Data Visualization (Required): Ability to design and implement advanced visualizations, including custom visualizations, geospatial visualizations, and interactive dashboards.

• Statistics (Required): Proficiency in inferential statistics, including hypothesis testing, regression analysis, and ANOVA. Ability to interpret and communicate statistical results.

• Business Intelligence (BI) Development (Required): Ability to design and implement advanced BI solutions, including data modeling, ETL processes, and performance optimization.

• General Coding Experience (Required): Ability to design and implement complex software solutions, including using advanced programming techniques and frameworks. Python preferred.

• Communication (Required): Ability to communicate complex analytical concepts clearly and concisely to technical and non-technical audiences, tailoring recommendations to stakeholder needs.

• Domain Experience (Preferred): Ability to utilize significant healthcare domain knowledge to provide meaningful context for data analysis and reporting.

• Project Experience (Preferred): Ability to lead cross-functional teams on large-scale projects, managing timelines, milestones, and deliverables while ensuring alignment with business goals.

• Project Management (Preferred): Ability to lead cross-functional teams on large-scale projects, managing timelines, milestones, and deliverables while ensuring alignment with business goals.

Competencies

• Analytical and logical reasoning

• Oral and written communication

• Continuous improvement

• Project Management

• Negotiation and Persuasion

Travel or Physical Requirements

• Travel as needed

Compliance Requirements

Adhere to all Company Policies, Procedures, and other training consistent with ConnectiveRx's Information Security and Compliance Programs, including but not limited to the following compliances and regulations: SOC1, SOC2, PCI, HIPAA.

Maintain strict compliance with company and client policies regarding business rules and ethics, as well as applicable local, state and national federal laws.

Compensation & Benefits: This position offers opportunities for a bonus (or commissions), with total compensation varying based on factors such as location, relevant skills, experience, and capabilities.

Employees at ConnectiveRx can access comprehensive benefits, including medical, dental, vision, life, and disability insurance. The company regularly reviews and updates its health, welfare, and fringe benefit policies to ensure competitive offerings. Employees may also participate in the company’s 401(k) plan, with employer contributions where applicable.

Time-Off & Holidays: ConnectiveRx provides a flexible paid time off (PTO) policy for exempt employees, covering sick days, personal days, and vacations. PTO is determined based on an employee’s first year of service. Employees also receive eight standard company holidays and three floating holidays annually, with prorations applied in the first year.

The company remains committed to providing competitive benefits and reserves the right to modify employee offerings, including PTO, STO, and holiday policies, in accordance with applicable laws and regulations.