OpTech

Business Data Analyst

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Business Data Analyst with a contract length of "unknown", offering a pay rate of "unknown". Key skills include advanced Excel, SQL, VBA, and project management experience. A bachelor's degree in business or a related field is preferred.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
360
-
πŸ—“οΈ - Date
August 20, 2026
πŸ•’ - Duration
Unknown
-
🏝️ - Location
Unknown
-
πŸ“„ - Contract
Unknown
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
Detroit, MI
-
🧠 - Skills detailed
#PostgreSQL #Database Design #Data Extraction #Pivot Tables #Power Pivot #RDBMS (Relational Database Management System) #Data Science #Data Analysis #SQL (Structured Query Language) #VBA (Visual Basic for Applications) #SQL Server #MySQL #Project Management #"ETL (Extract #Transform #Load)" #Datasets #Computer Science #Automation #Microsoft Access
Role description
Job Description This position is seeking a highly motivated, curious professional who can lead application and system implementation projects while also performing in-depth data analysis. The ideal candidate combines strong project management capabilities with advanced technical expertise in Excel, Microsoft Access, SQL, and VBA. The resource will manage projects through the full lifecycle, work directly with business stakeholders and subject-matter experts, analyze complex datasets, develop data-driven solutions, and translate technical findings into actionable business recommendations. This role requires someone who is comfortable working independently, asking questions in unfamiliar business areas, solving ambiguous problems, and continuously learning new domains. Skills / Experience / Education Requirements Professional Experience β€’ 5+ years of related experience preferred β€’ Translate technical/data findings into business recommendations β€’ Strong analytical and problem-solving abilities β€’ Business process improvement β€’ Working with business stakeholders and subject-matter experts β€’ Strong communication and presentation skills β€’ Bachelor’s degree preferred in business, computer science, data science Project Management Experience β€’ Application or system implementation projects β€’ Manage one moderate-sized project or multiple smaller projects β€’ Project planning, scheduling, risk management, resource allocation, and project controls β€’ Project management methodologies and PMO/PMI standards Technical Skills β€’ Advanced Excel – 3+ years - Pivot tables, Power Query, Power Pivot, Complex formulas, Data analysis and modeling β€’ Microsoft Access - Database design, Relational database development, Queries, VBA automation β€’ SQL - Efficient query writing, Data extraction, Performance tuning, Experience with SQL Server, PostgreSQL, MySQL, or another major RDBMS β€’ VBA - Macro development, Automation of repetitive processes, Demonstrated examples of automation that improved efficiency Essential Job Duties Project Management β€’ Initiate, plan, execute, monitor, control, and close application/system implementation projects. β€’ Develop project plans, schedules, risk registers, and resource allocations. β€’ Monitor project quality, cost, schedule, and performance metrics. Data Analysis & Discovery β€’ Perform deep-dive analysis of large and complex datasets. β€’ Use advanced Excel, Access, SQL, and VBA to investigate business questions. β€’ Build and maintain data models, dashboards, reports, and automated analytical tools. β€’ Identify trends, gaps, inefficiencies, and opportunities within business processes. Business Problem Solving β€’ Break complex or ambiguous business problems into manageable analytical tasks. β€’ Develop hypotheses, conduct analysis, and deliver actionable recommendations. β€’ Explore new analytical techniques, tools, and data sources. Stakeholder Engagement β€’ Lead interviews, workshops, brainstorming sessions, and working meetings. β€’ Collaborate with stakeholders across finance, operations, marketing, product, and other business areas. β€’ Quickly develop an understanding of unfamiliar business processes and terminology. Communication & Knowledge Sharing β€’ Facilitate meetings and drive discussions toward clear outcomes and next steps. β€’ Communicate technical findings in a clear, business-friendly manner. β€’ Share analytical findings, techniques, and best practices with the broader team.