Software Engineer – Business Intelligence and Data Integration | AppNexus Inc. | New York, United States

Software Engineer – Business Intelligence and Data Integration | AppNexus Inc. | New York, United States

Software Engineer – Business Intelligence and Data Integration (New York) Engineering | New York, United States

Send Jobvite

Team Description:
Each day, AppNexus transacts billions of ad impressions and millions of dollars.  The Business Intelligence team builds the tools that provide our business insight into the wealth of information generated each day.  We’re a small, agile team, and we’ve got the resources to work from a blank slate on new solutions.  Our team is looking to build a new business intelligence system from the ground up that will integrate across several existing internal data sources and consolidate all relevant information into a data warehouse where reports and analyses can be run.
Not only is this a challenging big data role, it is also an excellent opportunity to gain insight into how a leader in advertising technology operates.  As an engineer on this team, you’ll be working on the tectonic fault lines of several teams: data, finance, services, and engineering – you’ll be expected to learn our business as you go.  Due to the exchange-like nature of our business, you’ll be working with billions of rows of complex multi-dimensional data.
We’re just standing up this next iteration of our business intelligence system and team – this is an excellent opportunity to be involved in early design and tech decisions, to be a key contributor, and to have growing responsibilities as our system and team expands.
Role description:
You’ll be working with a Product Manager, Data Architect, and other engineers to create a new business intelligence solution for our company.  We’re looking for an engineer who is able to implement data models and data integration solutions that leverage enterprise open-source software tools.  You’ll work on financial cost and revenue reporting, assist in technology selection, data modeling, and design and implementation of the data warehouse and ETL components.
Responsibilities:

• Write efficient, enterprise-level code that populates the data warehouse in a reliable, testable, and fail-proof manner, integrating multiple data sources such as Vertica, MySQL, Salesforce, ERP and APIs
• Model data and create schemas that suite the needs of various tasks, such as reporting, scenario testing, and business analysis
• Write readable, testable code using Java and/or Python
• Ensure the system operates efficiently and meets SLAs by optimizing queries and key components
• Assist in the design and implementation of data warehouse
• Understand the nature of our business, and use this knowledge to inform all data & design decisions
• Work on a small, agile team to generate requirements and break up work into sizeable chunks

Requirements:

• 3+ years of software engineering experience, developing enterprise class software systems
• Superior coding skills in Java and/or Python
• Strong SQL skills
• Key contributor on projects involving ETL, data transformation, and data integration
• Experience data modeling for both SQL and no-SQL databases
• Exposure to Big Data : Hadoop, Cassandra etc.,
• Experience with one or more databases – PostgreSQL, MySQL, Vertica

What we look for:

• You want to be part of an organization with a transparent and agile environment and a clear communication path between your team and the CEO where you can communicate freely and openly.
• You are hands-on when designing applications and are comfortable coding off of not only a formal spec, but also a problem statement.
• You look for novel and creative solutions to complex problems.
• You are an independent thinker who is self-motivated and thrives in a fast-paced work environment.
• You are passionate about and thrive in a culture of learning and teaching – you are both open minded to others’ opinions and take opportunities to help and teach colleagues.

What's in it for you:

• Industry-changing work – build bold solutions to some of today’s most exciting technical challenges.
• Significant impact from your very first day thanks to our rapidly growing scale and agile engineering teams.
• Competitive benefits package, with plan options to design the coverage to fit your life — highly subsidized health, dental and vision insurance coverage from day one, fully vested employer-matched 401(k), company-seeded health savings accounts, back-up childcare, pet insurance, and much more.
• Global presence – AppNexus has offices around the world: Manhattan, San Francisco, Seattle, Portland, London, Paris, Hamburg, Toronto, Sydney, and Singapore. Engineers are primarily based in Manhattan and Portland.
• Regular access to industry events - AppNexus hosts many technical meet-ups and speakers on site.
• We are a technology company at heart. Our founders can hold their own in architecture discussions with the team. Occasionally, our CEO even checks-in bug fixes to the ad server codebase.

The other perks:

• Great Technology: Any computer of your choosing. Most of our team develop using retina displayed MacBook Pros, with multiple monitors for additional screen real estate.
• Free Food: Every office has fully-stocked kitchens featuring bagels each morning, as well as healthy and tasty snacks, drinks, and coffee throughout the day. Family Lunch Fridays – AppNexus provides free lunch for the company every Friday.
• Career Development: AppNexus offers a variety of internally-developed learning sessions, customized workshops, and robust professional development programs to help you strengthen your potential, develop new skills, grow your career and make greatness happen at AppNexus. 
• An Active Development Community: Participate in company sponsored Hackathons, Innovation days and events.
• Speak, Publish, and Patent: Your groundbreaking work will help enhance the engineering brand at an emerging powerhouse technology company.

http://appnexus.com/open-positions?jvi=oS1aZfwM