Position Details:
Title: Data Engineer 1
Location:
Plano, TX 75074
(Hybrid – 4 days/week onsite)
Duration: 6 Months Contract (Possible extension)
Job
Description:
This role is a mixture of DBA and Data
Engineering.
Top Skills Required:
- Stored
Procedures
- MS
Access (Table View, User Property Creation & Management)
- Alteryx
- Python
- Data
Engineering
Looking for experience with:
- SQL
Server
- Stored
Procedures
- Main
Table, Indexing, and Table Management
- SSAS
- Alteryx
Packages
- Python
- User
Properties & Rights Management (New Users, Permissions, Read Access)
- Demonstration
of SQL, Python, and ETL Fix/Failure Handling
- SQL
Migration
Day-to-Day Responsibilities:
- Managing
monthly and weekly ETL processes
- Moving
files (CSV or Excel)
- Loading
and processing data
- Data
engineering tasks
Experience Requirements:
- BS
degree with minimum 5-6 years of experience required
- Open
to candidates with 3-4 years of experience if they hold an MS degree
- Open
to all industry domains
Interview Process:
- Total 3 rounds
- The final round will be
face-to-face
Certifications:
- SQL
Server certification is a plus but not required
Summary:
- The
main function of the DBA/Data Engineer is to develop, evaluate, test and
maintain architectures and data solutions within the North America HR
organization. The typical Data Engineer executes plans, policies, and
practices that control, protect, deliver, and enhance the value of the
organization's data assets.
Job
Responsibilities:
- Design,
construct, install, test and maintain highly scalable data management
systems.
- Ensure
systems meet business requirements and industry practices.
- Design,
implement, automate and maintain large scale enterprise data ETL
processes.
- Build
high-performance algorithms, prototypes, predictive models and proof of
concepts.
- Implement
and test data warehousing/data lake environments
Skills:
- Ability
to work as part of a team, as well as work independently or with minimal
direction.
- Excellent
written, presentation, and verbal communication skills.
- Collaborate
with data architects, modelers and IT team members on project goals.
- Strong
PC skills and fluency in SQL, SSIS, SSMS, Python, Alteryx, Tableau
- Familiarity
with data warehousing tools and systems such as Snowflake, Data Bricks,
Datapalego, etc.
