Data Conversion Analyst

Springbrook Software, Inc.; United States; Remote; USD 70,000 - 90,000; Full time

Job summary

Springbrook Software, a leader in cloud-based ERP solutions, seeks a Data Conversion Analyst to ensure smooth data transitions for new customers. This remote role requires deep expertise in SQL and data conversion processes, offering a dynamic work environment focused on efficiency and collaboration.

Benefits

Excellent benefits

Flexible remote work options

Collaborative work environment

Qualifications

• Extensive hands-on experience with Microsoft SQL Server development.
• Adept in writing and troubleshooting T-SQL queries.
• Strong background in data conversion, migration, and ETL processes.

Responsibilities

• Analyze, map, and convert data from various sources into structured formats.
• Troubleshoot and resolve data-related issues for accuracy and compliance.
• Develop and maintain data conversion documentation including mapping documents.

Skills

Problem-solving

Data conversion

ETL processes

T-SQL

Tools

Microsoft SQL Server

ETL tools (ADF, Talend)

Dataform

dbt

Job description

Why Springbrook:

Over 2800 local government agencies trust Springbrook solutions.Springbrook develops true cloud-based government ERP financial software, with our flagship ERPCirrus, representing the most modern and secure platform in the market. Our fully integrated suite of cloud-based solutions are intuitive and continually evolving, with input from local governments and water, sewage, and fire districts in cities, towns, and municipalities from coast to coast. Springbrook's industry-leading finance, payroll, utility billing, payments, cash receipting, and tax collection modules are proven safe, reliable, scalable and designed for the needs of communities from 300-100,000.

Our employees experience a culture that emphasizes performance, productivity, and collaboration. You will be empowered and engaged, working with like-minded individuals who are driven and passionate about contributing to a market-leading software organization with proven technology. While we are busy changing the world, we also strongly believe in having fun and excitement at work and encouraging a collaborative and healthy work-life balance. We offer competitive salaries and excellent benefits.

If you are motivated by the idea of delivering on the promise of solving for a new era of more efficient, open, and innovative governance, then we would love to talk with you.

This position offers the flexibility for you to work remotely from any location within the United States.

Where You Fit:

The Data Conversion Analyst works with our implementation team to ensure the smooth transition of new customer data into our ERP system.We are looking for a seasoned MS SQL Data Conversion Analyst who values stability, excellent benefits, and an opportunity to apply their deep experience to solve complex data puzzles.

Our database environment is mature, and the workflow can be fast paced with immediate data challenges that require a steady, experienced hand. This is a role for a pragmatist who understands best practices and also knows how to get the job done effectively in a database that has evolved through the years.

Responsibilities:

• Analyze, map, and convert data from various sources into a structured format.
• Collaborate with cross-functional teams to support data transformation needs and project alignment across the software modules.
• Troubleshoot and resolve data-related issues to assure accuracy and completeness of converted data. Ensure compliance with data privacy and security policies.
• Respond to and resolve urgent data fix requests from the implementation team.
• Develop and maintain data conversion documentation, including mapping documents, conversion scripts, and validation plans.
• Maintain general awareness of Springbrook security and privacy policies.
• Report any security incident or suspected security incident to the Springbrook Incident Response Team.

Required Qualifications:

• Extensive, hands-on experience with Microsoft SQL Server development.
• Highly comfortable writing and troubleshooting T-SQL queries.
• Adept at working directly with production databases and understands the importance of care and precision.
• Strong background in data conversion, migration, and ETL processes.
• High level of proficiency and knowledge of how to interact and pull data from multiple different data formats such asOracle, SQL, MySQL, Flat File (CSV, Fixed length, JSON).
• Strong problem-solving skills and can remain calm and effective in a reactive, results-driven environment.
• Self-starter who can work independently, manage priorities, and provide feedback to the team.
• Understands the principles of database normalization but is pragmatic enough to work effectively with legacy database structures.
• Experience with dataform or dbt is a plus.
• Experience in ETL tools such as ADF and Talend is a plus.

Applicants must have the unrestricted ability to work in the United States (sponsorship will not be offered)

Springbrook Software is an Equal Opportunity Employer. Springbrook does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit and business need..