Boca Raton, FL, USA
5 days ago
Data Transformation Analyst
Kforce has a client in Boca Raton, FL that is seeking a Data Transformation Analyst. Summary: The Data Transformation Analyst will be responsible for developing and optimizing SQL queries and creating and maintaining stored procedures and possesses an expert understanding of the Structured Query Language (SQL), data structures, database management systems and data integration tools. The Analyst will work closely with the Development and Data Migration teams on projects and assists in determining the impact and integration of data to and from various systems. Additionally, the Data Transformation Analyst will validate solutions, so they fit within the data structure and are consistent with the existing configuration and will ensure that the data conforms to quality and content standards, stays current on industry best practices, standards, trends, tools, and techniques, and collaborates with other members of the project team to establish consistency and assist with data mapping and migration to ensure data normalization and validity. Responsibilities: * Analyze and interpret data structures from multiple sources * Maintain data mappings to ensure accurate data conversion * Create and execute scripts for data extraction, transformation, and loading (ETL) processes * Conduct thorough testing and validation of converted data to ensure accuracy and consistency * Identify and troubleshoot data inconsistencies and other data-related issues * Design, develop and optimize SQL queries for data retrieval and manipulation * Ensure SQL queries are efficient and adhere to best practices for performance and security * Create, maintain, and optimize stores procedures to support data migration processes and activities * Ensure stored procedures are well-documented and follow coding standards * Troubleshoot and resolve issues related to stored procedures * Work closely with the development and migration teams to understand data requirements and provide solutions
Confirm your E-mail: Send Email