| data architect with financial onsite from day one at tallahassee, florida at Tallahassee, Florida, USA |
| Email: [email protected] |
| From: sam, vitaforms [email protected] Reply to: [email protected] This is with Dept of Transportation so it will be plus to have DOT experience + Govt exp. Make sure that we have about 3+ Top candidates who can provide 3 ref (if needed). Start will be Dec 2024 so ideally we need candidates who are NOT on Bench. We would need the Resume and Signed Resume certification + On-site form for each candidate submitted. If you can provide a Data Architect with Financial Systems and State project experience the rate can be little higher Official Title: FDOT-OWPB Job 1410: Data Architect C - Advanced Request #: PR627435-R121186 Use for R-TR # of positions: 1 This closes Friday (11/01/2024) by NOON. Candidate need to show up first day to the office This is a 100% on-site position from day one. NO EXCEPTION Telecommuting: For candidates residing in the immediate Tallahassee area, 3-days in office and 2-days remote are allowed. MANDATORY Technical/Business Skill Set Requirements Bachelor s or Master s Degree in Computer Science, Information Systems, or other related field. Work experience can substitute on a year for year basis for the degree. Minimum 12-15+ years in IT A minimum of 7 years of experience with large and complex database management systems. A minimum of 7 years of experience as a data architect or senior data analyst, with extensive experience in designing, implementing, and maintaining data models and ETL processes. 10+ 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 Qualifications: Experience with the Florida PALM system or other state or federal financial management or DB2 systems. Experience with Informatica 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. In order to submit we need A) An up to date resume and Cover letter (why you should be the selected candidate) in word format only. Please make sure all the skills listed in the JD are reflected in your resume (only if you have the experience). B) Manual signed Resume certification form with Blue ink including the witness signature. GIS will provide the 2 witness signature. DL copy or passport copy is needed as form of identification to witness the persons signature. Please leave the date blank so we DO NOT have you bother you with this STEP for any future positions C) Manual signed on-site Acknowledgement form with Blue/Black ink by the consultant providing the services. Only place the signature at the bottom; the above info box will be filled by GIS, Inc; D) No Double submission to the state of Florida. Please confirm E) Rate as agreed - $XX/hr (All Inclusive) C-2-C with once a month billing terms NET 30. Please confirm This is in ref to the position listed below Position ID: 429201-DArc Title: On-Site Data Architect (Financial Systems; Oracle/SQL Server/DB2/ETL/Azure cloud solutions/Informatica Cloud Data Integration) Location: Tallahassee, FL Pay Rate: DOE Length: Long Term Travel Required: none Telecommute: no Skills: Data Architect , Data Analyst/Modeling/integration tools/Governance/Quality management; Database Management Systems, ETL processes; financial data systems; data warehousing; Business Intelligence tools/systems; Oracle; Microsoft SQL Server; DB2; SQL and scripting languages ; Power BI, Tableau; cloud-based data integration solutions, Azure; Snowflake; Florida PALM system; "Informatica Cloud Data Integration"; Work Program Datamart and General Ledger; DOCUMENTATATION, MS Word/Excel/Visio/PowerPoint/SharePoint; Govt; Job description: Note : Please reply ONLY if you 1) can report to work on-site from day 1 and then Candidates are expected to work a minimum of three (3) full days per week in the office. 2) have all the Required skill set and have experience as an "On-Site Data Architect (Financial Systems; Oracle/SQL Server/DB2/ETL/Azure cloud solutions/Informatica Cloud Data Integration)". Need to have Financial Systems projects. 3) can provide at least 3 verifiable experience from completed and/or substantially completed jobs that closely match this request (Filling the client provided form) + Sign a Resume Certification Form 4) Can go through a background check including fingerprinting + Agree to a Web Cam. 5) have A Competitive Rate 6) will be available in Dec 2024 timeframe as it takes a minimum of 3 weeks for a start after a successful interview. Each staff member assigned to this project must have a background screening that is equivalent to a Level Two (2) screening standard. This is a fixed fee/hourly based project which is inclusive of travel, lodging, per diem expenses and all other costs associated with the completion of the associated tasks. Face to Face Interviews: At the hiring manager s discretion, interviews may be conducted via Microsoft Teams or in person. Telecommuting: Candidates are expected to work a minimum of three (3) full days per week in the office. The selected candidate is required to start their first day in the office. In the future, and at the Department's discretion, this option may return to full-time, in the office. Scope of Services Background: As part of the Department's ongoing efforts to modernize and re-engineer core financial systems, over 1,500 computing assets have been identified as supporting various financial planning, analysis, and management functions. These assets are impacted by the State of Florida's accounting system changes under the Florida Planning, Accounting, and Ledger Management (PALM) project. Florida PALM is a multiyear initiative aimed at replacing the State of Florida's existing accounting and cash management systems with a modern financial management solution. The project will replace Central, Payroll, and Departmental FLAIR functionality, with go-live scheduled for January 6, 2026. The 1,500+ computing assets consist of interfaces, enterprise applications, databases, automated processes, and reporting programs within the CLIENT. These assets require remediation due to: Adoption of the Florida PALM Standardized Business Process Model. Transition to the Florida PALM Chart of Accounts values. Replacement of Central, Payroll, and Departmental FLAIR functionality. Redevelopment of agency interfaces to the statewide accounting system. Implementation of Information Warehouse data to support agency-specific reporting requirements. The PALM System Transition (FPST) will take place over two years in alignment with the Florida PALM Project timeline. The successful candidate will assist in guiding the transition to the PALM system, which involves reviewing as-is business processes, remediation strategies, reengineering, design, and integration with FM financial systems. Ensuring compatibility with cloud architecture is a key objective, aligning with the state s cloud-first policy. The role focuses on the analysis and remediation of data marts and models within the Office of Work Program and Budget (OWPB) and verifying compatibility with data once provisioned within the agency from the Florida PALM system. Scope: 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. 6. Technical Leadership and Strategic Support: Collaborate with OWPB leadership and the Office of Information Technology (OIT) to develop tactical strategies for the planning, design, implementation, and maintenance of data warehousing initiatives. Provide guidance on high-level design choices and technical standards, including software coding standards, tools, and platforms. Act as an internal consultant, mentor, and advocate to team members, supporting ongoing improvements and change management initiatives across the OWPB computing assets. Deliverables: Comprehensive assessment report on current Work Program Datamart and General Ledger data models. Enhanced data model designs integrating Florida PALM Chart of Account updates. Thorough documentation on data quality measures and ETL process enhancements. Guidelines on best practices for data visualization and reporting. Detailed implementation plan for the deployment and verification of new data models. Consistent updates and presentations to stakeholders on project progress and key insights. The candidate will play a pivotal role in ensuring that the transition to the Florida PALM system is smooth, efficient, and aligned with the strategic objectives of the FDOT, supporting the modernization of financial management processes and data architecture. MANDATORY Technical/Business Skill Set Requirements Bachelor s or Master s Degree in Computer Science, Information Systems, or other related field. Work experience can substitute on a year for year basis for the degree. Minimum 12-15+ years in IT A minimum of 7 years of experience with large and complex database management systems. A minimum of 7 years of experience as a data architect or senior data analyst, with extensive experience in designing, implementing, and maintaining data models and ETL processes. 10+ 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 Qualifications: Experience with the Florida PALM system or other state or federal financial management or DB2 systems. Experience with Informatica 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. Primary Job Duties/ Tasks The submitted candidate must be able to perform the following duties and/or tasks: 1. Analyze and verify existing data models and interfaces in the Work Program Datamart and General Ledger to assess impacts and identify potential disruptions due to the Florida PALM transition. 2. Design and implement comprehensive data models, integrating new PALM data elements to ensure compatibility with business processes and reporting needs. 3. Review and enhance ETL processes to improve data quality, timeliness, and accuracy, and implement robust data quality measures to maintain high standards of production data. 4. Collaborate with development teams to deploy revised data models, verifying successful implementation and resolving any integration issues. 5. Provide expert guidance on data visualization and reporting, establishing best practices to optimize business insights, and monitor dependencies with interfacing systems to propose remediation where necessary. 6. Act as a liaison between technical teams, business stakeholders, and OIT to ensure clear communication regarding data architecture changes and project timelines. 7. Mentor and provide technical leadership to team members, guiding them on best practices in data integration, architecture, and quality management. 8. Ensure continuous improvement in data processes by defining roadmaps, standardizing methodologies, and collaborating on strategic initiatives. 9. Evaluate and align current data systems with the state s cloud-first initiative, ensuring data models are scalable and compatible with cloud architecture. Job Specific Knowledge, Skills, and Abilities (KSAs) The submitted candidate must be able to apply Knowledge, Skills, and Abilities in the following areas: Knowledge: Strong knowledge of financial management business processes, including accounting, ledger management, and budget reporting. In-depth understanding of data modeling principles, including relational and dimensional modeling techniques. Familiarity with the Florida PALM system or similar state or federal financial management systems. Proficiency in database management systems (DBMS) such as Microsoft SQL Server and DB2. Comprehensive understanding of ETL processes and data integration tools like Informatica, Talend, or Microsoft SSIS. Knowledge of cloud-based data integration platforms (e.g., Azure, Snowflake) and cloud-first strategies. Familiarity with data quality management practices, data governance frameworks, and best practices. Knowledge of data visualization tools (e.g., Power BI) and reporting best practices. Understanding of data security, privacy regulations, and compliance requirements. Skills: Proficiency in SQL and scripting languages for database querying and data manipulation. Strong analytical and problem-solving skills, with the ability to conduct complex systems analysis and identify areas for improvement. Skill in designing scalable and robust data models that support business processes and reporting needs. Ability to work with ETL tools to streamline and automate data extraction, transformation, and loading processes. Skilled in verbal and written communication, with the ability to explain technical concepts to non-technical stakeholders. Competency in project management, including the ability to plan, prioritize, and manage multiple tasks effectively. Strong collaboration and interpersonal skills to work effectively with cross-functional teams and stakeholders. Skilled in conducting data impact assessments and presenting findings to management and development teams. Abilities: Ability to lead and mentor technical teams, providing guidance on best practices in data architecture, integration, and quality management. Ability to conduct detailed analysis of existing systems and identify opportunities for optimization and modernization. Capability to develop comprehensive data models and ETL processes that align with business requirements and organizational goals. Ability to translate user requirements into technical specifications and scalable data solutions. Ability to integrate research, trends, and industry best practices into continuous improvement efforts. Ability to communicate effectively with stakeholders at all levels, ensuring alignment between technical solutions and business needs. Ability to adapt to changing requirements and priorities, maintaining a focus on quality and project deadlines. Strong organizational skills and attention to detail, with the ability to document data architecture, processes, and standards. Ability to ensure data solutions comply with security, privacy, and compliance standards. General Knowledge Skills and Abilities (KSAs): The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas: 1. Communication: Ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings (i.e., project team meetings, management presentations, etc.). Must have the ability to effectively listen and process information provided by others. 2. Customer Service: Works well with clients and customers (i.e., business office, public, or other agencies). Able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem. 3. Decision Making: Makes sound, well-informed, and objective decisions. 4. Flexibility: Open to change, new processes (or process improvement), and new information. Has the ability to adapt in response to new information, changing conditions, or unexpected obstacles. Ability to receive and give constructive criticism and maintain effective work relationships with others. 5. Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others. 6. Leadership: Motivates, encourages, and challenges others. Adapt leadership styles in a variety of situations. 7. Problem Solving: Ability to identify, evaluate, and use sound judgement to generate and evaluate alternative actions, and make recommendations as accordingly. 8. Team Building: Encourages, inspires, and guides others toward accomplishing the common goal. "When replying please make sure to list your (All Inclusive) Compensation requirements !!!" Note: This is a Full Time ON SITE Contract Position with NO remote options allowed!! # of positions: 1 ESTIMATED Start date : Dec 2024 Keywords: cprogramm business intelligence rlang information technology golang microsoft Florida Idaho data architect with financial onsite from day one at tallahassee, florida [email protected] |
| [email protected] View all |
| Thu Oct 31 19:01:00 UTC 2024 |