Senior Data Analyst – Distribution Analytics

Job not on LinkedIn

🔥 2 minutes ago

🌲 North Carolina – Remote

🌲 North Carolina – Remote

💵 $101k - $132k / year

⏰ Full Time

🟠 Senior

📉 Data Analyst

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Foundation Finance Company LLC

WebsiteLinkedInAll Job Openings

51 - 200 employees

Foundation Finance Company (FFC) provides both prime and subprime installment and revolving credit financing for dealers and retailers in a variety of industries including home improvement, windows, roofing, siding, remodeling, HVAC, turf, and water treatment. FFC also purchases and services retail financing portfolios.

📋 Description

• Collaborate with the Distribution Analytics team to ensure proper functionality of current data applications and programs • Play a critical role in supporting data automation, data mining, and cleansing • Enhance and maintain automated programs and systems that aid in statistical analysis and forecasting • Support a range of teams, including Executive, Trade, Managed Markets, Global Supply Chain, Manufacturing, Finance, and Government Price Reporting • Analyze past results, perform variance analysis, identify trends, and make recommendations for areas of improvement in data automation and data systems • Serve as the backbone of the data ecosystem, designing and maintaining the connections between SQL databases, Microsoft Fabric, Power BI, and Dataflow pipelines • Own end-to-end data integration across systems, ensuring consistent, reliable, and performant data flow across the organization • Develop new Excel insights and Power BI analytics leveraging existing and new dataflows, notebooks, and lakehouses • Identify and support process improvements, including creation of standard and ad-hoc reports and tools using Excel and other dashboards • Support data mining, cleansing, and data quality for various projects • Perform reconciliation and management of commercial inventory transactions in compliance with related contracted terms, including DOH monitoring and inventory management • Build and manage Power BI semantic models, ensuring datasets are clean, governed, and ready for self-service analytics • Support inventory, specialty pharmacy, and sales-related data within Fabric and/or Databricks • Support development and use of automation tools for monitoring data quality • Serve as point of contact to IT for the team

🎯 Requirements

• Bachelor’s Degree in a related discipline • 5+ years of relevant data analysis and/or data engineering experience • 3+ years of experience with managing and interpreting large amounts of data and the ability to explain the outcomes of the information including data systems development, data mining, and data cleansing • 3+ years of proficient experience with Excel, Power BI, and other analytical/reporting platforms • 1+ year of project management experience • Strong proficiency in SQL, including complex joins, window functions, stored procedures, and query optimization • Hands-on experience with Microsoft Fabric, including Lakehouses, Pipelines, and Dataflows Gen2 • Demonstrated ability to build enterprise-grade Power BI reports and semantic models (DirectQuery, composite models) • General knowledge of statistical modeling and forecasting • Deep understanding of data warehouse concepts — star schemas, slowly changing dimensions, incremental refresh • Experience connecting disparate systems and thinking holistically about data flow and dependencies • Strong written and verbal skills

🏖️ Benefits

• medical / dental / vision / prescription coverage • employee wellness resources • savings plans (401k and ESPP) • paid time off & paid parental leave benefits • disability benefits • more