Business Intelligence Senior Specialist
EPITEC, Dearborn, MI, United States
Job Title:
Business Intelligence Senior Specialist
Location:
Dearborn, Michigan
Job Type:
Contract
Expected Hours per Week:
40 hours per week
Schedule:
9 AM – 5 PM, M-F
Pay Range:
$66-69 PER HOUR
Role Overview Location: Hybrid (Dearborn, MI preferred) | Open to Remote | Type: Full?Time | Senior Level
The Opportunity: Be the Brain Behind the Product
We’re looking for a Senior Product Analyst to act as the strategic “Insight Accelerator” for our Digital Cabin product. This is not a reporting role. We need a forensic investigator who can dive directly into raw data, break bottlenecks, and surface insights that drive real product decisions.
You’ll operate at the intersection of Product, Engineering, and Analytics, translating complex telemetry into clear, actionable insights while central teams build long?term pipelines.
Responsibilities
Investigate user behavior including retention, churn, engagement, MAU/DAU using advanced SQL in BigQuery
Perform deep?dive forensic analysis on raw logs to uncover root causes and meaningful patterns
Build analytical sandboxes in GCP by cleaning, joining, and structuring raw datasets (business logic, not ML)
Design and own product metrics, KPIs, dashboards, and analyses used by leadership
Create high?impact visualizations using Tableau, Power BI, Qlik, Dash Enterprise, or similar tools
Proactively generate hypotheses, challenge vanity metrics, and influence product roadmap decisions
Define and document business logic (e.g., what constitutes an “Active Session”) for future adoption
Partner with Data Engineering, Data Science, and Central Analytics teams — you prototype, they productionize
Qualifications
5–7+ years of experience in Product Analytics (not just operational or financial reporting)
Expert?level SQL including window functions, CTEs, nested data, and complex joins
Hands?on experience in Google Cloud Platform / BigQuery with the ability to structure datasets independently
Strong understanding of cohort analysis, retention curves, and funnel optimization
Comfort operating in ambiguous, messy data environments
Proven ability to translate raw data into actionable business insights
Nice to Have
Experience with dbt (Data Build Tool)
Experience with Amplitude or similar event?based analytics platforms
Background in subscription or usage?based products
Master’s degree
#J-18808-Ljbffr
Business Intelligence Senior Specialist
Location:
Dearborn, Michigan
Job Type:
Contract
Expected Hours per Week:
40 hours per week
Schedule:
9 AM – 5 PM, M-F
Pay Range:
$66-69 PER HOUR
Role Overview Location: Hybrid (Dearborn, MI preferred) | Open to Remote | Type: Full?Time | Senior Level
The Opportunity: Be the Brain Behind the Product
We’re looking for a Senior Product Analyst to act as the strategic “Insight Accelerator” for our Digital Cabin product. This is not a reporting role. We need a forensic investigator who can dive directly into raw data, break bottlenecks, and surface insights that drive real product decisions.
You’ll operate at the intersection of Product, Engineering, and Analytics, translating complex telemetry into clear, actionable insights while central teams build long?term pipelines.
Responsibilities
Investigate user behavior including retention, churn, engagement, MAU/DAU using advanced SQL in BigQuery
Perform deep?dive forensic analysis on raw logs to uncover root causes and meaningful patterns
Build analytical sandboxes in GCP by cleaning, joining, and structuring raw datasets (business logic, not ML)
Design and own product metrics, KPIs, dashboards, and analyses used by leadership
Create high?impact visualizations using Tableau, Power BI, Qlik, Dash Enterprise, or similar tools
Proactively generate hypotheses, challenge vanity metrics, and influence product roadmap decisions
Define and document business logic (e.g., what constitutes an “Active Session”) for future adoption
Partner with Data Engineering, Data Science, and Central Analytics teams — you prototype, they productionize
Qualifications
5–7+ years of experience in Product Analytics (not just operational or financial reporting)
Expert?level SQL including window functions, CTEs, nested data, and complex joins
Hands?on experience in Google Cloud Platform / BigQuery with the ability to structure datasets independently
Strong understanding of cohort analysis, retention curves, and funnel optimization
Comfort operating in ambiguous, messy data environments
Proven ability to translate raw data into actionable business insights
Nice to Have
Experience with dbt (Data Build Tool)
Experience with Amplitude or similar event?based analytics platforms
Background in subscription or usage?based products
Master’s degree
#J-18808-Ljbffr