Software Developer and Data Engineer I
Boston Public Health Commission
Boston, MA

$60,000 - $70,000 a year

EducationSkills
Overview

Boston Public Health Commission (BPHC) position as the leader in public health, which enable us to develop applications, collect and analyze a trove of data. The Information System Department enables BPHC to tell our data story trough business intelligence and develop innovative data-drive applications. Our data driven strategy is focused on advancing a new data platform, with a focus in three key areas:

Enable data-driven applications - Our objective is to enable any developer inside BPHC to build data- driven applications, which incorporate descriptive and predictive intelligence into business processes.
Differentiate through data - Differentiated data-driven applications are enabled by engines that encapsulate innovative capabilities, real-time data sharing between applications, and increased adoption of predictive intelligence.
Open up data assets - We will expose all of our key applications and selected platform capabilities via APIs as part of the City of Boston's Open Data Platform. We will also expose several self-service interfaces and tools to enable internal developers and analysts to access data in the shape and format they desire.

General Statement of Duties and Responsibilities:
The software developer position is to is to participate in the planning, development, implementation, maintenance, and evaluation of the information systems. These activities may include database building, data collection and cataloguing of gathered information, and documentation of the process. Maintains an up to date understanding of the process involved in these activities. This position must participate in an on-call rotation.

Duties and Responsibilities:
Support, maintain, and modify existing information systems including reporting tools, workflows and system metrics.
Provide technical assistance and support to bureau staff on data collection, data management and reporting, analysis of program data for management reporting purposes and development and implementation of quality assurance strategies.
Collaborate with the Bureau Director and the Director of Planning and Strategy to support the bureau's development of performance management system measures and dashboards.
Provide data reports to support the implementation of process improvement strategies.
In collaboration with program directors and managers, train staff on data entry and quality control.
Assist Bureau staff in the timely production of monthly and quarterly reports and respond to data requests for program data. Responsible for the timely and accurate production and dissemination of automated reports from the information systems as required by mandate or request. Produce regular and ad hoc program data reports, including tables and charts. Support divisions and programs in meeting internal and external reporting requirements.
Develop system requirements, business process and change control documents. Create and maintains system documentation.
Assist in assuring system confidentiality of client information (this specifically includes ensuring/enforcing HIPAA compliance) and implementation of new technologies for electronic data interchange.
Work in collaboration with the IS team to ensure compliance with application and data warehousing standards already in place across the commission.
Meet program information system needs, support and maintain electronic data exchange, and address technical issues.
Act as a liaison between the Community Initiatives Bureau and the IS Department.
Under the direction of IS director and with other IS team members, work to design and implement tools via SQL Reporting Services, or whatever means chosen to augment the data quality tools already provided by the current data collection software: the ultimate goal would be to implement a data quality infrastructure that will serve a model for the IS department.
Works in a confidential capacity. Operates independently. Uses independent judgment and discretion to make decisions affecting the department and staff as it relates to unit operations/services and BPHC policy
Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
Ability to effectively identify current or future problems, analyze, synthesize and compare data to understand issues, identify cause/effect relationships and explore alternative solutions.
Perform other duties as required.
Minimum Qualifications

Minimum Qualifications

BS in Computer Science, IS or related area required. Understanding of public health concepts and quantitative methodologies preferred. One year of experience in a health care, public health or academic agency required OR BA/BS and three (3) years' experience in a health care, public health or academic agency required
Demonstrated knowledge of instrument design and development, database architecture, and data coding procedures required.
Strong oral and written communication skills; presentation skills
Proficient in negotiation, facilitation and consensus building skills
Proficient in new and emerging technologies
Thorough knowledge of the following: IT concepts, strategies and methodologies, design and development tools, architectures and technical standards
Thorough knowledge of layered systems architectures and layered solutions and designs; understanding of shared software concepts
Understanding of agile software development concepts and processes; must be proactive, and demonstrate initiative and be a logical thinker
Consultative skills, including the ability to understand and apply customer requirements, including drawing out unforeseen implications and making recommendations for design, the ability to define design reasoning, understanding potential impacts of design requirements.Experience with reporting data to federal, state and other funding agencies preferred.
Deep experience with the Microsoft SQL Server technology stack (SSAS, SSIS)
Strong understanding of data warehousing, modern Cloud / Hybrid data architecture concepts
Experience with business intelligence tools and reporting solutions (Power BI, Tableau, etc)
Experience working in an Agile (scrum) development environment (Test-Driven Design, MVP, iterative and incremental design), familiarity with DevOps concepts.
Understanding of data modeling techniques; ability to lead and contribute to incremental and iterative modern data architecture
Experience using MS Office and Excel.
Additional Information
City of Boston Residency Required, Any position that requires an advanced degree will be subject to education verification, The Boston Public Health Commission is an EEO Employer and all applicants meeting the minimum requirements are eligible to apply