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:
1. 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
2. More than seven (7) years of experience in reporting, business intelligence, or data development.
3. Five (5) years of advanced SQL development experience with enterprise relational databases, including writing complex queries, stored procedures/functions, and performance tuning.
Desirable Qualifications:
1. Three (3) years of hands-on experience with PostgreSQL, including PL/pgSQL functions, query plan analysis (EXPLAIN/ANALYZE), and indexing strategies.
2. Three (3) years of e xperience with AWS data and reporting services (e.g., Amazon RDS/Aurora PostgreSQL, Amazon QuickSight, AWS Glue, Amazon Redshift).
3. Professional certification in a major BI platform (e.g., Tableau Desktop Certified Professional, Microsoft Certified: Power BI Data Analyst Associate).
4. Three (3) years of experience with ETL (Extract, Transform, Load) tools such as Informatica, SSIS, or Talend.
5. One year (1) of prior experience working on reporting solutions within a public sector or government agency environment.