Student Veterans of America Jobs

Welcome to SVA’s jobs portal, your one-stop shop for finding the most up to date source of employment opportunities. We have partnered with the National Labor Exchange to provide you this information. You may be looking for part-time employment to supplement your income while you are in school. You might be looking for an internship to add experience to your resume. And you may be completing your training ready to start a new career. This site has all of those types of jobs.

Here are a few things you should know:
  • This site is mobile friendly. You do not need a log-in or password to access information.
  • Jobs on this site are original and unduplicated and come from three sources: the Federal government, state workforce agency job banks, and corporate career websites. All jobs are vetted to ensure there are no scams, training schemes, or phishing.
  • The site is refreshed daily to remove out-of-date content.
  • The newest jobs are listed first, so use the search features to match your interests. You can look for jobs in a specific geographical location, by title or keyword, or you can use the military crosswalk. You may want to do something different from your military career, but you undoubtedly have skills from that occupation that match to a civilian job.

Job Information

The Hartford Senior Staff Data Engineer - Hybrid in Frisco, Texas

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 Hartford's Global Specialty IT team 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.

Role Description

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.

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

Responsibilities:

  • Demonstrate expertise in Snowflake’s cloud native architecture and Microsoft SQL server technology.

  • Ability to create, troubleshoot, enhance complex code in Snowflake and SQL server.

  • 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 Data warehouse using the Virtual warehouses based on best practices.

  • Hands on experience working with Talend or SSIS as an ELT tool with Snowflake and SQL server Data Integration.

  • 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 Data warehouse.

  • 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 Talend 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 of Talend / SQL Agent Jobs to reduce the CPU time/load timing.

  • Deeper Knowledge on SnowFlake License model and their continuous data protection life cycle.

  • Architect reusable Talend 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.

  • I dentify, 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:

  • Bachelor’s degree

  • 5+ years in Snowflake in AWS and Talend Data Integrator or other BI/ETL tools.

  • 7+ years of hands-on experience in Data warehouse and Data Integration (ELT/ETL)

  • 7+ years of Proficiency in ETL with Microsoft Business Intelligence (SSIS, SSRS) and other tools.

  • 2+ years of hands-on experience with Data Visualization (preferably Tableau).

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

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

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:

$132,400 - $198,600

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us (https://www.thehartford.com/about-us) | Culture & Employee Insights (https://www.thehartford.com/careers/employee-stories) | Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity) | Benefits (https://www.thehartford.com/careers/benefits)

Human achievement is at the heart of what we do.

We believe that with the right encouragement and support, people are capable of achieving amazing things.

We put our belief into action by ensuring individuals and businesses are well protected, and by going even further – making an impact in ways that go beyond an insurance policy.

Nearly 19,000 employees use their unique talents in careers that span a variety of disciplines – from developing the latest technology to creating and promoting our products to evaluating future financial risks.

We’re also committed to programs that drive education and support volunteerism, which put human beings first. We do it because it’s the right thing to do, and because when our customers, communities and employees succeed, we all do.

About Us (https://www.thehartford.com/about-us)

Culture & Employee Insights

Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity)

Benefits

Legal Notice (https://www.thehartford.com/legal-notice)

Accessibility StatementProducer Compensation (https://www.thehartford.com/producer-compensation) EEO

Privacy Policy (https://www.thehartford.com/online-privacy-policy)

California Privacy Policy

Your California Privacy Choices (https://www.thehartford.com/data-privacy-opt-out-form)

International Privacy Policy

Canadian Privacy Policy (https://www.thehartford.com/canadian-privacy-policy)

DirectEmployers