Senior Report Engineer (L3 Specialist)

Mega Cloud Lab; City of Albany (NY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Mega Cloud Lab is seeking a Senior Report Engineer to lead the design, development, and optimization of enterprise reporting solutions and BI dashboards. The role is hybrid in Albany, NY, requiring strong SQL, data engineering, and stakeholder collaboration to deliver accurate, scalable reports.

You will mentor junior team members, conduct data validation, and drive best practices in ETL and BI tooling within a modern analytics stack.

Qualifications

• 7+ years in IT/data projects with at least 2 years in a technical leadership role as a Specialist.
• 7+ years hands-on experience in BI, reporting, or data development.
• 5+ years advanced SQL development across enterprise databases with performance tuning.

Responsibilities

• Lead design, development, and optimization of enterprise reports and BI dashboards.
• Write, optimize, and maintain complex SQL queries, stored procedures, and views.
• Collaborate with business analysts to translate needs into technical specs.
• Perform data validation and end-to-end testing to ensure accuracy.
• Provide code reviews, guidance, and mentorship to junior team members.

Skills

BI experience

Data analysis

SQL development

Stakeholder mgmt

Technical leadership

Data quality

Mentorship

Tools

PostgreSQL

AWS data services

Informatica

SSIS

Talend

Job description

Are you an experienced BI & Data Specialist looking for a long-term, high-impact role? We are seeking a Senior Report Engineer to lead the design, development, and optimization of enterprise-level reporting solutions and BI dashboards.

Location: Hybrid – Albany, NY

Key Responsibilities

• Dashboard & Report Design: Lead the design, development, and performance optimization of complex enterprise reports and interactive dashboards using modern BI tools (e.g., Power BI, Tableau, SSRS).
• Data & SQL Engineering: Write, optimize, and maintain complex SQL queries, stored procedures, and views across relational databases.
• Stakeholder Collaboration: Partner with Business Analysts and key stakeholders to translate complex business needs into clear technical reporting specifications.
• Data Quality & Integrity: Perform rigorous data validation and end-to-end testing to guarantee accuracy across all deliverables.
• Technical Leadership: Serve as a subject matter expert, providing code reviews, technical guidance, and mentorship to junior reporting team members.

Mandatory Qualifications

• 7+ years of total experience working on complex IT/data projects, with at least 2+ years in a technical leadership role as a Specialist.
• 7+ years of hands-on experience in business intelligence, reporting, or data development.
• 5+ years of advanced SQL development experience with enterprise relational databases (complex query writing, stored procedures/functions, performance tuning).

Preferred / Additional Qualifications

• 3+ years of hands-on PostgreSQL experience (PL/pgSQL functions, query plan analysis using EXPLAIN/ANALYZE, and indexing strategies).
• 3+ years of experience working with AWS data services (Amazon RDS/Aurora PostgreSQL, QuickSight, AWS Glue, Redshift).
• 3+ years of experience with enterprise ETL tools (e.g., Informatica, SSIS, or Talend).
• 1+ year of prior experience building reporting solutions within a public sector or government agency environment.
• Professional BI Certification (e.g., Microsoft Certified: Power BI Data Analyst Associate, Tableau Desktop Certified Professional).

Skills: dashboards,databases,reporting,optimization,etl,sql,aws