Description
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 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.
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.
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.
About you:
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.
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 o