What are the responsibilities and job description for the Data Engineer - Hybrid position at A-G Specialty Insurance?
A-G Specialty Insurance, LLC designs, markets, and underwrites specialty sports, accident, and general liability insurance products. We have been in operation since 1983 and are nationally recognized as a leader in the sports insurance industry.
Job Summary
The Data Engineer (DE) will be responsible for supporting data operations, including development and maintenance of data ETL processes, analysis and integration of new data sources, and distribution of business data by various means. The DE will be expected to be self-driven and highly attentive to detail. This role will work very closely with the rest of the IT team on all projects and will regularly collaborate with non-technical personnel.
Essential Duties & Functions
Reasonable accommodations may be made to enable individuals to perform the essential functions.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Required/Preferred Education And Experience
Required Education: Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field, or the equivalent combination of education, technical certifications, or work experience.
Preferred Experience: 3 years of experience in data engineering, business intelligence, and/or data analysis.
Work Environment
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and scanners.
Position Type and Expected Hours of Work
This is a full-time, hybrid position. The employee would need to be in the Berwyn office 2-3 days per week. Days and hours of work are Monday through Friday, 8:30 a.m. to 5 p.m. The schedule for this role can be modified upon Supervisor and Human Resources approval. Some evening and weekend work may be required. Trainings and team meetings may require coming into the office.
Travel
No travel is expected for this position.
EEO Statement
A-G is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation based on the following protected classes: age (40 and older), race, color, national origin, ancestry, religion, sex, sexual orientation (including transgender status, gender identity or expression), pregnancy (including childbirth, lactation, and related medical conditions), physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed servicemember status, or any other status protected by federal, state, or local laws. A-G is dedicated to the fulfillment of this policy in regard to all aspects of employment, including, but not limited to, recruiting, hiring, placement, transfer, training, promotion, rates of pay, other compensation, termination, and all other terms, conditions, and privileges of employment. A-G will conduct a prompt and thorough investigation of all allegations of discrimination, harassment, or retaliation, or any violation of the Equal Employment Opportunity Policy in a confidential manner. A-G will take appropriate corrective action, if and where warranted. A-G prohibits retaliation against team members who provide information about, complain about, or assist in the investigation of any complaint of discrimination or violation of the Equal Employment Opportunity Policy.
Job Summary
The Data Engineer (DE) will be responsible for supporting data operations, including development and maintenance of data ETL processes, analysis and integration of new data sources, and distribution of business data by various means. The DE will be expected to be self-driven and highly attentive to detail. This role will work very closely with the rest of the IT team on all projects and will regularly collaborate with non-technical personnel.
Essential Duties & Functions
Reasonable accommodations may be made to enable individuals to perform the essential functions.
- Support processes that preserve the structure, cleanliness, and security of data as it moves into and out of internal systems
- Provide support for ad hoc data operations requests
- Collaborate with internal and external users to define requirements and expectations
- Support the continuous improvement of internal systems
- Structure and analyze operational data for actionable insights
- Be an advocate for sensible management of workload while adapting to changing priorities
- Contribute to a departmental culture of “I don’t know, but I can find out for you”
- Effective communication skills
- Ability to collaborate with diverse stakeholders in a team-oriented environment
- Excellent time management skills with the ability to work in a fast-paced environment with tight deadlines
- Highly detail oriented
- Excellent problem-solving and troubleshooting skills, with a focus on delivering high-quality solutions
- Experience with creation and interpretation of data models
- Experience with data ETL, complex SQL queries, and data cleaning
- Proficiency in JavaScript, Python
- Monitor and improve the performance of Data solutions to ensure efficient data retrieval and reporting
- Experience with cloud-based and on-prem data warehouses such as Azure SQL, Snowflake, SQL Server and/or Oracle
- Maintain comprehensive documentation of data models, configurations, and processes.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Required/Preferred Education And Experience
Required Education: Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field, or the equivalent combination of education, technical certifications, or work experience.
Preferred Experience: 3 years of experience in data engineering, business intelligence, and/or data analysis.
Work Environment
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and scanners.
Position Type and Expected Hours of Work
This is a full-time, hybrid position. The employee would need to be in the Berwyn office 2-3 days per week. Days and hours of work are Monday through Friday, 8:30 a.m. to 5 p.m. The schedule for this role can be modified upon Supervisor and Human Resources approval. Some evening and weekend work may be required. Trainings and team meetings may require coming into the office.
Travel
No travel is expected for this position.
EEO Statement
A-G is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation based on the following protected classes: age (40 and older), race, color, national origin, ancestry, religion, sex, sexual orientation (including transgender status, gender identity or expression), pregnancy (including childbirth, lactation, and related medical conditions), physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed servicemember status, or any other status protected by federal, state, or local laws. A-G is dedicated to the fulfillment of this policy in regard to all aspects of employment, including, but not limited to, recruiting, hiring, placement, transfer, training, promotion, rates of pay, other compensation, termination, and all other terms, conditions, and privileges of employment. A-G will conduct a prompt and thorough investigation of all allegations of discrimination, harassment, or retaliation, or any violation of the Equal Employment Opportunity Policy in a confidential manner. A-G will take appropriate corrective action, if and where warranted. A-G prohibits retaliation against team members who provide information about, complain about, or assist in the investigation of any complaint of discrimination or violation of the Equal Employment Opportunity Policy.
Salary : $80,000 - $95,000
