What are the responsibilities and job description for the Data Engineer position at Allegis Group?
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)
Salary Range:
- $98,000-$147,000
- The position is bonus eligible
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 llara@allegisgroup.com or call 410-579-3526 for other accommodation options.
Salary : $98,000 - $147,000