Job Title: Lead Business Intelligence Reporting Engineer
Location: Albany, NY
Type: Contract
Compensation: $90/hr. Range W2. Benefits available
Work Model: Hybrid, remote with periodic on-site meetings
Hours: 40 hours/week

System One IT is staffing a 12-month+ contract opening for a lead-level Business Intelligence Reporting Engineer to support a state healthcare program.

Responsibilities

Design, develop, and maintain 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.
Other duties as assigned.

Requirements

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.
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 experience 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) — desired.
Three (3) years of experience with ETL tools such as Informatica, SSIS, or Talend — desired.
Prior experience working on reporting solutions within a public sector or government agency environment — desired.

System One, and its subsidiaries including Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

#LI-MM1
Ref: #856-Baltimore-S1

Lead Business Intelligence Reporting Engineer

Key skills

About this role