Senior Analyst, Data Analytics and Business Intelligence

Jobtailor; Houston (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor in Houston, TX seeks a senior data/BI analyst to drive data products and predictive insights. You will combine data from data lake, Oracle, ERP, and WMS with Excel-based tools to create descriptive models and BI dashboards for decision-making.

You will collaborate with stakeholders across processes and locations, defining measurement solutions and driving performance through analytics. A strong background in SQL, Python/R, Power BI, and Power Query is required, with PM/Lean Six Sigma

Qualifications

• Bachelor's degree or equivalent related work or military experience.
• 5+ years of experience in business process analysis and process improvement.
• 5+ years building financial/operational models, reports, datasets and tools.
• Advanced analytical skills with SQL, Python/R, Excel, Power BI, Power Query.
• Ability to work autonomously and in a matrix organization.
• PM and Lean Six Sigma belt certification is a plus.
• Experience with automation tools like Airflow, Power Automate or RPA.
• Familiarity with Snowflake or GCP platforms.
• 3+ years of cross-functional project experience.
• MBA or related master's degree is preferred.

Responsibilities

• Leverage data from sources (data lake, Oracle, ERP, WMS, Excel) to build advanced data products and predictive models.
• Create descriptive and predictive models and visualize on BI platforms.
• Collaborate with stakeholders across processes, facilities, locations, units, and levels to define measurement solutions.
• Collaborate with account management, operations support, IT for alignment and preventing discrepancies.
• Serve as subject matter expert on the function product and boost operational performance.
• Identify and analyze user requirements to improve processes.
• Support initiatives via data analysis, barriers identification, and user acceptance testing.
• Participate in building and maintaining BI dashboards and education of end users.

Skills

SQL

Python/R

Excel

Power BI

Power Query

Project Management

Lean Six Sigma

Airflow

Power Automate

RPA

Snowflake

GCP

Education

Bachelor's degree or equivalent

MBA or master’s degree in Mathematics, Engineering, Computer Science, or related field

Tools

Oracle

ERP systems

WMS

Job description

Responsibilities

• Leverage data from various data sources including data lake, Oracle databases, ERP, WMS and internal tools (like Excel or other data management systems) to build advanced data products, create descriptive and predictive models, and visualize on BI platforms.
• Collaborate with and manage stakeholders across processes, facilities, locations, units, and levels to gain an understanding of business objectives, facilitate defining measurement solutions and implement business processes and techniques that drive performance.
• Partner with and influence other teams such as account management, operations support, IT for alignment and discrepancy prevention.
• Serve as the subject matter expert on the assigned function product and work with other business analysts to boost operational performance.
• Identify and analyze user requirements, procedures, and problems to improve existing processes.
• Support business initiatives through data analysis, identification of implementation barriers and user acceptance testing of various systems.
• Participate in building and maintaining BI dashboards, automated and self-service tools, and educating end users as well as other business analysts.

Requirements

• Bachelor's degree or equivalent related work or military experience
• Strong facilitation skills and process-driven analytical skills
• 5+ years’ experience with a proven record of success in business process analysis and process improvement initiatives
• 5+ years of experience in building financial and operational models, reports, tools, and datasets
• Advanced analytical skills and experience with data science tools including SQL, Python/R, as well as Excel, Power BI, and Power Query
• Proven ability to work autonomously as well as establish effective work relationships in a matrix organization
• It’d be great if you also have: Project Management and Lean Six Sigma belt certification
• Ability to work with automation tools such as Airflow, Power Automate or RPA
• Skillful with platforms such as Snowflake or GCP
• 3+ years work experience with various departments and multi-functional projects
• MBA or master’s degree in Mathematics, Engineering, Computer Science, or related field

Core Competencies

Demonstrates expertise in data analysis, business process improvement, and stakeholder collaboration, leveraging advanced analytical skills and tools to drive operational performance and implement effective measurement solutions.