Sr. Data Engineer/Manager

The Sr. Data Engineer/Manager will help build and manage Icon’s cloud-based data pipelines. Responsibility for architecting and implementing very large scale data intelligence solutions around Snowflake Data Warehouse.

A solid experience and understanding of ETL workflows, data modeling and data warehousing

Tenured experience architecting, designing and operationalization of large scale data and analytics solutions on Snowflake Cloud Data Warehouse is a must.

Collaborate with BI and Data Product Leaders to develop an overarching data governance framework to successfully manage large amounts of data, ensuring compliance with regulations while maintaining data integrity and accessibility. Develop data engineering best practices, guidelines, procedures, and repeatable and scalable frameworks.

About Icon Media Direct:

Icon Media Direct is a leading brand response media agency obsessed with maximizing ROI for our clients. We are a group of experts in media, technology, relationships and analytics working together to consistently exceed our clients’ expectations. With over 19 years of experience, we pride ourselves in the deep relationships we have built with our clients, partners and employees. Headquartered in Sherman Oaks, CA, Icon Media Direct strives to be an employer of choice, offering competitive benefits and compensation, true work/life balance, and a fun, energetic company culture. We are an organization, truly focused on the growth of our team. With in-depth leadership training, strengths-based coaching and mentorship programs, we foster a culture of continual development and positive collaboration.

Job Duties:

  • A solid and demonstrable understanding of ETL workflows and data warehousing
  • Design and implement secure data pipelines into a Snowflake data warehouse from on premise and cloud data sources
  • Prepare, process and organize data in the warehouse
  • Design and build monitoring and alerting processes to ensure the reliability and data quality of the pipelines and underlying data models
  • Work with product managers, data scientists, and data analysts to design and build data driven product features
  • Design and optimize high performing data models for different consumption patterns from the warehouse
  • Design and implement high performing BI dashboard integrations to leading BI & Visualization tools working with BI developers
  • Design and implement high performing data pipelines feeding downstream systems
  • Troubleshooting, problem solving and performance tuning of data pipelines and queries accessing data warehouse
  • Creation of best practices and standards for data pipelining and integration with Snowflake data warehouses
  • Ensure enterprise security and access control policies are adhered to in the solution
  • Creation of architecture and design artifacts and documents
  • Conduct design and code reviews
  • Work with Business Analysts and Users to translate functional specifications into technical requirements and designs
  • Preferred experience with cloud-based ETL tools (Matillion, Fivetran)
  • Experience with Python and Spark (PySpark or Scala)
  • Experience using Git for version control

Education and Experience Requirements:

  • 5+ years of experience in multiple of the following areas: distributed systems, data warehouse, data infrastructure, product development, analytics applications, machine learning
  • Experience in troubleshooting large scale data platforms, such as ingestion and data pipelines
  • Experience in building dashboards for diagnostics
  • Expert knowledge in SQL
  • Strong development skills in Python (preferred)
  • BS/MS in Computer Science or related majors, or equivalent experience

Other Considerations: 

  • Salary based on skills and experience
  • Skills will be tested upon interview
  • All applicants are subject to background checks and offers of employment will be pending the verification of information listed on application
  • All applicants will need to provide a list of professional references

Icon Media Direct is an Equal Opportunity Employer