Data Analytics Developer

1-800 Hansons LLC•Troy, MI

1d•$115 - $135

About The Position

The Data Analytics Developer is responsible for delivering end-to-end reporting and analytics solutions across the organization. This role owns the full reporting lifecycle including SQL Server data extraction and transformation, maintaining PowerBI, deployment, user enablement, and ongoing support. The Data Analytics Developer serves as a primary support for enterprise and reporting needs as well as analytics partner to business stakeholders. The role collaborates closely with IT and business stakeholders to ensure data is accurate, available, properly modeled, and translated into actionable dashboards, analyses, and scorecards. This includes maintaining reliable campaign, CRM, and marketing automation data.

Requirements

3+ years of professional experience in a BI, analytics, or SQL development role.
Advanced proficiency with SQL (MS SQL Server preferred) including coding logic and data transformation.
Proficiency in PowerBI (or similar BI/reporting tools) for dashboard/report creation.
Strong working knowledge of Excel and data analysis techniques.
Demonstrated ability to manage multiple priorities, deliver on deadlines, and solve problems independently.
Strong verbal and written communication skills; able to translate technical detail into business context.
Ability to work effectively with both IT engineering teams and creative/business functions.

Nice To Haves

Experience with marketing data, campaign reporting, segmentation, and sales/lead funnel analytics.
Experience with data warehousing concepts and reporting architecture.
Exposure to API/data integration tools such as MuleSoft or Boomi.
Prior experience in IT analytics, Marketing analytics, or a cross-functional BI role.

Responsibilities

SQL Development & Data Engineering
Design, build, test, deploy, and support SQL Server queries and database objects to enable reporting and analytics.
Translate business requirements into accurate, scalable SQL logic and data transformations.
Troubleshoot and resolve database/environment issues affecting reporting or data availability.
Apply standard development practices including peer review, documentation, testing, and release support.
Support data audit processes and ensure integrity, consistency, and traceability of reporting data.
Reporting, Visualization & Scorecarding
Design and implement dashboards and reports in PowerBI (ad hoc and recurring).
Build scorecards and KPI views for Marketing and enterprise stakeholders.
Ensure reporting outputs are accurate, consistent, and aligned to business definitions.
Maintain and improve existing reporting architecture; implement enhancements or new data models as needed.
Marketing & Business Analytics Support
Provide campaign performance reporting, segmentation support, funnel analysis, and insight generation.
Ensure required data for campaigns and segmentation flows correctly into CRM and marketing automation systems.
Partner with stakeholders to interpret trends and answer strategic business questions with data.
Support key projects with structured analysis, hypothesis testing, and actionable recommendations.
Stakeholder Partnership & Enablement
Serve as a cross-functional analytics partner to Marketing, IT, and other internal customers.
Manage intake and prioritization of reporting requests, including new builds and changes to existing reports.
Onboard and educate users on reporting tools, dashboards, and underlying data architecture.
Explain technical solutions clearly to both technical and non-technical audiences.

Benefits

$115-$135k/year
Yearly bonus opportunities
Weekly pay via direct deposit
Health benefits available at 30 days of employment
401k with a company match at 90 days of employment
Paid time off available at 90 days of employment with unlimited rollover of unused hours
Holiday pay available at 30 days of employment
Tools provided to develop and grow within the company
Committees to join to be a big part of the great company culture we have to offer
And So Much More!