Data Engineer
Share
Job Location:
Hanover, PA - USA
Monthly Salary:
$ 98000 - 147000
Posted on:
22 hours ago
Vacancies:
1 Vacancy
Job Summary
Overview
Job Summary:
The Senior Data Engineer (Matillion for Snowflake) will be responsible for development and delivery of the Allegis Analytics Warehouse in our cloud-based Data Platform. The Engineer will perform Code reviews estimate the effort based on solutions guided by Architects and participate in Databases Designs Development and ELT solutions to support all consumers across the entire Enterprise
Responsibilities
Essential Functions:
- Assist in writing and reviewing the design and Code specifications for solutions as identified by Data/Domain Architects.
- Maintains a working knowledge of new technologies and adopts suitable concepts for the organization to help move their organizations forward.
- Code test and support existing and new systems as necessary to support Analytics and Reporting applications.
- Ability to Code design and deliver data solutions that are reliable scalable and perform at a high-level to meet the service levels associated with mission-critical reporting and AI/ML used cases.
- Conduct code reviews and handles continuous Integration and deployment.
- Streamlines existing applications and systems to ensure integration and ease of use.
- Monitors systems technical performance and identifies opportunities to deliver data as quickly as possible
- Collaborates with developers architects project managers and business analysts in developing new reporting structures that will stand the test of time.
- Responds to support incidents and resolve issues for newly released code
- Works collectively with Global team and architects with guidance in delivering solutions
- Communicates difficult or sensitive topics and works to build consensus.
- Ability to tune SQL statements/queries; knowledge of optimal tuning techniques.
- Ability to analyze data and abstract relationships meaning and forensics from data profiling
- Demonstrated level of technical knowledge and understanding of architecture application systems design and data integration
- Ability to mentor and guide junior team members
- Experience working on technical initiatives from concept to implementation while ensuring alignment with broader team goals.
Qualifications
Minimum Education and/or Experience:
- 8 years of overall experience with:
- 5 years leading and implementing data lake and warehouse platforms
- Designing and developing database systems and/or applications in a diverse environment
- Experience in Snowflake (preferred) or other modern cloud data lake and warehouse platforms
- Extensive experience with ELT preferably with Matillion or other analogous modern ELT technologies for cloud data and integration
- Ability to tune SQL statements/queries knowledge of optimal tuning techniques.
- Experience programming in Python or modern programming languages
- Knowledge in building AI-Driven data solutions including feature engineering embeddings or ML/LLM enabled pipelines with preference for Snowflake based implementations
- Well verse with Dimensional Modeling
- Mentoring and guiding team members
Skills/Abilities:
- Team-oriented can-do self-starter attitude
- Ability to solve complex technical and/or logic challenges
- Ability to work in a fast passed environment
Benefits Overview:
Benefits are subject to change and may be subject to specific elections plan or program terms. This role is eligible for the following:
- Medical dental & vision
- Hospital plans
- 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available
- Life Insurance (Company paid Basic Life and AD&D as well as voluntary Life & AD&D for the employee and dependents)
- Company paid Short and long-term disability
- Health & Dependent Care Spending Accounts (HSA & DCFSA)
- Transportation benefits
- Employee Assistance Program
- Tuition Assistance
- Time Off/Leave (PTO Allegis Group Paid Family Leave Parental Leave)
- $98000-$147000
- The position is bonus eligible
Individual compensation offered for this position within this range will depend on many factors including qualifications skills relevant experience job knowledge geographic location internal equity and other pertinent job-related factors.
Office Requirements:
- Required in office 2 days a week out of our headquarters in Hanover MD or offices in Jacksonville FL
Core Competencies:
- Building Relationships
- Develop People
- Lead Change
- Inspire Others
- Think Critically
- Communicate Clearly
- Create Accountability
Individual compensation offered for this position within this range will depend on many factors including qualifications skills relevant experience job knowledge geographic location internal equity and other pertinent job-related factors.
The company is an equal opportunity employer and will consider all applications without regard to race sex age color religion national origin veteran status disability sexual orientation gender identity genetic information or any characteristic protected by law. If you would like to request a reasonable accommodation such as the modification or adjustment of the job application process or interviewing process due to a disability please email Lauren Lara at or call for other accommodation options. |
Required Experience:
IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Allegis Group retired the "Talent2" name and re-branded its specialist recruitment professionals brand to Aston Carter. Aston Carter is a distinguished global provider of recruitment services to companies requiring highly specialised business professionals. We have an unrivalled comm ... View more
