> Markdown version of [/jobs/ext/3442425-data-analytics-consultant-ii-senior-consultant-i](https://www.wearedevelopers.com/jobs/ext/3442425-data-analytics-consultant-ii-senior-consultant-i). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analytics Consultant II / Senior Consultant I - **Company:** Allstate Corporation - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $70,000.0 - $121,000.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Microsoft Azure, Big Data, Data Governance, Data Presentation, Data Visualization, Database Analysis, Database Queries, Python (Programming Language), Power BI, Standard Sql, SQL Databases, Microsoft Fabric, Information Technology, Data Analytics, Data Lakehouse, Programming Languages - **Published:** September 21, 2026 - **Apply:** https://www.builtincolorado.com/job/data-analytics-consultant-ii-senior-consultant-i/11293396?handler=ApplyRedirect ## About the Role * 1+ years of experience in analytics, reporting, business intelligence, or a related discipline. * Working knowledge with SQL * Experience building dashboards and reports using Power BI or a similar tool. * Ability to communicate findings clearly to technical and non-technical audiences. * Ability to organize work, manage priorities, and deliver multiple assignments. SENIOR CONSULTANT I: Support complex ambiguous analytical initiatives, define analytical approaches, drive stakeholder alignment, and influence business direction through data-driven recommendations., * 3+ years of experience in analytics, reporting, business intelligence, or a related discipline. * Strong SQL and advanced data analysis skills. * Experience building and improving dashboards, reports, and performance measurement solutions using Power BI or a similar tool. * Identify meaningful trends and communicate insights * Experience independently leading multiple analytics projects and influencing business decisions through insights., * Bachelor's degree in Business, Analytics, Finance, Statistics, Computer Science, or a related field. * Experience in insurance, sales, distribution, or financial analytics. * Experience with Microsoft Fabric, Azure, or data lakehouse environments. * Working knowledge of Python, R, or another programming language. * Experience influencing business strategy through data-driven insights. Skills Data Analytics Software, Data Analytics Tools, Database Analytics, Database Queries, Data Visualization, Microsoft Azure SQL, Microsoft Power Business Intelligence (PBI), SQL Database Queries, Structured Query Language (SQL) ## Description * Team partners with sales, strategy, and business leaders to deliver analytics, reporting, and actionable insights that improve agency performance and support profitable growth. We do more than build dashboards. We help the business understand what is happening, why it is happening, and what actions to take next. * Key stakeholder groups include Field Sales Organization, Distribution Strategy and Business Architecture, Program and Deployment teams, and Distribution and Agency leadership partners. Which Level Best Fits You? CONSULTANT II: Best suited for an analytics professional who can independently deliver defined analyses and reporting, partner with stakeholders, and translate data into practical recommendations. SENIOR CONSULTANT I: Best suited for an experienced analytics professional who can lead more complex or ambiguous work, shape analytical direction, and influence business decisions through recommendations and storytelling. What Success Looks Like * You enjoy digging into data, finding meaningful insights, and building clear visualizations. * You balance analytical thinking with strong communication and can turn findings into recommendations that help the business take action. * At either level, you will contribute to better decisions and improved business performance, with the Senior Consultant I role carrying broader complexity, ownership, and influence. Common Core Responsibilities * Analyze business questions and deliver actionable insights. * Compile, organize, query, and analyze large datasets from multiple sources. * Identify trends, risks, opportunities, and performance drivers. * Build and enhance Power BI dashboards, reports, KPI scorecards, and performance measurement tools. * Use SQL to query and manipulate data and create analytics-ready datasets. * Apply data quality and governance best practices. * Monitor business performance and evaluate key initiatives. * Partner with stakeholders to identify opportunities and solve business challenges. * Present findings through clear visualizations, data storytelling, and business-focused recommendations. * Manage multiple analytics assignments and contribute to continuous improvement and analytics best practices. Level-Specific Scope and Responsibilities CONSULTANT II: Responsible for leveraging data and analytics to answer complex questions and influence distribution strategy., * Complete analyses, recurring reporting, dashboard enhancements, and performance measurement assignments. * Work with stakeholders to clarify business questions, gather requirements, and translate needs into analytical outputs. * Apply established analytical methods, data standards, and governance practices. * Identify meaningful trends and communicate practical recommendations to team members and business partners. * Present findings to team members, project partners, and business stakeholders., * Complete complex analyses, recurring reporting, dashboard enhancements, and performance measurement assignments. * Partner with business leaders and cross-functional stakeholders to frame problems and identify opportunities. * Connect insights across datasets, initiatives, and performance indicators to explain business drivers. * Develop recommendations that influence strategy, priorities, and business action. * Anticipate data quality, governance, and measurement risks and guide practical solutions. * Contribute analytics best practices and help strengthen the quality and consistency of team deliverables. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Why and when should we consider Stream Processing frameworks in our solutions](https://www.wearedevelopers.com/videos/1085-why-and-when-should-we-consider-stream-processing-frameworks-in-our-solutions) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)