Senior Developer, BI Data Services

Aspire Bakeries is a North American baking company with a leadership position in specialty frozen baked goods. Formed from leading bakery companies, its innovative food portfolio includes breads, artisan breads, buns, cookies, donuts, muffins and pastries from beloved brands like La Brea Bakery®, Otis Spunkmeyer®, and Oakrun Farm Bakery®. With 13 bakeries in North America, we are committed to driving innovation, predicting upcoming consumer trends and flavors, and exceeding our customers’ expectations. Aspire Bakeries champions the values of Integrity, Ownership, Customer Focus, Creativity and Care to help us deliver on People Safety, Food Safety, Quality and Collaboration.

Position Purpose

• The Sr Developer, BI Data Services role is a part of the Business Intelligence & Data Analytics Services (BI & Analytics) function within IT accountable for the delivery of data and reporting to the wider organization in collaboration with other functional departments and reports to the Director BI & Analytics. This is a multi-dimensional role with aspects of Analysis, Configuration and Development, QA, and Product Management skills needed to manage, hands-on deliver and support the data ecosystem at Aspire Bakeries.      
• The Sr Developer, BI Data Services will lead and or execute the development and implementation of data systems and services which support the Aspire Bakeries data, analysis, and reporting needs. The incumbent will design and develop the systems and oversee components which will enable Aspire to build, maintain, and grow an enterprise data services layer. The incumbent will primarily perform design and development activities, conduct technical analysis, testing, build implement data solutions and provide system performance support that enhances the ability of the organization to consume data and understand the information presented.
• The incumbent will also work on multiple projects, provide guidance, and support to other team members and collaborate with other functional departments and IT team members to ensure data needs are being met. The incumbent will serve as a subject matter expert for inquiries regarding data assets including data sources, reporting datasets, and assigned reports and solutions. Additionally, they will identify opportunities and risks in business processes, provide recommendations and contribute to recommendations for improvements including working with other teams and or vendor partners.

Key Accountabilities

• Lead data layer design, build/configure/develop, and support for data sets/marts/warehouses/lakes along with certain reporting solutions. Hands on development of reports included.
• Manage the lifecycle of each data and reporting asset including changes, enhancements, and upgrades to ensure optimal operations.

• Support any issues that arise from the data systems and reporting solutions working in collaboration with the wider IT and functional teams.

Responsibilities

• Execute the design, build and implementation of enterprise-grade data solutions for large-scale, multi-tenant data systems and solutions including data warehouses, data marts, and data lakes.  Provide data services to applications and integrations.
• Perform complex systems development and design work including logic and architecture design for on-premise and cloud-based data solutions. Produce high-quality, well architected solutions with an upfront focus on testing and long-term support.
• Analyze and identify source-to-target mappings, develop ETL/ELT specifications, and perform ETL/ELT development, deployment, and monitoring for enterprise data warehouse systems.
• Executes Data Services strategy utilizing modern data technologies including Cloud data platforms and services (eg. Azure, AWS, GCP, SAP), data pipeline tools, and analytics services.
• Delivers on Business Intelligence & Analytics strategy for assigned domains leveraging SAP Business Warehouse, Business Objects (BW 7.5 on HANA, BO Enterprise, Analysis for Office, Lumira Designer & Discovery and WebI), PowerBI and drive alignment with business partners for execution support.
• Own technical responsibility for assigned BW backend data architecture for SAP and non-SAP data sources.
• Review completion and implementation of system additions and/or enhancements and make recommendations for future development.
• Create ETL/ELT pipelines to deliver data to stakeholders, while maintaining high accuracy and reliability. Includes development along with other ETL/ELT technologies and best practices.
• Collaborate with engineering and business stakeholders to understand data requirements. Also coordinate activities to facilitate internal and user acceptance testing.
• Interact and integrate with internal and external teams and systems to extract, transform, and load data from a wide variety of sources.
• Perform and support query optimization (for performance and/or cost reduction) and development (query design and optimization).
• Design and build BI reports & queries using applicable SAP, Business Objects, PowerBI, or other existing reporting tools.
• Provide Production support for existing BI applications and systems. Resolves second and third tier Help Desk tickets related to data sources, data warehouses, and reporting solutions; troubleshoot data issues, ETL/ELT chains, and reports. Provides daily technical and functional support as well as during maintenance.
• Maintains day-to-day tracking and follow-up on issues and questions of daily operations, includes tracking, updating, and resolving issues.
• Keeps abreast of tools, methods, and techniques, thereby acting as an internal resource for Data technologies and solutions.
• Participate in the design and planning of projects in conjunction with the external partners and other IT members.
• Responsible for supporting and adhering to data & reporting standards and frameworks ensuring consistency and quality.
• Contributes to the definition, design, and development of the BI solution information model.
• Drive workshops or training sessions with the business user community to further their knowledge and use of Data, Reporting, and Visualization tools.
• Additional duties as required, assigned by supervisor or management.

Skills, Experience & Qualifications

• Firm understanding of and experience with data concepts such as data mining, in-memory analysis, big-data analysis modeling and related best practices.
• Ability to develop business metrics, business requirements, and user acceptance test scripts preferred.
• Ability to work with mathematical concepts such as probability and statistical inference.
• Ability to effectively and succinctly simplify complex data and communicate information to senior management.
• Ability to identify, analyze, and resolve problems logically and systematically.
• Ability to assess and understand the impact of technical decisions and architectural changes.
• Experience working within a software development lifecycle utilizing project and product management techniques including Agile or similar methodology.
• Ability to demonstrate an organized and systematic approach in carrying out assignments (i.e., very orderly and excels at cutting through confusion and turning chaos into order).
• Ability to multi-task effectively without compromising the quality of the work.
• Excellent interpersonal, oral, and written communication skills.
• Detail-oriented, organized, process focused, problem solver, proactive, ambitious, customer service focused.
• Ability to draw conclusions and make independent decisions with limited information.
• Ability to respond to common inquiries from customers, staff, regulatory agencies, vendors, and other members of the business community.
• Self-motivated, reliable individual capable of working independently as well as part of a team.
• Excellent leadership, customer and internal communication, negotiation, continuous improvement mindset, and team building skills.
• Able to work independently and manage tasks appropriately.
• Ability to function strategically and handle multiple projects simultaneously.
• Proficient in computers including MS Office, Spreadsheets, statistical programs, and SAP applications.
• Good professional and technical writing abilities, analytical, and critical thinking skills
• Detail oriented and possess strong computer skills.
• Reliable and motivated to drive improvements in a challenging environment.

Education, Technical Qualifications, Experience and Competencies Proficiency Level:

Required

• Bachelor’s Degree from an accredited college in related field or equivalent work experience in quantitative and engineering discipline. In lieu of degree, 7+ years of experience or the equivalent combination of education and experience.
• 5+ years of experience in Business Intelligence/Decision Support/Data Engineering/Data Warehousing roles working with multiple disparate, large, complex datasets.
• Advanced knowledge of and experience in Data Warehouse concepts (modeling, tuning, maintenance), data modeling, SQL, ETL/ELT technologies.
• 5+ years of proven system/application experience in building SAP BW and BI solutions.
• Experience in business analytics, e.g., enterprise reporting, executive dashboards, scorecards, alerts, subscription push reporting, etc.
• Strong knowledge & experience in SAP BW & HANA modeling, ABAP/4, and AMDP code design and development including ABAP Programs, Custom Objects, and HANA Views.
• Hands-on experience with ABAP to write Datasource Enhancements Function module, extractors Transformation Routines; Experience in writing Transformations using AMDP scripts.
• Strong experience with BI analytical tools (PowerBI or similar) and Business Objects (Analysis for Office AO Reports, WebI, Design Studio) based development integrated with an SAP BW and non-SAP environments (SAP as the primary data source). SAP Datasphere, SAP Analytics Cloud, Tableau a plus.

Preferred

• Bachelor of Science or Masters degree in Computer Science, Software Engineering, Computer Engineering, Information Systems, or similar fields of study
• 7+ years of experience with SAP BW and BI solutions with detailed understanding of SAP BI technology and its application.
• 3+ years of experience with Cloud data platforms and services building Data Marts/Warehouses/Lakes, Pipelines, and Datasets utilizing Microsoft Azure, AWS, Datasphere.
• Experience with ERP systems and familiarity with Manufacturing industry processes along with Supply Chain
• Experience with modern reporting and analytics tools such as Business Objects, PowerBI, Tableau, Domo, Qlik, Looker, Alteryx.
• Experience in advanced analytics, e.g., corporate performance management, predictive analysis, etc.
• Exposure to cloud architecture for BI, Data Warehousing, Data Marts, Data Lakes, in-memory data exploration tools, and other data warehousing analytics solutions
• Experience managing large volumes of data and designing/building/optimizing for performance.
• Work experience with External Partners or 3rd Parties in an offshore/onshore delivery model.
• Experience working with Python, R, particularly for ETL or Data Science related tasks.
• Ability to Identify, propose and influence technology solutions to improve and maintain optimal data and architecture to support business requirements.
• Some background in data structures, algorithms, and debugging.

Aspire Bakeries is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.