Data Engineer

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., The Office of the State Auditor serves Minnesotans by protecting local decisions close to home. The OSA provides support and analysis to local entities so they can make decisions for their communities based on facts. At the OSA we pride ourselves on our supportive work environment for our staff., * A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance

• Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
• Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care

• 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 DevOps, GitHub).
• 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 through out the work day., * Must be legally authorized to work in the country of employment without sponsorship for employment via status (e.g. H1B status).

Pulled from the full job description

• Loan forgiveness
• Paid parental leave
• Health insurance
• Vision insurance
• Dental insurance
• Flexible spending account
• Life insurance, As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.

Your benefits may include:

• 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