Data Engineer

Job Description

About ASCAP

About ASCAP

The American Society of Composers, Authors and Publishers (ASCAP) is a professional membership organization of songwriters, composers, lyricists and music publishers of every kind of music and operates on a not for profit basis. ASCAP's mission is to license and promote the music of its members and foreign affiliates, obtain fair compensation for the public performance of their musical compositions and to identify and match such performances to the fractional shares of copyright ownership and finally to distribute the royalties that it collects based upon those performances. ASCAP members write the world's best-loved music and ASCAP has pioneered the efficient licensing of that music to hundreds of thousands of enterprises who use it to add value to their business - from bars, restaurants and retail, to radio, TV and cable, to Internet, digital and mobile services and more. The ASCAP blanket license offers an efficient solution for businesses to legally perform ASCAP music while respecting the right of songwriters, composers, lyricists and music publishers to be paid fairly. With more than 875,000 members representing more than 16 million copyrighted works, ASCAP is the worldwide leader in performance royalties, service and advocacy for songwriters and composers, and the only American performing rights organization (PRO) founded and governed by its writer and publisher members. Learn more and stay in touch at www.ascap.com, on Twitter and Instagram @ASCAP and on Facebook.

# # #

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

Please be aware that ASCAP is not a nut-free or other allergen-free workplace.

As a condition of employment, ASCAP requires all employees to be fully vaccinated (including a first booster, when eligible) against COVID-19. ASCAP will make reasonable accommodations for those who are unable to obtain a COVID-19 vaccination, where required by federal, state and local law, and in accordance with ASCAP's policies.

ASCAP is an equal opportunity employer. All ASCAP employment decisions are made on the basis of individual qualifications and performance and not on the basis of race, national origin, ethnicity, sex, age, marital status, sexual orientation or preference, gender identity, genetic information, disability, handicap, color, creed, religion, veteran status, or any characteristic protected by applicable federal, state or local laws.

Jobcode: Reference SBJ-re4890-3-144-25-74-42 in your application.