Job description

Data Solutions Developer
CTH 6 months then convert to FTE
Location: Franklin, TN Hybrid 2 days a week onsite

We are unable to sponsor or transfer any work visas at this time. US citizens and Green Card Holders

and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1B

candidates at this time.

We need a Data Solutions Developer for the conversion of property data from the legacy system (Series3/Exceed) into our new policy management system (Guidewire). This person will be designing, maintaining, and helping to execute ETL processes for extracting data from the legacy system, transforming it to a new format for ingestion into the new system, and loading the data into the appropriate target databases. The majority of the legacy data is stored in DB2 tables in z/OS and the new system stores its data in Sql Server. In addition to the ETL work, this person will assist in defining the current entities and mapping them to the new data model. We would also like to leverage the knowledge of logical entities and database objects that this developer acquires over the course of this work to assist in the implementation of our data catalogs, data dictionaries and business glossaries for our Data Governance Initiative.

The Data Solutions Developer creates and maintains data acquisition, transformation, and integration solutions for operational, reporting, and analytical purposes. The Data Solutions Developer is often called upon to load data from transactional systems into the data warehouse, applying prescribed transformations and business logic. He or she is also responsible for generating source-to-target mapping documents and other metadata necessary to make data assets understandable and easily used. He or she will adhere to the data management fundamentals and best practices. Duties and responsibilities include the following:

Duties and Responsibilities

• Develop and support efficient and reliable processes to extract, transform, clean, and move data from a variety of sources into a data warehouse or data extracts using ETL Tools (SSIS, Data Migrator, etc.) and/or stored procedures
• Support the operation of the conversion process during business hours and as part of an on-call rotation as needed.
• Work in tandem with business and IT subject matter experts to define data extracts as well as process scheduling and issue resolution
• Develop solutions which adhere to development, architecture standards, and best practices as set by the Data Architect and Data Governance committee.
• Optimize database structures and SQL code for maximum performance and reliability
• Document new applications, review and update existing documentation related to data processes and structures
• Provide back-end support and data integration development assistance to other teams and application developers
• Operationalize prototype data solutions developed by other team members or data analysts
• Perform peer review and occasional QA support for solutions developed by other associates within the Data Management group or other functional areas
• Investigate and document current data flow processes between corporate systems, business partners, and downstream data consumers
• Participate in the design and development of target-state analytics ecosystem using traditional and big data tools, as well as a mix of on-premises and cloud infrastructure
• Other duties assigned by management

Qualifications and Requirements

• Strong Experience using MS SQL Server and SSIS
• Experience developing high-performing data flows, adhering to established best-practices
• Experience in SQL development - creating complex queries, views, and stored procedures
• Experience with Azure Data Factor and Azure SQL DB
• Experience interfacing with business stakeholders to understand data and analytics needs and deliver solutions
• Understanding of relational and dimensional data structures
• Experience in Agile Scrum and / or Kanban project management frameworks is preferred
• Knowledge of applicable data privacy practices and laws is preferred

Job Types: Full-time, Contract

Pay: $110,000.00 - $130,000.00 per year

Benefits:

• 401(k) matching
• Flexible spending account
• Life insurance

Experience level:

• 2 years

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Columbia, TN 38401: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• Experience developing high-performing data flows, adhering to established best-practices. How many years of experience do you?
• We are unable to sponsor or transfer any work visas at this time. US citizens and Green Card Holders and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1B candidates at this time. What is your work status?

Experience:

• SSIS: 5 years (Required)
• Azure Data Factory: 2 years (Required)
• Data Migrator: 3 years (Required)
• SQL stored procedures: 5 years (Required)

Work Location: In person

seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.