Lead BI Reporting Engineer – Hybrid/Remote

System One, Inc.; City of Albany (NY); Hybrid; USD 102,000 - 146,000; Full time

Benefits offered by this job

Health and welfare benefits

401(k) plan

Hybrid work model

Job summary

System One IT is staffing a 12-month+ contract opening for a lead-level Business Intelligence Reporting Engineer to support a state healthcare program. Location is Albany, NY with a hybrid work model—remote with periodic on-site meetings.

Compensation is $90/hr on a W2 basis; benefits available. Responsibilities include designing and maintaining enterprise BI reports and dashboards, leading reporting initiatives, optimizing SQL queries, and collaborating with analysts to translate business needs

Qualifications

• 7+ years in BI reporting and data development.
• 5 years advanced SQL with enterprise databases and performance tuning.
• 3 years PostgreSQL with PL/pgSQL and EXPLAIN/ANALYZE.
• 3 years AWS data and reporting services (RDS/Aurora, QuickSight, Redshift).
• BI platform certification desired (e.g., Tableau Desktop, Power BI).
• 3 years experience with Informatica, SSIS, or Talend; public sector experience desired.

Responsibilities

• Design, develop, and maintain enterprise reporting solutions and BI dashboards.
• Lead design and optimization of complex reports and interactive dashboards.
• Write and optimize SQL queries, stored procedures, and views.
• Collaborate with analysts to translate requirements into specs.
• Validate data and test reports for accuracy and integrity.
• Provide technical leadership and code reviews for junior staff.
• Other duties as assigned.

Skills

Leadership

SQL development

PostgreSQL

PL/pgSQL

AWS data services

Tableau

Power BI

SSRS

Informatica

SSIS

Talend

Tools

Informatica

SSIS

Talend

Tableau

Power BI

SSRS

PostgreSQL

Job description

System One IT is staffing a 12-month+ contract opening for a lead-level Business Intelligence Reporting Engineer to support a state healthcare program. Location is Albany, NY with a hybrid work model—remote with periodic on-site meetings.

Compensation is $90/hr on a W2 basis; benefits available. Responsibilities include designing and maintaining enterprise BI reports and dashboards, leading reporting initiatives, optimizing SQL queries, and collaborating with analysts to translate business needs