BI & Data Visualization Specialist

Job Title: BI & Data Visualization Specialist Location: Albany, NY (hybrid) Only local to Albany, NY and should have government experience. Job Type: Contract Duration: 12 months

BI & Data Visualization Specialist (Power BI / Tableau) Specialist Level II Job Description:
The Integrated Eligibility System (IES) Program is seeking a BI & Data Visualization Specialist (Power BI/Tableau) to support the development and maintenance of dynamic, user-centered dashboards and reports that guide critical decisions in the health and human services space.
This role is responsible for transforming raw program and operational data into clear insights through data modeling, interactive reporting, and performance visualizations using both Power BI and Tableau.
The specialist will work closely with executive leadership, internal developers, and external stakeholders to ensure IES business objectives are clearly reflected in all reporting tools.
A strong understanding of data analysis, user experience, and government program operations (e.g., SNAP, Child Support) is essential to success in this role.

The Power BI Specialist will have:
Excellent attention to detail and problem-solving skills
Excellent communication and collaboration skills
Ability to work independently and as a part of a team
Adaptability to changing business requirements

Key Responsibilities:
Data Modeling Design, build, and optimize data models in Power BI and Tableau that support IES program reporting, product reporting or other performance and operational reporting.
Dashboard & Report Development Develop intuitive and user-friendly reports and dashboards tailored to program-specific needs
Data Analysis Identify trends, performance gaps, and actionable insights using statistical and visual techniques.
Data Visualization Translate complex datasets into accessible visual narratives that guide stakeholders in decision-making.
Stakeholder Engagement Collaborate with leadership, business users, and external agencies to gather requirements and iterate on deliverables.
Documentation & Maintenance Maintain clear documentation, ensure data integrity, and monitor the performance and accuracy of reports over time.
Training & Support Provide training to district users and leadership teams to promote adoption and interpretation of dashboards.
Troubleshooting Investigate and resolve issues related to data sources, loading, and visualization logic across the program and other teams.

Mandatory Qualifications:
1.Level II- Between four (4) and seven (7) years of experience as a Specialist
2. 4 7 years of experience working with both Power BI and Tableau: Including hands-on development of: Reports, dashboards, and data models
3.Demonstrated ability to translate raw data into visually meaningful insights for decision-makers.

Desirable Qualifications:
4-7 years - Proficiency in SQL, including T-SQL, SSRS, Power Query, and data extraction techniques.
4-7 years - Familiarity with Data Analysis Expressions (DAX) and complex calculations in Power BI.
4-7 years - Experience with data modeling techniques and relational database design.
4-7 years - Understanding of data warehouse concepts and enterprise-level reporting strategies.
4-7 years - Strong analytical skills with the ability to detect patterns and anomalies in large datasets.
4-7 years - Excellent verbal and written communication skills, especially when presenting data to executive leadership or cross-agency partners.
4-7 years - Experience working in public sector environments or with inter-agency collaboration teams nice to have