FACS Programmer and Analyst

SHERLOQ Solutions is looking to hire a full-time FACS Programmer and Analyst. Are you looking to work for a high-energy, fast-paced company that fosters a team environment? Do you want to work where you will be respected and valued for what you contribute? An organization with a long history in the community for over 100 years! Well, you found it. SHERLOQ Solutions is looking for you to become the next member of our team.

Position Summary:

We are seeking a FACS Programmer/Analyst with experience in Finvi/Ontario System's collection software and basic general scripting knowledge. This position will work with the team developing new client interfaces including automation scripts as well as maintaining and improving existing processes.

Responsibilities:

• Programming inbound and outbound files that adhere to client file layout specifications using combinations of Enable, Report Writer, Logic Blocks, Tactics, Night Jobs, MS Access, VBA, SSMS, SSRS, Task Scheduler and WinBatch or PowerShell scripting.
• Daily time-sensitive troubleshooting of script errors due to internal and external forces impacting automation.
• Provides extracts and reports for clients and leadership on demand using SQL warehouse database and direct production queries, FACS Report Writer, and FACS Analytics.
• Monitor newly designed and existing interfaces to ensure smooth operation.
• Conducts testing and analysis for successful program operation, timing with existing processes, and makes modifications.
• Setup and maintain SSRS/SQL subscriptions as needed.
• Create and maintain SSRS reports, SSMS stored procedures, and use Report Builder.
• Maintain documentation of new and existing interfaces, program changes, scripting comments, and ticketing system updates.
• Identify, resolve, and prevent business system and data issues.
• Work directly with clients and internal team members to design and implement projects.
• Perform Gap Analysis of projects by reviewing program objectives, data samples, and input/output requirements with project managers and clients.
• Arrange projects in programming sequence, prepare workflow charts/diagrams as may be needed.
• Handle multiple daily, weekly, monthly responsibilities/tasks in a fast-paced environment.
• Maintains client confidentiality and adheres to federal and state privacy laws.
• Maintains and grows professional and technical knowledge.

Qualifications:

• Strong project management, analytical, and problem-solving skills
• Ability to meet project deadlines on time
• Ability to collect, organize, analyze, and distribute large amounts of information with high attention to detail and accuracy
• Able to work well both with a team and independently
• Excellent interpersonal and communication skills
• Ability to communicate at all levels of the organization from front line representatives to executives and to clients
• Must have the ability to prioritize workload, handle multiple projects and be able to work with operations to streamline processes to optimize efficiency, compliance and the patient/consumer experience
• Knowledge of debt collection/healthcare financial services regulatory compliance requirements, including state and federal consumer protection laws.
• Candidate should have strong knowledge of the following: FACS Enable, Report Writer, Event Tactics, Logic blocks, Night Jobs, Debtor Cash, MS Excel, MS Access, VBA, SQL, WinBa tch or PowerShell or equivalent scripting language.
• Additional skills that are ideal but not required: FACS SQL, FACS Web, FACS Analytics or Crystal Reports, Microsoft SQL Server Management Studio (SSMS), Microsoft SQL Server Intelligence Studio (SSIS), Microsoft SQL Server Reporting Services (SSRS), Intersystems Cache Database.

Education and Experience

• At least five (5) years' experience working with IT Programming
• Undergraduate degree in Computer Science, Information Systems, Operations / Business Management or related discipline
• Three (3) years' experience in the healthcare/financial services industry or debt collection.

This position earns competitive pay, depending on experience. We value our employees and offer amazing benefits, including medical Insurance, a 401(k) plan, generous vacation and paid-time-off (PTO), eight paid holidays, and tuition reimbursement as well as life, dental, accidental death & disability, and supplemental insurance. Our plans are designed to be both valuable and affordable. If this sounds like the right opportunity for you, apply today!

We are proud to be an EOE/AA Employer - (Minority/Female/Disabled/Veteran) - .

We maintain a drug-free workplace and perform pre-employment substance abuse testing.

READY TO JOIN OUR TEAM?

We understand your time is valuable and that is why we have a very quick and easy application process. If you feel that you would be right for this position, please fill out our initial 3-minute, mobile-friendly application. We look forward to meeting you!