Business Intelligence Analyst at Oriental Trading Company Inc in Omaha, Nebraska

Job Description:

Business Intelligence Analyst

Are you ready for a career where fun means business? Join us at Oriental Trading Company, a Berkshire Hathaway Company!

General Summary of Purpose:

Develop business intelligence in support of corporate initiatives for use by Marketing, Finance, Merchandising, and Executive teams. Solicit, interpret, document, test, and analyze business requirements and transform those into technical requirements. Develop data structures, flows, reporting and analytics to answer business questions. Analyze results and communicate recommendations to guide business decisions in support of strategic goals.

Essential Functions:

1. Document business requirements and convert these requirements into functional/technical specifications for the development of new reporting solutions within the Business Intelligence applications
2. Write complex SQL queries to access data in the EDW (Enterprise Data Warehouse) for report development
3. Design data visualizations and infographics in Tableau to create insights into business trends and guide actionable business decisions
4. Monitor website and digital marketing performance utilizing digital analytics software, vendor UIs, and the EDW
5. Create P&Ls, standard reports, and ad hoc analysis that intersects with multiple areas of the business including e-commerce and catalog marketing channels, website metrics, customer attributes, and merchandise categories
6. Interpret results and advise business teams, sharing insights into data based on the analysis produced
7. Develop a deep understanding of the EDW environment including structure, data flows, and internal business rules that transform data
8. Maintain detailed documentation on processes and procedures
9. Must be able to attend face to face meetings on short or little advance notice
10. Work requires in-person collaboration among colleagues and contractors
11. Abide by all policies and procedures of Oriental Trading Company.

Here's what you need to join the fun:

• Ability to work independently as well as in a team environment
• Advanced ability in SQL coding
• Experience utilizing data visualization tools
• Highly developed knowledge of Microsoft Excel and Access
• Well-rounded experience with data warehouse and relational database concepts and structures
• Ability to work independently as well as in a team environment
• Excellent oral and written communication skills
• Exceptional organizational skills and a high level of problem solving and analytical skills
• Strong focus on work ethics, sense of urgency, quality, thoroughness, accuracy, attention to detail and timeline commitments
• Bachelors degree in Marketing, Finance, Data Science, Statistics, Economics, MIS or related field with emphasis in quantitative analysis or equivalent combination of education and experience
• Master's degree preferred
• Minimum of two years database reporting and analysis, preferably with a multi-million customer database
• Minimum of two years experience using SQL and enterprise reporting tools (Tableau, Crystal, Business Objects, etc.)
• Experience with digital analytics software such as Adobe Analytics, Google Analytics or Acoustic Analytics (formerly IBM/Coremetrics) is highly desirable

To apply in less than ten minutes click the "Apply" button or view a complete list of our current openings at http://www.myotccareer.com

All work and no play just isn't our style. Join us today!

Oriental Trading Company is the nation's largest direct retailer of value-priced party supplies, arts and crafts, school supplies, toys and novelties. Recognized as one of the Top 20 Internet Retailers based on customer satisfaction, Oriental Trading offers over 40,000 products to consumers, educators, businesses and non-profit organizations. Oriental Trading employs approximately 1,600 employees and makes the world more fun with items ranging from pink flamingos and wedding favors to holiday decorations, educational games and crafts.

EOE

Apply Now