Technical Business Analyst

Job Description

Posted Thursday, November 6, 2025 at 8:00 AM

Job Title:
Technical Business Analyst

Job Summary: Technical Business Analyst will act as the primary contact between client management and practice leads/managers, and development teams (including Graphical User Interface (GUI) Mid-Tier, Quality Assurance, and Project Management personnel). Technical Business Analyst will perform data profiling and analysis, write Extract, Transform, Load (ETL) scripts using SQL or other tools, and write data reports and provide recommendations for improving data utilization/usability for clients.

The Technical Business Analyst will work on a variety of projects in MBS’ pension and health benefits vertical. MBS performs data migration, data cleansing, and data analytics for public and private sector pension and health benefits funds.

Proof of US citizenship is required for this opportunity.

• Work with users and managers to translate business needs into technical requirements for development teams and agile artifacts.
• Gain a clear understanding of the business needs and detailed client processes/workflows per the user and document the needs as user stories/functional requirements.
• Facilitate data mapping workshops, issue resolution, and data profiling sessions.
• Assist project management teams to develop realistic timelines for client needs and work with client users to facilitate timely communication of key data to mitigate change impacts and scope creep.
• Analyze, transform, and write data migration scripts using SQL, SQL Server, SSRS.
• Document Data Maps and Script Designs and other documents as needed.
• Perform Quality Assurance on analyzed data, migrated data and developed scripts.
• Write reports exposing data issues.
• Analyze data issues to determine the best course of action for resolution.

• Proven experience within an Agile/SCRUM process.
• Experience and understanding of ETL/ELT processes.
• Ability to analyze large quantities of complex data.
• Strong analytical and problem‑solving skills.
• Must work well in a team environment and be flexible as workloads and priorities change.
• Must be a self‑starter and able to define and solve problems.
• Excellent verbal and written communication skills.
• Excellent organizational skills and attention to detail.
• Excellent time management skills with a proven ability to meet deadlines.

• Bachelor’s degree in information systems, Computer Science or related field strongly preferred.
• Two to five years (2‑5) of Business Analyst experience within the financial/pensions/benefits business areas.
• The position requires at least five (5) years of working directly with programming and database teams on enterprise‑level projects.
• On‑site and virtual meeting facilitation experience required.
• Prior experience in services‑based consulting environments.
• Experience with Oracle, Postgre
  
  SQL, or similar tools.
• Experience with Python, R, or similar programming languages.
• Experience with dashboard and reporting tools such as Power BI, SSAS, or SSRS.
• 2+ years of experience with data migrations and data conversions.
• Must be located in the United States.

• The physical and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• The position may require up to 5% of travel.

• While performing the duties of this job, the employee is required to walk, use hands to finger, handle objects, tools, or controls; reach with hands and arms; balance; stoop; bending or crouching; talk or hear. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

Position is sedentary with prolonged periods of standing, bending, sitting, and kneeling.