Report Engineer

Report Engineer Designated Work Location: Pearl St, 4th Floor, Albany, New York Anticipated Duration of the Engagement: 27 months

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.
• 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.

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.