Alliance for Better Health (Alliance) promotes and fosters an inclusive work environment built upon resiliency, trust, and steadfast commitment to our mission of making communities healthier. Forward-thinking creativity and diverse experiences are highly valued. As an Albany Business Review Best Place to Work, we prioritize empowering our team to do their best work toward better health for all.

The Senior Data Analyst is responsible for establishing and maintaining data analysis processes that support Alliance’s mission, strategic initiatives, and contractual obligations. The Senior Data Analyst collaborates closely with business and technical teams, in supporting data-driven decisions.

Primary duties and responsibilities

• Supports database development, data review and maintenance of specific data management documentation to shape the data infrastructure, inclusive of data-warehousing, reporting, and analytics platforms.
• Assists pipelines required for ingestion and extraction of data.
• Develops clear and well-structured analytical plans. 
• Builds and operationalizes processes, procedures and guidelines that ensure timely data-loading and maintains accuracy and relevance of data used within the organization.
• Ensures constant compliance with data standards and data sharing regulations and guidelines, with an emphasis on continuous quality control and process improvements.
• Identifies, evaluates, and documents potential data sources in support of project and contract requirements. 
• Identifies, communicates, and resolve data gaps that impact the fulfillment of the business’ functional requirements. 
• Identifies and addresses expected and unforeseen data complexities to mitigate their impact on reporting and analytic outcomes.
• Investigates and analyzes data to identify trends that could benefit both internal and external clients. 
• Looks for new data correlations that could be utilized to illustrate additional value to partners. 
• Designs and develops new standard and adhoc reports for both internal and external clients.
• Oversees the development of client dashboards and reports, ensuring timeliness and accuracy of data.  
• Builds statistical models as needed.
• Translates business requirements into specifications and guides business departments in appropriate and effective use of data
• Develops logical and conceptual data flows.

The above statements are intended to describe the general nature and level of work being performed by persons assigned to this classification. They are not to be construed as an exhaustive list of duties assigned. Responsibilities and activities may change at any time with or without notice.

Education and training requirements

• Bachelor’s degree in Mathematics, Statistics, Computer Science, Engineering, or related field. (Equivalent work experience in a related field may be considered in lieu of degree requirements)

Experience requirements

• 6+ years of experience developing SQL queries in (MS SQL Server, Oracle, MySQL, etc.) utilizing large data sets.
• Experience in health care or social care services industries preferred. Management experience preferred. 
• Experience and proficiency in Microsoft Office suite of products, especially Excel.
• Experience in performance tuning of reporting queries.  
• Some experience developing ETL processes using tools (i.e. MS SSIS, Talend, Informatica, etc.).  
• Experience analyzing and conducting critical analysis to derive business insights (i.e. segmentation).  
• Experience developing reports and dashboards in a Business Intelligence (BI) tool. (i.e. Tableau, Power BI, SAS, Oracle BI, etc.). 
• Experience with tools such as R, SAS, etc. and in a scripting language (Python, JavaScript, Ruby, etc.) a plus.  

Skills and qualifications

• Strong communication skills and ability to transform data into information, information into complex analytics and analytics into actionable plain-language to drive business decisions.
• Strong analytical and problem-solving skills.  
• Ability to perform quality control and troubleshoot with an emphasis on attention to detail. 
• Ability to set and meet deadlines in a fast-paced environment.
• Performs all work in accordance with Alliance Core Competencies and Values.

Hiring requirements

Offers of employment are contingent upon a satisfactory background investigation including OIG List of Excluded Individuals and Entities (LEIE) and state Medicaid exclusion lists. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States.

Physical requirements

This position involves sedentary work that primarily involves sitting/standing, use of typical office equipment such as a computer, laptop, and cell phone. May include light work that includes moving objects up to 20 pounds independently or with assistance.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Work Environment

Alliance is taking a hybrid approach in accordance with CDC and NYS COVID-19 guidelines allowing employees to work remotely with optional use of our office space located in Troy, NY. New employee on-boarding, orientation and training will be conducted remotely.

Equal Opportunity Employer

Alliance is an Equal Opportunity Employer. Alliance does not discriminate against any employee or applicant on the basis of age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable laws, regulations and ordinances. We adhere to these principles in all aspects of employment, including recruitment, hiring, training, compensation, promotion, benefits, social and recreational programs, and discipline.

Privacy Requirement

This job function involves potential access / interaction with protected health information. Position will be required to abide by Alliance policies and procedures that support federal, state and local HIPAA regulations. Any violations will be subject Alliance’s sanctioning policy which includes disciplinary actions up to and including separation of employment.