Senior Technical Analyst

Andersen; McKinney (TX); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Private health insurance

Sports compensation

Certification reimbursement

Referral program

Training portal access

Hybrid work option

Job summary

Andersen is seeking a Technical Analyst for a large-scale insurance transformation, focusing on optimizing business processes, aligning requirements, and ensuring successful delivery. The role involves close collaboration across teams and stakeholders in an Agile environment.

You will analyze insurance processes, translate requirements into specs, and design data models and integrations between OutSystems, Azure, and core systems.

Qualifications

• 5+ years experience as Technical Analyst, Technical Business Analyst or Systems Analyst.
• 3+ years experience in insurance domain (policy administration, underwriting, claims or billing).
• Strong SQL skills with complex queries, joins and performance analysis.
• Solid data modelling knowledge including relational models and data mapping.
• Hands-on experience with OutSystems or another low‑code platform.
• Experience with Microsoft Azure services (Azure SQL, App Services, Functions).
• Experience writing requirements, user stories and acceptance criteria using Jira/Confluence.
• English level: Intermediate+.

Responsibilities

• Analyze business and technical requirements for insurance processes (quoting, policy management, endorsements, renewals, claims, billing).
• Translate requirements into functional/technical specifications.
• Develop and optimize complex SQL queries and data flows between portals and core systems.
• Design data models, mappings and integration contracts between OutSystems, Azure and back-end systems.
• Define entities, screens and business logic for OutSystems apps and review solutions.
• Investigate data issues and perform root-cause analysis.
• Prepare acceptance criteria and support functional testing and UAT.
• Create and maintain requirements docs, data dictionaries and process flows.
• Collaborate with developers, architects, QA and stakeholders in an Agile/Scrum environment.

Skills

SQL expertise

Insurance domain

Data modelling

OutSystems

Azure

Jira & Confluence

English – Intermediate+

Education

Bachelor's degree in a relevant field

Tools

SQL Server

Oracle

Jira

Confluence

Azure API Management

Job description

Andersen is hiring a Technical Analyst for a large-scale insurance transformation project focused on optimizing business processes, aligning requirements, and ensuring successful project delivery.

The customer is an international insurance company operating across multiple countries, known for expertise in niche markets and commitment to high-quality service. With strong governance and transparent practices, it promotes a culture of innovation, diversity, and continuous learning. Recent achievements, including record financial results and recognition for customer service, highlight its resilience and long-term value creation.The project is focused on a large-scale transformation initiative for a leading US insurance company. It involves close collaboration across multiple teams and business stakeholders, with a strong emphasis on improving business processes, aligning requirements, and ensuring successful project delivery.

Responsibilities:

• Analysing business and technical requirements for insurance processes, including quoting, policy management, endorsements, renewals, claims and billing.
• Translating business requirements into clear functional and technical specifications.
• Developing and optimising complex SQL queries, analysing data structures and data flows between portals and core insurance systems.
• Designing and documenting data models, mappings and integration contracts between OutSystems applications, Azure services and back-end systems.
• Defining entities, screens, business logic and integration requirements for OutSystems applications, and reviewing technical solutions against requirements.
• Investigating data inconsistencies and integration issues, performing root-cause analysis and supporting issue resolution.
• Preparing acceptance criteria, supporting functional testing, data validation and User Acceptance Testing (UAT).
• Creating and maintaining requirements documentation, data dictionaries, process flows and integration diagrams.
• Collaborating with developers, architects, QA and business stakeholders within an Agile/Scrum environment.

Must-haves:

• Experience as a Technical Analyst, Technical Business Analyst or Systems Analyst for 5+ years.
• Experience in the insurance domain, including policy administration, underwriting, claims or billing for 3+ years.
• Strong SQL expertise, including complex queries, joins, aggregations and performance analysis using SQL Server or Oracle.
• Solid understanding of data structures and data modelling, including relational models, normalisation and data mapping.
• Hands-on experience with OutSystems or another low-code platform with a willingness to deepen OutSystems knowledge.
• Practical experience with Microsoft Azure (e.g. Azure SQL, API Management, App Services, Functions, Data Factory).
• Experience in writing requirements, user stories and acceptance criteria, using Jira and Confluence.
• Level of English – Intermediate+ and above.

Nice-to-haves:

• Experience with policy administration platforms such as OneShield, Guidewire or Duck Creek.
• Experience with Oracle PL/SQL.
• Experience in API and integration analysis, including REST, SOAP, XML/JSON and batch file integrations.
• Experience in the UK insurance or Lloyd's market.
• Experience in data migration or reporting (ETL, Power BI).
• Understanding of identity concepts, including Auth0, Okta and OAuth 2.0.
• OutSystems certification.

Reasons why this job would be interesting to you:

• Experience in teamwork with leaders in FinTech, Healthcare, Retail, Telecom, and others. Andersen cooperates with such businesses as Samsung, Siemens, Johnson & Johnson, BNP Paribas, Ryanair, Mercedes, TUI, Verivox, Allianz, T-Systems, etc.
• The opportunity to change the project and/or develop expertise in an interesting business domain.
• Job conditions – you can work both fully remotely and from the office or can choose a hybrid variant.
• Guarantee of professional, financial, and career growth! The company has introduced systems of mentoring and adaptation for each new employee.
• The opportunity to earn up to an additional 1,000 EUR per month, depending on the level of expertise, which will be included in the annual bonus, by participating in the company's activities.
• Access to the corporate training portal, where the entire knowledge base of the company is collected and which is constantly updated.
• Bright corporate life (parties / pizza days / PlayStation / fruits / coffee / snacks / movies).
• Certification compensation (AWS, PMP, etc).
• Referral program.
• Private health insurance and sports compensation, depending on the type of employment.

Your personal data is protected in accordance with GDPR regulations. Learn more: https://andersenlab.com/privacy-policy

Join us!