As our Business Intelligence Developer you will report to the Data and BI division of Oriental Trading Company and provide data solutions to stakeholders throughout the company.  This role emphasizes Tableau development while also covering broader BI and data engineering responsibilities.  This position will work with data engineers and business stakeholders to gather requirements, develop, test and deploy reporting solutions. 

This position is located onsite in Omaha, NE.

Principal Duties and Responsibilities

Essential Functions

1. Convert business needs into clear, actionable technical specifications for structural changes and reporting solutions. 
2. Create interactive Tableau dashboards and reports to address evolving business requirements. Assist in decommissioning legacy reporting systems by migrating them to Tableau. 
3. Manage Tableau Server, including user permissions, data source publishing, performance tuning, scheduling, and health monitoring. 
4. Oversee software upgrades, apply patches, enforce security protocols, ensure data governance compliance, and collaborate with IT on infrastructure and deployment. 
5. Perform logical and physical data modeling to support business intelligence initiatives. 
6. Design, deployment and maintenance of BI and Data systems ensuring scalability, performance, and reliability. 
7. Build and maintain data pipelines, semantic data models, and reporting layers to support a wide range of analytics use cases. Develop business insights into all categories of data. 
8. Query and database structure optimization using SQL as it pertains to the Cloud data warehouse is required. 
9. Collaborate with stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs. 
10. Act as liaison between the business areas and IT. 
11. Maintain detailed documentation on processes and procedures. 
12. Abide by all policies and procedures of Oriental Trading Company. 
13. Main regular and predictable attendance.
14. May be required to perform any of the above functions at any of the company locations.

Marginal Functions

1. Support the SAS application for generation of statistical customer models. 
2. Support Informatica cloud ETL processes. 
3. Assist in the setup of new users with database toolsets and security access requests to the infrastructure admin areas. 
4. Performs other related duties and projects as assigned. 
5. Build relationships with team members that promote free knowledge sharing and personal development which improve cross training among team members
6. Perform other related duties and projects as assigned.

Here’s what you need to join the fun:

Knowledge, Skills, and Abilities

Education

• Bachelor’s Degree in a quantitative field such as Computer Science, Mathematics, Statistics, Marketing, or related field or equivalent combination of education and experience. 

Experience

• 3 to 5 years database reporting and analysis, information technology, or related experience, supporting small to mid-size databases and reporting solutions.  

Other Qualifications

• Experience in both relational and multi-dimensional data modeling and architecture in traditional or Cloud database environment – Snowflake preferred but not required. 

• 3+ years of experience in BI development with hands-on experience in Tableau Desktop and Tableau Server administration  

• Intermediate level SQL required.  

• Experience with cloud base architecture, data migration and data analytics preferred. 

• Informatica IICS / Unix/Linux Scripting is a plus. 

• Experience in Python/R/SAS is a plus 

• Experience with waterfall and agile project management methodologies 

• Ability to communicate technical details in a clear manner 

• Exceptional analysis and problem-solving capabilities 

• Able to work independently and under tight deadlines 

• Understanding of data measurement, database structure and spreadsheets 

• Understanding of direct marketing principles, a plus 

• Excellent written and oral communications skills 

• Advanced knowledge of MS Access/Excel

Join us at Oriental Trading, a Berkshire Hathaway Company, where fun means business! 

Oriental Trading Company (www.orientaltrading.com), is the nation’s largest direct retailer of value-priced party supplies, arts and crafts, toys and novelties, and a leading provider of teaching supplies and affordable home décor and giftware. Founded in 1932 by a Japanese American, the Oriental Trading history of fun spans the better part of the last century. Today, Oriental Trading offers more than 60,000 products to individuals, teachers, schools, churches, businesses and nonprofits. With a corporate vision to “Make Life More Fun,” Oriental Trading (a Berkshire Hathaway company) spreads joy and smiles to millions each year through a robust family of brands; Oriental Trading, Fun Express, MindWare, SmileMakers, Morris Costumes and halloweenexpress.com.

EOE