Machines that Move Us. 

People who Inspire Us.

Stories that Drive Us.

 

Check us out: http://bit.ly/MotorTrendG

 

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. 

If you: feel the need to understand the big picture, believe that truth can be revealed when collaborating with others, and know how to bring data to life visually and reveal insights that would otherwise stay hidden forever, you might be the person we are searching for.

If you: are happy just to answer questions and move on with your day, leave the “big thinking” to other people, and don’t worry much about how your work is used (or not)… this is not the role for you.

 

The Role

Job Summary & Responsibilities:

This Data Visualization Engineer (Full-time, Regular, Salaried) will work with the BI data engineering and analytics teams and will be responsible for collecting, analyzing and distributing data using public cloud and open source technologies that offers transparency and new insights into customer behavior and business performance. When questions arise based on the reports and visualizations created, this person is the first line of defense in helping end users interpret and understand the information, and will require a command of the data that is being reported and visualized.

At MotorTrend Group data is central to measuring all aspects of the business, and critical to its operations and growth. This role will interface with many different departments and executives, and requires a person who has a strong data background and natural ability to clearly translate numbers and charts into meaningful insights.

Essential duties and responsibilities include but not limited to:

  • 7+ years of experience in Data Warehousing & BI reporting
  • Strong analytic skills and ability to develop, and implement analytical data models and dashboard and reports using Tableau and other tools to enable customers to analyze data and make business decisions.
  • Ability to see raw data, understand how it can best be reported or visualized on a case-by-case basis, and bring it to life in an intuitive and detailed format
  • Experience creating user stories in a Tableau Reporting environment
  • Experience and expertise creating executive and department-level canned reports
  • Ability to understand core business questions needing answered
  • Ability to write custom calculations (or queries) within the data visualization tool Tableau.
  • Solid understanding of Tableau presentation and data layer and implementation of Security with Tableau
  • Experience in rolling out Tableau as Self-service solution for large number of users
  • Extensive knowledge of data warehousing and information management best practices.
  • Extensive experience defining and rationalizing complex data models within data warehousing environment.
  • Extensive experience in defining, implementing, and executing data analysis concepts such as profiling, lineage, impact analysis, mapping
  • Hands on experience in Performance optimization, Query optimization.
  • Hands on experience in Tableau reporting, Tableau server management
  • Experience in Architecting Visualization / Analytics using Tableau (both extracted and live connected data sources)
  • Experience in building Integration of Tableau with various data sources like Redshift, Athena, Excel, Mysql and Postgres
  • Ability to consult business users to build Tableau dashboards
  • This role will require collaboration with end users, project stakeholders, and support partners to identify needs, goals, metric measurements, and business models which will result in easy to understand interfaces and enable end users to quickly identify key themes within the data
  • Good understanding of Relational Databases, Relational Datamodel, SQL and concepts of implementing Data Level security in RDBMS
  • Experience with other BI visualization tool : PowerBI will be an added advantage.

 

Education/Experience:

  • Bachelor’s degree – Computer Science or equivalent
  • Strong background in scripting language using Python, Perl, PHP or any other language to solving data problems
  • Experience with relational SQL and NoSQL databases, including Redshift, Postgres, and MongoDb
  • Familiar with Big Data tools; Hadoop, Spark, Kafka, Hive etc
  • Familiar with data exchange types and protocols (json, xml, soap, rest)
  • Experience with other BI tools like Power BI, ThoughtSpot, Domo, or any other open source BI tools etc.

 

 

Knowledge, Skills, & Abilities:

  • 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
  • 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 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you 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:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

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.