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

Job description

• 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.
• Serving as a BI developer, 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.
• About you:

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.

Requirements

• 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.
• Equivalent experience with Google Cloud, Amazon Web Services (AWS), or Microsoft Azure is also acceptable.
• 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.
• 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, such as role-based access control (RBAC), data governance, and compliance frameworks.
• Microsoft Fabric Analytics Engineer certification, in progress or completed.

Skills

Required

• Excellent analytical reasoning skills
• SQL
• DAX
• Power Query M
• Python
• pandas
• PyArrow
• Microsoft Fabric Lakehouse APIs
• PySpark
• Microsoft Fabric/Spark notebooks
• Dataflows Gen2
• Delta tables

Benefits

• The target base salary for this position is $84,497.00 to $120,830.00 per year. When determining compensation, we analyze and carefully consider several factors, including skill set, experience, location, and job-related qualifications.