Specialist III (Report Eng) 7+yrs (w-2+yrs as lead Spec); Reporting/Bus intelligence/data dev; SQL)

Mandatory Qualifications

• Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Specialist
• More than seven (7) years of experience in reporting, business intelligence, or data development.
• Five (5) years of advanced SQL development experience with enterprise relational databases, including writing complex queries, stored procedures/functions, and performance tuning.

Desirable Qualifications

• Three (3) years of hands-on experience with PostgreSQL, including PL/pgSQL functions, query plan analysis (EXPLAIN/ANALYZE), and indexing strategies.
• Three (3) years of experience with AWS data and reporting services (e.g., Amazon RDS/Aurora PostgreSQL, Amazon QuickSight, AWS Glue, Amazon Redshift).
• Professional certification in a major BI platform (e.g., Tableau Desktop Certified Professional, Microsoft Certified: Power BI Data Analyst Associate).
• Three (3) years of experience with ETL (Extract, Transform, Load) tools such as Informatica, SSIS, or Talend.
• One year (1) of prior experience working on reporting solutions within a public sector or government agency environment.

Travel/Part-Time/Duties/Responsibilities

Position Overview & Key Responsibilities

The Report Engineer (Specialist III) is responsible for designing, developing, and maintaining enterprise-level reporting solutions, data visualizations, and business intelligence (BI) dashboards.

• Lead the design, development, and optimization of complex enterprise reports and interactive dashboards using BI tools (e.g., Tableau, Power BI, or SSRS).
• Write, optimize, and maintain complex SQL queries, stored procedures, and views to extract data from various relational databases.
• Collaborate with business analysts and stakeholders to translate business requirements into technical reporting specifications.
• Perform data validation and testing to ensure the accuracy and integrity of all generated reports.
• Provide technical leadership, mentorship, and code reviews for junior reporting team members.
• Other duties as assigned.

Consultants may be eligible to telecommute for more than 50% of their work hours, up to and including 100% remote work. Telecommuting arrangements require direct manager approval and are subject to change based on program needs. Consultants approved for 100% remote work must attend monthly in-person meetings at the Albany office and be available for major milestone meetings as needed.