Systems Analyst

Tech Inc
Tallahassee, FL, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Access Microsoft Word Microsoft Excel Applications Architecture Software as a Service Information Systems Databases Data Integration Extract Transform Load (ETL) Data Migration Data Warehousing Relational Databases
+22 more
Programming Tools Systems Analysis Automation of Marketing Microsoft Visio Microsoft SQL Server Oracle (Applications) Microsoft PowerPoint Productivity Software Release Management Microsoft SharePoint Software Deployment Software Engineering SQL Databases SQL Server Reporting Services System Testing Web Services System Availability CrystalReports Advanced Reports Information Technology Toad (Software) Sql Database Administration

Job description

The Systems Analyst will be responsible for the following: a. Capture, collate, and disseminate the interfaces technical specifications documents and process flows by working with the agency IT and vendor technical teams. b. Identify the gaps in the interfaces’ technical specifications and process flow document. c. Work with the Agency IT /vendor technical teams to document the gaps, missing components and additional requirements. d. Day to day follow up with the vendor and the agency IT team to track, review, validate and confirm the interface documentation is updated as required. e. Create/Update Process Flow as needed working with multiple internal and external stakeholders. f. Understanding the system that includes various touch points across several modules/clusters of the product. g. Work with the agency (APD and others state agencies) and vendor technical teams on data migration/ETL activities. h. Well-versed on the new system from the interfaced point of view. i. Effectively collaborate with project team on operational constraints and project product deployment across multiple and progressive rollouts. j. Act as a point of contact for supporting interface development through postproduction support. k. Work with the Agency IT team on the implementation of new interfaces between CDMS (the new system) and internal systems. l. Work with the Agency/vendor IT teams on the comprehensive data migration plan required for the system implementation. m. Work with Agency /vendor IT teams on the comprehensive test plan required for the implementation of all the interfaces. n. Perform the testing of interfaces and data migration. o. Document the bugs, follow up, track, re-test and confirm the required fixes are implemented. p. Act as one of the key technical testers from the Agency during the system testing of the product. q. Work with the Agency and vendor IT teams on the scheduling of the interfaces jobs in production environment. r. Execute the test run of all the interfaces in pre-production environment. s. Follow up and coordinate the change management, Release Management and Deployment process between agency and external stakeholders. t. Work with the agency/vendor IT teams to enhance the APD data warehouse to include the CDMS data. u. Act as a liaison between SMEs and agency IT on the interfaces and data migration implementation. v. Create ad-hoc reports using SQL, SSRS, and HAR (Harmony Advanced Reporting). w. Work closely with other technical support personnel (internal and external ) to resolve any operational issues. x. Review, validate and confirm the interfaces, data migration and data warehouse components of configuration workbooks provided by vendor. y. Follow and work with the Change Management, release Management, and Deployment process. z. Act as an effective team player and communicator. aa. Communicate consistently and effectively with the project team. bb. Help identify issues and risks and suggest mitigation strategies and contingency plans. cc. Review deliverables for accuracy and completeness working with the end or project team to address any deficiencies. dd. Work effectively with cross-functional business units and groups with varying functional backgrounds (operational, technical, managerial, programmatic, etc.)ee. Build partnerships and collaboration between individuals and project teams.

Requirements

Do you have experience in Visio?, a. Academic and Certification i. A bachelor’s degree from an accredited college or university with a major in one of the Computer Sciences, Information Systems, Engineering, or other related fields. b. Skills and Abilities i. Must have Interface / Data Integration /Web Services, Engineering, or other related fields. ii. Must be skilled in Database Developer Tools (SQL Management Studio /TOAD /Access). iii. Must possess SQL Query Writing and Execution skills. iv. Must have thorough understanding of relational database design and development (SQL Server /Oracle). v. Must possess Data Migration/ ETL( Extract, Transformation and Load ) skills., vi. Must have Report Development skills with experience with standard tools (SSRS/CrystalReports/Access/Excel). vii. Must have SaaS/COTS product maintenance and support skills. viii. Must have team /project leader skills. ix. Must have strong documentation skills. x. Must be highly self-motivated and directed. xi. Must have strong analytical and interpersonal skills. xii. Must have excellent oral and written communication skills and be able to adapt message to a variety of stakeholders. xiii. Must have keen attention to detail. xiv. Ability to build partnerships and collaboration between individuals and project teams. xv. Ability to work in a dynamically changing environment as well as the ability to work effectively while under pressure. xvi. Ability to effectively while under pressure. Ability effectively to prioritize and execute tasks. xvii. Ability to present ideas and multi-task in an organized and highly efficient manner. c. Experience i. Fifteen (15+) Years of overall experience across various phases of Software Development Life Cycle (SCLC) projects. ii. Ten (10+) Years of Systems Analysis and Development of process flow experience. iii. Five (5+) Years of Database& Application design experience. iv. Five (5+) Years of experience in configuring and administering SaaS/COTS products. v. Two (2+) Years of experience with FL Medicaid (FMMIS) data exchanges, specifically, consumer eligibility, provider data, and service authorization related data exchanges. vi. Prior or current project experience with the Agency. vii. Experience developing interfaces solutions for business functions, Data Integration jobs, Web Services, and others similar types of interfaces. viii. Experience working in Data Analysis & Reporting. ix. Experience in Use Case Development. x. Experience developing Technical Specifications documentation. xi. Experience with data Migrations /ETL tools. xii. Experience working on Data Warehouse implementation projects. xiii. Experience working on Application Architecture. xiv. Experience working on High Availability applications. xv. Quality Assurance (QA)/Testing experience. xvi. Experience with Change Management Process. xvii. Experience working and collaborating with vendor and diverse stakeholder groups, internal and external. d. Certifications i. Certification(S) in related fields is desirable. e. General i. Office of Automation/Productivity Tools: Proficient in Microsoft Excel, PowerPoint, Project, SharePoint, Visio, and Word. ii. Communication: Team player with excellent verbal and written communication skills; Active Toastmasters strongly preferred. iii. Experience in Health & Human Services domain is a plus.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

3:49 min

Container hosting options available on Amazon Web Services

Federico Fregosi · WWC 2022

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · WWC 2024

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all