Data Analyst I

Allied Solutions, LLC is seeking a Data Analyst I to support business decision-making through data analysis and reporting. The role develops and maintains Power BI dashboards, performs trend and statistical analyses, validates and manages datasets, and collaborates with business leaders to improve reporting, operational efficiency, and product performance.

What you'll do:

• Build, maintain and enhance Power BI dashboards and reports to support operational decision-making
• Conduct data mining and advanced statistical analysis to provide actionable insights and identify trends to measure and optimize product performance for the business’ top product lines
• Leverage SQL queries for data extraction projects
• Manage carrier file imports and conduct frequent database audits to ensure data integrity
• Conduct root cause analyses to provide actionable insights into an account’s performance
• Communicate and clearly present findings/results to department leadership
• Design, distribute, and maintain weekly, monthly, and quarterly product performance reports
• Support the automation of manual reporting processes by creating scalable reporting solutions using Power BI
• Support ad-hoc data and reporting needs for various operational initiatives
• Conduct monthly audit and reconciliations of external data
• Supports the department’s data extraction and collection needs
• Proactively identify areas for operational efficiencies and collaborate with various business units to provide scalable solutions to increase efficiency

What they're looking for:

• Associate's degree in a related field required
• 1-2 years of work-related experience required
• Proficiency in core Microsoft packages required (Word, Excel and PowerPoint) required
• Foundational experience building and maintaining reports and dashboards in Power BI required (or other BI tools with willingness to learn Power BI quickly)
• Strong analytical skills with an ability to translate data findings into meaningful business insights
• Bachelor's degree in mathematics, statistics or computer science, or 6+ years equivalent experience preferred
• Experience with SQL or other SAS languages preferred but not required

Benefits:

• Medical, dental and vision insurance coverage
• 100% company-paid life and disability coverage
• 401k options with company match
• Three weeks PTO by the end of the first year
• Career growth opportunities through promotion from within
• Broad career options within the same organization