Sr Data Warehouse Architect

San Diego, CA, United States

Why work with us?

The North American branch of Generali Global Assistance offers a diverse and inclusive work environment while employees work towards making real difference in the lives of our clients. As an Organization, we pride ourselves with offering white glove service while being mindful of corporate responsibility and our environmental footprint.

Employees enjoy a plethora of benefits to include:

A diverse, inclusive, professional work environment

Flexible work schedules

Company match on 401(k)

Competitive Paid Time Off policy

Generous Employer contribution for health, dental and vision insurance

Company paid short term and long term disability insurance

Paid Maternity and Paternity Leave

Tuition reimbursement

Company-paid life insurance

Employee Assistance Program

Wellness programs

Fun employee and company events

Discounts on travel insurance

Salary Range: $140,000.00 - $170,000.00

* No H1B Sponsorships Available. No C2C OR Contract Work.

Who are we?

Generali Global Assistance is proudly part of the Europ Assistance Group brand and our products utilize a number of corporate and product brands. The brands for our North American team include the following: CSA: US travel insurance brand for retail and lodging partners. Learn more here.

Generali Global Assistance (GGA): The primary Corporate brand in the United States for our travel insurance, travel assistance, identity and cyber protection, and beneficiary companion products. Learn more here.

GMMI is the industry standard for global medical cost containment and risk management solutions. Learn more here.

Iris, Powered by Generali: identity and digital protection solution. Learn more here.

Trip Mate: US travel insurance brand for tour operators, cruise, and airline partners. Learn more here.

Job Summary :

Generali Global Assistance (GGA) is a travel insurance administration company committed to becoming the US's leading travel insurance provider while utilizing data driven methodologies to guide our success and growth. We are looking for a skilled and innovative Data Warehouse Architect to join our team and lead the design, development, and maintenance of our data warehousing solutions.

The Data Warehouse Architect will be responsible for overseeing the design and implementation of our data warehouse architecture. You will collaborate with cross-functional teams to understand business requirements, define data models, and ensure efficient data storage, retrieval, and analysis. This position collaborates heavily with our other organizations across the globe defining standardized data models, architecture, and practices.

Principal Duties and Responsibilities : Design, develop, and maintain scalable and efficient data warehouse solutions to meet business needs and analytical requirements.

Play a foundational role in building a data driven culture.

Partner with Product, Actuarial and Operations Teams to help drive insights, identify opportunities, and understand behavior and long-term trends.

Take a leading role in producing new datasets that unlock business opportunities.

Collaborate with stakeholders to understand data requirements and translate them into technical specifications and data models.

Define data integration strategies and methodologies to ensure seamless data flow from various sources into the data warehouse.

Implement and manage ETL (Extract, Transform, Load) processes for data extraction, transformation, and loading into the data warehouse.

Optimize data warehouse performance through tuning, indexing, and other optimization techniques.

Establish and enforce data governance policies, ensuring data quality, consistency, and security.

Stay updated with emerging technologies and industry best practices in data warehousing and analytics.

The Data Warehouse Architect will work with various stakeholders to create optimized queries and reports that can be used to gain valuable business insights.

Researching and recommending the use of various data warehouse technologies

Building a new Data Lake and Data Warehouse solution utilizing the recommended technologies.

Implementing strong data governance practices within the Data Warehouse environment.

Required / Desired Knowledge, Experiences and Skills : 5+ years of proven experience as a Data Warehouse Architect, Data Engineer, or in a similar role.

Strong proficiency in data warehousing concepts, methodologies, and best practices.

You possess a natural curiosity and strive to uncover the deeper relationships that are not always immediately discoverable.

You have experience writing and optimizing complex SQL queries for large data sets and are familiar with a scientific programming language, such as R or Python.

Expertise in designing and implementing data warehouse solutions using tools like SQL Server, Oracle, Snowflake, or similar platforms.

Experience building a data warehouse solution from the ground up

Experience with an event streaming platform such as Kafka

Experience working with the AWS cloud infrastructure and services such as S3

Experience working with big data technologies.

Hands-on experience with ETL tools and processes.

Experience with SQL Analysis Services.

Experience using Talend.

Working knowledge of data modeling, data governance, and data security principles.

Strong analytical and problem-solving skills.

Excellent communication and collaboration abilities to work effectively with cross-functional teams.

Experience with cloud-based data warehouse solutions (e.g., AWS Redshift, Azure Synapse Analytics, Talend).

Nice to have : Knowledge of Amazon DynamoDB.

Knowledge of Data Science

Education/Certifications : Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.

Relevant certifications in data management or data warehousing (e.g., Microsoft Certified: Azure Data Engineer, AWS Certified Big Data - Specialty) is a plus.

Where you'll be doing it.

100% Remote Role. Preferred residence for candidates would be San Diego, CA, or Pembroke Pines, FL

Apply today to begin your next chapter .

Don't meet every single requirement? At Generali Global Assistance, we are dedicated to building a diverse, inclusive and enriching workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

California Residents - Privacy Notice for California Residents Seeking Employment with Generali Global Assistance is available here: https://us.generaliglobalassistance.com/privacy-notice-for-california-residents-seeking-employment/

The Company is committed to providing equal employment opportunity in all our employment programs and decisions. Discrimination in employment on the basis of any classification protected under federal, state, or local law is a violation of our policy. Equal employment opportunity is provided to all employees and applicants for employment without regard age, race, color, religion, creed, sex, gender identity, gender expression, transgender status, pregnancy, childbirth, medical conditions related to pregnancy or childbirth, sexual orientation, national origin, ancestry, ethnicity, citizenship, genetic information, marital status, military status, HIV/AIDS status, mental or physical disability, use of a guide or support animal because of blindness, deafness, or physical handicap, or any other legally protected basis under applicable federal, state, or local law. This policy applies to all terms and conditions of employment, including, but not limited to, recruitment and hiring, classification, placement, promotion, termination, reductions in force, recall, transfer, leaves of absences, compensation, and training. Any employees with questions or concerns about equal employment opportunities in the workplace are encouraged to bring these issues to the attention of Human Resources. The Company will not allow any form of retaliation against individuals who raise issues of equal employment opportunity. All Company employees are responsible for complying with the Company's Equal Opportunity Policy. Every employee is to treat all other employees equally and fairly. Violations of this policy may subject an employee to disciplinary action, up to and including termination of employment.