PRD-20250707-431 - Specialist-Level II - Hybrid - Albany, NY PRD #: PRD-20250707-431 Client: Integrated Eligibility System (IES) Position(s) Required: Specialist-Level II Designated Work Location: 40 North Pearl St | 4th Floor, Albany, NY • The awarded consultant is required to be onsite at their assigned work location at the frequency required by the Office of Information Technology Services (ITS). This frequency is subject to change with advanced notice Position Anticipated Start Date: 8/22/2025 Anticipated Duration of the Engagement: 19 months (8/22/2025 - 3/21/2027) Mandatory Qualification • Level II- Between four (4) and seven (7) years of experience as a Specialist • 4-7 years of experience working with both PowerBI and Tableau: Including hands-on development of: Reports, dashboards, and data models. 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 Duties/Responsibilities 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. This Position has the ability to go beyond the 50% telecommuting policy if candidate is not based in NY.