BI Solution Engineer


Media, PA Hybrid Aug 22
Apply now

The primary role for the Business Intelligence Solutions Engineer is to provide technical and business expertise in integrating data from a variety of source systems and presenting it through an array of self-service applications. The BI Solutions Engineer will support all development efforts including data analysis, data modeling and data design tasks as well as the creation of metrics and attributes to be consumed by interactive dashboards and data visualization tools like MicroStrategy, Tableau and other BI tools that are widely used throughout the organization. Additionally, the BI Solutions Engineer will be instrumental in the creation of optimal reporting structures at the database for ongoing reporting and analytics. Will be partnering with the data engineers to translate business requirements into data requirements and structures for schema creation.

Principal Duties:

  • Convert business requirements into reporting rata layer design for business intelligence tools.
  • Provide technical requirements to data engineering team for conversion of business requirements to reporting data layer.
  • Design and develop reporting data layer for business intelligence tools like MicroStrategy and Tableau using big data platform databases / querying (Impala, Hive, Kudu) as well as modern cloud data warehouse like Snowflake. Ensure system scalability, security, performance, and reliability.
  • Perform data analysis, data modeling and data design tasks/transformation on complicated datasets with potentially complex data integration scenarios related to reporting.
  • Build data structures/database objects and data blending technologies to support data harmonization and provide data to MicroStrategy / Tableau/PowerBI and other BI tools.
  • Develop/maintain views (metrics, attributes) for use across queries, dashboards, self-service templates and standard reports.
  • Design, develop and deploy business intelligence backend structures (Materialized views, Tables etc) necessary for data analysis and report development to support business requirements, ensuring system scalability, security, performance, and reliability.
  • Responsible for creating and designing database coding structure (in DDL - Data Definition Language), including the classification, naming and design of the database (including independent decision making for data normalization techniques as an example).
  • Design and implement improvements in BI architecture, team processes and functions.

Essential Functions:

  • Excellent oral and written communication skills
  • Excellent customer service skills
  • Ability to work with little or no supervision
  • Detail-oriented and excellent organizational, time and stress management skills
  • Excellent analytical and problem-solving skills
  • Ability to handle multiple projects simultaneously and independently
  • Excellent interpersonal skills
  • Proven self-starter with demonstrated ability to make decisions
  • Ability to be on-call 24/7 when required
  • Proactively shares new learning with others in order to improve organizational efficiencies
  • Assists in cross-training others to ensure coverage and shared departmental knowledge
  • Proven ability to learn quickly and independently train themselves on existing and new technologies and technology platforms
  • Proven project management skills and adherence to deadlines
  • Ability to facilitate inter-team issue resolution
  • Offers technical expertise, feedback or advice as a valuable resource to others
  • When prioritizing work, considers the bigger picture, ensuring alignment with department objectives
  • Work collaboratively with cross-functional teams
  • Ability to work in a fast-paced, team environment

Basic Qualifications:

  • Bachelor’s degree in Information Technology or a technical discipline (e.g., engineering) preferred
  • 8+ years database, data integration experience
  • 3+ years’ experience with Hadoop, SQL and Big Data solutions
  • 5+ years’ experience in designing and implementing the data structures (conceptual, logical, physical & dimensional models) for reporting tools like MicroStrategy, Tableau or any reporting tools
  • Supporting data enablement for enterprise Business Intelligence solutions using one or more of the following EDW platforms: Big Data Platforms / HANA / BW / Snowflake
  • Development experience in using Big Data solutions using open source technologies within the Hadoop ecosystem such as: Impala, Hive, Spark, Pig, etc.
  • Strong knowledge of scripting to support data requirements
  • Strong knowledge of reporting related data security principles
  • Proven track record working with complex, interrelated systems and bringing that data together on Big Data platforms.
  • Deep background in database (Snowflake,Hana,Hadoop) models and SQL
  • Be knowledgeable in visualization tools data requirements for Microstrategy / Tableau
  • Heavy, In-Depth Database Knowledge – SQL and NoSQL.
Retirement & Stock Options Benefits
  • 401k with company contribution
  • Company Equity
  • Financial Planning Services
  • Access to Coaching (Health, Professional, Life)
  • Community Service Programs
  • Hybrid Work Options
  • Pet Insurance
  • Public Transportation Assistance
  • Relocation Assistance
  • Accessible Building
  • Accessible Devices
  • Accessible Work Environment
  • Job Modification
Perks & Discounts
  • Bring Your Own Device Reimbursement
  • Casual Dress
  • Cell Phone Reimbursement
  • Lunch Provided
  • Offsite Company Events
  • On Site Gym/Fitness
  • Special Discounts
Parental Benefits
  • Childcare Assistance Programs
  • Family Medical Leave
  • Nursing Room
  • Commitment to Work/Life Harmony
  • Flexible Work Schedule
  • Paid Holidays
  • Paid Sick Days
  • PTO
Health & Wellness
  • Dental Insurance
  • Employee Assistance Program (EAP)
  • FSA
  • Gym Reimbursement/Discounts
  • Health Insurance
  • HRA
  • HSA
  • Life Insurance
  • Long Term Disability
  • Mental Health Benefits
  • Onsite Gym
  • Short Term Disability
  • Vision Insurance
Professional Development
  • Employee Recognition Programs
  • Tuition Reimbursement
What types of technologists are you looking to hire? As we continue our digital transformation, we’re looking to hire an incredible team of technologists to build the back-end features and functionality of our platform, including: Senior software engineers Lead software engineers Platform engineers Platform architects Security engineers Risk and compliance Forensic analysts SCRUM masters   What is your tech stack? We are always exploring new technology and languages to see how they can benefit our platform. Right now we’re working with AWS, Java, Kubernetes and Golang on the back-end and ReactJS on the front-end. It can surprise people who only think of Wawa as a convenience store, but we’re very passionate and proactive about using the latest technology to build our digital experiences. There’s a lot of room for our tech team to try new things and bring them to the table.   Tell us about what it's like to work at Wawa HQ. Wawa is a people-first organization, which means we care about our people over everything else and treat them fairly. The culture is very supportive and collaborative — everyone works together. And, we really give you the opportunity to spread your wings. We have many people who have worked here for 15 to 40 years, which says a lot. You can go to the cafeteria and eat lunch next to the CEO. It’s the kind of place where everyone is happy to come to work on a Monday morning. And there’s coffee everywhere.   How does Wawa give back? Wawa proudly gives back through The Wawa Foundation, a 501 (c)(3) non-profit corporation focused on building stronger communities in three areas of health, hunger and everyday heroes. Since its inception in 2014, The Wawa Foundation has contributed more than $100 million to non-profit community organizations. Wawa and The Wawa Foundation are proud to support seven National Partners with in-store customer fundraising campaigns and provides its associates with year round volunteer and participation opportunities with waived registration and fundraising at community events such as JDRF One Walks, LLS Light the Night, Special Olympics Polar Plunges, among others. At Red Roof, our corporate campus, our associates support some mentoring programs directly including  a  Big Brother, Big Sister program called Beyond School Walls that brings kids into HQ to get on-the-job mentorship in a real world environment, as well as a partnership through Cristo Rey High School that also pairs high school students with job opportunities.  Our Product Development team hosts Future Food Scientist workshops giving middle schoolers from throughout our communities a closer look at careers in the food sciences.