Advisor, Public Health Data Analytics & Visualization

Job Title: Advisor, Public Health Data Analytics & Visualization Location: Remote Description Founded in 2004, BME Strategies is a Massachusetts-based consulting firm specializing in the design, implementation, and evaluation of public health programs for local, regional, and state government partners. Our work supports evidence-based, community-driven solutions that strengthen public health systems and advance equity across the communities we serve. At BME, our clients are on the front lines of Public Health. Priorities may shift but our commitment to supporting our partners does not. We take pride in having multi-year, multi-project engagements, often working closely as an extension of their staff. Our success comes from our shared values: a bias toward action; optimistically collaborative; willingness to navigate ambiguity; minimal ego - no job is too small or big; pursuing the equitable solution; always learning, and; committed to quality at every stage. Position Overview BME Strategies is seeking an Advisor, Public Health Data Analytics & Visualization to support the Massachusetts Local Public Health Data Solution (Metrik) initiative. This role will support the analysis, interpretation, validation, and visualization of complex public health data, helping translate business, epidemiologic, and analytic requirements into accurate and accessible data products. The Advisor will work across the analytics and visualization lifecycle, including data exploration, indicator development, statistical analysis, data validation, dashboard development, and stakeholder review. The ideal candidate combines strong business intelligence and data visualization skills with experience working with public health data and an understanding of epidemiologic and/or biostatistical methods. In this role, a successful candidate will demonstrate: Analytical rigor: Ability to critically evaluate data, methodologies, calculations, and conclusions. Public health context: Ability to understand how epidemiologic and population-health concepts affect the appropriate analysis and presentation of data. Visualization expertise: Ability to translate complex information into clear and intuitive analytical products. Data quality orientation: Strong focus on reproducibility, validation, accuracy, and documentation. Stakeholder collaboration: Ability to work effectively with program staff, epidemiologists, analysts, data engineers, developers, and leadership. Technical adaptability: Ability to work across multiple BI and analytical platforms and learn new tools as project needs evolve. Project Overview Metrik is a statewide initiative led by the Office of Local and Regional Health (ORLH) to modernize and standardize workflows, data collection, reporting, and performance management across Massachusetts’ local and regional public health system. The project supports alignment with state performance standards, improves data quality and interoperability, and strengthens the ability of local health departments to demonstrate capacity, outcomes, and compliance in a consistent, user-friendly Salesforce platform. In this role, the candidate will work closely with Flourish & Thrive Labs as the third-party integrator on the project. Key Responsibilities BME Org-Wide Responsibilities for Advisors (Subject Matter Experts): Leads or co-leads larger projects, technical & advisory, contributes to project design Mentorship Potential: mentors Associates and Senior Associates on projects when possible; serves as a technical resource for their practice area Business Development: manages projects to exemplary client satisfaction; contributes to and/or leads proposals Role expectations: 90% project work, 5% administrative work, and 5% business development work. Role-Specific Responsibilities: Data and Public Health Analytics Analyze public health datasets to identify trends, patterns, disparities, and other findings relevant to program and surveillance needs. Support the development and validation of public health indicators, measures, rates, percentages, denominators, stratifications, and other analytical outputs. Apply appropriate epidemiologic and statistical concepts when analyzing population-level health data. Conduct exploratory data analysis and data profiling to evaluate completeness, consistency, distributions, and potential data-quality issues. Validate calculations and analytical outputs against source data, established benchmarks, and documented business rules. Work with epidemiologists, program staff, analysts, and other subject-matter experts to translate public health questions into clear analytical specifications. Document indicator definitions, methodologies, assumptions, limitations, and analytic business rules. Data Visualization and Business Intelligence Design and develop interactive dashboards, reports, and visual analytical products for public health audiences. Develop visualizations using platforms such as Tableau, Microsoft PowerBI, and/or Amazon QuickSight. Translate analytical and stakeholder requirements into effective charts, dashboards, filters, drill-downs, tooltips, and other interactive features. Develop reusable visualization components, templates, and standards to promote consistency across analytical products. Apply data visualization best practices to ensure outputs are understandable, accurate, accessible, and appropriate for both technical and nontechnical audiences. Optimize dashboards for usability, performance, and maintainability. Participate in iterative stakeholder review and incorporate business feedback into visualization designs. Data and BI Development Work with data engineers, data architects, analysts, and BI developers to understand source data and curated analytical datasets. Query and analyze data using SQL and other analytical tools as appropriate. Support development and validation of BI-layer measures, calculations, mappings, and semantic models. Evaluate whether analytical logic should be implemented within the database/data warehouse, semantic layer, or visualization platform. Support integration of cloud-based data platforms and BI tools, including environments using Snowflake and/or AWS technologies. Assist with troubleshooting discrepancies between source data, analytical datasets, and published dashboard outputs. Quality Assurance and Documentation Conduct systematic validation of dashboard metrics, calculations, filters, and visualizations prior to release. Support peer review, QA, user acceptance testing, and business validation activities. Document data sources, transformations, analytical methodology, metric definitions, dashboard functionality, and known limitations. Maintain clear documentation and work products using project tools such as Jira, Confluence, SharePoint, Microsoft Teams, and Microsoft Office. Support development of repeatable analytical and visualization processes that can be applied across future Metrik use cases. Experience, Qualification, & Skills Required: Minimum 6 years experience required 2+ years in a consulting firm environment Demonstrated subject matter expertise in at least one practice area Capable of independent technical contribution 1-4+ years client-facing experience Master’s degree in public health, epidemiology, biostatistics, data analytics, health informatics, statistics, computer science, or a related quantitative field. Demonstrated experience analyzing complex datasets and translating findings into actionable analytical products. Experience developing dashboards and data visualizations using a modern business intelligence platform. Strong understanding of data visualization principles and dashboard design. Experience performing data validation and quality assurance on analytical outputs. Experience using SQL to query, analyze, and validate data. Ability to translate business and analytical requirements into technical specifications and visualization designs. Strong analytical reasoning, attention to detail, and documentation skills. Ability to communicate technical and analytical concepts clearly to both technical and nontechnical stakeholders. Ability to work independently and as part of a team in a fast-paced consulting environment. And an alignment with BME’s shared values. Preferred: Experience working with public health, healthcare, surveillance, population health, or health and human services data. Applied experience with epidemiologic or biostatistical methods, including calculation and interpretation of population-based rates, stratified measures, trends, confidence intervals, age-adjusted measures, or similar public health statistics. Experience working with multiple public health datasets and integrating information across surveillance or administrative data sources. Advanced experience with one or more of the following: Tableau Microsoft Power BI Amazon QuickSight Experience working with Snowflake, AWS, or other cloud-based analytical environments. Experience developing analytical products for state or local government, public health agencies, or other public-sector organizations. Familiarity with data governance, suppression, privacy, accessibility, and reporting requirements applicable to public health data. Work Environment This is a full-time position based in a home office environment within the U.S. BME Strategies in a remote-first organization. This role may require occasional travel to client sites, conferences, or meetings as required. BME's work is organized around contracts that have defined scopes and timelines. As contracts conclude, we make every effort to transition team members to new projects that align with their practice area or skill set. As a result, the responsibilities of an employee hired for a particular position may adapt based on project needs and assignments. Compensation & Benefits BME Strategies offers a competitive compensation package that includes: 11 paid floating holidays each year, plus 4 weeks of additional PTO, giving employees flexibility to take time off when it matters most. Health, dental, and vision insurance, with 80% employer-paid coverage for the employee & 70% employer-paid coverage for dependents; Health FSA and dependent care FSA; 401(k) with employer match; Employer-paid short-term and long-term disability insurance; And opportunities for professional development and career growth. The salary range for this position is $87,360 - $120,640 per year. Please note: New employees are typically brought into the organization at a salary between the range minimum and the salary range midpoint, dependent upon internal equity and the budgeted amount for the position. #J-18808-Ljbffr BME Strategies