ABOUT PER SCHOLAS: For 30 years, Per Scholas has been on a mission to drive mobility and opportunity in the ever-advancing technology landscape by unlocking the untapped potential of individuals, uplifting communities, and meeting the needs of employers through rigorous tech training. By teaming up with dynamic employer partners, ranging from Fortune 500 companies to innovative startups, we're forging inclusive tech talent pipelines, fulfilling an ever-increasing need for skilled talent. With national remote training and campuses in 20+ cities and counting, Per Scholas offers no-cost training programs in the most sought-after tech skills, spanning Cloud, Cybersecurity, Data Engineering, IT Support, Software Engineering, and more. To date, 30,000+ individuals have been trained through Per Scholas, propelling their professional trajectories into high-growth tech careers with salaries three times higher than their pre-training earnings. Learn more by visiting PerScholas.org and follow us on LinkedIn, X, Facebook, Instagram, and YouTube. Per Scholas preferred hires reside within the following states: AZ, CA, CO, FL, GA, IL, IN, KS, MD, MA, MI, MO, NC, NJ, NY, OH, PA, TX, WA Position Title: Data Engineer Location: Remote Reports To: EVP, IT Position Summary Per Scholas is seeking a Data Engineer to maintain and expand our enterprise data infrastructure. This role focuses on the technical execution of our data strategy, specifically managing the flow of data into our newly established Snowflake Data Lake. You will be the "bridge" that ensures data from various sources is accurately ingested, transformed, and ready for visualization in Tableau. Core Responsibilities 1. Data Pipeline Management - Set up and monitor automated data ingestion connectors using Fivetran. - Troubleshoot sync errors and work with API providers to ensure continuous data flow. - Write and optimize SQL transformations within Snowflake to prepare data for reporting. - Familiarity or experience with OpenFlow data ingestion is nice-to-have 2. Data Lake Maintenance - Maintain the structure of the Snowflake Data Lake (schemas, tables, and views) as defined in partnership with InterWorks. - Perform regular data quality checks to ensure the "source of truth" remains accurate. - Monitor warehouse performance and assist in managing Snowflake credit consumption. 3. Reporting & Visualization Support - Build and maintain "Published Data Sources" in Tableau for use by various departments. - Assist team members in building complex Tableau dashboards by providing the necessary back-end data structures. - Translate business requests into technical requirements for new data pipelines. 4. Privacy & Compliance - Execute data masking and access control policies to ensure compliance with Data Privacy frameworks. - Assist in maintaining documentation for data lineage and the organizational data dictionary. Required Qualifications - Excellent communication skills, able to communicate technical requirements to non technical audiences - A clear understanding of data modeling and best practices - 2–4 years of professional experience in data engineering or a highly technical data analyst role. - Experience with CI/CD pipelines - Snowflake: Hands-on experience querying and managing tables within a Snowflake environment. - Fivetran: Proficiency in setting up and managing SaaS connectors. - Experience writing and implementing data transformations with dbt (Data Build Tool) - Tableau: Experience in data modeling for Tableau (calculating fields, joining data sets, and optimizing for performance). - Technical Skills: Strong SQL skills are mandatory. Experience with Python for basic scripting is preferred. - Mission-Driven: A genuine interest in using technology to support Per Scholas’ mission of closing the opportunity gap. LI#- Remote For this position, our target salary is $139,000, with a range of $129,000 to $139,000. The variation in compensation typically hinges on factors such as the candidate's geographic location and their qualifications and experience that align with the role. QUESTIONS? If you have any questions about this role, please feel free to email our Talent team at jobs@perscholas.org. We look forward to viewing your application! Equal Employment Opportunity We're proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or national origin. PII Policies Non-Discrimination Policy

• Develop and continuously improve a data service that underpins cloud-based applications • Support data and database modeling efforts • Contribute to the development and maintenance of reusable component libraries and shared codebase • Participate in the entire software development lifecycle, including requirement gathering, design, development, testing, and deployment, using an agile, iterative process • Collaborate with developers, designers, testers, project managers, product owners, and project sponsors to integrate the data service to end user applications • Communicate tasking estimation and progress regularly to a development lead and product owner through appropriate tools • Ensure seamless integration between database and messaging systems and the frontend / UI they support • Ensure data quality, reliability, and performance through code reviews and effective testing strategies • Write high-quality code, applying best practices, coding standards, and design patterns • Team with other developers, fostering a culture of continuous learning and professional growth

Description We are currently looking for an experienced Senior Operations Data Engineer to join our Finance Team. The right candidate will have the opportunity to work fully remote, a hybrid schedule or in the office. The Senior Operations Data Engineer is responsible for designing, building, and optimizing data pipelines and models that support critical financial and operational reporting. This right candidate will work closely with stakeholders across Finance, Operations, and IT to translate complex business questions into structured data solutions, enabling more consistent, reliable, and actionable insights. This includes improving existing data architecture, standardizing key metrics, and enhancing the performance and usability of data across platforms. As a Senior Operations Data Engineer, you’ll play a key role in shaping data practices, influencing decision-making through analytics, and advancing the organization’s overall data capabilities, in support our vision. Benefits for the Senior Operations Data Engineer: - Free Health insurance - Free Dental insurance - Free Vision insurance - Free Life insurance - Free Short-Term & Long-Term Disability insurance - 2% 401k Company Match - 11% 401k Company Contribution - Excellent Paid Time Off - Generous paid time for Parental Leave - Day of Service - We promote from within our widely-talented workforce regularly and consistently offer opportunities to learn and grow - Student Loan Assistance Program - Educational Incentive Program - Several committees to explore, to help you make and keep connections - Two robust Employee Assistance Programs for you and your family - Flexible Work Arrangements that include work locations in the office, hybrid schedules and fully remote. The type of arrangement available is determined by the position and business needs - Matching funds of up to $100 annually are available from the company for your favorite charitable organization - Associate recognition awards, fun gatherings, and opportunities to make friends are part of our culture - An on-site fitness center, as well as free and convenient parking, make life easier Requirements Qualifications and Responsibilities for the Senior Operations Data Engineer: - Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Finance, or related field - 6–10+ years of experience in data engineering, analytics, or advanced data roles - Minimum of 5 years of experience in Property & Casualty Insurance - Advanced SQL and strong experience with data modeling and large datasets - Experience building data pipelines using ETL/ELT methodologies - Proficiency in Power BI or similar data visualization tools - Experience with data warehousing platforms (e.g., Azure Synapse, Snowflake, SQL Server) - Working knowledge of Python or similar scripting languages - Strong ability to connect data solutions to business outcomes - Strong interpersonal communication skills to engage cross-functional stakeholders, translate business needs into technical solutions, and communicate insights clearly to both technical and non-technical audiences Why work for Indiana Farmers Insurance? Imagine working for an employer like this: - An average associate retention rate of 95% over the last 5 years - Financially stable as shown by our A- (Excellent) rating by AM Best - Truly customer focused, as all mutual insurance companies are and - A strong legacy of excellent performance throughout our 149 years in business! For more information about Indiana Farmers Mutual Insurance Company, please go to https://insurance.indianafarmers.com/about-us. Indiana Farmers Insurance is an equal opportunity employer!

• Manage and maintain GCP data services and data middleware solutions (Cloud Storage, Pub/Sub, BigQuery, DBT, Cloud SQL, etc.). • Deploy data applications in staging and production environments using CI/CD pipelines (GitHub) and manage monitoring tools (Google Observability). • Oversee implementation and execution of functional monitoring for pipelines, data quality, and data availability. • Manage Dataiku and Fivetran jobs and pipelines. • Manage execution of Power BI and/or Qlik dashboards. • Handle monitoring alerts, troubleshoot incidents, and address issues within SLAs. • Execute change management workflows for small updates to deployed applications. • Ensure availability of the data product and track performance metrics. • Provide technical support to developers and end users.