Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Senior Staff Data Engineer Hybrid.
United States Jobs Expertini

Urgent! Senior Staff Data Engineer - Hybrid Job Opening In Charlotte – Now Hiring The Hartford

Senior Staff Data Engineer Hybrid



Job description

Sr Staff Data Engineer - GE07DE

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies.

Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too.

Join our team as we help shape the future.

The Enterprise Data Services department’s IT team supporting Global specialty is seeking a hands-on Senior Staff Data Engineer to enhance and support its Data assets on snowflake and SQL server platform.

We are looking for a talented professional with a proven track record of engineering the ELT development and integration using Snowflake.

Our ideal candidate will leverage deep technical expertise and problem-solving skills to deliver invest , maintenance and enhancement projects within the Data & Analytics Value stream.

This role will have a Hybrid work schedule, with the expectation of working in an office location (Hartford, CT; Danbury, CT; Charlotte, NC; Chicago, IL; Columbus, OH) 3 days a week (Tuesday through Thursday).

The Senior Staff Data Engineer will be proficient with data platform architecture, design, data curation, multi-dimensional models, strong understanding of data architecture, principles of ETL and Data Warehousing.

Responsibilities will also include technical delivery review, resolution of architecture issues in AWS Snowflake platform.

Responsibilities:

  • Demonstrate Technical leadership and expertise in Snowflake’s cloud native architecture.

  • Ability to create, troubleshoot, enhance complex code in Snowflake Data Lakes/Data hubs/data warehouses.
  • Experience in building data pipelines(ELT) with Snowflake cloud data platform using AWS compute (EC2) and storage layers (S3).
  • Experience in building the Snowflake SQL Datawarehouse using the Virtual warehouses based on best practices.
  • Hands on experience working withELT tool with Snowflake.

  • Implement and leverage Materialized views, Data Sharing, Clone Feature and Performed Dynamic data Masking.
  • Have a solid understanding of delivery methodology(SDLC) and lead teams in the implementation of the solution according to the design/architecture.
  • Hands on experience with Snow SQL, Stored Procedures, UDF’s using JavaScript, SnowPipe and other snowflake utilities.

  • Experience in Data migration from RDMS to snowflake cloud Datawarehouse.
  • Experience in data security and data access controls and design.

  • Solution the data loading and unloading activities to/from Snowflake.
  • Experience working with Data Lakes loading disparate data sources- Structured, semi-structured data (Flat files, XML, JSON, Parquet) and unstructured data.
  • Experience in building data pipelines using cloud native ELT tools and automation of data ingestion including change data capture (CDC).
  • Integration of data pipelines with source control repository and build CI/CD pipeline and DevOps.
  • Experience in Performance Tuning ofJobs to reduce the CPU time/load timing.
  • Deeper Knowledge on SnowFlake License model and their continuous data protection life cycle.
  • Architect reusable ETL components such as Audit and reconciliation of jobs.

  • Researches and evaluates alternative solutions and recommends the most efficient and cost-effective solution for the systems design.
  • Support and quickly respond to Production issues and requirements clarifications.
  • Coordinate as needed between multiple disciplines such as, Architects, Business Analysts, Scrum Masters, and Developers to get technical clarity leading to design, develop and implementation of business solution.
  • Oversight of quality and completeness of detailed technical specifications, solution designs, and code reviews as well as adherence to the non-functional requirements.
  • Experience in delivering technical solutions in an iterative, agile environment (Scrum/Kanban)
  • Participate as active agile team member to help drive feature refinement, user story completion, code review, etc.
  • Identify, document, and communicate technical risks, issues and alternative technical solutions discovered during project.
  • Collaboration with a high-performing, forward-focused team, Release train engineer, Product Owner(s) and Business stakeholders.
  • Ability to work on innovative and new projects with a fail-fast approach to provide optimal solutions that bring the most value to the business.
  • Passion for learning new skills and the ability to adjust priorities on multiple projects based on changing demands/needs.
  • Qualifications & Key Skills:

  • Candidates must be authorized to work in the US without company sponsorship.

    The company will not support the STEM OPT I-983 Training Plan endorsement for this position.

  • 5+ years in Snowflake data warehousing, data pipelines and automation.
  • 7+ years of hands-on experience in Datawarehouse and Data Integration(ELT/ETL)
  • 7+ years of Proficiency in ETL with Microsoft Business Intelligence and other tools.
  • Strong background and problem-solving skills with Enterprise Data warehouse , ETL/ELT development, Database Replication, metadata management and data quality.
  • Hands-on experience in all phases of SDLC developing ETL solutions using T-SQL code, Stored Procedures, SSIS.
  • Strong data warehouse applications knowledge in preferably in financial/insurance domain is required.
  • Knowledge of version control tools , CI/CD pipeline and DevOps tools like GitHub , Jenkins nexus and uDeploy.
  • Knowledge of Data Profiling, Data Modeling and Database design is key to this role.
  • Preferred Skills:

  • Hands-on experience with Data Visualization (preferably Tableau).
  • Experience in the Insurance industry.
  • Experience with Artificial Intelligence.
  • Experience with Informatica Data management cloud.
  • Experience with Data Governance (Catalog, Quality, Lineage).
  • Compensation

    The listed annualized base pay range is primarily based on analysis of similar positions in the external market.

    Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role.

    The base pay is just one component of The Hartford’s total compensation package for employees.

    Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition.

    The annualized base pay range for this role is:

    $135,040 - $202,560

    Equal Opportunity Employer/Sex/Race/Color/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

    About Us | Our Culture | What It’s Like to Work Here | Perks & Benefits


    Required Skill Profession

    Computer Occupations



    Your Complete Job Search Toolkit

    ✨ Smart • Intelligent • Private • Secure

    Start Using Our Tools

    Join thousands of professionals who've advanced their careers with our platform

    Rate or Report This Job
    If you feel this job is inaccurate or spam kindly report to us using below form.
    Please Note: This is NOT a job application form.


      Unlock Your Senior Staff Potential: Insight & Career Growth Guide


    • Real-time Senior Staff Jobs Trends in Charlotte, United States (Graphical Representation)

      Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Senior Staff in Charlotte, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 212924 jobs in United States and 2407 jobs in Charlotte. This comprehensive analysis highlights market share and opportunities for professionals in Senior Staff roles. These dynamic trends provide a better understanding of the job market landscape in these regions.

    • Are You Looking for Senior Staff Data Engineer Hybrid Job?

      Great news! is currently hiring and seeking a Senior Staff Data Engineer Hybrid to join their team. Feel free to download the job details.

      Wait no longer! Are you also interested in exploring similar jobs? Search now: .

    • The Work Culture

      An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at The Hartford adheres to the cultural norms as outlined by Expertini.

      The fundamental ethical values are:
      • 1. Independence
      • 2. Loyalty
      • 3. Impartiality
      • 4. Integrity
      • 5. Accountability
      • 6. Respect for human rights
      • 7. Obeying United States laws and regulations
    • What Is the Average Salary Range for Senior Staff Data Engineer Hybrid Positions?

      The average salary range for a varies, but the pay scale is rated "Standard" in Charlotte. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

    • What Are the Key Qualifications for Senior Staff Data Engineer Hybrid?

      Key qualifications for Senior Staff Data Engineer Hybrid typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.

    • How Can I Improve My Chances of Getting Hired for Senior Staff Data Engineer Hybrid?

      To improve your chances of getting hired for Senior Staff Data Engineer Hybrid, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

    • Interview Tips for Senior Staff Data Engineer Hybrid Job Success
      The Hartford interview tips for Senior Staff Data Engineer   Hybrid

      Here are some tips to help you prepare for and ace your job interview:

      Before the Interview:
      • Research: Learn about the The Hartford's mission, values, products, and the specific job requirements and get further information about
      • Other Openings
      • Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.
      • Dress Professionally: Choose attire appropriate for the company culture.
      • Prepare Questions: Show your interest by having thoughtful questions for the interviewer.
      • Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.
      During the Interview:
      • Be Punctual: Arrive on time to demonstrate professionalism and respect.
      • Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.
      • Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.
      • Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.
      • Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.
      • Follow Up: Send a thank-you email to the interviewer within 24 hours.
      Additional Tips:
      • Be Yourself: Let your personality shine through while maintaining professionalism.
      • Be Honest: Don't exaggerate your skills or experience.
      • Be Positive: Focus on your strengths and accomplishments.
      • Body Language: Maintain good posture, avoid fidgeting, and make eye contact.
      • Turn Off Phone: Avoid distractions during the interview.
      Final Thought:

      To prepare for your Senior Staff Data Engineer Hybrid interview at The Hartford, research the company, understand the job requirements, and practice common interview questions.

      Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the The Hartford's products or services and be prepared to discuss how you can contribute to their success.

      By following these tips, you can increase your chances of making a positive impression and landing the job!

    • How to Set Up Job Alerts for Senior Staff Data Engineer Hybrid Positions

      Setting up job alerts for Senior Staff Data Engineer Hybrid is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!