Sea Alaska-posted about 1 month ago
Full-time • Mid Level
Lakewood, CO
1,001-5,000 employees
Food Services and Drinking Places

Senior 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.
  • Other duties as assigned.
  • 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
  • Five to eight years (5-8) 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, PostgreSQL, or similar tools.
  • Experience with Python, R, or similar programming languages.
  • Experience with dashboard and reporting tools such as Power BI, SSAS, or SSRS.
  • 5+ years of experience with data migrations and data conversions.
  • Must be located in the United States.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service