Title: Data Architect
Location: Tallahassee, FL
Job Description:
Key Responsibilities
• Analyze and verify existing Work Program Datamart and General Ledger data models to assess impacts related to Florida PALM Chart of Account changes.
• Evaluate data model dependencies on current Chart of Account structures and assess the scope of required changes.
• Conduct impact analysis on reporting and application usage to ensure business outcomes are not disrupted.
• Design and implement comprehensive data models integrating new PALM data elements.
• Ensure redesigned data models are scalable, robust, and aligned with data management best practices.
• Analyze existing ETL jobs to identify inefficiencies and areas for enhancement.
• Design and implement data quality measures to ensure timeliness, accuracy, and completeness of production data.
• Collaborate with development teams to automate and streamline ETL processes.
• Provide best practices for data visualization and reporting to support financial data analysis.
• Enhance reporting frameworks to ensure compatibility with new data models and structures.
• Work closely with development teams to deploy new and revised data models.
• Act as a liaison between technical and non-technical stakeholders to communicate system impacts, changes, and timelines.
• Mentor and provide technical leadership on data integration, architecture, and quality management.
• Align data systems with the State's cloud-first initiative and ensure cloud compatibility.
Required Qualifications
• Minimum of seven (7) years of experience with large and complex database management systems.
• Minimum of seven (7) years of experience as a data architect or senior data analyst.
• Ten (10) or more years of experience working with database management systems such as Oracle, SQL Server, or DB2.
• 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.
• Experience with data visualization and reporting best practices, including tools such as Power BI or Tableau.
Location: Tallahassee, FL
Job Description:
Key Responsibilities
• Analyze and verify existing Work Program Datamart and General Ledger data models to assess impacts related to Florida PALM Chart of Account changes.
• Evaluate data model dependencies on current Chart of Account structures and assess the scope of required changes.
• Conduct impact analysis on reporting and application usage to ensure business outcomes are not disrupted.
• Design and implement comprehensive data models integrating new PALM data elements.
• Ensure redesigned data models are scalable, robust, and aligned with data management best practices.
• Analyze existing ETL jobs to identify inefficiencies and areas for enhancement.
• Design and implement data quality measures to ensure timeliness, accuracy, and completeness of production data.
• Collaborate with development teams to automate and streamline ETL processes.
• Provide best practices for data visualization and reporting to support financial data analysis.
• Enhance reporting frameworks to ensure compatibility with new data models and structures.
• Work closely with development teams to deploy new and revised data models.
• Act as a liaison between technical and non-technical stakeholders to communicate system impacts, changes, and timelines.
• Mentor and provide technical leadership on data integration, architecture, and quality management.
• Align data systems with the State's cloud-first initiative and ensure cloud compatibility.
Required Qualifications
• Minimum of seven (7) years of experience with large and complex database management systems.
• Minimum of seven (7) years of experience as a data architect or senior data analyst.
• Ten (10) or more years of experience working with database management systems such as Oracle, SQL Server, or DB2.
• 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.
• Experience with data visualization and reporting best practices, including tools such as Power BI or Tableau.