Description
ABOUT THE PRODUCT AND ENGINEERING TEAM
Centro is building the world’s most respected product and engineering organization. This is a bold claim, and one we do not make lightly. Of course, we can back it up: Ad Tech is one of the hottest technology sectors today, with the worlds most distinguished product and engineering organizations vying to be the first to truly and forever disrupt a $200 billion industry.
Of course, delivering technology that changes the way an industry does business requires a massive product, design, and engineering effort. To do our heavy lifting, we attract talent from an array of disciplines to work in highly-collaborative, agile, cross-functional teams. Together we tackle the complexity of scale that comes from performing 30 billion transactions per day. We innovate with machine learning and Big Data solutions to deliver optimized campaign performance and recommendations. We create elegant user interfaces that unite all the functions of our platform into one, seamless, intuitive, and delightful experience.
Together, we are winning advertising tech, will you join us?
ABOUT THE TEAM
The Data Ops team is responsible for transforming Centro's data into actionable information across the organization. This ranges from daily performance reports to real-time historical analysis. Currently we use the Pentaho suite as our business intelligence platform and PostgreSQL for our database platform. We believe in Agile software development and use Scrum as our project management methodology. 'Inspect and Adapt' is more than just a catch-phrase to us. We are willing to have every problem under the sun exactly once, in exchange for never having the same problem twice.
ABOUT THE ROLE
Centro is looking for talented, passionate Data Warehouse Engineer with the skill and desire to contribute to our business intelligence team. Centro’s technology focuses on improving streamlining the entire digital media process, from research thru trafficking, with focus on each step in between. We are seeking talented Data Warehouse Engineer that can help transform the data created from these activities into actionable information. We aim to derive meaning from our data that enables us to run our business better, and also equips our clients to advertise smarter. If you have experience working with large data systems, then we would love to talk with you. If you are the type of person who comes to work every day expecting to learn, contribute, teach, and have fun, then we think you will fit right in.
CORE RESPONSIBILITIES
As part of our business intelligence team you are going to collaborate to solve real-world business problems that Centro is tackling. You'll be working with all parts of the BI stack. This ranges from design, implementation and support of our data warehouse all the way through how our end users consume information we generate. You'll work closely with business users, data analysts and software engineers to design and implement data integration flows into the enterprise warehouse.
- A qualified applicant should be familiar with a variety of the data warehousing concepts and practices.
- At a basic level, you can translate business intelligence needs into a system design and then implement it.
- You have the capabilities to extend a given BI tool's out-of-box functionalities to provide better user experiences, if that is called for.
- You enjoy working directly with the people that use these reports and know how to manage their expectations.
- We expect that you will contribute to the culture of learning and continuous improvement on the team.
- Also, if you don't already have it, that you will build strong business domain knowledge related to online advertising, campaign planning and execution, ad serving technologies and related topics.
QUALIFICATIONS
- You have 5-10 years of end-to-end experience with data warehousing and BI systems (including data modeling, ETL architectures and OLAP).
- You've designed, built, and supported data warehouses.
- You have a strong understanding of dimensional modeling and other data warehouse techniques.
- You have the ability to quickly understand business requirements and transform them into data models.
- You have experience developing and implementing ETL processes, and dealing with performance and scaling issues.
- You have strong database and SQL skills. (We use PostGreSQL, but experience with similar database platforms works for us.)
- You have experience in scripting languages (perl, python, javascript, etc)
- You are knowledgeable in Java (We use Pentaho as our BI platform)
- You have expertise in job scheduling, data quality, metadata management and monitoring systems.
- You have excellent written and verbal communication skills, with an ability to express business concepts in technical terms (and vice-versa).
- You are able to help troubleshoot problems and resolve issues.
Bonus items:
- You have experience with Ruby
- You have experience with the Hadoop eco-system (HDFC, MapReduce, Hive, Pig, etc).
EDUCATION
- No degree can substitute for aptitude, attitude, and integrity so we have no such requirement. Bachelor’s degrees in business, economics or other related field are nice to have. An MBA, or other advanced degree related to position, is a strong bonus.
ABOUT CENTRO
Centro provides unified, cloud-based software to simplify digital media operations. Our media management platform streamlines and scales ad buys across all channels, accessing both guaranteed and biddable inventory, to achieve any campaign objective. Our holistic approach gives marketers a single system of record to fulfill their research, planning, buying, optimization and reporting needs. Since 2001, Centro has successfully planned and executed more than 100,000 national and local campaigns across all digital display platforms and ad format types. Headquartered in Chicago with 33 offices in North America, Centro's success and commitment to culture has led to many accolades, including #1 on Crain's Best Places to Work in Chicago in 2011, 2012, 2013 and 2014.
***Centro is an Equal Opportunity Employer and does not discriminate against any employee or applicant on the basis of race, gender, age, disability or any other basis protected under the law.***
