Data Engineer

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