Business Intelligence Data Engineer
Apply NowCompany: MotorTrend Group
Location: El Segundo, CA 90245
Description:
Machines that Move Us.
People who Inspire Us.
Stories that Drive Us.
About Us
MotorTrend Group is the largest automotive media company in the world. MotorTrend Group, a Warner Bros. Discovery company, is the largest automotive media company in the world, bringing together MotorTrend TV and a vast automotive digital, direct-to-consumer, social, and live event portfolio, including MOTORTREND, HOT ROD, ROADKILL, AUTOMOBILE and more than 20 other industry-leading brands. With a monthly audience of 26 million across web, TV and print, and 110 million social followers, culminating in 1.3 billion monthly impressions across all platforms, MotorTrend Group encompasses television's #1 network for automotive fans, a leading automotive YouTube Channel and MotorTrend+, the only subscription streaming service dedicated entirely to the motoring world. MotorTrend Group serves to embrace, entertain and empower the motoring world.
An institution in the automotive industry, we have been delivering premium content, in depth analysis, and culturally relevant material since 1949. We celebrate our heritage, while boldly looking to the future - reimagining motor entertainment for a broader, more diverse audience. MotorTrend Group has remained ahead of the automotive world and developed the single most relevant resource for any auto enthusiast and in-market shopper.
Have a look at what we do! https://bit.ly/motortrendintro
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
Employer: Motor Trend Group, LLC
Job Title: Business Intelligence Data Engineer
Job Location: 2004 Park Place, Suite K, El Segundo, CA 90245
Job Type: Full-time, 40 hours a week, Monday - Friday
Duties: 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. Hybrid work from home permitted 3 days a week.
Requirements: Bachelor's degree in Management Information Systems, Computer Science, Information Technology or closely related field of study and five (5) years of experience as a Technology Architect, Lead Technical Consultant, Programmer, Senior Executive, Programmer Analyst, Sr. Technical Architect, Technical Architect, or related role where experience was gained. Also requires at least 4 years of experience in the following:
SALARY: $187,400 to $200,000 per year
This Notice is being provided as a result of the filing of an application for permanent alien labor certification for the opportunity. Any person may provide documentary evidence bearing on the application to:
Certifying Officer
U.S. Department of Labor
Employment and Training Administration
Office of Foreign Labor Certification
200 Constitution Avenue NW, Room N-5311
Washington, DC 20210
NOTE: This position description reflects management's assignment of essential functions; it does not prescribe or restrict any other tasks that may be assigned.
*MotorTrend Group will never ask for sensitive personal information or fees as part of your application process*
*A warning about recruitment scams*
Unscrupulous individuals sometimes pose as MotorTrend Group recruiters and mislead jobseekers into providing sensitive personal information (such as social security numbers) or paying fees as a condition of submitting an application to MotorTrend Group or obtaining a job at MotorTrend Group. These individuals or entities posing as recruiters are not affiliated with MotorTrend Group and do not act on behalf of MotorTrend Group. Always utilize the MotorTrend Group Careers page https://boards.greenhouse.io/motortrendgroup to find available openings and whenever submitting a job application to MotorTrend Group, and know that MotorTrend Group will never ask for sensitive personal information or fees as part of your application.
People who Inspire Us.
Stories that Drive Us.
About Us
MotorTrend Group is the largest automotive media company in the world. MotorTrend Group, a Warner Bros. Discovery company, is the largest automotive media company in the world, bringing together MotorTrend TV and a vast automotive digital, direct-to-consumer, social, and live event portfolio, including MOTORTREND, HOT ROD, ROADKILL, AUTOMOBILE and more than 20 other industry-leading brands. With a monthly audience of 26 million across web, TV and print, and 110 million social followers, culminating in 1.3 billion monthly impressions across all platforms, MotorTrend Group encompasses television's #1 network for automotive fans, a leading automotive YouTube Channel and MotorTrend+, the only subscription streaming service dedicated entirely to the motoring world. MotorTrend Group serves to embrace, entertain and empower the motoring world.
An institution in the automotive industry, we have been delivering premium content, in depth analysis, and culturally relevant material since 1949. We celebrate our heritage, while boldly looking to the future - reimagining motor entertainment for a broader, more diverse audience. MotorTrend Group has remained ahead of the automotive world and developed the single most relevant resource for any auto enthusiast and in-market shopper.
Have a look at what we do! https://bit.ly/motortrendintro
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
Employer: Motor Trend Group, LLC
Job Title: Business Intelligence Data Engineer
Job Location: 2004 Park Place, Suite K, El Segundo, CA 90245
Job Type: Full-time, 40 hours a week, Monday - Friday
Duties: 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. Hybrid work from home permitted 3 days a week.
Requirements: Bachelor's degree in Management Information Systems, Computer Science, Information Technology or closely related field of study and five (5) years of experience as a Technology Architect, Lead Technical Consultant, Programmer, Senior Executive, Programmer Analyst, Sr. Technical Architect, Technical Architect, or related role where experience was gained. Also requires at least 4 years of experience in the following:
- Scripting language using Python, Bash, Perl, or PHP to solve data problems;
- Relational SQL and NoSQL databases, including Postgres, Neo4j and/or MongoDb;
- Big Data tools such as Hadoop, Spark, Kafka, and/or py-spark;
- AWS cloud services such as EC2, EMR, RDS, S3, Redshift (spectrum) and/or Athena;
- Data exchange types and protocols such as json, xml, soap and rest;
- Stream Processing systems such as Storm or Spark-Streaming;
- BI tools such as Tableau, Amplitude, and mParticle;
- Python data ecosystem using pandas and numpy;
- SQL, data modeling, and data warehousing; and
- Analytics tools such as Adobe,Google Analytics, and Mux,Braze(ESP).
SALARY: $187,400 to $200,000 per year
This Notice is being provided as a result of the filing of an application for permanent alien labor certification for the opportunity. Any person may provide documentary evidence bearing on the application to:
Certifying Officer
U.S. Department of Labor
Employment and Training Administration
Office of Foreign Labor Certification
200 Constitution Avenue NW, Room N-5311
Washington, DC 20210
NOTE: This position description reflects management's assignment of essential functions; it does not prescribe or restrict any other tasks that may be assigned.
*MotorTrend Group will never ask for sensitive personal information or fees as part of your application process*
*A warning about recruitment scams*
Unscrupulous individuals sometimes pose as MotorTrend Group recruiters and mislead jobseekers into providing sensitive personal information (such as social security numbers) or paying fees as a condition of submitting an application to MotorTrend Group or obtaining a job at MotorTrend Group. These individuals or entities posing as recruiters are not affiliated with MotorTrend Group and do not act on behalf of MotorTrend Group. Always utilize the MotorTrend Group Careers page https://boards.greenhouse.io/motortrendgroup to find available openings and whenever submitting a job application to MotorTrend Group, and know that MotorTrend Group will never ask for sensitive personal information or fees as part of your application.