Business Intelligence Developer

Los Angeles, CA /
Technology – Business Intelligence /
Full Time
Core Digital Media (CDM) was founded to empower people to improve their lives financially. CDM combines its proprietary Performance Marketing Platform with a state-of-the-art data analytics capability to optimize billions of online display, social, mobile and search marketing impressions acquiring millions of high-quality customers for its clients. Core Digital Media is a certified Great Place to Work and a Fortune 100 top medium size place to work. The company operates in a fast-paced, dynamic environment where everyone on the team “comes to win”.

We are currently seeking a highly motivated individual with a background in Business Intelligence, ETL and Data Warehousing.  The candidate will join the team in this exciting period of company growth and technology modernization. This team member will be a key contributor in building our next-generation data stack to power business decisions and innovation.

Responsibilities

    • Develop and support ETL processes using SQL, Python and Airflow
    • Code scripts to integrate with new data sources or targets via API, SFTP or Email
    • Develop data pipelines to enable business intelligence, data visualization, machine learning and application integration
    • Design and develop reporting solutions in MicroStrategy or Tableau
    • Collaborate with various departments to ideate and implement optimal data solutions
    • Prepare and execute Test cases/scripts to ensure high quality deliverables
    • Participate in a regular on-call support rotation
    • Work in a fast-paced Agile environment

Preferred Skills

    • Solid knowledge in ETL tools like Airflow, Informatica or Talend
    • Cloud Computing (AWS, Snowflake, etc)  experience, training or certification
    • MicroStrategy/Tableau experience

Required Experience

    • Bachelor’s degree in Computer Science or related field
    • 2+ years of experience working in building ETL solutions
    • 2+ years of experience in leveraging SQL for performing data profiling, analysis and building ETL process in Data Warehousing environments
    • 2+ years of experience in working with RDBMS like Snowflake, Oracle or Teradata,
    • 1+ year of experience in leveraging Python for data analysis/processing
    • Knowledgeable in Data Warehousing and Data Modeling