Data Analyst - Excel Automation & BI Specialist - Remote

Overview

Eggs Unlimited is one of the world’s largest suppliers of eggs, servicing the biggest retail and food manufacturing companies around the globe. Every day, we find homes for millions of eggs by tapping into our vast supply chain and customer networks. Bringing sellers and buyers together in fair market negotiations, we open up a world of possibilities for expanding their knowledge, reach, and access. With dedicated service teams and a mission to uphold transparency and trustworthiness, we create quick and creative solutions to help manage the ever-evolving demands of the global egg industry.

In Short

• Develop and execute a forward-thinking technology roadmap aligned with business objectives.
• Design and implement Power Query workflows to clean, transform, and consolidate Excel datasets.
• Develop Python scripts (using Pandas, OpenPyXL, etc.) to automate complex data cleansing and manipulation tasks.
• Build and maintain Power BI dashboards and reports that provide actionable insights to stakeholders.
• Leverage Microsoft Power Platform tools (Power Apps, Power Automate, Power BI) to enhance data workflows and reporting.
• Collaborate with cross-functional teams to understand data requirements and deliver scalable solutions.
• Optimize data pipelines and ensure data integrity across systems and reports.
• Document processes, data flows, and technical specifications for future reference and training.

Requirements

• Proven experience with Power Query in Excel or Power BI for data transformation.
• Proficiency in Python, especially with libraries like Pandas, NumPy, and OpenPyXL.
• Strong knowledge of Excel, including advanced formulas, pivot tables, and data validation.
• Hands-on experience with Power BI for data modeling, DAX, and interactive visualizations.
• Experience with Microsoft Power Platform including Power Apps, Power Automate, and Power BI.
• Ability to work with large datasets and perform data quality checks.
• Strong analytical thinking and problem-solving skills.
• Excellent communication and documentation abilities.
• Experience with Microsoft Dynamics 365 Business Central (BC), particularly in extracting and reporting on financial or operational data preferred.
• Familiarity with Power BI integration with Dynamics 365 BC, including using OData feeds, web services, or API connections preferred.
• Experience working within a Microsoft Azure tenant, including integration with Azure-based data sources and services preferred.
• Experience with Azure Data Lake for scalable data storage and analytics, SQL or other database querying languages and knowledge of ETL tools or data integration platforms also preferred.
• Background in statistics, data science, or business intelligence is highly desirable.
• Bachelor’s or Master’s degree in Computer Science, Engineering, or related fields.
• Must be available to work onsite in Irvine, CA Monday through Friday.

Benefits

• Competitive salary
• Supportive work environment
• Schedule flexibility
• Company-provided equipment