Role Description The Power BI Consultant will be responsible for the following: - 4–8+ years of experience in Business Intelligence, Data Analytics, and Reporting Solutions - Strong experience in Microsoft Power BI development - Expertise in DAX, Power Query (M Language), and data modeling - Hands-on experience with SSRS (SQL Server Reporting Services) - Advanced SQL development skills on SQL Server - Experience with Power BI Service, Gateways, Workspaces, and Deployment Pipelines - Strong understanding of data warehousing concepts and dimensional modeling - Knowledge of report performance tuning and optimization techniques - Experience working with large datasets and complex reporting environments Qualifications - Experience with Azure Data Factory, Azure Synapse, Microsoft Fabric, or Databricks - Knowledge of SSIS and SSAS - Experience with Paginated Reports in Power BI - Familiarity with CI/CD and DevOps practices - Exposure to REST APIs and data integration techniques Requirements - SSRS to Power BI migration projects - Financial, Sales, Operations, or Supply Chain reporting - Agile/Scrum delivery environments - Enterprise BI governance and security frameworks Benefits - Design, develop, and maintain interactive Power BI dashboards, reports, and scorecards - Develop efficient data models using star and snowflake schemas - Create complex calculations, KPIs, and business metrics using DAX - Implement row-level security (RLS) and data governance best practices - Optimize report performance and manage Power BI datasets and workspaces - Publish, schedule, and maintain reports in Power BI Service - Develop, modify, and support operational and analytical reports using SSRS - Build paginated reports and pixel-perfect reporting solutions - Maintain existing SSRS report catalog and subscriptions - Troubleshoot report performance and data retrieval issues - Support migration of legacy SSRS reports to Power BI where applicable Company Description Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments.

Role Description The Investments Senior Associate, Alternatives Forecasting & Portfolio Intelligence is the dedicated analytics, forecasting, and performance expert for the Alternatives and Non-Core portfolio spanning Private Equity, Private Credit, Real Estate, Infrastructure, Hedge Funds, and Non-Core asset classes. The role translates portfolio data, performance, cash flow forecasts, and market intelligence into actionable insights supporting strategic asset allocation, M&A pricing, portfolio construction, and executive decision-making. The role owns: - Asset- and strategy-level cash flow, NAV, and return forecasting - The Alternatives segment of the investment financial plan - M&A pricing projections for alternative assets - Long-term strategic asset allocation inputs for alternatives - Performance attribution, variance analysis, and non-core benchmarks - Portfolio risk and exposure reporting - Fee and expense analytics - Enstar’s alternatives data infrastructure, including Power BI dashboards and key external platforms such as SPI by StepStone and Canoe Qualifications - 6+ years of experience in a quantitative investment analytics, portfolio analytics, investment forecasting, or alternatives-focused role at an institutional investment organization, asset manager, alternative investment firm, or investment bank - Prior experience in a dedicated alternatives analytics, portfolio data, or investment forecasting function; experience within an insurance company investment environment strongly preferred - Demonstrated experience building and maintaining asset-level forecasting models for illiquid asset classes - Experience with performance measurement, attribution, and custom benchmark construction for alternative investments - Experience with large investment datasets using SQL, Power BI, Excel, and related analytics tools - Experience with alternatives-specific data platforms and reporting tools - Strong written and verbal communication skills - Demonstrated ability to automate and scale analytical processes - Bachelor’s degree in finance, economics, mathematics, statistics, computer science, or a related quantitative discipline required; Master’s degree preferred - Progress toward CFA and/or CAIA designations is preferred - Familiarity with alternative asset classes - Deep understanding of alternative fund structures, cash flow mechanics, NAV and capital account reporting, fee structures, and their implications for portfolio modelling - Deep understanding of alternatives performance measurement - Knowledge of strategic asset allocation frameworks and capital market assumption development - Knowledge of portfolio risk analytics concepts - Expert proficiency in Excel for financial modelling - Proficient in leveraging Excel Cube Functions and Power Pivot data models - Advanced Power BI skills - Strong project management and organizational skills - Experience applying AI-enabled tools, automation platforms, or data engineering workflows - Collaborative team player - Self-starter with intellectual curiosity Requirements - Develop and maintain asset- and strategy-level forecasts, financial plans, and M&A pricing models for all alternative and non-core investments - Provide performance attribution, actual vs. budget variance analysis, and benchmarking for the alternatives and non-core investments portfolio - Develop and maintain long-term capital market assumptions and strategic asset allocation inputs for alternative asset classes - Serve as the subject matter expert for alternatives portfolio analytics and exposure reporting - Build and maintain a suite of Power BI dashboards and lead alternatives data management across internal and external systems - Drive continuous enhancement of forecasting and analytics capabilities - Work in close coordination with the Portfolio Forecasting & Investment Analytics function - Gather input from internal and external managers and vendors; update forecasts on a quarterly, semi-annual, annual, or as-needed basis - Lead the annual liquidity survey across the Alternatives portfolio - Develop, maintain, and update investment projection models for individual alternative and non-core assets - Run quarterly and annual planning cycles in partnership with the broader Investments team - Analyze and explain quarterly asset class returns against assigned benchmarks - Quantify and explain the variance of quarterly investment results against the annual budget - Develop, build, and maintain custom benchmarks for each alternatives asset class - Lead requests to produce and analyze portfolio exposures - Prepare analytics, attribution, forecasting, and portfolio materials supporting Investment Committee discussions - Build, develop, and maintain fee estimation models for assigned assets - Aggregate, analyze, and present total fees and expenses paid to alternative investment managers - Maintain historical fees and expenses data and related Power BI reporting - Build and maintain a suite of interactive performance, forecasting, fee, risk, and portfolio analytics dashboards in Power BI - Lead data management for Alternative Investments across internal and external systems - Act as business owner for alternatives analytics platforms and reporting infrastructure - Oversee the setup, configuration, and ongoing maintenance of key external platforms - Deliver additional analyses, models, and special projects as business needs dictate Benefits - Best-in-class Medical, Dental, and Vision healthcare for single and family coverage - Board-certified doctors and pediatricians available virtually 24/7 for urgent care - Access to Health Savings Account (HSA) or Flexible Spending Account (FSA) - Access to Dependent Care FSA to cover daycare expenses - Access to Employee Assistance Programs (EAP) for health and well-being - Optional Pet & Home/Auto Insurance - Wellness Reimbursement program (up to $600 annual reimbursement for wellness-related expenses) - 401K retirement plan (company matches up to 6% of employee contribution) - One paid annual volunteer day

Role Description As a Senior Business Intelligence Engineer, you will be responsible for designing and implementing analytical dashboards using our internal BI tools, leveraging data from BigQuery and REST APIs. You will work closely with stakeholders to define business requirements and ensure the scalability, performance, and usability of customer-facing dashboards. In this role, you will collaborate with Product Managers to shape analytics reporting requirements and partner cross-functionally with developers, designers, and business stakeholders to deliver high-quality analytical solutions. - Ensure solutions are scalable, maintainable, and secure, meeting both technical and business requirements - Oversee the end-to-end development process, from initial concept to deployment of the BI Dashboards - Lead hands-on development using report builder tools and custom coding where necessary - Review and optimize performance of SQL statements - Work closely with UX/UI designers to ensure user-centric design and functionality - Partner with marketing and content teams to deliver flexible and easily manageable content solutions - Engage with clients and internal stakeholders to gather and translate requirements into technical solutions - Automate workflows where possible to reduce manual effort and increase efficiency - Conduct thorough testing of all solutions to ensure stability, functionality, and performance - Implement and enforce best practices for code quality, security, and compliance - Act as a subject matter expert for customer-facing BI dashboards and provide troubleshooting and issue resolution Qualifications - 5+ years of experience in data analytics and developing analytical dashboards - Strong SQL expertise, including query performance optimization (ideally with BigQuery) - Hands-on experience designing and building dashboards/reports following UX/UI best practices - Experience in building and maintaining data pipelines - Strong analytical skills with the ability to interpret data and derive actionable insights Requirements - Experience working with APIs, webhooks, and 3rd-party integrations (e.g., Supermetrics, Funnel, Zapier) - Not Required but a plus - Experience using Python for data extraction, transformation, and integration - Not Required but a plus - Experience with digital marketing and SEO data - Not Required but a plus Benefits - Unlimited PTO - Hobby & team building budget allowance - Employee Support Program - Loss of family member financial aid - Employee Resource Groups

Role Description This position is a field role within Illinois. - Develops strategic marketing plans, considering agency strengths, competitors, and market conditions. - Identifies and secures profitable new business opportunities in target markets and develops and implements strategic plans, resulting in a specified increase in market share. - Cultivates and maintains strong relationships with key agencies by providing tailored insurance solutions that meet their specific needs, leading to an increase in agency retention and satisfaction. - Educates agencies on product features, market placement, and effective selling techniques. - Drives revenue growth by achieving or exceeding sales targets. May develop and execute cross-selling and up-selling strategies. - Conducts market research and competitive analysis to identify trends, opportunities, and threats, informing strategic decision-making. - Performs other duties as assigned. #LI-Remote Qualifications - Bachelor’s Degree in Business Administration, Marketing, or a related field. - Generally, a minimum of 5 years of experience in strategic business development, marketing, or a related role. - Completion of or continuing progress toward certifications including: - Associate in Underwriting (AU) - Chartered Property Casualty Underwriter (CPCU) - Certified Insurance Counselor (CIC) - Program in General Insurance (INS) - Associate of Risk Management (ARM) - Strong understanding of agency dynamics, marketing, underwriting, and risk management. - Demonstrates excellent communication skills and ability to build relationships. - Proficiency in interpreting competitive data and industry trends. - Ensures compliance with insurance laws and regulations, applying underwriting rules, guidelines, and rating manual standards. - Strong analytical skills with the ability to use data to inform decisions. - Demonstrated decision-making ability and customer-centric mindset. - Position requires frequent day and overnight travel (60% - 80% of time) to visit agents and brokers. Benefits - Competitive benefits packages for full-time and part-time employees. - Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. - Full-time and eligible part-time employees enjoy Paid Time Off and paid holidays. - 401(k) plan with company match. - Employee stock purchase plan. - Commuter benefits. Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers . *Excludes seasonal employees and interns.