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

Apply for this Job

* Required

  
  
When autocomplete results are available use up and down arrows to review
+ Add Another Education


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at MotorTrend Group are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 1/31/2020

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities1. To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • HIV/AIDS
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.