*About the Office of the Massachusetts State Treasurer and Receiver General (“Treasury”)* Our mission is to manage and safeguard the State's public deposits and investments through sound business practices for the exclusive benefits of our citizens, and perform these duties with integrity, excellence, and leadership. Additionally, we strive to provide economic opportunity, stability, and security for every Massachusetts resident. We are committed to excellence in recruiting, hiring, and retaining diverse and qualified individuals. We value the culture of diversity and professionalism in the workplace and strongly believe that our workforce should reflect our community. https://www.surveymonkey.com/r/FM68GFV *Purpose of the Job:* Build, maintain, document, and monitor the interfaces that the Treasury maintains with its business partners. Will act as the Treasury’s technical liaison with partners who have interfaces with the Treasury. May also work on other data and ETL related projects as needed. *Essential Functions and Responsibilities:* * Develop and maintain C# console apps for ETL purposes * Develop and maintain PowerShell scripts for file management * Manage interface file storage * Manage FTP infrastructure * Establish logging and monitoring practices for all interfaces * Develop and execute test plans for new interfaces and changes to interfaces * Extensively document processes including data flows and file formats * Develop competency with the Commonwealth Information Warehouse (CIW) and facility Treasury’s ad hoc reporting needs * Maintain reporting databases in SQL Server * Maintain MS Access ad hoc reporting databases * Attain expertise in all aspects of payment processing at the Treasury * Attain proficiency with NACHA rules and regulations and ACH file formats * Attain proficiency with data integration with ArcGIS mapping software * Learn how to administer, maintain, and develop Salesforce solutions *Supervisor Responsibilities:* * N/A *Knowledge and Skills:* * Intermediate skills using C# for ETL and file management * Intermediate skills with PowerShell scripting * 2 years of previous programming experience * Intermediate skills with T-SQL and Microsoft SQL Server * Demonstrated understanding of FTP systems * Demonstrated project management skills * Previous experience developing ETL process * Previous experience documenting system processes * Strong desire to learn and develop new skills * Ability to manage competing priorities * Ability to work regularly on-site and remotely according to schedule approved by Treasury Management * Microsoft Office proficiency *Physical Requirements:* * Ability to lift up to 10lbs * Ability to sit for extended periods of time *Hybrid Work Environment:* All new hires at the Office of the State Treasurer and Receiver General (Treasury) will go through an In-Office Orientation Period consisting of a combination of virtual, in-person and on-the-job training so as to assimilate you to the Treasury’s culture and work environment. Following the initial In-Office Orientation Period a gradual transition to hybrid work will take place over the first 3-8 weeks of employment. The hybrid work environment will consist of a minimum of two (2) days in the office each week, with one of these days being either aMonday or a Friday. Hybrid work arrangement is based on business needs of the department. There will be an additional (1) day in the office per month for a mandatory in person department meeting. *An Equal Opportunity Employer:* The Office of the State Treasurer and Receiver General is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. *Employment Eligibility Regarding Family Members:* Please note that the Office of the State Treasurer and Receiver General will not consider family members of current employees as eligible for employment. Family members shall include an employee’s spouse, brother, sister, children, stepchildren, parents, stepparents, sister/brother-in-law, daughter/son-in-law or an individual residing in an employee’s household. **Job:** **Administrative Services* **Organization:** **Off of State Treas & Rec Genrl* **Title:** *Programmer Analyst I* **Location:** *Massachusetts-Boston-1 Ashburton Place* **Requisition ID:** *2500062I*