Sr. Software Engineer (Data)-3937

FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and sales channels. As a global company, we have offices in nine countries and can insert advertisements around the world.

Job Summary

Job Description

DUTIES: Provide technical leadership in designing and developing new software and data warehouse; manage large datasets using Snowflake, Atlan, and DBT (Data Build Tool); query data using Spark SQL, MySQL, Presto, Snowflake and Clickhouse; automate ETL processes using Airflow; work with OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) systems; work with programmatic advertising features including real-time bidding and algorithmic decision making, and integrate them with demand side platforms (DSP) and supply side platforms (SSP); develop software using Java and Scala; process data and automate tasks using Python and Shell; build ETL pipelines using Spark and Databricks; support applications under development and customize current applications; assist with the software update process for existing applications, and roll-outs of software releases; analyze, test, and assist with the integration of new applications; document all development activity; research, write, and edit documentation and technical requirements, including software designs, evaluation plans, test results, technical manuals, and formal recommendations and reports; monitor and evaluate competitive applications and products; review literature, patents, and current practices relevant to the solution of assigned projects; collaborate with project stakeholders to identify product and technical requirements; conduct analysis to determine integration needs; work with the Quality Assurance team to determine if applications fit specification and technical requirements; and guide and mentor junior-level engineers. Position is eligible to work remotely one or more days per week, per company policy.

REQUIREMENTS: Bachelor's degree, or foreign equivalent, in Computer Science, Engineering, or related technical field, and five (5) years of experience managing large datasets using Snowflake, Atlan, and DBT (Data Build Tool); querying data using Spark SQL, MySQL, Presto, Snowflake and Clickhouse; automating ETL processes using Airflow; working with OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) systems; working with programmatic advertising features including real-time bidding and algorithmic decision making, and integrating them with demand side platforms (DSP) and supply side platforms (SSP); of which three (3) years include developing software using Java and Scala; processing data and automating tasks using Python and Shell; and building ETL pipelines using Spark and Databricks.

Disclaimer: This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications.

Skills
Data Building Tool, MySQL, Spark SQL

We believe that benefits should connect you to the support you need when it matters most, and should help you care for those who matter most. That's why we provide an array of options, expert guidance and always-on tools that are personalized to meet the needs of your reality-to help support you physically, financially and emotionally through the big milestones and in your everyday life.

Please visit the benefits summary on our careers site for more details.

Comcast is an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other basis protected by applicable law.