Business Intelligence Senior Specialist #1052294
FastTek Global, Dearborn, MI, United States
Business Intelligence Senior Specialist #1052294
Dearborn, Michigan
Job Description Employees in this job function are responsible for enabling intelligent business decisions by designing robust analytics solutions through a blend of business acumen, data and analytics proficiency and technical solution architecture; leveraging knowledge and expertise in multiple tools for data integration, data modeling, data analysis tools, advanced data visualization tools etc.
Key Responsibilities
Create strong business partnership for intelligent solutions through stakeholder interviews and solution designs
Own the design, implementation and maintenance of ongoing metrics, reports, analyses and end-user tools to drive key business decisions. Use advanced visualization tools like Qlik, Dash Enterprise, Tableau, PowerBI etc.
Conduct deep-dive analysis of business problems and data issues to formulate recommendations for business improvement and technical efficiency. Use data modeling tools, data analysis tools, advanced programming languages like R, Python, SQL, etc.
Identify and implement avenues to optimize and enhance data analysis, interpretation and visualization tools, techniques and methodologies for functional analysts
Design and implement new metrics, techniques and strategies to improve business KPI, metrics unity and end-user adoption
Partner with Data Engineering, Data Science and Data Management teams to improve data completeness, usability, and performance
Skills Required
SQL
Skills Preferred
Business Intelligence
Experience Required
Senior Specialist Exp: 7+ experience in relevant field.
Experience Preferred
Specific Domain Experience: GCP Ecosystem: Strong preference for candidates with direct experience in Google Cloud Platform (BigQuery), including writing complex SQL (Window Functions, CTEs, Nested Data) to structure their own datasets.
Product Analytics Focus: Experience must be in analyzing User Behavior (Retention, Churn, Engagement, MAU/DAU), not just financial or operational reporting.
"Full-Stack" Capability: Demonstrated ability to act as a bridge between Engineering and Product—taking raw telemetry and transforming it into business insights without relying on a central data team for every query.
Education Required
Bachelor's Degree
Education Preferred
Master's Degree
Additional Information Senior Product Analyst
The Opportunity
The Insight Accelerator Act as the strategic "Brain" of the Digital Cabin product triad.
We need a forensic investigator, not a report generator.
You will break the data bottleneck by diving directly into Google Cloud Platform (GCP) to wrangle raw data and deliver immediate insights while central teams build long-term pipelines.
What You'll Do
Forensic Analysis: Go beyond basic counts. Use Advanced SQL (BigQuery) to dig into raw logs, identify root causes of churn, and find the "signal in the noise" that explains user behavior.
Data Structuring: Don't wait for the perfect table. Use SQL to clean, join, and structure raw data into "Analytical Sandboxes" in GCP. (Note: This is business logic structuring, not AI/ML modeling).
Proactive Strategy: Don't just take tickets. Monitor data, generate unasked hypotheses, and challenge vanity metrics.
Define Logic: Translate business concepts into precise code/documentation (e.g., defining "Active Session") for future adoption by central engineering.
Bridge the Gap: Translate between Central Analytics (GDIA) and Product. You build the prototype; they build the production pipeline.
Requirements
5+ Years Product Analytics: Experience driving roadmaps through data, not just reporting.
Tech Mastery (GCP & SQL): Expert-level SQL (Window functions, nested data, joins) and ability to navigate BigQuery to structure data independently.
Investigative Mindset: Comfortable navigating ambiguity and solving messy data puzzles without a roadmap.
Strategic Intuition: Deep understanding of Cohort Analysis, Retention Curves, and Funnel Optimization.
Preferred
Experience with dbt (Data Build Tool).
Experience with Amplitude or similar event-based platforms.
Background in subscription models.
Benefits
Medical and Dental (FastTek pays majority of the medical program)
Vision
Personal Time Off (PTO) Program
Long Term Disability (100% paid)
Life Insurance (100% paid)
401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
AI & Hiring Disclosure We use AI tools to support parts of our hiring process, such as reviewing applications and identifying potential matches. These tools are designed to promote efficiency, consistency, and fairness, and they are always used under human oversight. All personal data collected is used solely for recruitment purposes, and you have the right to know, access, or request deletion of your data at any time, subject to legal limits. If AI will be used in a video interview, you'll be informed in advance and asked for your consent, with the option to opt out. Our tools are regularly reviewed to detect potential bias and to ensure compliance with all applicable laws and our commitment to inclusive hiring. To learn more or exercise your rights, please contact us at info@fasttek.com.
#J-18808-Ljbffr
Job Description Employees in this job function are responsible for enabling intelligent business decisions by designing robust analytics solutions through a blend of business acumen, data and analytics proficiency and technical solution architecture; leveraging knowledge and expertise in multiple tools for data integration, data modeling, data analysis tools, advanced data visualization tools etc.
Key Responsibilities
Create strong business partnership for intelligent solutions through stakeholder interviews and solution designs
Own the design, implementation and maintenance of ongoing metrics, reports, analyses and end-user tools to drive key business decisions. Use advanced visualization tools like Qlik, Dash Enterprise, Tableau, PowerBI etc.
Conduct deep-dive analysis of business problems and data issues to formulate recommendations for business improvement and technical efficiency. Use data modeling tools, data analysis tools, advanced programming languages like R, Python, SQL, etc.
Identify and implement avenues to optimize and enhance data analysis, interpretation and visualization tools, techniques and methodologies for functional analysts
Design and implement new metrics, techniques and strategies to improve business KPI, metrics unity and end-user adoption
Partner with Data Engineering, Data Science and Data Management teams to improve data completeness, usability, and performance
Skills Required
SQL
Skills Preferred
Business Intelligence
Experience Required
Senior Specialist Exp: 7+ experience in relevant field.
Experience Preferred
Specific Domain Experience: GCP Ecosystem: Strong preference for candidates with direct experience in Google Cloud Platform (BigQuery), including writing complex SQL (Window Functions, CTEs, Nested Data) to structure their own datasets.
Product Analytics Focus: Experience must be in analyzing User Behavior (Retention, Churn, Engagement, MAU/DAU), not just financial or operational reporting.
"Full-Stack" Capability: Demonstrated ability to act as a bridge between Engineering and Product—taking raw telemetry and transforming it into business insights without relying on a central data team for every query.
Education Required
Bachelor's Degree
Education Preferred
Master's Degree
Additional Information Senior Product Analyst
The Opportunity
The Insight Accelerator Act as the strategic "Brain" of the Digital Cabin product triad.
We need a forensic investigator, not a report generator.
You will break the data bottleneck by diving directly into Google Cloud Platform (GCP) to wrangle raw data and deliver immediate insights while central teams build long-term pipelines.
What You'll Do
Forensic Analysis: Go beyond basic counts. Use Advanced SQL (BigQuery) to dig into raw logs, identify root causes of churn, and find the "signal in the noise" that explains user behavior.
Data Structuring: Don't wait for the perfect table. Use SQL to clean, join, and structure raw data into "Analytical Sandboxes" in GCP. (Note: This is business logic structuring, not AI/ML modeling).
Proactive Strategy: Don't just take tickets. Monitor data, generate unasked hypotheses, and challenge vanity metrics.
Define Logic: Translate business concepts into precise code/documentation (e.g., defining "Active Session") for future adoption by central engineering.
Bridge the Gap: Translate between Central Analytics (GDIA) and Product. You build the prototype; they build the production pipeline.
Requirements
5+ Years Product Analytics: Experience driving roadmaps through data, not just reporting.
Tech Mastery (GCP & SQL): Expert-level SQL (Window functions, nested data, joins) and ability to navigate BigQuery to structure data independently.
Investigative Mindset: Comfortable navigating ambiguity and solving messy data puzzles without a roadmap.
Strategic Intuition: Deep understanding of Cohort Analysis, Retention Curves, and Funnel Optimization.
Preferred
Experience with dbt (Data Build Tool).
Experience with Amplitude or similar event-based platforms.
Background in subscription models.
Benefits
Medical and Dental (FastTek pays majority of the medical program)
Vision
Personal Time Off (PTO) Program
Long Term Disability (100% paid)
Life Insurance (100% paid)
401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
AI & Hiring Disclosure We use AI tools to support parts of our hiring process, such as reviewing applications and identifying potential matches. These tools are designed to promote efficiency, consistency, and fairness, and they are always used under human oversight. All personal data collected is used solely for recruitment purposes, and you have the right to know, access, or request deletion of your data at any time, subject to legal limits. If AI will be used in a video interview, you'll be informed in advance and asked for your consent, with the option to opt out. Our tools are regularly reviewed to detect potential bias and to ensure compliance with all applicable laws and our commitment to inclusive hiring. To learn more or exercise your rights, please contact us at info@fasttek.com.
#J-18808-Ljbffr