Production Support Specialist
Lead I - Production Support
Who We Are:
Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world.
UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live.
With us, you’ll create a boundless impact that transforms your career—and the lives of people across the world.
Visit us at UST.com.
You Are:
We are seeking an experienced Production Support Specialist to manage and support our data integration processes, particularly focusing on the VLM Checkbook and VLM/Encounter 837 processes. This role will be responsible for ensuring the seamless operation of ETL and data management systems, including Informatica PowerCenter, Power Exchange, SQL, Kafka, and SSIS. The ideal candidate will have a deep understanding of data flows, database systems, and message queues, with a strong ability to troubleshoot, optimize, and support large-scale data integration processes.
The Opportunity:
· Monitor and manage the VLM Checkbook process to ensure the smooth flow of data. This includes the handling of transactions, file transfers, and status updates related to the checkbook process.
· Troubleshoot issues related to the VLM Checkbook process, ensuring that any interruptions are resolved quickly and efficiently to minimize impact on production environments.
· Ensure data accuracy and consistency by performing checks on the incoming and outgoing data related to the VLM Checkbook process.
· Collaborate with cross-functional teams (business, IT, and vendors) to address process improvements, data issues, and optimize workflow performance.
· Perform root cause analysis for recurring issues and proactively implement solutions to prevent similar incidents.
· Monitor and manage the VLM/Encounter 837 process, ensuring that the 837 EDI files are processed in a timely manner. This includes validating data integrity, ensuring proper file formatting, and ensuring timely file delivery.
· Oversee ETL processes using Informatica PowerCenter and Power Exchange, ensuring that data is correctly extracted, transformed, and loaded into the appropriate databases or systems.
· Work with Kafka to manage message queues and ensure that data is being properly transmitted across systems and applications within the VLM/Encounter 837 workflow.
· Perform SQL and Oracle database checks to validate the integrity of data within the systems and address any discrepancies or issues in the 837 data processing pipeline.
· Utilize SSIS (SQL Server Integration Services) for data integration, transformation, and loading processes, ensuring that the VLM and Encounter 837 data flows correctly between systems.
· Address and resolve production issues in real-time for the VLM Checkbook and VLM/Encounter 837 processes, ensuring that any disruptions are promptly mitigated with minimal impact to the business.
· Utilize monitoring tools to track job status and performance for all processes and initiate timely corrective actions for any errors.
· Escalate critical issues to appropriate teams and stakeholders for resolution, and provide detailed post-incident analysis to prevent recurrence.
· Validate data quality by ensuring the accuracy and integrity of data flows related to the VLM Checkbook and Encounter 837 processes. Identify any data discrepancies and work with stakeholders to correct them.
· Optimize performance of ETL processes, ensuring that Informatica PowerCenter, Power Exchange, and Kafka functions are running efficiently and that processing times for large volumes of data are minimized.
· Monitor and optimize SQL queries to ensure that databases are performing optimally, especially in terms of data retrieval and manipulation for VLM and Encounter data.
· Maintain documentation for all VLM/Encounter 837 processes, including workflows, troubleshooting guides, and best practices for supporting the process.
· Provide status updates and incident reports to stakeholders, including details of system performance, issues encountered, and resolutions implemented.
· Collaborate with other production support teams to ensure end-to-end system integrity and ensure data flows as expected across multiple systems.
· Communicate effectively with business and IT stakeholders to ensure that any requirements, changes, or issues are addressed promptly.
· Support post-deployment validation by verifying the proper functioning of the VLM Checkbook and VLM/Encounter 837 processes after updates or system changes.
· Participate in testing of new features or fixes to the VLM/Encounter 837 workflows, ensuring that new releases do not disrupt current operations.
This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.
What You Need:
· Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field.
· 4+ years of experience in production support, particularly in the management of ETL processes, data integration, and large-scale data pipelines across on-prem and cloud-based environments.
· Hands-on experience with Informatica PowerCenter and Power Exchange for managing complex data transformations, extractions, and loads.
Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.
Role Location: Remote
Compensation Range: $81,000-$123,000
Benefits
Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), 10 paid holidays, and are eligible for paid bereavement leave and jury duty. They are eligible to participate in the Company’s 401(k) Retirement Plan with employer matching. They and their dependents residing in the US are eligible for medical, dental, and vision insurance, as well as the following Company-paid Employee Only benefits: basic life insurance, accidental death and disability insurance, and short- and long-term disability benefits. Regular employees may purchase additional voluntary short-term disability benefits, and participate in a Health Savings Account (HSA) as well as a Flexible Spending Account (FSA) for healthcare, dependent child care, and/or commuting expenses as allowable under IRS guidelines. Benefits offerings vary in Puerto Rico.
Part-time employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year) and are eligible to participate in the Company’s 401(k) Retirement Plan with employer matching.
Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year) and are eligible to participate in the Company’s 401(k) program with employer matching. They and their dependents residing in the US are eligible for medical, dental, and vision insurance.
Part-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).
All US employees who work in a state or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws.
What We Believe:
We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity. These values inspire us to nurture a people-first, human centric culture that fosters diversity, prioritizes sustainable solutions, and keeps our people and clients at the forefront of all decisions.
Humility:
We will listen, learn, be empathetic and help selflessly in our interactions with everyone.
Humanity:
Through business, we will better the lives of those less fortunate than ourselves.
Integrity:
We honor our commitments and act with responsibility in all our relationships.
Equal Employment Opportunity Statement
UST is an Equal Opportunity Employer.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other applicable characteristics protected by law. We will consider qualified applicants with arrest or conviction records in accordance with state and local laws and “fair chance” ordinances.
UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.
#UST
#CB
#LI-AS11
#LI-Remote