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.
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.
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
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
Financial Planning Services
Access to Coaching (Health, Professional, Life)
Community Service Programs
Hybrid Work Options
Public Transportation Assistance
Accessible Work Environment
Perks & Discounts
Bring Your Own Device Reimbursement
Cell Phone Reimbursement
Offsite Company Events
On Site Gym/Fitness
Childcare Assistance Programs
Family Medical Leave
Commitment to Work/Life Harmony
Flexible Work Schedule
Paid Sick Days
Health & Wellness
Employee Assistance Program (EAP)
Long Term Disability
Mental Health Benefits
Short Term Disability
Employee Recognition Programs
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.