Job Title: Solutions Engineer Company Name: Tolemi Job Url: https://www.simplyhired.com/job/R0ox8WUDGDoAtQom6K1awLEwFIBIxeZ0Atm-UXMlC1Hk8-MWIi6w6w Job Description: Solutions Engineer Tolemi Remote Job Details Full-time $75,000 - $95,000 a year 2 days ago Benefits Health savings account Health insurance Dental insurance 401(k) Flexible spending account Paid time off Parental leave Vision insurance 401(k) matching Professional development assistance Flexible schedule Life insurance Referral program Qualifications FTP Data Integration (Data management) Mapping using GIS Automation PostGIS Data migration Process optimization Relational databases Technical documentation Data reporting Consulting experience Mid-level SQL Technical solutions implementation Project management Continuous improvement JavaScript PostgreSQL Back-end development Scripting APIs IT Front-end development JSON Root cause analysis Communication skills Project stakeholder communication Shell Scripting Debugging Stakeholder management Database software proficiency Full Job Description Title: Solutions Engineer Job Summary The Tolemi team is looking for creative, data-minded team members to help our local government customers create and maintain safe and stable housing. As a Solutions Engineer, you will play a pivotal role in helping cities to transform into data-driven organizations by supporting the implementation and maintenance of our workflow and registry tool, Slate. You’ll have the opportunity to work along-side our municipal partners where you’ll act as both consultant and engineer: advising, building, and delivering best-in-class solutions to their data and engineering challenges. You’ll work closely with our Customer Success & Engineering teams to streamline implementations, and to build our internal processes. If you are looking to join a dynamic team with plenty of room to advance in a fast-growing Company, Tolemi is right for you. Responsibilities and Duties ● Support and lead data migrations of municipal raw data into our tool ● Build custom reports using SQL ● Standardize and map municipal raw data using SQL (PostgreSQL) ● Debug logs and error messages to identify root causes to issues, and to work alongside engineering to build and deploy fixes ● Identify recurring patterns, recommend best practices, and upgrade legacy integrations to the current standard ● Own documentation for data integration best practices ● Drive continuous improvement of our processes and internal tools Qualifications and Skills Technical skills ● Proficient to advanced SQL knowledge (writing and optimizing complex queries - using CTEs, subqueries, json flattening, window functions, indexes, joins, aggregation etc.) ● Experience working with relational databases ● Experience with Javascript frontend and/or backend ● Ability to automate basic scripts for data automation and retrieval using in-house configurable templates ● General understanding of APIs, command line tools, networks, FTP servers extra credit for: ● Experience writing shell scripts ● Experience with GIS (shapefiles, ESRI ArcGIS, PostGIS, QGIS) ● Experience with Windmill ● Experience working with workflow automation tools and software Communication and Project Management skills ● Clear communication with internal and external project stakeholders ● Managing deadlines, leading discussions with internal stakeholders, prioritizing multiple projects extra credit for: ● Experience working with municipalities (housing, planning, code, IT) You will gain expertise in: ● Using advanced data transformation techniques (deep expertise in the powerful PostgreSQL ecosystem) ● Process management best practices ● Municipal and housing data, including its challenges, workflows, and solutions. ● Data management and monitoring best practices ● Working in a small, agile, fast-paced environment; overcoming startup growing pains *All correspondence regarding this position will come from a email address with tolemi.com domain. Any other domain should be ignored* The position is Remote or Hybrid (Boston), with quarterly 3-4 day on-sites in Boston, MA (Travel & Accommodations covered) Job Type: Full-time Pay: $75,000.00 - $95,000.00 per year Benefits: 401(k) 401(k) matching Dental insurance Flexible schedule Flexible spending account Health insurance Health savings account Life insurance Paid time off Parental leave Professional development assistance Referral program Vision insurance Work Location: Remote