IT & Data Integrations Specialists

Job Description

Bolla operates 200+ Retail Gas Stations with Convenience Stores (C-Stores) and automotive repair shops. Bolla partners with major food chains like Burger King, Tim Horton, Pizza Hut and Subway.

Bolla is a premier Wholesale and Retail Motor Fuel (MF) supplier in Metro New York and New Jersey areas. Through our Bolla Transport division the company hauls Motor Fuel in both New York and New Jersey areas. We supply MF to our 200+ locations as well as an additional 100 Wholesale Dealers. It also constructs Ultra-Modern and upscale Gas Stations with C-Stores.

Bolla has over one Billion dollars in revenues and employs over 1200 Team Members.

Mandatory Qualifications: and Character Traits

• Bachelors or masters degree in computer science, Information Systems, Information Technology, or a related field.
• Proven experience as an Integration Specialist or a similar role.
• Strong proficiency in MS Excel, with excellent knowledge of SQL1.
• Experience working with diverse database systems
• Hands-on experience with Power BI for data visualization and reporting.

Preferred Qualifications:

• Hands on experience in Data Analytics
• Skilled in VBA Macros
• Experience working with diverse database systems, with a preference for SAP B1.
• Familiar with Python web scraping techniques
• Basic understanding of GL accounting in an ERP system.

Position Responsibilities:

• Integrate data from multiple front-end systems and ensure seamless import into the accounting software.
• Develop and maintain integration controls.
• Implement data security measures to safeguard information.
• Ensure data quality and integrity across systems while developing, troubleshooting, and optimizing Power BI reports and workflows. Analyze data trends, patterns, and anomalies to support integration and resolve business software issues.
• Develop and automate workflows; reporting process and data integration processes using Power Automate.
• Design and create data collection forms with Microsoft Forms. (Create a Ticketing system, to track the issue’s)
• Collaborate with cross-functional teams to align with project objectives and meet deadlines.
• Exhibit strong communication, teamwork, and attention to detail.
• Monitor and maintain data accuracy by implementing validation checks and reconciliation processes.
• Creating dashboards, reports, and charts in Excel/Powerbi
• Work until deadlines are met especially at months’ end.
• Ability to motivate multiple teams to perform and exceed expectations.
• Should be ready to think outside the box.

Technical Experience

• Three years of experience with Microsoft Access database design and development and VBA programming including ETL experience
• Two years of experience with developing Microsoft Automation applications in Excel
• Hands on experience on design or modify software, systems, and applications using Visual Basic
• Experience on VB.NET, Microsoft Access, and MySQL Professional Attributes
• Two years of experience with Access databases and SQL Databases (SQL Server, MySQL, PostgreSQL)
• Must be able effectively write SQL Queries
• Expert in Excel VBA programming and coding
• Technical expertise (demonstrate with examples)
• Knowledge of programming languages like C#, Java, Python, or PHP is a huge plus.