Sr. Data Engineer
6AM City
- Florida, New York, United States
- Florida, New York, United States
À propos
EBG powers a robust portfolio of technology solutions and operates a network of employer and membership‑based platforms reaching a captive audience, providing leading brands with incremental distribution opportunities. EBG's expanded network reaches over 100 million users from participating companies and closed loop affinity and membership groups.
EBG owns and operates one of the largest and most comprehensive employee savings programs in the country — serving over 40,000 corporate clients through its proprietary platforms TicketsatWork, Plum Benefits, Working Advantage and Beneplace.
EBG is a b2b2c company headquartered in Miami (Aventura), with offices in New York, Orlando, Austin and Las Vegas.
Job Description The Senior Data Engineer role is responsible for overseeing the data engineering activities, including but not limited to building the business’ data collection systems and processing pipelines, and building and maintaining optimized and highly available data pipelines that facilitate deeper analysis and reporting by the Data Science and Analytics departments.
The Senior Data Engineer is involved in various phases of data science initiatives, starting from data acquisition, data collection, building and configuring the data connectors to funnel data from various heterogenous sub‑systems to the corporate data warehouse, data cleansing and merging, creating and maintaining the dimensional models on the data warehouse, creating and maintaining necessary database constructs (such as views, functions, stored procedures), and providing the necessary pipelines to feed the company's visualization tools.
The Senior Data Engineer works closely with the data science leadership as well as other data and analytics teams in leveraging data with reporting and scientific tools, for instance, Tableau, Python, SnowFlake, among other tools and technologies. The Senior Data Engineer strives to continuously develop new and improved data engineering capabilities.
Responsibilities
Maintain and build on top of our data warehouse and analytics environment, the home for almost all the data.
Design, implement, test, deploy, and maintain stable, secure, and scalable data engineering solutions and pipelines in support of data and analytics projects, including integrating new sources of data into our central data warehouse, and moving data out to applications and affiliates.
Build reports and data visualizations, using data from the data warehouse and other sources.
Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks.
Perform one‑off data manipulation/munging and analysis on a wide variety of data.
Implement and monitor best‑in‑class security measures in our data warehouse and analytics environment, with an eye towards the evolving threat landscape.
Help troubleshoot other data engineers’ SQL and Python code among other data manipulation languages and tools.
Other duties as assigned.
Qualifications
BS in related field or equivalent work experience (MS is preferred for this role)
Strong command of relational databases and SQL. Extract, Transform, and Load (ETL) data into a relational database.
Proficiency with Python or R, especially for data manipulation and analysis, and ability to build, maintain and deploy sequences of automated processes with these tools
General data manipulation skills: read in data, process and clean it, transform and recode it, merge different data sets together, reformat data between wide and long, etc
Demonstrated ability to learn new techniques and troubleshoot code without support, e.g. find answers to common programming challenges on Google. In other words, be able to learn on the job
Demonstrated ability to write clear code that is well‑documented and stored in a version control system (we use Git)
Demonstrated ability to work independently and be a self‑starter
Excellent listening, interpersonal, communication and problem‑solving skills
Demonstrated ability to work effectively in teams, in both a lead and support role
Use APIs to push and pull data from various data systems and platforms
Experience working with cloud infrastructure services like Amazon Web Services and Google Cloud is preferred but not required
Effective time management skills, including demonstrated ability to manage and prioritize multiple tasks and projects
Experience with SnowFlake is required
Experience with Amazon Airflow is required
Strong familiarity with Dimensional Modeling
MDM Processing of Data
Identity Resolution (Golden Record Generation and Maintenance)
ETL using DBT
File Processing using Python
Experience with advanced data visualization and mapping are required
Additional Information Entertainment Benefits Group offers outstanding employee benefits including:
Medical, Dental & Vision
401k Match
Short Term Disability, Long Term Disability (Company Paid)
Basic Life and AD&D (Company Paid)
Additional Voluntary Benefits (additional life, legal, critical care, and more)
Flexible Work Arrangements
3 Weeks of PTO + 5 Personal Days
Paid Holiday Break from Christmas to New Year
Paid Holidays
Fitness Centers (location dependent)
Annual Day of Giving
Company Bonus Program
Share in the FUN! EBG gives $1000 per year in Tickets‑At‑Work gift cards to full‑time employees to experience and enjoy the savings marketplace!
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.