Business Intelligence Developer

Business Intelligence Developer at New York State Technology Enterprise Corporation (NYSTEC)

About Us
NYSTEC is a nonprofit technology consulting company, advising agencies, organizations, institutions, and businesses since 1996. We’re independent and vendor‑neutral, so we have our clients’ best interests  NYSTEC, we know that we succeed when individuals and teams flourish personally and professionally, so our benefits and perks support that mindset.

About The Role
As a business intelligence (BI) developer in the Business Intelligence department, you will collaborate with team members to create and refine datasets, dashboards, and reports that support decision‑making across the organization. Your day‑to‑day role will include managing data pipelines, validating data accuracy, and resolving issues that arise within the BI ecosystem. You will collaborate closely with analysts, finance, IT, and other teams to translate needs into technical solutions.

Key Responsibilities

• Develop, maintain, and optimize datasets, data models, and reports to support organizational decision‑making.
• Build and manage extract, transform, and load/extract, load, and transform (ETL/ELT) processes to ensure reliable data ingestion, transformation, and delivery across systems.
• Validate data accuracy and troubleshoot issues with pipelines, models, and reports to maintain a high‑quality BI environment.
• Collaborate with stakeholders to gather requirements, translate business needs into technical solutions, and deliver user‑friendly dashboards.
• Monitor BI system performance, implement enhancements, and ensure adherence to data governance and security standards.
• Document processes, data definitions, and system changes to support long‑term sustainability and team knowledge sharing.
• Provide ongoing support for existing reports and datasets, including maintenance, updates, and performance tuning.
• Partner with analysts and other teams to enable consistent, accurate, and accessible reporting across the organization.

Required Qualifications

• Expertise with reporting tools, software, and other applications.
• Established experience as a BI developer, creating interactive reports, visualizations, and data modeling.
• Advanced Query
  
  Languages:
  
  Structured Query Language (SQL), Data Analysis Expressions (DAX), and Power Query M.
• Python Proficiency Ability to write clean, efficient Python for data transformation, validation, and automation, including using libraries such as pandas, Python Apache Arrow (PyArrow), or Microsoft Fabric Lakehouse Application Programming Interfaces (APIs).
• Spark/Notebooks:
  Experience using Python Apache Spark (PySpark) and Microsoft Fabric/Spark notebooks to manipulate large datasets, create transformation pipelines, and support more scalable data engineering tasks.
• Experience building and maintaining fabric data pipelines, dataflows Gen2, notebooks, and lakehouse tables.
• Understanding of delta tables, medallion architecture, incremental refresh, and performance tuning.
• Ability to troubleshoot data pipeline failures, refresh issues, schema changes, and data mismatches across multiple layers.
• Excellent analytical reasoning skills to translate operational and financial processes into scalable, accurate data models.
• Similar experience in Google, Amazon Web Services (AWS), or Microsoft Azure Cloud is qualified.

Preferred/Desired Qualifications

• Advanced Microsoft Fabric experience.
• Kusto Query Language (KQL) for fabric real‑time intelligence and telemetry analysis.
• Exposure to Microsoft Azure services, such as Azure Data Factory, Azure SQL, or Data Lake Storage.
• Understanding of security models (role‑based access control [RBAC]), data governance, and compliance frameworks.
• Microsoft Fabric Analytics Engineer certification (in progress or completed).

Education and Experience

• A bachelor’s degree in computer science, information technology/systems, finance/accounting, math/statistics, or a similar discipline, and five years of related experience, including experience with writing reports and analyzing technical requirement modes.
• An equivalent combination of advanced education, training, and experience will be considered.

Salary
The target base salary for…