<p>Senior Data Architect</p> <p>Seeking a Senior Data Architect / Senior Data Analyst to lead the analysis, redesign, and implementation of data models and data integration processes supporting this transition, with a strong focus on data quality, reporting, and cloud compatibility.</p> <p>Scope of Services</p> <ol> <li>Data Analysis and Impact Assessment </li></ol> <ul> <li> <p>Analyze and validate existing Work Program Datamart and General Ledger data models.</p> </li><li> <p>Assess impacts resulting from Florida PALM Chart of Accounts and standardized business process changes.</p> </li><li> <p>Identify dependencies on current accounting structures and determine required remediation.</p> </li><li> <p>Conduct impact analysis on reports, applications, and downstream systems to ensure continuity of business operations.</p> </li></ul> <ol start="2"> <li>Data Model Design and Enhancement </li></ol> <ul> <li> <p>Design and document enhanced data models incorporating Florida PALM data elements.</p> </li><li> <p>Ensure data models are scalable, maintainable, and aligned with industry best practices.</p> </li><li> <p>Support both current operational needs and future analytical and reporting requirements.</p> </li></ul> <ol start="3"> <li>ETL and Data Quality Improvement </li></ol> <ul> <li> <p>Review existing ETL processes to identify inefficiencies and improvement opportunities.</p> </li><li> <p>Design and implement data quality controls to ensure accuracy, completeness, and timeliness.</p> </li><li> <p>Support automated data refresh schedules (e.g., nightly, hourly, or ad hoc).</p> </li><li> <p>Collaborate with development teams to streamline and modernize ETL workflows.</p> </li></ul> <ol start="4"> <li>Reporting and Data Visualization </li></ol> <ul> <li> <p>Provide best-practice guidance for financial data visualization and reporting.</p> </li><li> <p>Ensure reporting frameworks remain compatible with updated data models.</p> </li><li> <p>Support business users in effectively analyzing and interpreting financial data.</p> </li></ul> <ol start="5"> <li>Collaboration and Deployment </li></ol> <ul> <li> <p>Work closely with development teams to deploy updated data models and ETL processes.</p> </li><li> <p>Validate implementations against functional and business requirements.</p> </li><li> <p>Serve as a liaison between technical teams, business stakeholders, and OIT.</p> </li><li> <p>Communicate system impacts, data changes, and timelines clearly and effectively.</p> </li></ul> <p>Deliverables</p> <ul> <li> <p>Assessment report of current Work Program Datamart and General Ledger data models.</p> </li><li> <p>Updated data model designs aligned with Florida PALM requirements.</p> </li><li> <p>Documentation of ETL enhancements and data quality controls.</p> </li><li> <p>Best-practice guidelines for data visualization and reporting.</p> </li><li> <p>Implementation and deployment plan for revised data models.</p> </li><li> <p>Regular status updates and presentations to stakeholders.</p> </li></ul> <p>Education</p> <ul> <li> <p>Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.</p> </li><li> <p>Relevant work experience may substitute for formal education on a year-for-year basis.</p> </li></ul> <p>Experience</p> <ul> <li> <p>7+ years of experience with large, complex database management systems.</p> </li><li> <p>7+ years of experience as a data architect or senior data analyst.</p> </li><li> <p>10+ years of experience with DBMS platforms (e.g., Oracle, SQL Server, DB2).</p> </li><li> <p>Strong experience with financial data systems, data modeling, and data governance.</p> </li><li> <p>Proven experience with ETL tools and data warehousing solutions.</p> </li><li> <p>Experience with data visualization tools such as Power BI or Tableau.</p> </li><li> <p>Familiarity with cloud-based data platforms (e.g., Azure, Snowflake).</p> </li></ul> <p>Preferred Qualifications</p> <ul> <li> <p>Experience with Informatica (Cloud Data Integration, Governance, or Catalog).</p> </li><li> <p>Strong analytical and documentation skills.</p> </li><li> <p>Excellent communication skills with both technical and non-technical stakeholders.</p> </li><li> <p>Experience supporting large-scale government or enterprise financial systems.</p> </li></ul> <p>Primary Job Duties</p> <ul> <li> <p>Analyze and remediate data models and interfaces impacted by Florida PALM.</p> </li><li> <p>Design and implement updated data models and integration processes.</p> </li><li> <p>Enhance ETL workflows and data quality standards.</p> </li><li> <p>Support deployment and resolve data integration issues.</p> </li><li> <p>Establish reporting and visualization best practices.</p> </li><li> <p>Coordinate with business stakeholders, OIT, and development teams.</p> </li><li> <p>Provide technical leadership and mentorship.</p> </li><li> <p>Align data architecture with the State's cloud-first strategy.</p> </li></ul> <p>Knowledge, Skills, and Abilities (KSAs)</p> <p>Knowledge</p> <ul> <li> <p>Financial management and accounting business processes.</p> </li><li> <p>Relational and dimensional data modeling.</p> </li><li> <p>ETL and data integration platforms.</p> </li><li> <p>Cloud-based data architectures and strategies.</p> </li><li> <p>Data governance, quality, and compliance practices.</p> </li><li> <p>Data visualization and reporting tools.</p> </li><li> <p>Data security and privacy requirements.</p> </li></ul> <p>Skills</p> <ul> <li> <p>Advanced SQL and data analysis skills.</p> </li><li> <p>Strong system analysis and problem-solving abilities.</p> </li><li> <p>Clear technical documentation and communication skills.</p> </li><li> <p>Project planning and prioritization.</p> </li><li> <p>Stakeholder collaboration and facilitation.</p> </li></ul> <p>Abilities</p> <ul> <li> <p>Lead and mentor technical teams.</p> </li><li> <p>Translate business requirements into scalable data solutions.</p> </li><li> <p>Adapt to changing requirements and timelines.</p> </li><li> <p>Maintain attention to detail while managing complex systems.</p> </li><li> <p>Communicate effectively across organizational levels.</p> </li></ul>