Nanigans is currently seeking a Business Intelligence Software Engineer. In this role, you'll be responsible for design, development, enhancement and support of the Data Warehouse system. The candidate must be strong in BI technologies and possess strong process automation experience, real-world production deployment and production support experience, and strong communication skills, both written and verbal.
Aggregates data across hundreds of sources for interpretation, both internally and externally
Analyze existing data structures for reusability, coding standards, technical design specifications and extracts
Troubleshoot, debug, tune and optimize ETL performance
Identify data discrepancies and data quality issues
Work to ensure data consistency and integrity
3+ years’ experience in RDBMS (MySQL, Postgres, Vertica etc)
Experience with Database Warehousing Design Concepts; Dimensional Modeling, Star/Snowflake Schemas, ETL/ELT, Data Marts, Analytic Playgrounds, Reporting techniques, etc.
Proficient in Unix.
Knowledge of mainstream BI tools, such as Tableau is nice to have, but not required
Experience in NoSQL (HBase, Cassandra, CouchDB, etc)or similar architectures
Proficient in automated testing practices
Previous experience in advertising highly valued
At Nanigans, we are taking an active role in shaping the future of social advertising. We are looking for dedicated people with a strong sense of urgency and appetite to learn. In addition to our competitive compensation package, each full time employee receives stock options, onsite product training, paid continuing education through Intelligently and top tiered health and dental insurance benefits. Backed by Avalon Ventures, Nanigans corporate headquarters is located in the heart of downtown Boston, with additional office locations in San Francisco, CA and New York, NY and London.
Based on experience.
• Daily catered lunch and all the snacks and coffee you could imagine
• Playing (err, testing) Facebook apps and games is part of your job
• Enjoy spectacular views of the Boston skyline, Boston Common, and the State House
• Includes healthcare and dental insurance
• The chance to take a leadership role in a company and industry at the cutting edge of technology