The Starr Companies Data Engineer interview guide, interview questions, salary data, and interview experiences.

Starr Companies Data Engineer Interview Guide

Getting ready for an Data Engineer interview at Starr Companies? The Starr Companies Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Starr Companies Data Engineer roles.</li>
<li>Gain insights into the Data Engineer interview process at Starr Companies.</li>
<li>Practice real Starr Companies Data Engineer interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Starr Companies Data Engineer interview.


Getting ready for an Data Engineer interview at Starr Companies? The Starr Companies Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Starr Companies Data Engineer roles.
- Gain insights into the Data Engineer interview process at Starr Companies.
- Practice real Starr Companies Data Engineer interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Starr Companies Data Engineer interview.
        

Overview

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Starr Companies Data Engineer Interview Process

You are tasked with keeping track of a customer’s addresses in your database.

However, customer’s addresses change whenever they move. We want to keep track of their moving history as well as the person that moves in afterwards.

How would you create or modify a schema to keep track of these address changes?

Create a schema to keep track of customer address changes

Address Schema

You’re tasked with designing a database system for Swipe Inc., a company that manages payments for software developers. Swipe manages a set of APIs so developers can abstract payment processes for their web service and transfer control over to Swipe’s APIs to manage payment security and finance handling (contacting credit card providers, etc.)

Your database system should store a collection of API keys with their attributes, as shown in the example below:

<pre tabindex="0" class="chroma"><code>{
 &#34;API_key&#34;:{
 &#34;Transaction_list&#34;:{
 &#34;User_ID&#34;:{
 &#34;Name&#34;:{
 &#34;f_name&#34;: 
 &#34;l_name&#34;: 
 }
 &#34;Card_Details&#34;:{
 &#34;Bank&#34;:
 &#34;Card_No&#34;:
 &#34;Expiry&#34;:
 &#34;CV&#34;:
 } 
 }
 }
 &#34;Curr_balance&#34;:
 }
}
</code></pre>

What are the functional and non-functional requirements for this database?

Determine the requirements for designing a database system to store payment APIs

Swipe Payment API

You’re given a dataframe of students named <code>students_df</code>:

<code>students_df</code> table

<table>
<thead>
<tr>
<th>name</th>
<th>age</th>
<th>favorite_color</th>
<th>grade</th>
</tr>
</thead>

<tbody>
<tr>
<td>Tim Voss</td>
<td>19</td>
<td>red</td>
<td>91</td>
</tr>

<tr>
<td>Nicole Johnson</td>
<td>20</td>
<td>yellow</td>
<td>95</td>
</tr>

<tr>
<td>Elsa Williams</td>
<td>21</td>
<td>green</td>
<td>82</td>
</tr>

<tr>
<td>John James</td>
<td>20</td>
<td>blue</td>
<td>75</td>
</tr>

<tr>
<td>Catherine Jones</td>
<td>23</td>
<td>green</td>
<td>93</td>
</tr>
</tbody>
</table>
Write a function named <code>grades_colors</code> to select only the rows where the student’s favorite color is green or red and their grade is above 90.

Example:

Input:

<pre tabindex="0" class="chroma"><code>import pandas as pd

students = {&#34;name&#34; : [&#34;Tim Voss&#34;, &#34;Nicole Johnson&#34;, &#34;Elsa Williams&#34;, &#34;John James&#34;, &#34;Catherine Jones&#34;], &#34;age&#34; : [19, 20, 21, 20, 23], &#34;favorite_color&#34; : [&#34;red&#34;, &#34;yellow&#34;, &#34;green&#34;, &#34;blue&#34;, &#34;green&#34;], &#34;grade&#34; : [91, 95, 82, 75, 93]}

students_df = pd.DataFrame(students)
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def grades_colors(students_df) -&gt;
</code></pre>

<table>
<thead>
<tr>
<th>name</th>
<th>age</th>
<th>favorite_color</th>
<th>grade</th>
</tr>
</thead>

<tbody>
<tr>
<td>Tim Voss</td>
<td>19</td>
<td>red</td>
<td>91</td>
</tr>

<tr>
<td>Catherine Jones</td>
<td>23</td>
<td>green</td>
<td>93</td>
</tr>
</tbody>
</table>

Write a function to select only the rows where the student's favorite color is green or red and their grade is above 90.

Good Grades and Favorite Colors

Starr Companies Data Engineer Interview Questions

Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world.

Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world’s fastest growing insurance organizations, capable of writing in 128 countries on 6 continents.
About Us:
Starr Insurance Holdings is a leading Property and Casualty Insurance company dedicated to providing innovative solutions and exceptional service to our clients. We are seeking a highly skilled and experienced Data Analytics Engineer to join our dynamic team. If you are passionate about solving data problems and building scalable solutions that empower business users to make informed decisions, we want to hear from you.
Position Overview:
As a Data Analytics Engineer, you will play a critical role in:
Designing, developing, and optimizing our data infrastructure and building ETL using SSIS and Azure Synapse Analytics /Azure Data Factory. Building Reports using PowerBI with SQL and DAX. You will work closely with cross-functional teams to ensure data integrity, scalability, and accessibility. Your expertise in Microsoft Business Intelligence tools, cloud technologies, and Tabular Models and ETL processes will be essential in driving our data initiatives forward.
Mandatory Technical Skills:
Expertise in building efficient DAX and SQL queries for the SSRS and PowerBI reports.
Expertise in designing and working with Tabular models.
Expertise in any of ETL tools though SSIS or Azure Data Factory experience is preferable.
Key Responsibilities:
Design, develop and manage ETL processes utilizing SSIS and Azure Synapse Analytics/Azure Data Factory. Build PowerBI and SSRS reports using SQL and DAX queries. Integrate data from various structured and unstructured sources, including databases, APIs, and third-party systems. Perform data integration and transformations with PySpark Notebooks. Develop and execute comprehensive testing strategies to ensure the reliability and accuracy of data pipelines and integrations. Optimize data processing workflows for performance and scalability. Implement and enforce robust data governance policies and best practices. Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and deliver actionable insights. Implement and manage Continuous Integration/Continuous Deployment (CI/CD) pipelines using Azure GIT and Deployment Pipelines to automate and streamline data engineering workflows. Create and maintain comprehensive design documents and technical specifications. Stay up to date with emerging technologies and industry trends to continuously improve data engineering practices.
Minimum Qualifications:
Bachelor's degree in Computer Science, Information Technology, or a related field. 6+ years of experience working with on-prem Microsoft BI tools or cloud data warehousing solutions like Azure Synapse Analytics, Snowflake, Redshift, or BigQuery. Strong experience writing efficient DAX and SQL is a must. Strong understanding of modern data lake architecture, medallion architecture, parquet file, JSON files, etc. Experience with modern data processing frameworks such as Apache Spark, Apache Flink, or similar. Knowledge of data governance, data quality, and data security best practices. Experience in creating backend APIs is a plus. Excellent communication and presentation skills. Strong problem-solving and data analytics skills.
Why Join Us:
Competitive salary and benefits package. Opportunity to work with cutting-edge technologies and innovative projects. Collaborative and inclusive work environment. Professional development and growth opportunities.
Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.
About Us   Starr Insurance is a global insurance and investment organization providing property and casualty insurance solutions to business and industry, and one of the fastest-growing insurance companies in the world. Our talented and experienced associates manage risk and ultimately support the profitable growth of organizations in a dynamic, competitive and ever-changing marketplace. Join us and become part of our talented and passionate workforce.

#J-18808-Ljbffr

Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world.

Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world’s fastest growing insurance organizations, capable of writing in 128 countries on 6 continents.
Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to a diverse range of businesses and industries worldwide. Established in 1919 by Cornelius Vander Starr in Shanghai, China, we have grown to become one of the world’s fastest-growing insurance organizations, operating in 128 countries across six continents. Twin Maples is a brand new division of Starr specializing in the Broker Wholesale space.
Position Overview: The IT Business Analyst will provide extensive business analysis support for building and maintaining Twin Maples Underwriting applications. The candidate will collaborate closely with the Product Owner, Technical Lead, and other IT Business Analysts to contribute to the product strategy on various challenging initiatives. This role requires in-depth analysis of user requirements, creation of Features/User Stories using Agile/Scrum methodologies, development of mockups, data mappings, coordination of integration points, and assistance in testing as needed. Additionally, the candidate will provide maintenance and support for assigned production applications and interact with stakeholders at all levels of the organization, from analysts to senior management across multiple departments.
Key Responsibilities:
Assist business SMEs with requirements definition and write business requirements documents
Conduct in-depth and sophisticated analysis to define problems, develop innovative solutions, and influence strategic functional decisions for complex projects.
Identify and communicate risks and issues, proposing risk mitigation options while considering business implications.
Develop expertise in the functionality, operation, and integration points of the assigned application.
Collaborate with the Product Owner and Technical Lead to identify Epics and Features for Roadmap items.
Work with the Product Owner, Technical Lead, Stakeholders, and Business SMEs to document process flows for functional improvements and enhancements.
Collaborate with Business SMEs during refinement meetings to create user stories with clear acceptance criteria or author business requirements.
Create mockups using tools such as Balsamiq for review with Stakeholders, Business SMEs, and the Delivery team.
Develop data mapping documents to define integrations with external/internal systems.
Troubleshoot 2nd-level production support issues and manage production support tickets in the ticketing system.
Assist in the development of test scenarios, test execution, and test results validation, and support UAT testing.
Assist in the development of training materials.
Learn how to identify and analyze data discrepancies and data quality issues
Learn how to use SQL to query database for testing and analysis
Attend and may lead support meetings for collaboration, reviews and updates, documenting action items and lessons learned
Skills/Experience Required:
5 years of experience working with Agile/Scrum teams for writing user stories and iterative development (sprints).
5 years of experience as a business analyst, IT business systems analyst, insurance data analyst, or similar role.
Broker Wholesale or Commercial Property & Casualty experience is a plus.
Experience with programming/SQL/BI/data reporting tools is a plus
Strong critical thinking and problem-solving skills.
Excellent oral and written communication skills.
Self-motivation and the ability to prioritize tasks and actions to meet deadlines according to business priorities.
Experience handling 2nd-level production support issues.
Proficiency in the use of MS Office products.
Ability to handle multiple tasks and shifting priorities in a fast-paced environment.
#LI-EP1
Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.
Starr Insurance is a global insurance and investment organization providing property and casualty insurance solutions to business and industry, and one of the fastest-growing insurance companies in the world. Our talented and experienced associates manage risk and ultimately support the profitable growth of organizations in a dynamic, competitive and ever-changing marketplace. Join us and become part of our talented and passionate workforce.

#J-18808-Ljbffr

Data Analytics Engineer Starr Insurance Companies Atlanta, United States
Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world.

Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world's fastest growing insurance organizations, capable of writing in 128 countries on 6 continents.

About Us:
Starr Insurance Holdings is a leading Property and Casualty Insurance company dedicated to providing innovative solutions and exceptional service to our clients. We are seeking a highly skilled and experienced Data Analytics Engineer to join our dynamic team. If you are passionate about solving data problems and building scalable solutions that empower business users to make informed decisions, we want to hear from you.

Position Overview:
As a Data Analytics Engineer, you will play a critical role in:

Designing, developing, and optimizing our data infrastructure and building ETL using SSIS and Azure Synapse Analytics /Azure Data Factory. Building Reports using PowerBI with SQL and DAX. You will work closely with cross-functional teams to ensure data integrity, scalability, and accessibility. Your expertise in Microsoft Business Intelligence tools, cloud technologies, and Tabular Models and ETL processes will be essential in driving our data initiatives forward.

Mandatory Technical Skills:
Expertise in building efficient DAX and SQL queries for the SSRS and PowerBI reports.
Expertise in designing and working with Tabular models.
Expertise in any of ETL tools though SSIS or Azure Data Factory experience is preferable.

Key Responsibilities:

Design, develop and manage ETL processes utilizing SSIS and Azure Synapse Analytics/Azure Data Factory. Build PowerBI and SSRS reports using SQL and DAX queries. Integrate data from various structured and unstructured sources, including databases, APIs, and third-party systems. Perform data integration and transformations with PySpark Notebooks. Develop and execute comprehensive testing strategies to ensure the reliability and accuracy of data pipelines and integrations. Optimize data processing workflows for performance and scalability. Implement and enforce robust data governance policies and best practices. Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and deliver actionable insights. Implement and manage Continuous Integration/Continuous Deployment (CI/CD) pipelines using Azure GIT and Deployment Pipelines to automate and streamline data engineering workflows. Create and maintain comprehensive design documents and technical specifications. Stay up to date with emerging technologies and industry trends to continuously improve data engineering practices.

Minimum Qualifications:

Bachelor's degree in Computer Science, Information Technology, or a related field. 6+ years of experience working with on-prem Microsoft BI tools or cloud data warehousing solutions like Azure Synapse Analytics, Snowflake, Redshift, or BigQuery. Strong experience writing efficient DAX and SQL is a must. Strong understanding of modern data lake architecture, medallion architecture, parquet file, JSON files, etc. Experience with modern data processing frameworks such as Apache Spark, Apache Flink, or similar. Knowledge of data governance, data quality, and data security best practices. Experience in creating backend APIs is a plus. Excellent communication and presentation skills. Strong problem-solving and data analytics skills.

Why Join Us:

Competitive salary and benefits package. Opportunity to work with cutting-edge technologies and innovative projects. Collaborative and inclusive work environment. Professional development and growth opportunities.

Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.
More jobs From Starr Insurance Companies
Boost your career Find thousands of job opportunities by signing up to eFinancialCareers today.

#J-18808-Ljbffr

Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world.

Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world’s fastest growing insurance organizations, capable of writing in 128 countries on 6 continents.
The Candidate will be responsible for IT Business Analysis support of the Underwriting & Claims Workflow & Document Management application. The Candidate will work closely with the Product Owner and Senior IT BA to document business requirements and solution workflows into Features and User Stories using Agile/Scrum to support delivery. The Candidate will assist in collaboration with business users, Starr IT developers and vendor implementation teams. The Candidate will also perform testing as needed as well as troubleshooting production issues.
Key Responsibilities:
Develop a good understanding of the functionality and operation of the application
Develop a good understanding of application integration points with other systems
Support the Senior IT BA to drive initiatives forward ensuring timely delivery of project milestones
Work with Business Operations SME’s to gather, analyze and document business requirements into workflows to support solutioning, build mockups, develop/maintain Story Maps and build detailed user stories with clear, testable Acceptance Criteria
Work closely with Senior IT BA to document process flows for functional improvements and enhancements
Support the creation of data mapping documents to define integrations with external / internal systems
Troubleshoot 2nd level production support issues and document root cause and resolutions
Frequently communicate status of tasks and ensuring all deadlines are met
Assist in the development of test scenarios, test execution and test results validation, as needed
Skills/Experience Required:
Minimum5 years’ experience as an IT Business Systems Analyst, Insurance Data Analyst or similar role in the Commercial P&C industry
Minimum 2 years' experience working with Agile / Scrum teams writing user stories and iterative development (sprints)
Team player who takes the initiative when a known gap is present
Excellent oral and written communication skills a must
Experience handling 2nd-level production support issues a plus
Experience with SQL/data reporting tools a must
Proficient in the use of MS Office Tools (Word, Visio)
Experience with ticketing/problem tracking systems
Critical & Design thinking and problem-solving skills a plus
Able and willing to handle multiple tasks and shifting priorities in a fast-paced environment
For individuals assigned and/or hired to work in New York, Starr Insurance Companies is required by law to include a reasonable estimate of the compensation range for this role. The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets: experience and training: licensure and certifications: and other business and organizational needs. A reasonable estimate of the current range is $105,000-$125,000.
#LI-EP1
Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.
About Us   Starr Insurance is a global insurance and investment organization providing property and casualty insurance solutions to business and industry, and one of the fastest-growing insurance companies in the world. Our talented and experienced associates manage risk and ultimately support the profitable growth of organizations in a dynamic, competitive and ever-changing marketplace. Join us and become part of our talented and passionate workforce.

#J-18808-Ljbffr

Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world. Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world's fastest growing insurance organizations, capable of writing in 128 countries on 6 continents. The Senior Data Analyst position will sit within the Reinsurance Business Intelligence group and play a pivotal role in guiding the group in providing data insights to support strategic projects and decision-making. This individual will be responsible for managing and enhancing our reinsurance reporting processes, developing insightful data analytics, and creating interactive dashboards using Power BI. The ideal candidate will have a strong background in reinsurance, data analytics, and process improvement, with a proven ability to translate complex data into actionable insights. Key Responsibilities: Reinsurance Reporting: <ul> <li>Manage and drive the reinsurance reporting process, ensuring accuracy, timeliness, and compliance with regulatory requirements. </li><li>Upgrade and increase flexibility of reinsurance renewal and audit data calls. </li><li>Develop and maintain comprehensive reinsurance reports for internal and external stakeholders. </li><li>Collaborate with reinsurance, finance, and actuarial teams to gather and analyze data for reporting purposes. </li></ul>Data Analytics: <ul> <li>Perform detailed data analysis to identify trends, patterns, and insights that support business decision-making. </li><li>Utilize advanced analytical techniques to interpret complex data sets and provide actionable recommendations. </li><li>Develop predictive models and risk assessments to support reinsurance strategies. </li></ul>Process Improvements: <ul> <li>Identify opportunities for process improvements within the reinsurance reporting and data analytics functions. </li><li>Implement best practices and streamline workflows to enhance efficiency and accuracy. </li><li>Lead initiatives to automate manual processes and reduce operational risks. </li></ul>Dashboard Creation: <ul> <li>Design and develop interactive dashboards using Power BI to visualize key metrics and performance indicators. </li><li>Ensure dashboards are user-friendly, visually appealing, and provide real-time insights to stakeholders. </li><li>Continuously enhance and update dashboards based on user feedback and evolving business needs. </li></ul>Power BI Expertise: <ul> <li>Serve as the subject matter expert for Power BI, providing guidance and support to team members. </li><li>Develop and maintain Power BI reports, datasets, and data models. </li><li>Train and mentor team members on Power BI best practices and advanced functionalities. </li></ul>Project Leadership: <ul> <li>Collaborate with cross-functional teams to identify business needs and translate them into data-driven deliverables and solutions. </li><li>Manage multiple projects simultaneously, ensuring timely delivery and alignment with business goals. </li><li>Assist in the development of business requirements documentation and user acceptance test (UAT) execution. </li><li>Collaborate with IT and data engineering teams to optimize data infrastructure, streamline data workflows, and develop new data pipelines where applicable. </li></ul>Qualifications: <ul> <li>Bachelor's degree in Finance, Accounting, Data Science, Statistics, Economics, Engineering, Mathematics, Computer Science, or a related field. </li><li>3-5 years of experience in reinsurance reporting, data analytics, or a similar role within the insurance industry. </li><li>Minimum of 4 years of experience in data analytics, with experience leading end-to-end projects. </li><li>Proficiency in Power BI, including data modeling. </li><li>Strong proficiency in data analysis tools and programming languages such as SQL, Python, R, etc. </li><li>Extensive experience with data visualization and data presentation using tools such as Power BI, Tableau, Looker, etc. </li><li>Strong analytical skills with the ability to interpret complex data and provide actionable insights. </li><li>Experience with SQL, Excel, and other data analysis tools. </li><li>Excellent communication and presentation skills, with the ability to convey complex information to non-technical stakeholders. </li><li>Strong attention to detail and a commitment to accuracy. </li><li>Proven track record of driving process improvements and implementing best practices. </li><li>Ability to work independently and collaboratively in a fast-paced environment. </li><li>Experience in the insurance industry, with a solid understanding of insurance products, underwriting, claims, and risk management. </li><li>Ability to translate business needs and challenges into technical requirements to work with relevant data engineering and software engineering teams on developing deliverables which make tangible business impact. </li></ul>Preferred Qualifications: <ul> <li>Advanced degree or professional certification (e.g., CPCU, ARe, CFA). </li><li>Experience with other data visualization tools (e.g., Power BI preferred, Tableau, Qlik). </li><li>Knowledge of reinsurance treaties and regulatory requirements. </li></ul> For individuals assigned and/or hired to work in New York, Starr Insurance Companies is required by law to include a reasonable estimate of the compensation range for this role. The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets: experience and training: licensure and certifications: and other business and organizational needs. A reasonable estimate of the current range is $130,000-$150,000. #LI-EP1 Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.

Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world. Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world's fastest growing insurance organizations, capable of writing in 128 countries on 6 continents. Starr Companies is a globally recognized insurance and investment organization with a rich history dating back to 1919. Our commitment to innovation drives us to continuously improve our tools and technologies. We're looking for a Senior Full Stack Software Engineer to play a pivotal role in reshaping our software for underwriters and staff. If you're passionate about creating durable, industry-leading solutions and want to work with a team of dedicated developers, your expertise is needed here. Why Join Starr Companies? At Starr Companies, our software development team pride ourselves on fostering a culture of excellence where merit, innovation, and collaboration are at the forefront. We believe in empowering our employees to grow professionally and contribute to the success of our global mission. Here's what you can expect working with us: <ul> <li>Merit-Based Environment: We are committed to recognizing and rewarding outstanding performance, ensuring that the best ideas and contributions are always given the opportunity to shine. </li><li>Innovative Spirit: Continuous improvement is part of our DNA. We encourage creative problem-solving and the exploration of new technologies to stay ahead in our industry. </li><li>Collaborative Teamwork: Our team is our greatest asset. We work together in a supportive atmosphere that values open communication and perspectives. </li><li>Professional Growth: We invest in our employees through professional development opportunities, training programs, and a culture that promotes career advancement. </li></ul>Day-to-Day Responsibilities: <ul> <li>Design and build intuitive, efficient user interfaces using the latest stable releases of Angular and Blazor WASM. </li><li>Develop, maintain, and deploy stable, scalable, and secure APIs with .NET 8. </li><li>Employ modern design practices with HTML5 and CSS. </li><li>Focus on building and maintaining automated build and release pipelines, enhancing the deployment process in Azure DevOps. </li><li>Engage in active development by fully leveraging a wide range of Azure services and tools, optimizing performance and scalability through native serverless and PaaS Azure resources. </li><li>Work closely with customers and business stakeholders to comprehensively understand their needs and requirements, and ensure that software applications are aligned and developed to meet those needs. </li><li>Collaborate with cross-functional teams, both within IT and the business, to identify and prioritize software development initiatives. </li><li>Effectively communicate development progress and issues to executive leadership. </li></ul>Skills and Experience: <ul> <li>Bachelor's degree in computer science or a related field. </li><li>Extensive professional experience (5+ years) with the Microsoft stack, particularly with .NET (including .NET 6+) and Angular. </li><li>Solid background in MSSQL & NoSQL encompassing database design, maintenance, and optimization. EF (Entity Framework) code first experience is a must. </li><li>Proficiency in JavaScript and front-end frameworks/libraries. </li><li>Proficiency in designing and implementing state-of-the-art APIs, with a focus on modern standards and best practices in API architecture. </li><li>Competence in source control management using Git. </li><li>Proven ability in writing effective unit tests and refining testing practices leveraging nUnit/xUnit. </li><li>A deep understanding of cloud architectures and DevOps practices. </li><li>Strong understanding of software development life cycle, including requirements gathering, design, development, testing, and deployment. </li><li>Knowledge of software development best practices and methodologies. </li><li>Proficiency in leadership and management abilities. </li><li>Strong analytical and problem-solving skills. </li><li>Self-motivated with the capability to prioritize and execute tasks in a high-pressure environment. </li><li>Strong organizational and time management skills. </li><li>Excellent communication and collaboration skills. </li><li>Additional certifications and relevant training are highly valued. </li></ul>Nice-to-Haves: <ul> <li>Experience with designing, developing, and maintaining Blazor WASM applications in a production environment. </li><li>In-depth experience with various Azure services, showcasing a comprehensive understanding of the platform. </li><li>Experience in the insurance industry. </li></ul> #LI-EP1 Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.

Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world. Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world's fastest growing insurance organizations, capable of writing in 128 countries on 6 continents. Starr Companies is seeking a Senior Systems Data Analyst with reinsurance or insurance data expertise in both Premium and Claims, Treaty and Facultative contracts. Knowledge of Reinsurance Accounting data a plus. The ideal candidate will have a minimum of 7 years' experience in data analysis and have worked on a prior data migration. This position will be an addition to the IT area that supports Starr's Reinsurance applications. The analyst will be part of a team of developers / analysts responsible for the design and implementation of a new reinsurance data integration platform and data repository that will support Starr's Global reinsurance transformation initiative. The analyst will work in collaboration with other data analysts, developers, and key business stakeholders both internal and external to ensure system design best practices and data quality. Essential Functions: Data Management & Project Support <ul><li>Use SQL and Excel to identify, analyze and resolve data discrepancies and data quality issues</li><li>Perform data profiling and analysis on reinsurance and enterprise data warehouses</li><li>Document and map ETL transformations to Onboard or enhance data feeds</li></ul><ul><li>Have ability to see downstream implications resulting from change in scope and/or requirements.</li><li>Ensure data standards are reused and enforced across data platforms.</li><li>Maintain system protocols by writing and updating procedures.</li><li>Work closely with internal and external business partners.</li><li>Meet deadlines.</li></ul> Testing and Project Coordination <ul><li>Develop test cases and Perform testing</li><li>Ensure issues are identified, tracked, reported on and resolved in a timely manner.</li><li>Monitor project progress by tracking activity and resolving problems.</li><li>Effectively manage daily tasks to meet key deliverables within the software development lifecycle.</li><li>Use SQL or similar tools to query databases for testing and analysis.</li></ul> Effective Communication and Team Collaboration <ul><li>Understand complex interdependencies</li><li>Ability to capture meeting notes as needed, create and maintain issue logs</li><li>Able to identify and escalate issues appropriately and provide timely progress updates.</li><li>Review designs by other team members and give constructive feedback in meetings or written form when required.</li><li>Follow departmental standard operating procedures, workflow processes and work in a transparent manner.</li></ul> Position Requirements: <ul><li>Bachelor's Degree or equivalent (7+ years data experience), Masters a plus</li><li>Knowledge of Reinsurance and Insurance STRONGLY PREFERRED</li><li>Quick Learner with an excellent memory</li><li>Strong Excel skills - speed and proficiency</li><li>Demonstrated expertise with SQL</li><li>Strong analytical skills, especially data analysis</li><li>Understand data flows, Starr Schema and Relational architecture</li><li>Experienced with ETL transformations & data mapping</li><li>Project Management skills a plus</li><li>Intellectual curiosity and a desire to seek new challenges</li><li>Ability to work autonomously</li></ul> #LI-EP1 Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.

The Data Engineer designs and maintains scalable data pipelines and infrastructure for real-time analytics, ensuring data quality and security. The Data Engineer will collaborate with cross-functional teams, optimize performance, and innovate through automation. Roles and Responsibilities:<ul><li>Build and Optimize Data Pipelines: Analyze and organize raw data from various internal and external sources. Design, develop, and manage scalable, high-performance and resilient data pipelines that process, transform, and make data accessible for real-time analytics and reporting.</li><li>Data Infrastructure Development: Design, build, and maintain data infrastructure to ensure data is reliable, accessible, and secure for various applications and stakeholders. Implement lake-house architecture.</li><li>Data Integration: Analyze business use case, perform data profiling and implement data transformations required for curating raw data into AI/ML and BI ready data.</li><li>Streaming & Batch Processing: Build streaming and batch data pipelines that are reusable, fault-tolerant and scalable.</li><li>Data Quality & Governance: Implement data integrity validations and data quality checks for ensuring accuracy, consistency, and completeness across all datasets.</li><li>Collaboration & Cross-Functional Partnerships: Collaborate with platform engineers, data analysts, platform engineers and business stakeholders to define and implement data requirements and deliver end-to-end solutions.</li><li>Data Warehouse Design: Design, implement, and optimize data lake, data warehouse and data mart to meet analytics and reporting needs. </li><li>Innovation & Automation: Identify opportunities to automate data workflows, streamline processes, and introduce best-in-class tools and frameworks that enhance productivity and efficiency.</li><li>Performance Tuning: Continuously monitor and tune data pipelines and infrastructure for optimal performance, scalability, and cost-efficiency.</li></ul> Required Skills:<ul><li>Experience: 5 to 10 years of experience building and maintaining enterprise-level data applications on distributed systems at scale.</li><li>Programming Skills: Expert proficiency in SQL, Python or similar language for data processing and automation. Experience building semantic processes for distributed data applications.</li><li>Data Pipeline: Experience in building scalable and resilient ELT data pipelines using modern ELT tools like DBT, Azure, Airflow, Fivetran or similar. Knowledge of streaming platforms like Kafka, Spark or similar.</li><li>Data Lake & Warehouse: Experience with cloud-based data platforms like Snowflake. Advanced proficiency with SQL, writing complex queries and optimizing performance. Familiar with dimensional and party data models.</li><li>Data Governance: Knowledge of data governance practices, including RBAC, RLS, data masking, data lineage and compliance with regulatory standards (e.g., GDPR, HIPAA). Experience with data governance tools such as Datahub or Collibra.</li><li>Automation & DevOps: Expertise in CI/CD pipelines with tools such as GitHub Actions, Jenkins, or AWS CodePipeline and containerization (Docker, Kubernetes) to automate and manage data infrastructure. Experience in implementing observability using tools such as Prometheus, Grafana, and AWS CloudWatch. Automated testing frameworks (e.g., JUnit, PyTest).</li></ul>

About the RoleThe Data Engineer plays a key role in shaping and delivering Global Switch’s modern data platform, enabling insights and analytics across a global data centre organisation. Reporting to the Head of Data, this role is central to the development and optimisation of scalable data pipelines and solutions within Microsoft Fabric, supporting the company’s transformation into a data-driven enterprise. This is an exciting opportunity for a technically skilled and business-savvy professional who thrives on building data products that empower decision-making. You’ll work closely with cross-functional teams to understand stakeholder needs and deliver high-quality, cloud-native data solutions that drive value across the organisation. Key Responsibilities<ul><li>Design, develop, and maintain scalable data pipelines within the Modern Data Platform.</li><li>Collaborate with business and technical teams to gather requirements and translate them into effective data products.</li><li>Implement robust data models and ensure data integrity, performance, and reliability.</li><li>Develop and optimise batch and real-time ETL processes from diverse data sources.</li><li>Monitor and troubleshoot data pipelines to ensure efficient data flow.</li><li>Contribute to the development of data engineering best practices and standards.</li><li>Shape and maintain cloud-native data assets to support advanced analytics and AI initiatives.</li></ul> Key Requirements<ul><li>Proven experience as a Data Engineer with a strong grasp of data engineering principles and lifecycle.</li><li>Proficiency in Python, SQL, Spark, and modern data engineering tools.</li><li>Experience with cloud platforms such as Microsoft Azure, Microsoft Fabric, AWS, or Google Cloud.</li><li>Strong understanding of data ingestion, integration, modelling, and consumption.</li><li>Ability to translate business needs into technical solutions with a user-centric mindset.</li><li>Excellent communication and collaboration skills, with a proactive and entrepreneurial approach.</li><li>Degree in Computer Science, Information Technology, or a related field.</li></ul> About Global SwitchYou might not know it, but you use a data centre like Global Switch every day, whether you’re browsing, streaming, gaming, or shopping. Global Switch is a recognised leader in the industry, with more than two decades of experience, dedicated to excellence, innovation, and sustainable operations. We foster a friendly, supportive culture, and offer opportunities for professional growth and development. Joining Global Switch means becoming part of a collaborative team of highly skilled and passionate professionals. As an equal opportunity employer, Global Switch is committed to providing a working culture that values diversity and inclusion and will support reasonable adjustments to ensure a barrier-free recruitment process and working environment.

We're working with a multi-manager hedge fund managing over 10BN, who employs data teams to support trading pods; supporting their strategy development with data driven tools and platform. This data driven ethos requires them to hire a Data Engineering Lead to build infrastructure for new Quant Researchers in multiple pods. Specifically, these engineers will be building pipelines and platforms for quant research data sets. Stack: Python, AWS, S3, ETL, SQL They need an excellent Lead Engineer with a passion for data, and somehow who can partner with investment staff to enable them to maximize the usability of these applications. If you would like to join a high performing tech driven trading firm, and get exposure to world class technologists and traders, then please do apply.

Starr Companies Data Engineer Interview Guide

Overview

Starr Companies Data Engineer Interview Process

Starr Companies Data Engineer Interview Questions

Starr Companies Data Engineer Jobs