• Gather and analyze business reporting and analytics requirements. • Define KPIs, metrics, and business rules with stakeholders. • Develop, maintain, and enhance dashboards and reports using BI tools. • Design reusable analytical datasets and collaborate with Data Modelers to enhance analytical data models. • Evaluate and refine business reporting requirements to deliver scalable analytical solutions • Perform data analysis to identify trends, patterns, and business insights. • Support Data Governance initiatives by documenting business metrics, dashboard definitions, metadata, and business glossary entries.

Role Description We are seeking a highly skilled Data Engineer with strong Business Intelligence (BI) reporting experience to design, build, and maintain scalable data solutions that support enterprise analytics and reporting needs. The ideal candidate will have expertise in data engineering, data warehousing, ETL/ELT development, and dashboard creation using AWS QuickSight. This role will collaborate closely with business stakeholders, analysts, and technical teams to transform data into actionable insights. Key Responsibilities - Data Engineering - Design, develop, and maintain scalable data pipelines and ETL/ELT processes. - Build and optimize data models, data lakes, and data warehouses in AWS environments. - Integrate data from multiple internal and external sources while ensuring data quality and consistency. - Implement data governance, validation, monitoring, and security best practices. - Optimize database performance, query execution, and data processing workflows. - BI Reporting & Analytics - Develop, maintain, and enhance interactive dashboards and reports using AWS QuickSight. - Translate business requirements into meaningful KPIs, metrics, and visualizations. - Design data models and datasets optimized for reporting and analytics. - Collaborate with business users to gather reporting requirements and provide actionable insights. - Create self-service reporting solutions for business stakeholders. - Ability to configure and manage Row-Level Security (RLS) and apply it across datasets, analyses, and dashboards. - Ability to securely embed QuickSight dashboards into web portals/applications with integrated application-level security and RLS-based access control. - Ability to create and manage QuickSight Topics and Spaces to enable natural language querying and self-service analytics for business users. - Ability to provide AI-powered insights and dashboard interactions through Amazon QuickSight Q/Generative BI capabilities. - Develop cloud-native data solutions leveraging AWS services. - Work with AWS services such as Amazon S3, AWS Glue, Amazon Redshift, Amazon Athena, AWS Lambda, Amazon RDS, and AWS QuickSight. - Implement data security, access controls, and compliance requirements within AWS. - Collaboration & Support - Partner with business analysts, data scientists, and application teams to deliver analytics solutions. - Provide technical guidance on reporting architecture and dashboard best practices. - Troubleshoot data issues and support production reporting environments. - Document data pipelines, reporting solutions, and technical processes. Qualifications - Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field. - 5+ years of experience in Data Engineering, Data Warehousing, or BI Development. - Hands-on experience building and maintaining dashboards using AWS QuickSight. - Strong experience with SQL and relational databases. - Experience developing ETL/ELT pipelines using AWS Glue, Python, Spark, or similar technologies. - Strong understanding of dimensional modeling, star/snowflake schemas, and data warehousing concepts. - Experience with AWS cloud services and data analytics architecture. - Proficiency in Python and/or other scripting languages. - Experience with Git and CI/CD deployment practices. Requirements - AWS Certifications (e.g., AWS Certified Data Engineer, AWS Certified Solutions Architect, AWS Certified Data Analytics). - Experience with Redshift, Athena, and large-scale cloud data platforms. - Knowledge of data governance, data quality frameworks, and metadata management. - Experience working in Agile/Scrum environments. - Familiarity with healthcare, federal, financial, or regulated industry reporting environments. Technical Skills Required - AWS QuickSight - SQL - Python - AWS Glue - Amazon Redshift - Amazon S3 - Amazon Athena - ETL/ELT Development - Data Modeling - Data Warehousing Preferred - Apache Spark - Lambda - Airflow - Terraform - Tableau or Power BI - Snowflake Key Competencies - Strong analytical and problem-solving skills. - Excellent communication and stakeholder engagement abilities. - Ability to translate business requirements into technical solutions. - Attention to detail and commitment to data quality. - Strong collaboration and teamwork skills. Nice-to-Have Experience - Federal government or healthcare data environments. - Building executive dashboards and KPI scorecards. - Data migration and modernization initiatives. - Real-time or near-real-time analytics solutions. Target Experience Level Junior-Mid (5–10+ years) Primary Focus Data Engineering, AWS Data Platform, BI Reporting, AWS QuickSight Dashboard Development. Benefits We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life.

• Managing the end-to-end rollout of new Power BI dashboards to business end users across Sales and Finance functions. • Coordinating and overseeing user acceptance testing, ensuring dashboards are validated before full deployment. • Supporting users in transitioning from static legacy reports (IBM Cognos) to interactive Power BI dashboards, driving adoption and reducing friction. • Capturing issues raised by end users, prioritising resolution with the development team, and tracking outcomes through to completion. • Identifying unmet reporting and information needs within the business and feeding structured requirements back to the development team. • Owning communication between end users and IT, ensuring feedback loops are clear, consistent, and followed through. • Engaging stakeholders at all levels, from individual contributors in sales to senior finance leadership, with confidence and clarity. • Conducting training and enablement sessions to accelerate user adoption and reduce dependency on legacy tooling.

Title: Business Intelligence Engineer Location: Lansing United States Job Description: time type Full time job requisition id R_13795 A career at Auto-Owners is challenging and rewarding. Our group of caring associates create financial security by helping individuals and businesses make a new start when a loss occurs. Job Description We offer a merit-based work-from-home program based on job responsibilities. After initial training in-person, this specific role could have the flexibility to work from home up to 3 days per week. Auto-Owners Insurance, a top-rated insurance carrier, is seeking a motivated entry-level Business Intelligence Engineer to join our team. The position is responsible for creating data processes, assets, and solutions to help us accomplish our growth and profitability objectives and requires the person to: - Create data extracts and infrastructure to support the Business Intelligence Reporting teams. - Build, maintain, and document code used to transform, aggregate, and present data. - Learn and apply the tools and techniques employed in designing and implementing data engineering solutions. - Develop an understanding of our data sources and data flows. - Effectively communicate with other employees through verbal and written means. - Participate in both formal and informal training sessions. Desired Skills & Experience - Bachelor’s degree or higher in Mathematics, Statistics, Actuarial Science, Computer Science, or another related technical field is required - High aptitude for mathematics and statistics - Actuarial studies and exams are considered but not required - Experience with Microsoft SQL, Python or other programming/database/statistical languages - Proficient in Microsoft Excel - Above average communication skills (written and verbal) - Ability to adapt to constant change and innovation Benefits Auto-Owners offers a wide range of career opportunities, and we are seeking talent that will help us continue our long tradition of success. We offer a friendly work environment, structured training program, employee mentoring and an excellent compensation/benefits package. Along with a competitive base salary, matched 401(k), fully-funded pension plan (once vested), and bonus programs, Auto-Owners also provides generous paid time off including holidays, vacation days, personal time, and sick leave. If you're looking to do rewarding work alongside great people, Auto-Owners is the place for you! Equal Employment Opportunity Auto-Owners Insurance is an equal opportunity employer. The Company hires, transfers, and promotes on the basis of ability, without consideration of disability, age, sex, race, color, religion, height, weight, marital status, sexual orientation, gender identity or national origin, or any factor contrary to federal, state or local law. *Please note that the ability to work in the U.S. without current or future sponsorship is a requirement. #LI-DNI #IN-DNI