Role/Title: - Application System Analyst Programmer
Remote, Indianapolis, Indiana
Agency Interview Type: Webcam only
Candidate must currently be local to Indiana. Please provide the address the candidate resides.
Need to attend meeting once in a month.
General Description
Resource will be responsible for the activities of an Applications Systems Analyst/Programmer of Master Data Management team of State of Indiana’s child welfare system, which is built on a PostgreSQL/Ruby on Rails/SQL Server/ASP.NET platform.
Job Description
Resource will be responsible for the activities of an Applications Systems Analyst/Programmer of Master Data Management team of State of Indiana’s child welfare system, which is built on a PostgreSQL/Ruby on Rails/SQL Server/ASP.NET platform. This system is currently being rebuilt on Salesforce and MuleSoft platform. Resource will work under the direction of the Indiana Department of Child Services (DCS), Child Welfare (CW) IT Office.
Responsibilities Include:
Design and develop interactive and dynamic reports for business intelligence.
Work on Integration of data from various sources into a unified system.
Assist in design and implementation of Master Data Management solutions.
Proactive in identifying and resolving performance bottlenecks and data quality issues.
Adhere to SQL Development best practices.
Meet project deadlines and requirements while working in an independent and remote role.
Communicate progress, needs, and planning with supervisors on a weekly basis, or as requested.
Perform other related duties as assigned.
Skills Matrix
Information Technology (IT) Experience Required6 Years
Extensive Experience in Postgres SQL and SQL Server Databases and Reporting with Strong programming skills in languages like T-SQL, PL/pgSQL, or other Required 5 Years
Database Systems/Database Tools (Microsoft SQL Server RDBMS Advanced and PostgreSQL Advanced) Required 4 Years
ETL - SSIS or similar Required 4 Years
SSRS or other reporting tools Required 4 Years
Proficient in writing complex SQL queries, stored procedures, and functions Required 2 Years
Experience with database design, schema creation, and maintenance as well as Strong programming skills in languages like T-SQL, PL/pgSQLRequired 2 Years
SQL Server features such as indexing, partitioning, and security Required 2 Years
Performance tuning and optimization of database queriesRequired 2 Years
Proficient in designing, developing, and maintaining SSIS packages Required 2 Years
Experience with data migration, ETL processes, and data transformation using SSIS with Knowledge of best practices for SSIS development and deployment Required 2 Years
Hands-on experience in designing and creating reports using SSRS with Knowledge of best practices for SSIS development and deployment Required 2 Years
identifying and resolving database-related issues and Strong debugging skills for troubleshooting code and performance problems Required 2 Years
Ability to work on multiple projects simultaneously, manage priorities, and meet deadlines Required 2 Years
Bachelor’s degree Highly desired 4 Years
Knowledge of Tableau Desired 2 Years
Ability to work within a team environment Desired 2 Years
Strong communication skills Desired 2 Years
Experience with Salesforce DataDesired2 Years
Knowledge of Child Welfare Information System Desired 2 Years