Data Analyst

Joining OneRail as a Data Analyst means integrating into a skilled group intent on revolutionizing data management and analytics. You will align closely with different departments, including Transportation, Operations, Sales, Marketing, and IT, leveraging data to influence decisions and drive strategic growth. Your role is pivotal in maintaining and developing our Power BI reports, creating sophisticated Excel analyses, and scripting with Python to streamline data processes. This is an onsite role, requiring the chosen incumbent to be able and willing to work within our Orlando, Florida HQ (ZIP 32819).
RESPONSIBILITIES

• Engage directly with both internal and external stakeholders to conduct targeted data analysis, fulfilling specific data-related requirements and supporting informed decision-making.
• Conduct ad-hoc data analysis using Excel, Python, and other tools to provide actionable insights to guide business decisions.
• Maintain and oversee Power BI datasets and reports, ensuring accuracy and performance.
• Develop new Power BI reports that articulate complex data in a clear, concise manner.
• Write and optimize SQL queries to support data analysis tasks.
• Create and maintain scripting routines for data manipulation and automation with Python.
• Engage with stakeholders to understand data needs and deliver solutions that meet these requirements.
• Prepare and present findings to non-technical audiences, translating data into strategic insights.
• Support continuous improvement by identifying and implementing enhancements to reporting and analysis processes.
• Create and support tooling for various departments in the business.
• Work directly with internal and external stakeholders to complete data analysis to meet a need the stakeholder has.
• Design, create, and maintain tools for various business departments, enhancing their productivity and capabilities.
• Apply artificial intelligence techniques to address complex business challenges and contribute to strategic decision-making.
• Construct and maintain advanced data models that forecast trends and inform company directives.

WHAT YOU WILL DO

• Manage multiple data projects concurrently, maintaining flexibility to shift priorities as needed.
• Regularly update stakeholders on project progression, potential risks, and planned actions.
• Translate complex data findings into understandable reports and dashboards that inform business strategies.
• Develop in-depth understanding of business needs and leverage data to propose innovative solutions.
• Maintain documentation for all data processes and reports for transparency and continuity.
• Present findings to both internal and external stakeholders.
• Other duties as assigned – it is understood that this list of major duties and responsibilities is not an inclusive list and that other duties and responsibilities, which may include helping others in the same or different departments, may be assigned by supervision.
• Apply artificial intelligence techniques to address complex business challenges and contribute to strategic decision-making.
• Construct and maintain advanced data models that forecast trends and inform company directives.

WHAT YOU WILL BRING TO THE TEAM

• Proficiency with Excel, including the creation of advanced macros using Visual Basic for Applications (VBA) to automate repetitive tasks and streamline data analysis.
• Competence in developing and maintaining Power BI datasets and reports, adept at converting complex datasets into intuitive and impactful visual reports.
• Practical experience with SQL for effective database querying, analysis, and management.
• Proficiency in scripting with Python, especially in the context of data manipulation and automation tasks.
• A strong foundation in data analysis and business intelligence principles with an emphasis on delivering actionable insights.
• Robust mathematical and analytical skills to accurately collect, measure, organize, and interpret large datasets.
• Proactive identification of risks and opportunities with the ability to communicate these to both technical and non-technical stakeholders.
• Outstanding verbal and written communication skills, including the ability to create clear documentation and present complex data insights to a diverse audience.
• Highly organized with an innate sense of urgency, able to juggle multiple priorities and meet stringent deadlines without compromising on detail or accuracy.
• A collaborative mindset and willingness to pitch in where needed, recognizing that the role may evolve in line with the company's growth and data strategy.
• Previous experience in a data-centric role within a dynamic business environment is highly beneficial.