Apply on Employer Site

1-800 Hansons, LLC · 21 hours ago

Data Analytics Developer

Troy, MI

Full-time

Onsite

Mid Level

$115K/yr - $135K/yr

3+ years exp

1-800 Hansons is a top ranked home improvement company that is continuously growing and expanding. The Data Analytics Developer is responsible for delivering end-to-end reporting and analytics solutions, collaborating closely with IT and business stakeholders to ensure data accuracy and availability.

Building MaintenanceBuilding MaterialConstructionService Industry

Responsibilities

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

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

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

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

Qualification

SQL DevelopmentPowerBIData AnalysisData WarehousingAPI IntegrationCommunication SkillsProblem SolvingTime Management

Required

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

Preferred

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

Benefits

Yearly bonus opportunities

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

Company

1-800 Hansons, LLC

At 1-800-HANSONS, we pride ourselves on presenting the best quality replacement windows, siding, roofing, gutters, gutter guards and bathtubs & showers.

Founded in 1988

Troy, Michigan, USA

201-500 employees