Apply on Employer Site

New York State Technology Enterprise Corporation (NYSTEC) · 11 hours ago

Business Intelligence Developer

United States

Full-time

Remote

Senior Level

$84K/yr - $110K/yr

5+ years exp

NYSTEC is a nonprofit technology consulting company that has been advising various organizations since 1996. The Business Intelligence Developer will collaborate with team members to create and refine datasets, dashboards, and reports to support decision-making across the organization.

CharityInformation TechnologyNon Profit

Work & Life Balance

No H1B

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

Qualification

Business Intelligence developmentSQLPythonETL/ELT processesData modelingMicrosoft FabricData Analysis Expressions (DAX)Azure servicesAnalytical reasoningData governanceKusto Query Language (KQL)Communication skills

Required

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

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