Data Engineer

Innocean Huntington Beach , CA 92605

Posted 1 week ago

Department Overview

The Data Science Department works with the Hyundai Marketing clients to identify business objectives and develop insights that help optimize tactics and strategy for paid media, social media, web content, and CRM marketing. The team centralizes marketing data by managing a data warehouse; developing and implementing technical requirements for web analytics tools; managing tagging; conducting A/B and multivariate testing; producing reports and dashboards; developing models; and managing attribution. The Data Science team also works closely with other agencies and third-party vendors to extend its capabilities and produce more holistic views of the clients marketing efforts.

Position Overview

We are currently searching for a Data Engineer who will be responsible for understanding functional and business requirements, defining solutions, and building and deploying technical solutions that satisfy business needs.

The Data Engineer must have strong skills in application development, and ETL.

Our primary languages are Python and Postgres SQL, and we make heavy use of AWS platform and services. We use a Django framework and Celery for background processing.

This person would work with other engineers or technology leads.

Intra-team communications and collaboration are important, as this person will fulfill a key role within the Data Science team.

Key Responsibilities

  • Analyze and organize raw data
  • Build data systems and pipelines
  • Evaluate business needs and objectives
  • Interpret trends and patterns
  • Conduct complex data analysis and report on results
  • Prepare data for prescriptive and predictive modeling
  • Build algorithms and prototypes
  • Combine raw information from different sources
  • Explore ways to enhance data quality and reliability
  • Develop analytical tools and programs
  • Collaborate with data scientists and architects on several projects

Requirements

The ideal candidate will have a strong combination of skills that include but are not limited to:

  • University degree, ideally in the field of computer science, engineering, or another rigorous technical discipline.

Core Technology Skills:

  • Additional relevant certifications (for example, on AWS) are a plus.
  • Knowledge of relevant data and analytics tools such as:
    • Oracle Siebel CRM Systems
    • Analytics: Adobe Analytics or Google Analytics
    • Databases: SQL, Redshift, MongoDB, Dynamo
    • BI tools: Tableau Desktop/Scheduler, DOMO, PowerBI or similar software
    • ETL: Hadoop, EMR, Hive, Spark, Alteryx
    • Statistical tools: R Studio, SAS, Python
  • 3 to 5 years experience with database development including sophisticated SQL coding techniques. Postgres preferred.
  • 3 to 5 years experience with Python and other high-level languages such as Java or C#.
  • Ability to create clean well-organized, well-commented code.
  • Experience working with a cloud computing platform in particular AWS, using EC2 and RDS.
  • Experience using collaborative work management systems such as JIRA.

Additional desirable experience includes:

  • Familiarity with cross-channel marketing (email, direct mail) preferred
  • Knowledge of Data Environment architecture
  • Familiarity with AI/Machine Learning libraries and their use.
  • Strong verbal and written communication skills, especially with non-technical audiences
  • Ability to work collaboratively with team members
  • Ability to meet deadlines and business/functional requirements
  • Experience working for an Advertising or Media agency in the digital space is desirable.
  • Experience with Adobe Marketing Cloud is desirable
  • Experience with Databricks is desirable

Benefits

  • 100% paid Medical, Dental and Vision Premiums.
  • 401k matching program
  • Fun and fast-paced agency environment.
  • Lots of individual autonomy & rewards for merit and creativity.
  • Be part of a close-knit and exciting team & growing agency.
  • Generous PTO.

& when we get back into the office...

  • Enjoy catered happy hour every Thursday and breakfast on Fridays.
  • Full-time Barista on-site.
  • Amazing views of the Pacific Ocean by the pier in HB.
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Big Data Engineer

Landmark Health

Posted 7 days ago

VIEW JOBS 10/15/2020 12:00:00 AM 2021-01-13T00:00 Overview Landmark Health is hiring Big Data Engineers join a growing organization to support our Data Integration Team. Our Big Data Engineers will work side by side with our IT development team to assist in the design and development of our data feeds, data warehouses, data lakes and enterprise reporting. Our Big Data Engineers will have a strong working knowledge of ETL development, using SQL Server Integration Services (SSIS) and ability to liaison between our internal stakeholders, business partners and IT teams to determine requirements and apply business rules to data. Provide recommendations to data modeling, data ingestion of our health plans partners data and implement H-Scale tool built on top of Hadoop eco-system to integrate, scale and manage healthcare data. If you have a passion for Big Data Technologies/Hadoop, looking for long term career growth & opportunity then we want to hear from you! Preferred locations: Huntington Beach - Corporate Headquarters, OR Ellicott CIty, MD or Los Angeles, CA. If not in one of those locations, willing to consider full time work at home (REMOTE) Unfortunately, VISA SPONSORSHIP is NOT offered for these roles Responsibilities * Architect, design, develop, implement, configure and document current and future Hadoop infrastructure• Perform software installation and configuration, database backup and recovery, storage management, performance tuning, database connectivity and security• Implement and support various components of the Hadoop ecosystem • Monitor Hadoop cluster connectivity and performance.• HDFS support and maintenance.• Setting up new Hadoop users.• Responsible for the new and existing administration of Hadoop infrastructure.• Support data modelling, design and implementation, • Work closely with infrastructure, network, database, business intelligence and application teams to ensure business applications are readily available and performing within agreed upon service levels• Develop tools for automated build test deployment and management of the platform• Continuously improve integration and delivery systems Qualifications * Bachelor's degree in Computer Science, Information Systems, Information Technology, Management Information Systems, or equivalent experience is preferred• 3+ years designing, developing and implementing solutions in Hadoop environments• 3+ years supporting technologies in the Hadoop ecosystem• Expertise with HDFS, YARN, MapReduce, Hive, Pig, Spark• Proficiency with Hadoop technologies such as Nifi, HDFS, HBase, Flume and Sqoop• Ability to write reliable, manageable and highly efficient code using Hadoop tools• Proficiency with SQL scripting• Experience in backend programming, particularly Java, JavaScript, Python, R, Scala• Working knowledge of Linux/Unix, distributed computing, networks and network security• Strong problem solving and analytical skills• Effective oral and written communication skills for both technical and non-technical audiences• Excellent systems and data analysis skills• Ability to prioritize and manage competing projects Landmark Health Huntington Beach CA

Data Engineer

Innocean