Business Intelligence Developer

Business Intelligence Developer 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 at heart. At NYSTEC, we know that we succeed when individuals and teams flourish personally and professionally, so our benefits and perks support that mindset. 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. 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. Equivalent experience with Google Cloud, Amazon Web Services (AWS), or Microsoft Azure is also acceptable. 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, such as 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. 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. It is NYSTEC's policy to provide equal employment opportunity (EEO) to all individuals, regardless of actual or perceived race, color, creed, religion, sex, or gender (including pregnancy, childbirth, and related medical conditions), gender identity or gender expression (including transgender status), age, national origin, ancestry, citizenship status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, military service and veteran status, sexual orientation, marital status, or any other characteristic protected by local, state, or federal laws and ordinances. NYSTEC is strongly committed to this policy and believes in the concept and spirit of the law. Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please contact View email address on click.appcast.io if you require a reasonable accommodation to apply for or to perform this job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment. Applicants must be authorized to work in the United States without the need for visa sponsorship now or in the future. NYSTEC