Technical Business Analyst (SQL)

JOB DESCRIPTION – TECHNICAL BUSINESS ANALYST

Position Summary:

The Technical Business Analyst is knowledgeable in SQL and will be responsible for the development of functional and non-functional business requirements by working closely with the Trionfo team members to understand business strategy and translate into platform requirements. This position must understand business and technology needs in order to analyze, design, build, implement, and maintain IT solutions and processes in a well-organized documented manner. Leads significant business analysis efforts and improves the overall impact of requirements in support of critical enterprise projects and programs. This individual must have the ability to write\understand queries as well as pulling reports using SQL.

Duties and Responsibilities:

• Develop and analyze functional specifications in order to provide advice and technical training.
• Design efficient IT systems to meet business and technology needs, as well as make recommendations for process improvements through data analysis.
• Reporting and knowledge of SQL.
• Perform assigned test scripts and deliverables on schedule and with high quality.
• Manage incoming queries and technical issues related to systems.
• Coordinate with developers to build and implement technology solutions.
• Integrate multiple systems and reconcile needs of different teams.
• Gather feedback from end users about system performance.
• Develop, implement, and maintain elements of systems design, including business process documentation, workflow charts, diagrams, data migration rules, business rules, wireframes, and other detailed deliverables including integration documentation.
• Responsible for documenting and maintaining quality meeting data.
• Assist with defining assessment and implementation methodology and deliverables for client delivery.
• Supporting production-related issues reported by client and CSR team.
• Understand issues and help resolve them through data analysis, technical research, and team collaboration on complex issues.
• Publish weekly release notes for delivery to internal and external stakeholders.
• Keep job-related reporting Standard Operating Procedures up-to-date and accurate.
• Define innovative technology solutions to further automate processes and workflows.
• Assist with connecting processes and overcoming internal silos, as well as identify controls necessary to ensure long-term system stability.
• Create various plans and strategy in a well-documented format for clients.
• Understand platform strategy and direction.
• Be able to quickly learn and adapt to company tools and resources.
• Identify process, system, and data gaps and pain points both within and across operational workflows.
• Write clear requirements and creating data models, process diagrams, and design wireframes that will further support the business’ needs.
• Participate in pre-scheduled after-hours support of weekly on-call rotation and/or as a team member supporting special projects or releases.
• Present business documentation, creative work, and proposed solutions to clients in a comprehensive and effective manner.
• Conduct training sessions to our clients in order to improve and enhance their knowledge of our platforms.
• Responsibilities and tasks outlined in this document are not exhaustive and may change as determined by the needs of the company.
• Teleworking may be required based on business needs. Must adhere to Trionfo’s Teleworking Policy by demonstrating fundamental controls and practices in protecting Trionfo’s information/assets required by candidate to complete job duties at remote location as specified in policy.

Education, Experience, and Other Skills:

• Bachelor's Degree in Information Services, Business Administration, Computer Science, or related field.
• 3 years experience in IT in a business environment.
• Proficient in SQL, Diagramming tools (e.g. Visio), and Productivity tools (e.g. Word, Excel, PowerPoint).
• Ability to write\understand queries as well as pulling reports using SQL.
• Understanding of system/API and data integration concepts, a plus.
• Understanding of the Insurance Business from the IT side, a plus.
• DevOps and Backend knowledge, preferred.
• Self-starter, creative, and thrives under limited supervision.
• Works well under pressure.
• Rock star organization skills – you pay attention to the details that others might overlook.
• Exceptional oral and written communication skills.
• Strong presentation skills and experience explaining technical concepts to clients are crucial in this role.
• Must be legally authorized to work in the United States for any employer without sponsorship.

Job Type: Full-time

Pay: $95,000.00 - $105,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Application Question(s):

• What are your salary requirements?
• Do you now, or will you in the future, require sponsorship for employment visa status (i.e. H-1B visa status, etc)? Please answer Yes or No.

Experience:

• SQL: 3 years (Required)

Work Location: In person

Salary : $95,000 - $105,000