Jobs
>
San Diego

    Sr Data Warehouse Architect - San Diego, United States - Generali Global Assistance

    Generali Global Assistance
    Generali Global Assistance San Diego, United States

    2 weeks ago

    Default job background
    Description
    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 environmentFlexible work schedulesCompany match on 401(k)

    Competitive Paid Time Off policyGenerous Employer contribution for health, dental and vision insuranceCompany paid short term and long term disability insurancePaid Maternity and Paternity LeaveTuition reimbursementCompany-paid life insuranceEmployee Assistance ProgramWellness programsFun employee and company eventsDiscounts on travel insuranceSalary Range:
    $140, $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 hereTrip 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 technologiesBuilding 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 upExperience with an event streaming platform such as KafkaExperience working with the AWS cloud infrastructure and services such as S3Experience 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 ScienceEducation/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:

    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.
    #J-18808-Ljbffr
  • NextGen Leads, LLC

    Data Warehouse Architect

    5 days ago

    NextGen Leads, LLC San Diego, United States

    **Data Warehouse Architect** · Development San Diego, California Minimum Experience **Mid-level** Compensation **$125,000 / Yearly** PURPOSE · NextGen Leads wants to build a new data warehouse solution in order to give our sales, marketing, and executive teams the ability to le ...

  • Customized Services Administrators, Inc.

    Sr Data Warehouse Architect

    1 day ago

    Customized Services Administrators, Inc. San Diego, United States

    Job Description · Job Description · 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 ourselve ...

  • GMMI Inc.

    Sr Data Warehouse Architect

    5 days ago

    GMMI Inc. San Diego, United States

    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 ...

  • Customized Services Administrators, Inc.

    Sr Data Warehouse Architect

    1 week ago

    Customized Services Administrators, Inc. San Diego, United States

    Job Description · Job DescriptionWhy 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 wit ...

  • TribolaTech Inc

    Enterprise Data Warehouse Architect- Banking Domain

    2 hours ago

    TribolaTech Inc San Diego, United States

    Job Title: EDW Architect · Location: San Diego · Client Bank · Can be remote but requires travel to Office occasionally. · US citizens/ GC holders only · Looking for 15+ years of experience in data architecture, data modeling, and data management within the banking or financial s ...

  • C | An Executive Search Firm

    Project Manager

    3 days ago

    C | An Executive Search Firm San Diego, United States

    **THE FIRM**: · My client is a well-known and entirely employee-owned California based commercial general contractor currently listed on California's top ENR ranking commercial contractors list as well as a top ranking U.S. ENR commercial contractor. The firm holds a very high re ...

  • Insight Global

    Data Architect

    5 days ago

    Insight Global San Diego, United States

    An employer in Mexico is looking for a Senior Data Architect. This person will be joining the Enterprise Data Architecture and Platform vertical and will be part of a team that is essential in defining and delivering the Data and Analytics based insights that can be leveraged by ...

  • BRAIN CORP

    Staff Software Engineer

    1 week ago

    BRAIN CORP San Diego, United States

    We are Brain Corp and we enable smarter operations. We set out to create the most intelligent tools ever, and now we power the world's largest fleet of robots operating in commercial public spaces. By injecting intelligence into our customers' operations, we transform manual oper ...

  • Spectraforce Technologies

    Database Architect

    1 week ago

    Spectraforce Technologies San Diego, United States

    Job Title: Database Architect · Location: San Diego, CA · Duration: 5 months · Interview: 2 video and one onsite. · Job Description: · Principal Duties and Responsibilities: Leverages advanced Software knowledge and experience to design, develop, create, modify, and validate embe ...

  • RIT Solutions, Inc.

    Healthcare MDM Data Architect

    2 weeks ago

    RIT Solutions, Inc. San Diego, United States

    Must be based in PST zone · Must have a valid LinkedIn profile · Duration: 12+ months · Data Architect to be part of the growing Enterprise Data team. This person will collaborate with practice stakeholders to translate their data-information-knowledge requirements into data sol ...

  • K2 Staffing, LLC

    Sr. Estimator

    1 week ago

    K2 Staffing, LLC San Diego, United States

    Summary · Our client is a leading commercial GC in California and Washington and they are seeking an · Commercial ConstructionEstimator . An Estimator by trade prepares/coordinates preparation of full estimates on conceptual or large work. This individual will providecomplete c ...

  • Spectraforce Technologies

    Database Architect

    2 weeks ago

    Spectraforce Technologies San Diego, United States

    Job Title: Database Architect · Location: San Diego, CA · Duration: 5 months · Interview: 2 video and one onsite. · Job Description: · Principal Duties and Responsibilities:Leverages advanced Software knowledge and experience to design, develop, create, modify, and validate embed ...

  • Yoh, A Day & Zimmermann Company

    Senior Database Administrator

    1 week ago

    Yoh, A Day & Zimmermann Company San Diego, United States

    Yoh has an exciting opportunity as a Sr. DBA, Specializing in database infrastructure analysis within Public/Private Cloud and Virtualization environments. This role will design and maintain the stable operation of enterprise database infrastructure and systems, provide weekly, m ...

  • Booz Allen Hamilton

    Data Engineer, Mid with Security Clearance

    1 week ago

    Booz Allen Hamilton San Diego, United States

    Job Number: R Data Engineer, Mid The Opportunity: Do you want to work at the forefront of advanced te chn ology and solve complex data challenges? You know that data yields pivotal insights when it's gathered from disparate sources and organized. As a data engineer, you have the ...

  • Booz Allen Hamilton

    Data Engineer, Mid with Security Clearance

    1 week ago

    Booz Allen Hamilton San Diego, United States

    Job Number: R Data Engineer, Mid The Opportunity: Do you want to work at the forefront of advanced te chn ology and solve complex data challenges? You know that data yields pivotal insights when it's gathered from disparate sources and organized. As a data engineer, you have the ...

  • C | An Executive Search Firm

    Project Manager

    1 week ago

    C | An Executive Search Firm San Diego, United States

    ABOUT THE FIRM: · My client is a well-known and entirely employee-owned California based commercial general contractor currently listed on California's top ENR ranking commercial contractors list as well as a top ranking U.S. ENR commercial contractor. The firm holds a very high ...

  • Booz Allen Hamilton

    Data Engineer, Mid with Security Clearance

    1 week ago

    Booz Allen Hamilton San Diego, United States

    Job Number: R Data Engineer, Mid The Opportunity: Do you want to work at the forefront of advanced te chn ology and solve complex data challenges? You know that data yields pivotal insights when it's gathered from disparate sources and organized. As a data engineer, you have the ...

  • Spectraforce Technologies

    Database Architect

    2 weeks ago

    Spectraforce Technologies San Diego, United States

    Job Title: Database Architect · Location: San Diego, CA · Duration: 5 months · Interview: 2 video and one onsite. · Job Description: · Principal Duties and Responsibilities: · Leverages advanced Software knowledge and experience to design, develop, create, modify, and valid ...

  • Gunderson Dettmer

    Data Engineer

    3 days ago

    Gunderson Dettmer San Diego, United States

    Job Description · Job DescriptionGunderson Dettmer is the only business law firm of its kind - exclusively serving the global venture capital and emerging technology marketplace. With 400 attorneys in eleven offices - from Silicon Valley to Singapore - we innovate for innovators, ...

  • C | An Executive Search Firm

    Senior Project Manager

    2 weeks ago

    C | An Executive Search Firm San Diego, United States

    THE FIRM: · My client is a well-known and entirely employee-owned California based commercial general contractor currently listed on California's top ENR ranking commercial contractors list as well as a top ranking U.S. ENR commercial contractor. The firm holds a very high reput ...