Data Engineer at MGT Insurance

About MGT InsuranceMGT is the first AI-driven neo-insurer focused on evolving commercial P&C insurance for the brokers and small business owners. By combining the expertise of industry veterans with state-of-the-art technology we are ushering in the next evolution of commercial insurance and working to move the industry forward through the use of modern technology better processes and a rock-star team. We seek visionary leaders who thrive in dynamic entrepreneurial settings and excel in autonomous roles.About the RoleWere seeking a Data Analyst to join our growing team and help transform raw data into actionable insights that drive business decisions across underwriting operations and strategic this role youll own end-to-end analytics projects build scalable reporting solutions in Looker and Google Cloud Platform and work directly with leadership to answer critical business questions.This is a high-impact role where your work will directly influence product strategy operational efficiency and growth initiatives. The ideal candidate combines strong analytical thinking with technical execution skills has a passion for storytelling with data and thrives in a fast-paced startup environment where priorities shift quickly and autonomy is essential.LocationCandidates based in Denver CO Madison WI or San Francisco CA are strongly preferred to facilitate close collaboration with our team.Analytics & InsightsConduct deep-dive analyses on underwriting performance loss ratios and portfolio trends to inform strategic decisionsDevelop financial and operational models to support forecasting budgeting and business planningTranslate complex data findings into clear actionable recommendations for non-technical stakeholdersPartner with underwriting and operations teams to identify opportunities for process optimizationPerform ad-hoc analyses to answer critical business questions and support leadership decision-makingBusiness Intelligence & ReportingDesign build and maintain interactive dashboards and reports in Looker (our primary BI platform)Establish key performance indicators (KPIs) and create automated reporting frameworksDevelop self-service analytics capabilities to empower teams across the organizationMonitor business metrics and identify trends anomalies and areas for improvementCreate executive-level presentations and financial reports for leadership and board meetingsData Engineering & InfrastructureWrite efficient SQL queries to extract transform and analyze data from multiple sources in BigQueryBuild and maintain data pipelines using Dataform and Cloud Functions in Google Cloud PlatformEnsure data quality and integrity through validation frameworks and testing protocolsWork with data from Socotra (our policy administration system) and other insurance platform APIsCollaborate with engineering teams to improve data infrastructure and accessibilityDocument data definitions business logic and analytical processesCross-Functional CollaborationWork closely with FP&A to support financial planning variance analysis and investor reportingPartner with product and engineering teams to define data requirements for new featuresSupport underwriting with risk assessment analytics and portfolio segmentationCommunicate insights effectively to stakeholders at all levels of the organizationQualifications3-5 years of experience in data analytics business intelligence or related rolesAdvanced SQL proficiency for complex data extraction transformation and analysis (joins window functions CTEs query optimization)Strong experience with BI tools such as Looker Tableau or Power BIUnderstanding of data modeling statistical analysis and analytical methodologiesExcellent communication skills with ability to translate technical concepts for business audiencesEntrepreneurial mindset with ability to work independently and drive projects to completionExperience working in a fast-paced environment where priorities change frequentlyPreferred QualificationsFP&A background with experience in financial modeling forecasting and variance analysisData engineering skills including experience building ETL pipelines in GCP (BigQuery Dataform Cloud Storage)Experience in the insurance industry with knowledge of underwriting metrics loss ratios and insurance operationsFamiliarity with version control (Git) and modern data stack toolsExperience with Socotra or other insurance policy administration systemsPython or R for statistical analysis and data manipulationWho We AreSmall & Agile: Were a tight-knit team who moves fast and makes things happenHigh Agency: We operate with autonomy and ownership - everyone acts like a founder and drives meaningful impactAction-Oriented: We believe in see something do something - no bureaucracy just resultsPassionate Builders: We take pride in creating elegant solutions and solving real problemsTeam First: We genuinely enjoy working together and believe great products come from great relationshipsQuality Focused: We deliver work were proud of and build systems that stand the test of timeWhat We OfferCompetitive salary and benefits packageHigh-impact role with direct visibility to leadership and boardOpportunity to shape analytics infrastructure and strategy from the ground upCollaborative and forward-thinking work environment at the intersection of AI and insuranceContinuous learning and career development opportunities in insurance technology and data scienceOur Commitment to Diversity Equity & InclusionAt MGT inclusion drives excellence and belonging sustains it. We believe diverse perspectives make us stronger more innovative and more connected to the people we serve. We value every voice champion equity and create space where all people can grow and succeed together.Equal Employment Opportunity StatementMGT is proud to be an Equal Opportunity Employer. We do not discriminate in employment opportunities or practices based on race color religion gender gender identity or expression sexual orientation national origin age disability genetic information marital status military or veteran status or any other status protected by applicable law.All employment decisions are based on qualifications merit and business needs. We are committed to providing reasonable accommodations for qualified individuals with disabilities throughout the application and employment process. If you need assistance or accommodations please contact us at .DisclaimerThis job description is intended to outline the general nature and level of work performed by employees in this role. It is not an exhaustive list of all responsibilities duties or qualifications required. MGT Insurance reserves the right to modify interpret or apply this job description in any way the company deems appropriate. Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full Time Experience: years Vacancy: 1