- Handling table changes in SQL as it relates to specific client configured data
- Merging records and/or other client requested data change requests in SQL and GUI with recommendations on how to resolve
- Testing data in various environments, including but not limited to: automated interfaces, Virtual OneStop GUI, nightly batch processes; verification of converted legacy data
- Troubleshoot Federal reporting issues as identified by clients
- Resolving issues identified by clients or internal staff where GUI may have caused inaccurate data to be recorded
- Work directly with clients to discuss issues, propose solutions to correct data issues, implement the resolution and follow up on the resolutions
- Make recommendations (written and verbal) on how changes could be implemented to improve the overall data quality
- Designs advanced SQL queries, stored procedures, triggers, scripts, cursors
- Leads/assists in data conversion and data migration projects Assists business analysts and end-users with reporting needs
- Collaborates with applications developers to ensure correct data and data structure to support evolving development
- Understands Full Development Life Cycle & RDBMS Develops processes for nightly builds, and deployment Optimizes and improves SQL code for better performance
- Develops programming specifications through interaction with business unit subject matter experts
- Works closely with the Team Lead and Analysts throughout the change request process to insure the delivery of an accurate solution
- Processes change requests through OPC ticket system, including application wide data changes Estimates the level of effort required to complete a project or change request
- Prepares and update technical documentation
- May also be assigned various projects and tasks as needed.
- Excellent written and oral communication skills
- Ability to interface with wide range of individuals, both internally (Project Managers, Business Analysts, Programmers) as well as external clients
- Must possess strong MSSQL skills (including proficiency with data tables, merges, table changes)
- Workforce development experience highly desired, two or more years' experience with data analysis in a software/IT development setting strongly preferred
- High attention to detail and accuracy
- Ability to write simple and/or complex SQL queries as needed
- Excellent interpersonal and time management skills essential
- Strong analytical skills
- Ability to document database designs and conversion maps
- Familiarity with data corruption and database recoverability methods
- Ability to learn and master the business rules associated with our applications and how they interact with the data and data structure
- Ability to monitor and resolve database performance issues
- Understanding of the Virtual OneStop system
- Understanding of the OPC/Intranet
- Understanding of UI System Concepts
- Experience in the labor market, Unemployment Insurance or regulatory occupation industries preferred
- Advanced Microsoft SQL Server knowledge (to include advanced querying in T-SQL, stored procedures, indexes, triggers, SSIS, import and export capabilities)
- May also be assigned various projects and tasks as needed.
- May be required to travel to client locations for data conversion planning sessions
-
Integration Analyst Senior
3 weeks ago
Tampa General Hospital Tampa, United StatesJob Summary Performs routine analysis to include evaluation of hardware and software based on end user criteria and workflow analysis, design, development, testing, training, implementation, management and support of assigned application systems and/or projects. Directly interact ...
-
HR Services Data Integrity Analyst
3 days ago
Sevita Tampa, United StatesOUR MISSION AND PERFORMANCE EXPECTATIONS · At Sevita, we believe that everyone deserves to live well. For more than 50 years, our team members have provided home and community-based health care for adults, children, and their families across the United States. Our extraordinary ...
-
AVP OPRF Data Integration Analyst
5 days ago
Citigroup Inc Tampa, United StatesExcited to grow your career?We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you see is right for you, we encourage you to apply Our p ...
-
Epic Third party Integration Analyst
12 hours ago
ClinDCast LLC Tampa, United StatesDesign and optimize workflows, write queries. · Engage in domain discussions with clients. · Access and extract data from EHR & 3rd party systems. FHIR · Familiarity with Electronic Health Record systems (EHR) and third-party healthcare systems (e.g., 3M Encoder). · ...
-
Billing Integrity Analyst Credentialed
3 weeks ago
Parallon St Petersburg, United StatesDescription · Introduction · Do you have the career opportunities as a Billing Integrity Analyst Credentialed you want with your current employer? We have an exciting opportunity for you to join Parallon which is part of the nation's leading provider of healthcare services, HCA ...
-
Integration analyst Tampa FL
3 weeks ago
ESR Healthcare Tampa, United StatesIntegration analyst Tampa FL · Experience level: Associate Experience required: 5 Years Education level: All education level Job function: Non IT Consultant Industry: Financial Services Pay rate : $40 per hour Total position: 1 Relocation assistance: No Visa sponsorship eligibil ...
-
VP, Data Integration Lead Analyst
1 week ago
Citigroup Inc Tampa, United StatesThe Data Integration Lead Analyst is responsible for facilitating / executing the day-to-day activities that support the execution, enablement and adoption of the Data Transformation Plan and/or support of use cases through collaboration with Functions, Regions and Lines of Busin ...
-
AVP OPRF Data Integration Analyst
3 weeks ago
Citigroup Inc Tampa, United StatesExcited to grow your career? · We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you see is right for you, we encourage you to apply O ...
-
AVP OPRF Data Integration Analyst
3 weeks ago
Citigroup Inc Tampa, United States**Excited to grow your career?** · We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you see is right for you, we encourage you to app ...
-
Revenue Integrity Charge Capture Analyst
2 weeks ago
Johns Hopkins Medicine St. Petersburg, United States Full timeYou were meant for Hopkins Come see why the Johns Hopkins Hospital is a world-renowned leader in patient care, serving the greater Baltimore community and patients from all across the globe. Our friendly and knowledgeable staff teams provide support throughout our many specialty ...
-
Vp, Data Integration Lead Analyst
1 week ago
Citi Tampa, United StatesThe Data Integration Lead Analyst is responsible for facilitating / executing the day-to-day activities that support the execution, enablement and adoption of the Data Transformation Plan and/or support of use cases through collaboration with Functions, Regions and Lines of Busin ...
-
Data Scientist Analyst I
2 days ago
Iquery Palm Harbor, United StatesJob Description · Job DescriptionDescription:Job Summary: The Data Science Analyst I provides financial analysis and manages complex financial information to determine potential companies for merger acquisition. Reviews, reconciles, and analyzes data to ensure financial integrity ...
-
Analyst III
12 hours ago
PODS Enterprises, LLC Clearwater, United StatesJob Description · Job DescriptionJOB SUMMARY · PODS Moving and Storage is seeking a motivated, self-starter, problem-solver to fill the role of Sr CRM Analyst, primarily working on B2B customer facing digital applications. The Sr CRM Analyst will be responsible for the day-to-day ...
-
Senior Governance, Risk and Compliance Analyst
2 weeks ago
Trulieve Clearwater, United States"Trulieve Grows One Patient at a Time" · If you have an interest in being part of one of the fastest growing industries in the nation in you may consider wanting to work for Trulieve If you have a desire to help others in need through your efforts, this may be the role for you · ...
-
Supervisor of Medical Records
2 weeks ago
Directions for Living Clearwater, United StatesJob Description · Job DescriptionSalary: $55,000 · Do you envision working for a dynamic, mission-driven organization which supports the community while fostering an employee culture of appreciation and fun? If your answer is yes, than an employment opportunity at Directions for ...
-
Commercial Insurance Business Analyst
2 weeks ago
Frank Winston Crum Insurance Clearwater, United StatesJob Description · Job DescriptionFrankCrum is a Top Workplace · Frank Winston Crum Insurance (FWCI) issues Workers' Compensation and General Liability policies by offering flexible coverage and payment options to meet the varied needs of businesses. Over the years, FWCI has grown ...
-
IT Program Manager
1 week ago
Blue Sky Innovative Solutions Largo, United StatesBlue Sky is seeking an IT Program Management Analyst with a strong technical background, broad knowledge of program management, and hands-on experience managing enterprise-wide programs, to support our local government customers. · WORK HOURS: Monday through Friday on a regular ...
-
Developer/Analyst
4 weeks ago
Qwalifize LLC Clearwater, United StatesJob Description · Job DescriptionType: · Temporary · Full Time or Part Time: · Full time · Pay Rate: · TBD · Location: · Clearwater, FL 33756 · Language Requirements: · Write, read, and speak English fluently · Language Preferences: · Also Spanish · Job Overview: · We are ...
-
010-IT Program Management Analyst
1 week ago
ANGARAI Largo, United StatesJob Description · ANGARAI is looking for a Program Management Analyst who possess IT expertise, knowledge, skills, abilities, certifications to provide a multifaceted approach, blended program management expertise with a keen focus on integration, business process optimization, a ...
-
Insurance QA Manager
2 weeks ago
Frank Winston Crum Insurance Clearwater, United StatesJob Description · Job DescriptionFrankCrum is a Top Workplace · Frank Winston Crum Insurance (FWCI) issues Workers' Compensation and General Liability policies by offering flexible coverage and payment options to meet the varied needs of businesses. Over the years, FWCI has grown ...
Data Specialist/Systems Integration Analyst - Palm Harbor, United States - GEOGRAPHIC SOLUTIONS INC
Description
Job Description
Job DescriptionDescription:Job Summary: This individual will be responsible for performing heavy SQL data analysis in support of Business Analysts and Project Managers. In addition, develops, administers, maintains, and supports policies and procedures for creating interfaces between and/or converting data from client existing and legacy systems to Geographic Solutions systems. Designs programming specifications through interaction with business owners and subject matter experts. Ensures correct functionality and accuracy of the interface or conversion scripts. Familiar with the standard concepts, practices, and procedures within the labor market industry as well as job services concepts. Relies on direction and good judgment to plan and accomplish goals. Works under general supervision.
Note: All new hires will travel to GSI's headquarters in Palm Harbor, Florida for a week of new hire orientation.
Duties and Responsibilities:
Communication Skills:
Technical Knowledge, Skills and Experience:
Knowledge that is a plus:
Special Requirements:
Equal Opportunity Employer. M/F/D/V