Jobs
>
Atlanta

    Sr Data Warehouse Engineer - Atlanta, United States - AssuranceAmerica

    Default job background
    Description

    JOIN THE ASSURANCEAMERICA TEAM

    Do you want to be part of an organization where you are valued, and your ideas and opinions have an impact? Join the AssuranceAmerica team.

    For more than 25 years, AssuranceAmerica has provided superior property and casualty insurance products through contracted independent agents and directly to customers.

    Our team succeeds through diversity of thought, experiences, skills, and backgrounds.

    Senior Data Warehouse Engineer

    AssuranceAmerica is seeking a Sr Data Warehouse Engineer to join our growing ranks as we continue to transform the way technology impacts the insurance business. You will work with a small team of experienced IT professionals and interface directly with stakeholders to understand their challenges and develop solutions. This individual will play a key role in transforming our legacy data warehouse into a modern cloud-based (Azure) solution. Your daily contributions will have direct, positive impacts on our employees, agents, and customers.

    AssuranceAmerica will not consider international applicants requiring employer sponsorship.

    About the ROLE

    Each day at AssuranceAmerica is different, but as a Sr Data Warehouse Engineer in Information Technology, you will:

    • Provide technical leadership in design and engineering for the modernization of legacy Data Ingestion, ETL/ELT and OLAP cubes to new technologies in Azure.

    • Lead multidisciplinary projects or initiatives.

    • Have a strong understanding of Enterprise Data warehouse data models and dimensional modeling concepts, source to target mapping and Data pipeline architectures.

    • Serve as technical expert on data warehouse development projects. Participate in full development life cycle including requirements analysis and design.

    • Be a key participant in Data Strategy vision and planning.

    • Manage break/fix events and drive solutions to correct and prevent recurring issues.

    • Respond to user needs for ad hoc queries using T-SQL, and institutional reports using SSRS, Power BI and refreshable Excel Pivot tables.

    • Proactively communicate directly with business representatives to extract requirements and review work in progress.

    • Communicate data warehouse related issues, changes and outages to department manager and end-user community.

    • Recommend standards, procedures, and policies that help both the internal group as well as other operations and customer groups.

    • Demonstrate a proactive and self-motivated approach to learning new technologies and techniques to enhance development skills.

    Requirements

    About YOU

    • Detail-oriented

    • Thrives in a fast-paced environment

    • Creative, driven and motivated problem solver

    • Well-developed critical thinking skills

    • Enjoys working with data

    • Can communicate complex concepts and procedures to associates at all levels

    • Ability to form strong relationships and work collaboratively

    • Propensity to learn new technologies

    • Good oral and written communications skills

    Required

    • Requires a 4-year degree in computer science or a related technical area.

    • 8+ years of experience as a SQL / Data Warehouse Developer in a SQL Server environment.

    • Minimum of 3+ years of experience designing, scaling, and/or implementing data warehouse and analytics solutions in Azure.

    • Strong T-SQL skills and the ability to performance tune SQL queries.

    Preferred

    • Relevant certifications

    • Auto insurance experience

    Physical Requirements

    • Prolonged periods sitting at a desk and working on a computer

    • Must be able to lift 15 pounds at times

    • May be required to work on-call, evenings or weekends

    Benefits

    About US

    • We are direct, results-driven, and dedicated to the success of our business and each other

    • We are a diverse group of thinkers and doers

    • We offer many opportunities to grow in your professional skills and career

    • We fight homelessness by directing 5% of our earnings from each policy we sell to organizations that help those in need. We call it our Generous Policy.

    WHAT WE OFFER

    • AssuranceAmerica provides these benefits to Associates:
    o Premium healthcare plans: All full-time Associates and part-time Associates working a regular schedule of 30 hours, or more, are eligible for benefits day one, including Medical, Dental, Vision, Voluntary Life, Flexible Spending Accounts, and a Health Savings Account.
    o Employer Paid Benefits: We enroll all eligible Associates in Group Life and AD&D Insurance, Short- and Long-Term Disability Plans, Employee Assistance Program, Travel Assist, and the Benefit Resource Card which includes TeladocTM, Pet Insurance and Health Advocate.

    • Additional Benefits:
    o 401(k) Employer Match: We want to help you prepare for the future, now. All full-time and part-time Associates over age 21 are eligible to participate in the 401(k) Savings Plan. AssuranceAmerica will match 100% of the first 4% of an Associate's contributions.
    o Engagement Events. We make time for fun activities that strengthen Associate relationships in all our locations.
    o Annual Learning Credit: Want to learn something new? We'll reimburse you for approved educational assistance, up to $5,250 annually.

    • Time Off:
    o Paid Time Off (PTO), Parental Leave Pay, Volunteer Time Off (VTO), Bereavement Pay, Military Leave Pay, and Jury Duty Pay.

    This job description indicates the essential responsibilities of the job. The duties described are not to be interpreted as being all-inclusive to any specific associate. Management reserves the right to add to, modify, or change the work assignments of the position as business needs dictate. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job. This job description does not represent a contract of employment. Employment with AssuranceAmerica is at-will. The at-will relationship can be terminated at any time, with or without reason or notice by either the employer or the associate.

    AssuranceAmerica is an Equal Opportunity Employer


  • Genuine Parts Company Atlanta, United States

    Company Background: · Genuine Parts Company ("GPC" or the "Company"), founded in 1928 and based in Atlanta, Georgia, is a leading distributor of automotive and industrial replacement parts and value-added services. The Company operates a global portfolio of businesses with more ...


  • Innovate Atlanta, United States

    Principal Control Systems Engineer · We are working with a leading intralogistics and warehouse automation company on the rise. the client just secured a series of major contracts for warehouse automation projects across the Eastern United States, and we're seeking a talented Pr ...


  • GXO Logistics Atlanta, United States

    Logistics at full potential. · At GXO, we're constantly looking for talented individuals at all levelswho can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our ...


  • GXO Logistics Corporate Services, Inc. Atlanta, United States

    Logistics at full potential. · At GXO, we're constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our ...


  • Credit Acceptance Atlanta, United States

    Credit Acceptance is proud to be an award-winning company with local and national workplace recognition in multiple categories Our world-class culture is shaped by dedicated Team Members who share a drive to succeed as professionals and together as a company. A great product, ama ...


  • Credit Acceptance Atlanta, United States

    Credit Acceptance is proud to be an award-winning company with local and national workplace recognition in multiple categories Our world-class culture is shaped by dedicated Team Members who share a drive to succeed as professionals and together as a company. A great product, ama ...


  • Credit Acceptance Atlanta, United States

    Credit Acceptance is proud to be an award-winning company with local and national workplace recognition in multiple categories Our world-class culture is shaped by dedicated Team Members who share a drive to succeed as professionals and together as a company. A great product, ama ...


  • The Timken Company Fulton, United States

    Personal and Professional Growth · Material Coordinator-Press · - Fulton, IL, US, 61252**What Timken makes possible begins with you.** · Those who came before us helped land a man on the moon, create the world's infrastructure, and introduce renewable energy alternatives. Now you ...


  • PRICE WATERHOUSE COOPERS Atlanta, United States

    A career within Functional and Industry Technologies services will provide you with the opportunity to build secure and new digital experiences for customers, employees, and suppliers. We focus on improving apps or developing new apps for traditional and mobile devices as well as ...


  • Kanaan Communications Whitehall, United States

    Overview and Essential Functions: · **Kanaan Communications, LLC** is currently seeking a Warehouse Technician · **Responsibilities**: · - Scan equipment for daily routes · - Quarterly material audit or as per customer requirements · - Weekly equipment audit and reconciliation wi ...


  • SilverTech Centennial Park, United States

    Are you finished with school and have a degree in hand? Finally, you can take the first step towards your professional future. Where? Of course, with us. Start your apprenticeship in a familiar environment where you can develop and use your interests, talents, and skills. The Ric ...


  • ITTConnect Atlanta, United States

    ITTConnect is seeking a Senior Data Architect to work for a client in the Atlanta area. This is a position with a client that is a global leader in consulting, digital transformation, technology and engineering services present in nearly 50 countries. The end client is in the tel ...


  • GXO Logistics Forest Park, United States

    Logistics at full potential. At GXO, we're constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our te ...


  • GXO Logistics, Inc. Forest Park, United States

    Logistics at full potential. · At GXO, we're constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On ou ...


  • GXO Logistics, Inc. Forest Park, United States

    Logistics at full potential. At GXO, we're constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our te ...


  • GXO Logistics Forest Park, United States

    Logistics at full potential. At GXO, we're constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our te ...


  • GXO Logistics Forest Park, United States

    Logistics at full potential. · At GXO, we're constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our ...


  • GXO Logistics Forest Park, United States

    Logistics at full potential. At GXO, we're constantly looking for talented individuals at all levelswho can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our tea ...


  • GXO Forest Park, United States

    Logistics at full potential. · At GXO, we're constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our ...


  • GXO Logistics Forest Park, United States

    Logistics at full potential. · At GXO, we're constantly looking for talented individuals at all levelswho can deliver the caliber of service our company requires. You know that a positive work environment creates happy employees, which boosts productivity and dedication. On our ...