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.

• 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.

• 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 Dev Ops, Git Hub).
• Experience with Version Control Systems (Subversion, Git).
• Experience with Esri ArcGIS Software for creating maps, dashboards, and visual elements.

• 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.

• 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).

• 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.)

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…