Departmental Specialist 13 - System Integration...

This position serves as the System Integration Specialist for the Michigan Department of Agriculture and Rural Development (MDARD) within the System Integration Unit. The position is responsible for developing, maintaining, and enhancing data systems that support MDARD program operations, with a focus on SQL database management, script writing, system interfaces, data exchanges, and Agile delivery practices. The role oversees User Acceptance Testing (UAT), data modeling, security-compliant integration processes, and system documentation while collaborating closely with DTMB, vendors, and internal program areas. This position supports ongoing modernization efforts and ensures reliable, accurate, and seamless system integration across MDARD's enterprise systems., Please explain the experience you have working with SQL (queries, views, functions, stored procedures)?

Possession of a bachelor's degree in any major., Four years of professional experience, including two years equivalent to the experienced (P11) level or one year equivalent to the advanced (12) level., Alternative experience qualifications of nonprofessional experience, previously identified by the appointing authority and approved by Civil Service, will be accepted as a substitute for the required classified, professional experience for the classification. The nonprofessional experience must be related to departmental programs and services that provide the required knowledge, skills, and abilities.

Individuals appointed must possess the department-specific alternative experience for positions within that agency only.

NOTE:Equivalent combinations of education and experience that provide the required knowledge, skills, and abilities will be evaluated on an individual basis., DEPSPL - Do you possess one of the following? A bachelor's degree or higher in any major. If so, please attach a copy of your official college transcripts. OR At least one year of professional experience in the state classified service., DEPSPL - Do you possess at least four years of professional experience?, How many years of experience do you have working with SQL (queries, views, functions, stored procedures)?, Please select the number of years' experience building dashboards or reports using Power BI or similar tools., Please explain the experience you have building dashboards or reports using Power BI or similar tools., How many years of experience do you have participating in Agile project development methodology?, Please explain your experience in Agile project development methodology. If you have no experience, indicate N/A.

11

Please describe your experience building partnerships inside and outside your current organization. If you have no experience, indicate N/A.

Vacation and Sick Leave:Eligible full-time employees receive between15 and 35 personal daysand 13 sick daysper year that may be rolled over to the following year if not used. Eligible employees also receive an additional day each year for community service or school functions.

Paid Parental Leave:Eligible employees can take 12 weeks of paid leaveimmediately after a birth or adoption to allow needed time together at home with a new child.

Paid Holidays:Eligible employees receive 13 or 14 paid holidays each year including New Year's Eve and Day, Martin Luther King Jr. Day, Presidents' Day, Memorial Day, Juneteenth, the Fourth of July, Labor Day, Election Day, Veterans Day, Thanksgiving, Thanksgiving Friday, Christmas Eve and Day.

Bonus Programs:Eligible employees with five years of service also receive annual longevity bonuses that grow as seniority increases. Some positions also may qualify for recruitment, retention, and performance bonuses or other special pay premiums.

Military Pay Differential:Employees in the guard or reserves may also qualify for supplemental pay benefits if miliary pay during qualifying duty is less than normal state pay. Prior military service may also allow seniority credits to accelerate eligibility for longevity bonuses and additional personal leave accrual.

Tax-Advantaged Programs:In addition to 401(k) and 457 retirement accounts, the state also offers flexible spending account (FSA), health savings account (HSA), and qualified transportation fringe benefit (QTFB) programs that can help you save money by reducing your taxable income.

Student Loan Forgiveness:Working for the State of Michigan may allow you to participate in programs that forgive the balance of qualifying student loans. Please view Student Loan Information (https://studentaid.gov/manage-loans/forgiveness-cancellation) to help determine if you could qualify is available from the U.S. Department of Education.

Tuition Reduction:Some colleges and universities offer savings to eligible employees and family members to further their education while working for the State of Michigan.

Professional Development: To help develop your career, programs are available to apply for reimbursement of up to $2,000 a year for education and training for college course credits and non-degree programs.

Alternative and Remote Work Schedules:Depending on the nature of their duties, many state jobs offer flexible work schedules and remote or hybrid telecommuting options that can help obtain the work-life balance that you seek.

Great Lakes and Great Times:Michigan boasts four Great Lakes, 11,000 inland lakes, 36,000 miles of rivers and streams, 20 million acres of forests, 100 state and national parks and recreation areas, 1,300 miles of bike trails, 6,500 miles of snowmobile trails, the second-most ski areas in the nation, 650 public golf courses, 600 campgrounds, and an international dark-sky park-just for starters. Our cities offer concerts and cultural events, storied sports teams, education hubs, vibrant downtowns, one-of-a-kind craft beverages, and renowned restaurants for every appetite. From urban centers to beach towns to the great outdoors, the opportunities are endless. With your state salary and benefits and Michigan's affordable cost of living, you can explore all that Michigan has to offer.

Food and Agriculture is one of the largest industries in Michigan. Grow with us and make a difference!, The Michigan Department of Agriculture and Rural Development (MDARD) is comprised of four bureaus that use a customer-driven, solution-oriented approach to cultivate and expand new economic opportunities for the food and agricultural sector; safeguard the public's food supply; inspect and enforce sound animal health practices; control and eradicate plant pests and diseases threatening the $125.8 billion food and agriculture system; preserve the environment by which the farming community makes their living and feeds consumers; and protect consumers by enforcing laws relating to weights and measures. MDARD offers a positive work-life balance with optional hybrid work options and flexible work schedules. Department leaders support a great team culture and are committed to professional development. MDARD is committed to a department-wide diversity, equity, and inclusion program that builds upon our values and invests in our employees. We provide an inclusive culture through involvement and empowerment, where the inherent worth and dignity of all people are recognized., State employment also offers rewarding careers where you can help Michiganders enjoy better lives. Many State of Michigan jobs offer alternate work schedules and remote-work options that can help give the flexibility you need. The State of Michigan has been recognized as a leading U.S. employer by new graduates from 2021-2023 and a best large U.S. and state employer. Recognized on the international stage for fostering positive employee engagement, the State of Michigan is a past recipient of a North America Government Agency Employees Engagement Award. More details on benefits for our new hires are below: Rewarding Work:State of Michigan jobs allow you to serve Michiganders in many different ways depending on your interests and skills. Help preserve and protect our environment and the public health; enforce state laws and regulations; advocate for children, families, and victims of discrimination; support our state's military and veterans; rebuild our state's infrastructure; or support other state agencies through our fiscal, IT, and HR systems.