STATE SYSTEMS ADMINISTRATOR

Position Number: 22098529 
County: Pulaski 
Posting End Date: 04/14/2025 
Anticipated Starting Salary: $71,703.63 
DMS 
Hiring Official: Nell Smith

Functional Job Title: DMS IT ENGINEER

Summary: The DMS IT Engineer collaborates with DMS staff to understand reporting needs and requirements to generate insightful reports and dashboards to facilitate data-driven decision making. This function requires a meticulous person with an extremely strong analytical mindset, excellent communication skills (both verbal and written), and a passion for understanding the needs of the organization.

Preferred Qualifications: Prior work experience with PowerBI/Cognos Dashboards and reports, Snowflake Database, and worked in a large-scale data warehouse environment.

Summary: The DMS IT Engineer collaborates with DMS staff to understand reporting needs and requirements to generate insightful reports and dashboards to facilitate data-driven decision making. This function requires a meticulous person with an extremely strong analytical mindset, excellent communication skills (both verbal and written), and a passion for understanding the needs of the organization.

Special Requirements:
•    Understanding of Medicaid programs, commercial insurance, health systems.
•    Commitment to accuracy and quality of reports, including ability to learn from previous experiences to inform future efforts 
•    Possess and apply analytical and communication skills to understand report outcomes and identify data trends, learn and understand how data is stored and structured, and translate between business and technical stakeholders.

•    Demonstrate ability to design and create visually appealing , useful reports and dashboards.
•    Ability to handle sensitive and often urgent matters with a focus on problem resolution and learning from experience 
•    Ability to facilitate discussions among a variety of stakeholders and synthesize information in an easily understandable way 
•    Ability to work collaboratively across teams to identify root causes and solutions 
•    Data management skills, PowerBI and Cognos dashboard/report skills, Snowflake, JIRA, problem-solving skills, communication skills, interpersonal skills, continuous learning and adaptability skills

Functions :-

    The IT Engineer primary duties will include enhancing and optimizing current analytical techniques, assist in analyzing any data anomalies, generate ad hoc/periodic reports using SQL queries / Microsoft PowerBI, collaborate with partners on data warehouse in new initiatives and existing functionality improvements. Prior Work experience with data warehouse, developing PowerBI dashboards/reports, Cognos reports in a cloud based Snowflake database. This position is governed by state and federal laws and agency/institution policy.

Knowledge, Skills, and Abilities: -

• Ability to create and modify reports, dashboards using Microsoft PowerBI and Cognos.
• Ability to write SQL Queries to retrieve data from backend Snowflake and other relational Database.
• Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.
• Experience in Data warehousing – OLTP, OLAP, Dimensions, Facts and Data Modelling.
• Knowledge of Snowflake utilities like SnowSQL, Metadata Manager, data sharing and stored procedures.
• Ability to analyze data from multiple sources, identify data anomalies and recommend corrective actions.
• Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.

The Department of Human Services is a place for people passionate about serving others and changing lives for the better. We care for Arkansans of all ages and ensure places like child care centers and nursing homes are safe. We are the safety net for the most vulnerable Arkansans. Whether you answer the phones, take applications, protect children, or help care for residents or patients at one of our facilities, you make a difference by working at DHS. Plus, working for the State has great perks, including a pension, maternity leave, paid state holidays, and much more. At DHS, we take care of our employees so you can help care for others.

The State of Arkansas is committed to providing equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, pregnancy, age, disability, citizenship, national origin, genetic information, military or veteran status, or any other status or characteristic protected by law.