Senior Data Analyst Job at Blain's Farm & Fleet in Janesville

Overview

At Blains Farm leet we believe everyone deserves the opportunity to have a job they love, work in a great environment, grow their career & enjoy a positive balance.

As a family-owned retailer we take pride in offering a competitive benefit package designed to support you & your life. It is one of the reasons we have been named a Forbes Best Employer for seven consecutive years!

Benefits

• Associates hired into a full-time role will become eligible for the following benefits effective their 91st day of full-time employment: Medical, Prescription, Dental, Vision, Short & Long Term Disability, Life Insurance, Ancillary Benefits, Identity Theft Protection, Pet Insurance, Etc.
• All major Holidays & Birthday off
• Advanced Leadership Training Programs: build the skills to grow your career
• Associate discount on name brands like Carhartt, Under Armour, STIHL, Milwaukee Tool, DeWalt & much more!
• Internal recognition programs that support an engaged workplace
• 401(K) with company match

Compensation

• Base pay starting between $72,400 to $95,800/yr

The pay listed for this position may vary based on experience. Please note, compensation decisions are contingent on the facts and conditions for each job opening. We take into consideration the minimum requirements outlined in the job description, such as, training and experience, the position7s work location, required travel (if any), and external market conditions when determining the final salary for potential new hires.

Please note salary estimates published via alternate online job boards may not be a true representation of the actual pay range offered for this position. Please refer to the Blains Farm & Fleet position description for accurate pay range information.

Job Duties

The Senior Data Analyst will play a critical role in supporting data migration, data quality, and operational reporting initiatives for the Unified Transformation project. This position will partner closely with technical and business teams to ensure the integrity, accuracy, and usability of master data as it moves from legacy systems into platforms such as Microsoft Dynamics 365 and other enterprise systems. The analyst will also support operational reporting, business term and KPI documentation, and data stewardship activities.

• Communication & Leadership: Strong interpersonal skills with the ability to lead teams, influence decision-making, and drive adoption of data governance practices.
• Lead and execute data migration activities: data mapping, validation, cleansing, and integrity checks from SQL Server to Dynamics 365 and other systems
• Collaborate with technical and business team members to ensure data quality and successful migration
• Support operational reporting, including dispositioning existing reports, capturing business terms, and documenting KPIs
• Develop and maintain SQL queries and scripts for data analysis, validation, and reporting
• Build and maintain Power BI dashboards and reports to support business needs
• Engage with stakeholders to understand business processes, requirements, and data challenges
• Assist in the development and documentation of data governance and stewardship practices
• Investigate and resolve complex data quality issues, providing root cause analysis and recommendations
• Participate in data modeling activities, including supporting Snowflake and dbt initiatives
• Support integration efforts between MDM and other enterprise systems
• Present data findings, insights, and recommendations to leadership and project teams
• Contribute to the continuous improvement of data management processes and best practices
• Maintain accurate and up-to-date documentation for data flows, definitions, and business logic

Qualifications

• Bachelors degree in Computer Science, Information Systems, Data Analytics, Business, or related field (or equivalent experience)
• 4+ years of hands-on experience in data analysis, data migration, or data quality roles
• Advanced SQL skills required
• Experience with data mapping, validation, cleansing, and profiling
• Experience with data migration projects, preferably involving ERP or MDM systems
• Experience with reporting and measure, metric, and/or KPI definitions and documentation
• Excellent communication and stakeholder engagement skills

EEO Statement

Blain Supply, Inc and Blains Farm and Fleet (collectively “Blains”) is proud to be an Equal Opportunity Employer. We recognize the importance of diversity and creating an inclusive culture in order to leverage the skills and talents of all people to the mutual advantage of each individual and the organization. Blains does not discriminate against applicants or employees on the basis of race, religion, color, sex (including pregnancy and sexual harassment), sexual orientation, gender identity, national origin, age, marital status, disability, military or veteran status, or any applicable legally protected status. Our goal is to continue to be recognized as an employer of choice and we have received Forbes Best Mid-Sized company to work for an unprecedented 7 years in a row.

• Bachelors degree in Computer Science, Information Systems, Data Analytics, Business, or related field (or equivalent experience)
• 4+ years of hands-on experience in data analysis, data migration, or data quality roles
• Advanced SQL skills required
• Experience with data mapping, validation, cleansing, and profiling
• Experience with data migration projects, preferably involving ERP or MDM systems
• Experience with reporting and measure, metric, and/or KPI definitions and documentation
• Excellent communication and stakeholder engagement skills

The Senior Data Analyst will play a critical role in supporting data migration, data quality, and operational reporting initiatives for the Unified Transformation project. This position will partner closely with technical and business teams to ensure the integrity, accuracy, and usability of master data as it moves from legacy systems into platforms such as Microsoft Dynamics 365 and other enterprise systems. The analyst will also support operational reporting, business term and KPI documentation, and data stewardship activities.

• Communication & Leadership: Strong interpersonal skills with the ability to lead teams, influence decision-making, and drive adoption of data governance practices.
• Lead and execute data migration activities: data mapping, validation, cleansing, and integrity checks from SQL Server to Dynamics 365 and other systems
• Collaborate with technical and business team members to ensure data quality and successful migration
• Support operational reporting, including dispositioning existing reports, capturing business terms, and documenting KPIs
• Develop and maintain SQL queries and scripts for data analysis, validation, and reporting
• Build and maintain Power BI dashboards and reports to support business needs
• Engage with stakeholders to understand business processes, requirements, and data challenges
• Assist in the development and documentation of data governance and stewardship practices
• Investigate and resolve complex data quality issues, providing root cause analysis and recommendations
• Participate in data modeling activities, including supporting Snowflake and dbt initiatives
• Support integration efforts between MDM and other enterprise systems
• Present data findings, insights, and recommendations to leadership and project teams
• Contribute to the continuous improvement of data management processes and best practices
• Maintain accurate and up-to-date documentation for data flows, definitions, and business logic