Data Engineer

Job Description

Job Description:

We are looking for someone who is passionate about data and who enjoys solving challenging problems by coming to understand and utilize complex datasets. You will be working closely with the data strategy team on high-impact revenue-generating and cost-saving projects for the business, specifically ensuring stakeholders have the data they need for analysis and can trust the integrity of the data. You will be responsible for setting up and maintaining critical data pipelines into our big data environment along with marrying various complex datasets to support analyses.

Responsibilities
• Build critical data ingestion pipelines for new datasets required to support organization-wide analytics' needs, while ensuring data integrity is well-maintained. Create automated ETL jobs to move, cleanse filters and join data sets.
• Support day-to-day activities of the data strategy team responsible for key revenue-driving or cost-saving analysis, specifically mining for critical datasets and/or taking the lead on complex analyses
• Help drive self-service analytics throughout the organization by capturing and organizing important data and/or domain knowledge in a centralized location
• Will work closely with the principal data engineers on the team and run point on production support activities

Qualifications
• You have a bachelor's degree in computer science or equivalent experience
• 3-5 years of hands-on experience using SQL to analyse data.
• 3-5 years of hands-on experience using Python
• 3-5 years of shell scripting experience in Linux environment
• 3-5 years experience working with relational databases, flat files, unstructured data (JSON/AVRO).
• You are by nature a curious individual and a lifelong learner
• You are meticulous and cautious in how you approach a challenge, ensuring that you check and document your work along the way
• You find it fun thinking critically and creatively with others
• You have a passion for data and find yourself using it to defend your position or to support a new decision
• Excellent verbal and written communication skills

Nice-to-have:
• Working experience in AWS
• Working knowledge of Spark /Spark streaming
• Knowledge of Kafka fundamentals
• Experience with cloud DWH like Redshift or Snowflake
• Exposure to any other HLL like Java or Scala.
• Exposure to Tableau or similar reporting/visualization tools

Besides providing a unique and dynamic work environment, there are a few other reasons you should consider ASCAP in your career planning. We also offer generous benefit options that are comprehensive and provide the flexibility that most employees want and need. These health care and financial plan options include the following:
• A choice of either network only provider medical and dental plans or more flexible medical and dental plans where you can see providers in or out-of-network
• Vision plan that offers both in and out- of network provider options
• Immediate eligibility for 401(k) participation with an employer provided match
• An additional Employer paid retirement savings program regardless of your participation in the 401(k) Plan
• Generous time-off policy
• Health care and dependent care flexible spending accounts
• Short term disability Insurance / salary continuation and Long term disability insurance
• Company provided basic life and accidental death and dismemberment insurance
• Supplemental and dependent life insurance options

Jobcode: Reference SBJ-rjqkn0-3-129-249-105-42 in your application.