Junior Business Intelligence Data Engineer

| El Segundo
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Machines that Move Us.
People who Inspire Us.
Stories that Drive Us.
Check us out: http://bit.ly/MotorTrendG Opens in New Window
About Us
We are MotorTrend.
With a monthly reach of more than 131 million, MTG is the largest automotive media company in the world. With franchises including MotorTrend, Hot Rod, Automobile, Wheeler Dealers, Roadkill, Best Driver’s Car, and dozens of other world-class brands, we are reimagining storytelling around mobility. Our portfolio brings together Discovery’s #1 TV network for automotive super fans, with our vast automotive digital platform that includes direct-to-consumer products, websites, apps, connected TVs, social, and live events.
Our People
The people who work at MotorTrend embody the passion of our content, and wake up every day intent on embracing, entertaining, and empowering the motoring world.
The Role
Job Summary & Responsibilities:
The Junior Business Intelligence Data Engineer (full-time, salaried, regular) reports into the business intelligence division.
At Motor Trend Group data is central to measuring all aspects of the business, and critical to its operations and growth. The BI data engineering team is responsible for collecting, analyzing and distributing data using public cloud and open source technologies and offers transparency into customer behavior and business performance
Responsibilities:
• Collaborate with product teams and data analysts to design and build data-forward solutions
• Build and deploy streaming and batch data pipelines capable of processing and storing petabytes of data quickly and reliably
• Integrate with a variety of data metric providers ranging from advertising, web analytics, and consumer devices
• Build and maintain dimensional data warehouses in support of business intelligence tools
• Develop data catalogs and data validations to ensure clarity and correctness of key business metrics
• Drive and maintain a culture of quality, innovation and experimentation
• Deliver strong Python and SQL development and maintenance techniques surrounding data movement to include technologies
• Investigate and understand different data sources and ability to connect to a wide variety of 3rd party APIs
• Design, enhance and implement ETL/data ingestion platform on the cloud
• Development of ETL source and target mapping design/specifications based on the business requirements. Create ETLs/ELTs to take data from various operational systems and create a unified/enterprise data model for analytics and reporting
• Develop load and transformation processes in support of the requirements, validate that they meet business and technical specifications, manage ongoing maintenance of the system and data, and make recommendations for process improvements to optimize data movement from source to target
• Provide production and operational support to existing ETL jobs. Monitor and manage production ETL jobs to verify execution and measure performance to assure ongoing data quality and optimization of the system to manage scalability and performance and identify improvement opportunities for key ETL processes.
• Strong troubleshooting and problem-solving skills in large data environment
• Capable of investigating, familiarizing and mastering new data sets quickly
Education/Experience:
• Bachelor’s degree – Computer Science or equivalent
• Strong background in scripting language using Python, Bash, Perl, PHP or any other language to solving data problems
• Experience with relational SQL and NoSQL databases, including Postgres, ,Neo4j and MongoDb
• Experience with Big Data tools; Hadoop, Spark, Kafka, Hive etc
• Proficiency with the AWS cloud services : EC2, EMR, RDS, S3, Redshift (spectrum)
• Proficiency with data exchange types and protocols (json, xml, soap, rest)
• Experience with Stream Processing systems: Storm ,Spark-Streaming etc
• Experience with BI tools like Tableau or any other open source BI tools etc.
Knowledge, Skills, & Abilities:
• Knowledge of the Python data ecosystem using pandas and numpy
• Data integration tools
• Proficiency in SQL, data modeling, and data warehousing
• Excellent problem solving skills
• Exposure to cloud platforms (preferably AWS)
Physical Requirements:
• The ability to sit for prolonged period of time and view computer screen.
Equipment/Software Used:
• Microsoft Office Suite (Outlook, Word, Excel, PowerPoint)
• SQL, MySQL or other relational databases
• Linux, Python, AWS Stack (EC2,EMR S3, Redshift) 
• Tableau or any other data visualization tool
• SiteCatalyst (Omniture)/Google Analytics or any other web analytics tools experience (Nice to have)
Work Environment:
• Work is performed in an office environment that is well lit and ventilated.
NOTE: This position description reflects management’s assignment of essential functions; it does not prescribe or restrict any other tasks that may be assigned.

We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including but not limited to all local Fair Chance Ordinances.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • SqlLanguages
    • ReactLanguages
    • ReduxLibraries
    • Node.jsFrameworks
    • MongoDBDatabases

Location

Conveniently located next to the 405, LAX, Douglas Metro Green Line stop, and the beach! Many walkable food/coffee/tea, grocery, and shopping options.

An Insider's view of MotorTrend Group

What are some social events your company does?

We work hard and love to celebrate our diligence. We host wellness classes, caterings, have arcade machines and give back in our community. We go to Dodger's Stadium, K1 Speed, host movie nights, and get free access to MTG events. Summer time is the best time at MotorTrend! We have KidsDay, ice cream bars, pizza parties and end with a company BBQ.

Stephanie Rios

Human Resources Generalist

What is your vision for the company?

Every day our team wakes up ready to Embrace Entertain & Empower a motoring world. Embracing the Car-Nivore in all of us. Entertaining our 110 MM digital fans with addictive storytelling & experiences. Empowering MotorTrend families with over 70 yrs of street cred. MotorTrend is building a billion-dollar car company without building a single car.

Alex Wellen

President

What's something quirky about your company?

As an automotive enthusiast, working at MotorTrend is the realization of a dream. Each day brings something new, from million dollar Pagani's to LowRiders and HotRods. MotorTrend is on the cutting edge of technology implementation and we are diving the way consumers now consume content via their mobile device and television apps.

Thomas Rosquin

SEO Manager

What are MotorTrend Group Perks + Benefits

MotorTrend Group Benefits Overview

We offer comprehensive health benefits for you and your family.

Culture
Volunteer in local community
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Group brainstorming sessions
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Acme Co.'s team fitness initiatives include In-office yoga, In-office fitness classes.
Retirement & Stock Options Benefits
401(K)
Performance Bonus
Child Care & Parental Leave Benefits
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Our game room includes Ping Pong, Video Games.
Some Meals Provided
Parking
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Promote from within
Mentorship program
More Jobs at MotorTrend Group34 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Product
new
El Segundo
Design + UX
new
El Segundo
Product
new
El Segundo
Project Mgmt
new
El Segundo
Content
new
El Segundo
Content
new
El Segundo
Project Mgmt
new
El Segundo
Developer
new
El Segundo
Developer
new
El Segundo
Content
new
El Segundo
Data + Analytics
new
El Segundo
Finance
new
El Segundo
Operations
new
El Segundo
Project Mgmt
new
El Segundo
Finance
new
El Segundo
Design + UX
new
El Segundo
Project Mgmt
new
El Segundo
Internships
new
El Segundo
Content
new
El Segundo
Content
new
El Segundo
Sales
new
El Segundo
Data + Analytics
new
El Segundo
Operations
new
El Segundo
Data + Analytics
new
El Segundo
Developer
new
El Segundo
Developer
new
El Segundo
Operations
new
El Segundo
Data + Analytics
new
El Segundo
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView MotorTrend Group's full profileSee more MotorTrend Group jobs