Data Engineer

Data Engineer Job Class: Information Technology Specialist 3 Location: St. Paul; Telework Eligible: Yes This position will serve as the primary data engineer, responsible for planning, designing, developing, and managing modern data solutions and applications, including reporting, business intelligence systems, data warehousing, and data infrastructure. This position may serve as a primary or backup role in supporting other software systems used by the OSA. This position is expected to work independently, and in a team setting. Work location: The employee must be able to work onsite at the Office of the State Auditor, 525 Park Street, Suite 500, St. Paul, Minnesota. This is a hybrid position. Minimum Qualifications Three (3) years of experience designing and developing data warehouse solutions. Three (3) years of experience developing reports, dashboards, and datasets using Power BI and SQL Server Reporting Services (SSRS). Three (3) years of experience developing Extract Transform Load (ETL) and Extract Load Transport (ELT) processes and data pipelines using Azure Data Factory and SQL Server Integration Services (SSIS). Three (3) years of experience of C# or Python programming experience developing data solutions and automation. Three (3) years of experience of T‑SQL programming experience creating tables, views, stored procedures, and queries using Microsoft SQL Server. Two (2) years of experience developing solutions using Microsoft Fabric. Preferred Qualifications Four (4) years of experience designing and developing enterprise cloud-based data warehouse solutions using Azure data platform. Four (4) years of experience with SQL Server database design, development, and administration. Four (4) years of experience gathering and documenting business and technical requirements and translating those requirements into scalable data solutions. Two (2) years of experience developing solutions using Microsoft Power Platform (Copilot Studio, Power Automate, Power Apps) and SharePoint. Two (2) years of experience developing machine learning models and generative AI solutions. Two (2) years of experience developing automated deployment pipelines using CI/CD tools (Azure DevOps, GitHub). Experience with Version Control Systems (Subversion, Git). Experience with Esri ArcGIS Software for creating maps, dashboards, and visual elements. Physical Requirements Requires occasional transport of less than 10 pounds, along with ability to move through work space and maintain a stationary position throughout the work day. Additional Requirements Job offer is contingent upon candidate passing a job‑related background check that may include the following: reference checks to verify job‑related credentials, a criminal background check and driver’s history check prior to appointment. Must be legally authorized to work in the country of employment without sponsorship for employment via status (e.g. H1B status). Benefits Paid vacation and sick leave 12 paid holidays each year Low‑cost medical, dental, vision, and prescription drug plans Fertility care, including IVF Diabetes care Dental and orthodontic care for adults and children 6 weeks paid leave for parents of newborn or newly adopted children Pension plan that provides income when you retire (after working at least three years) Employer paid life insurance to provide support for your family in the event of death Short‑term and long‑term disability insurance that can provide income if you are unable to work due to illness or injury Tax‑free expense accounts for health, dental, and dependent care Resources that provide support and promote physical, emotional, social, and financial well‑being Support to help you reach your career goals: Training, classes, and professional development Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program.)

EQUAL OPPORTUNITY EMPLOYERS

Minnesota state agencies are equal opportunity, affirmative action, and veteran‑friendly employers. State agencies are committed to creating a workforce that reflects the diversity of the state and strongly encourages persons of color and Indigenous communities, members of the LGBTQIA2S+ community, individuals with disabilities, women, and veterans to apply. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve Minnesotans. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy, childbirth, and disabilities related to pregnancy or childbirth), gender identity, gender expression, marital status, familial status, age, sexual orientation, status regarding public assistance, disability, veteran status or activity in a local Human Rights Commission or any other characteristic protected by law. Applicants With Disabilities Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. #J-18808-Ljbffr Minnesota State University, Mankato