Business Intelligence Developer

| Greater LA Area
Core Digital Media is a leader in online marketing and online consumer acquisition. Our websites WalletJoy.com, LowerMyBills.com and ClassesUSA.com are fueled by an industry leading marketing platform which operates across a variety of financial and education markets working with more than 1,000 unique partners. We are focused on performance marketing and our infrastructure and process is second to none. We have a patented real-time optimization algorithm that allows for testing of over 1,000 creatives per month and supports over 2 million decisions per day. We have also built out incredibly efficient proprietary deployment and tracking systems. Given the trajectory of the online advertising industry – towards more data elements being made available for modeling and more transactional channels becoming available – our Business Intelligence team is perfectly positioned. Core Digital Media continues to build on our analytical foundation, harnessing the power of a Teradata-based enterprise data warehouse.
 
We are currently seeking a highly motivated Individual with a background in Business Intelligence/Data Warehouses. The candidate will be mainly focused on supporting and developing high quality DW ETL solutions for CDM’s Cloud data warehouse. He/She will be expected to develop reporting applications in Microstrategy. His/her work must be result oriented and focused on high quality, timeliness and scalability.

Responsibilities

  • Develop ETL processes using Informatica and SQL
  • Work on creating ETL processes using python for data processing, publishing/subscribing to Kafka and interacting with external API’s to download data as per business requirements
  • Prepare test cases and test ETL code to ensure high quality deliverables
  • Understand multiple data sources like Oracle, Postgre, MongoDB, flat files etc. and build ETL processes using the same to load data into CDM’s cloud data warehouse
  • Partner with different departments to understand processes and requirements to develop high quality ETL code
  • Provide data load support to all the data loads that happen in the EDW system

Required Skills

  • Strong understanding of Data Warehouse methodologies
  • Strong knowledge in SQL Programming
  • Good experience in working with at least one RDBMS like Oracle, SQL Server, Teradata etc. is preferred
  • Proven ability to translate the business requirements into effective ETL solutions
  • Good knowledge in programming with Python
  • Able to produce business results in a fast-paced environment 

Bonus Skills

  • Knowledge in ETL tools like Informatica, Talend, Data
  • Experience in languages like Scala and Java
  • Knowledge of Apache Spark and Kafka framework
  • Develop reporting processes using Microstrategy

Required Experience

  • Bachelor’s degree in Computer Science or related field
  • 2+ years of experience working in DW environments
  • 2+ years of experience working in building ETL solutions in DW environments
  • 2+ years of experience in leveraging SQL for performing data profiling, analysis and building ETL process in DW environments
  • 2+ years’ experience in working with RDBMS like Oracle, Teradata, SQL Server
Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • NodeLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • HibernateFrameworks
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • TeradataDatabases
    • KafkaDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • TableauAnalytics
    • R StudioAnalytics
    • MicrostrategyAnalytics
    • PythonAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • After EffectsDesign
    • DreamweaverDesign
    • PremiereDesign
    • Adobe AnimateDesign
    • Adobe XDDesign
    • ConfluenceManagement
    • JIRAManagement
    • WordpressCMS
    • Microsoft DynamicsCRM

Location

We are located in West Los Angeles in the heart of Silicon Beach.

An Insider's view of Core Digital Media

What’s the vibe like in the office?

CDM is unique in that it exists in a competitive, fast-paced, ever-changing industry and still maintains its collaborative, nurturing community spirit. People are encouraged to think creatively and take risks; the result is a group of people invested in and energized by the work they do.

Chelsea Fusco

Social Marketing Manager

What makes someone successful on your team?

The most successful people are flexible and open to new ideas. Our industry, and even our individual roles, are constantly changing, so an ability to adapt and pick up on new clients, new processes, and new company goals is essential. Successful teammates are constantly pushing themselves to do better and think of innovative ideas.

Tamara Newman

Campaign Manager

What projects are you most excited about?

We are excited to be moving towards a micro services architecture which will allow us to create modular applications which are easier to build, maintain and deploy. We are re-architecting our front end to utilize newer UI frameworks. We are working on encrypting sensitive consumer data. We are also working on making our applications cloud ready.

Deepak Vashishtha

Sr. Director of Software Engineering

What are Core Digital Media Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
We match 100% up to 4% of the employee's contribution
Child Care & Parental Leave Benefits
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
We offer 10 paid holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Game Room
Some Meals Provided
We bring in breakfast every Friday morning
Happy Hours
Parking
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
More Jobs at Core Digital Media15 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Product
Data + Analytics
new
Los Angeles
Marketing
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Marketing
new
Los Angeles
Marketing
new
Los Angeles
Developer
new
Los Angeles
Design + UX
new
Los Angeles
Data + Analytics
new
Los Angeles
Marketing
new
Los Angeles
Product
new
Los Angeles
Product
new
Los Angeles
Marketing
new
Los Angeles
Data + Analytics
new
Los Angeles
Product
new
Los Angeles