Senior BI Reporting Engineer — Dashboards, SQL & Data Quality

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

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.