Senior Analytics Consultant

Role Overview: We are seeking a Senior Analytics Consultant to support a business-facing analytics engagement with First Command. This role requires a strong blend of analytics expertise, stakeholder communication, and visualization skills. The ideal candidate is consultative, curious, and comfortable translating ambiguous business questions into clear, data-driven insights. Key Responsibilities: • Partner directly with business stakeholders at all levels to understand goals and challenges • Ask thoughtful, open-ended questions to uncover business context and requirements • Translate complex and ambiguous problems into clear analytical approaches and visualizations • Design and deliver impactful dashboards and reports, primarily using Power BI • Write, explain, and optimize SQL queries used for analytics and reporting • Create and maintain clear documentation, including BRDs, FRDs, and related artifacts • Present insights and recommendations in a clear, compelling, and business-friendly manner Required Skills & Experience: • Strong SQL expertise • Comfortable with simple and complex joins • Solid understanding of aggregations and grouping • Able to clearly explain query logic and design choices • Data Warehousing & Modeling • Experience querying enterprise data warehouses • Strong understanding of star schemas and dimensional models • Knows when to query fact vs. dimension tables • Visualization & Reporting • Advanced experience with Power BI (mandatory) • Visualization-first mindset; Tableau experience is a plus • Experience reporting directly against a data warehouse • Business & Communication Skills • Client-facing, consultative mindset • Strong verbal and written communication skills • Comfortable explaining analytical concepts to non-technical audiences Nice to Have: • Familiarity with Microsoft Fabric