Software Engineer, Internal BI
Company
DV is the leader in digital performance solutions, improving the impression quality and audience engagement of digital advertising. Built on best practices, DV solutions create value for media buyers and sellers by bringing transparency and accountability to the market, ensuring ad viewability, brand safety, fraud protection, accurate impression delivery and engagement quality across campaigns to drive performance. Since 2008, DV has helped hundreds of Fortune 500 companies gain the most value out of their media spend by delivering best in class solutions across the digital ecosystem that help build a better industry.
Position Overview
The Performance Insights Senior Data Engineer will be in-charge of ongoing efforts to develop DV’s internal BI system. The ideal candidate will have extensive experience in designing data systems which incorporate DWH methodologies, ETL processes, reporting tools and dashboards. The candidate will have the ability to understand the company needs, translate them into technical requirements, design a relational data model as well as the database schema and will have the ability to develop the system, deliver it all the way to the production environment, write unit tests, and ensure adequate monitors are in place.
In addition, The candidate will participate in designing and coding the infrastructure for automating the entire system life cycle
Job Responsibilities
- Develop the infrastructure that enables the delivery of data and insights to DV’s senior management and DV’s operational teams
- Gather business requirements received from the product management department, translate them into technical requirements
- Work closely with various teams using the Internal BI solution (Finance, Sales, etc…)
- Write technical design documents
- Create deployment roll out plans
- Break down development tasks into manageable sub tasks.
- Perform manual and programmatic unit and integration tests
- Be responsible for adding the relevant monitoring
- Manage releases of new software versions
- Develop and maintain DV’s BI system ETL processes
- Develop reports and dashboards
Minimum Qualifications
- 4 years of ETL and SQL writing experience
- 3 years in designing DWH systems from scratch
- 2 years of reporting tools experience
- 1 year of OOP programming
- Experience with writing Unit tests
- Team player
- Business oriented
- Responsible and Independent
- Participate in on call rotation as necessary
Preferred Qualifications
- AdTech domain proficiency
- Hadoop experience
- Luigi/Airflow framework experience
- Agile development methodology experience
- Passionate about technology
- OLAP cubes experience