Senior Report Engineer / BI Reporting Specialist

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.

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 e xperience 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.