ETL Data Architect

This is 100% onsite work position based in Tallahassee,FL. Apply only if you are willing to relocate.

Education: Bachelor''s Degree in a field of study related to technology or finance. Work experience can substitute on a year for year basis for the degree.

Certifications in the field.

Required Experience:

·         12+ years of experience with large and complex database management systems.

·         12+ years of experience as a data architect or senior data analyst, with extensive experience in designing, implementing, and maintaining data models and ETL processes.

·         15+ years of broad experience working with database management systems (such as Oracle, SQL Server, or DB2) and data integration tools.

·         Strong background in financial data systems, including data modeling, data governance, and data quality management.

·         Proven experience with ETL tools, data warehousing, and automation of data processes to ensure accuracy, timeliness, and completeness of data.

·         Experience in data visualization and reporting best practices, with familiarity with tools like Power BI, Tableau, or similar platforms.

·         Familiarity with cloud-based data integration solutions, such as Azure or Snowflake.

Preferred Experience:

·         Experience with Informatica, Cloud Data Governance and Catalog, Cloud Data Integration, or other modern data integration platforms.

·         Strong analytical skills and the ability to translate business requirements into technical specifications.

·         Excellent communication and collaboration skills, capable of working effectively with technical and non-technical stakeholders.

Responsibilities:

1.    Data Analysis and Impact Assessment:

·         Analyze and verify existing Work Program Datamart and General Ledger data models to assess impacts related to changes in Chart of Account data elements due to the Florida PALM Project.

·         Evaluate the existing data models for dependencies on current Chart of Account structures and assess the scope of necessary changes.

·         Conduct impact analysis on reporting and application usage of data models to ensure business outcomes are not disrupted by the transition to PALM.

2.    Data Model Design and Enhancement:

·         Provide a comprehensive design of data models, incorporating new Chart of Account data elements introduced by the PALM system.

·         Ensure that the redesigned data models are scalable, robust, and aligned with best practices in data management, supporting both current and future business needs

3.    Data Quality and ETL Process Improvement:

·         Analyze existing ETL (Extract, Transform, Load) jobs to identify inefficiencies and potential areas for enhancement.

·         Design and implement robust data quality measures to ensure the timeliness, accuracy, and completeness of production data on a scheduled basis, including nightly, hourly, or less frequent intervals as needed.

·         Collaborate with development teams to automate and streamline ETL processes to support efficient data flow and integration.

4.    Data Visualization and Reporting Best Practices:

·         Provide expertise in data visualization and reporting, offering best practices to support the business’s ability to analyze and interpret financial data effectively.

·         Develop strategies to enhance existing reporting frameworks, ensuring that they are compatible with the new data models and data structures.

5.    Collaboration and Deployment:

·         Work closely with existing development teams to deploy new and revised data models, verifying that the implementation aligns with functional requirements and business goals.

·         Act as a liaison between technical and non-technical stakeholders, ensuring clear communication regarding data model changes, system impacts, and timelines.