Senior Business Intelligence Data Analyst

Role Description

Develop complex business intelligence solutions and support data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks.

• Develop complex dashboards, scorecards, reports, and data analysis.
• Improve the delivery and management of risk adjustment programs by utilizing advanced analytics, including but not limited to advanced algorithms, data visualizations, and maps.
• Develop and maintain complex SQL queries and scripts used to create tables, views, and data marts in SQL Server, Snowflake.
• Participate in project discussions to document and recommend alternative technical solutions or requirements.
• Participate in units, integration, and system testing.
• Maintain effective communication and relationships with all individuals involved with the project.
• Gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests.
• Perform peer-reviews and provide technical support or guidance to the project team.
• Forecast and plan resource requirements.
• Authorize deviations from standards.
• Lead functional or segment teams or projects.
• Provide explanations and information to others on the most complex issues.
• Motivate and inspire other team members.
• Support the project manager and leadership in project planning and executing activities, including presentations, risks or issues, and status reporting.
• Demonstrate deliverables to the team or the customers for approval and gain buy-in to implement solutions or adapt to new products/services/programs.
• Work with DBAs, data modelers, and application/system admins to support maintaining the processes and leading industry level standards or best practices.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology or related field.
• 5 years of progressive post-baccalaureate experience in the job offered or Data Analyst-related occupation.

Requirements

• Develop, implement, and maintain complex MS Power BI dashboards, MS Power Pivot dashboards, SSRS dashboards visualizations, and analytics.
• Develop complex SQL scripts, stored procedures, functions and views.
• ETL solutions with SSIS.
• Data warehouse platforms like Snowflake, Redshift, Databricks or Azure.
• Analyze and deliver complex analytics using Medicare and enrollment data for Medicare Risk Adjustment.
• Scripting tools such as Python or Batch Scripting to support data analysis, troubleshooting and ETL automation.
• Work with Provider Portals or EMRs.

Benefits

• Full range of comprehensive benefits, including medical, dental and vision.
• Matching 401k.
• Employee stock purchase plan.