Software Development Specialist
Listed on 2026-06-18
-
IT/Tech
Data Analyst, Data Engineering, Data Warehousing
Software Development Specialist 1 (Posting 227-26)
SALARY: $64,340.11 - $94,061.71
The Department of Children and Families (DCF), Office of Data Management & Reporting is seeking a qualified candidate for our Software Development Specialist 1 vacancy. The position will be located in Trenton, NJ.
DEFINITION:
Under close supervision and monitoring in a state or local government agency, performs analysis, maintenance, programming and support work on modules of existing systems; may develop web applications or websites; does other related work.
SUMMARY:
The Analytics Engineer reports to the Administrative Analyst 4 in the Data Platform Unit and is responsible for building and maintaining SQL-based data pipelines, models, and reports that support the Children's System of Care. This role transforms raw data into clean, tested datasets in Azure Synapse for analytics and regulatory reporting. Hands‑on and code‑focused, the Analytics Engineer writes production SQL, optimizes queries, validates data quality, and collaborates with stakeholders to deliver reliable data products that ensure accuracy and integrity across the platform.
& Programming
- Code and unit test SQL components (queries, views, stored procedures) based on business requirements
- Design and develop data pipelines to ensure efficient and reliable ETL processes
- Build robust data models and architectures to support analytics initiatives
- Deliver well‑defined, transformed, tested, documented, and code‑reviewed datasets for analysis
- Maintain production data pipelines and reporting systems
- Debug data quality issues and implement error‑handling processes
- Prepare test data for unit and integration testing
- Test and verify function and performance of new datasets and changes to existing queries
- Validate data accuracy between the application (CYBER) and the data warehouse (Azure Synapse)
- Implement data validation and monitoring processes to ensure data quality and accuracy
- Follow pre‑defined test plans for data integration work
- Collaborate with business stakeholders to understand analytics needs and deliver comprehensive reports, dashboards, and updates
- Identify and implement optimizations to enhance query performance, reduce processing time, and increase overall productivity
- Modernize existing SQL reports (optimize queries, improve logic, update documentation) and develop datasets for federal and state compliance reporting
- Identify, document, communicate, and design solutions for data quality challenges
- Communicate findings, recommendations, and conclusions to technical and non‑technical audiences
- Provide support for ad hoc data requests and analysis
- Develop and maintain technical documentation for all datasets, queries, and data pipelines
- Participate in code reviews to ensure quality and adherence to best practices
- Maintain essential records and files related to data systems
- Work cooperatively with system administrators, data analysts, and program staff across cross‑functional teams
- Participate in requirement gathering sessions for new data products
- Perform additional job duties as assigned
- SQL proficiency (intermediate+): queries, joins, aggregations, CTEs, window functions, stored procedures for data extraction and manipulation
- Knowledge of ETL processes, data integration, and data warehousing concepts
- Understanding of data modeling and database design principles
- Experience with program development and testing tools
- Ability to understand decision tables, charts, and diagrams
- Strong problem‑solving skills and ability to think critically and analytically
- Knowledge of data quality best practices
- Python or other scripting languages for data manipulation and automation
- Ability to prepare accurate and informative reports
- Excellent communication skills to collaborate with cross‑functional teams and present insights to business stakeholders
- Experience with Azure Synapse, Azure Data Factory, or other cloud data warehouses/platforms
- T‑SQL and/or PL/SQL
- Data visualization tools (Power BI or Tableau)
- MS Excel for data validation and analysis
- MS Access or other desktop database tools
- Python or other scripting languages…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).