IN-DCS-Application System Analyst Programmer

Resource will be responsible forthe activities of an Applications Systems Analyst/Programmer of Master DataManagement team of State of Indiana s child welfare system which is built on aPostgreSQL/Ruby on Rails/SQL Server/ASP .Net platform.

Resource will be responsible forthe activities of an Applications Systems Analyst/Programmer of Master DataManagement team of State of Indiana s child welfare system which is built on aPostgreSQL/Ruby on Rails/SQL Server/ASP .Net platform. This system is currentlybeing rebuilt on Salesforce and MuleSoft platform . Resource will work underthe direction of the Indiana Department of Child Services (DCS) Child Welfare(CW) IT Office.

Responsibilities Include:

Design and develop interactive and dynamicreports for business intelligence.

Work on Integration of data from various sourcesinto a unified system.

Assist in design and implementation of MasterData Management solutions.

Proactive in identifying and resolvingperformance bottlenecks and data quality issues.

Adhere to SQL Development best practices.

Meet project deadlines and requirements whileworking in an independent and remote role.

Communicate progress needs and planning withsupervisors on a weekly basis or as requested.

Perform other related duties as assigned.

Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceInformation Technology (IT) ExperienceRequired6YearsExtensive Experience in Postgres SQL and SQL Server Databases and Reporting with Strong programming skills in languages like TSQL PL/pgSQL or otherRequired5YearsDatabase Systems/Database Tools (Microsoft SQL Server RDBMS Advanced and PostgreSQL Advanced) Required4YearsETL SSIS or similar Required4YearsSSRS or other reporting tools Required4YearsProficient in writing complex SQL queries stored procedures and functionsRequired2YearsExperience with database design schema creation and maintenance as well as Strong programming skills in languages like TSQL PL/pgSQLRequired2YearsSQL Server features such as indexing partitioning and securityRequired2YearsPerformance tuning and optimization of database queriesRequired2YearsProficient in designing developing and maintaining SSIS packagesRequired2YearsExperience with data migration ETL processes and data transformation using SSIS with Knowledge of best practices for SSIS development and deploymeRequired2YearsHandson experience in designing and creating reports using SSRS with Knowledge of best practices for SSIS development and deploymentRequired2Yearsidentifying and resolving databaserelated issues and Strong debugging skills for troubleshooting code and performance problemsRequired2YearsAbility to work on multiple projects simultaneously manage priorities and meet deadlinesRequired2YearsBachelor s degreeHighly desired4YearsKnowledge of TableauDesired2YearsAbility to work within a team environmentDesired2YearsStrong communication skillsDesired2YearsExperience with Salesforce DataDesired2YearsKnowledge of Child Welfare Information SystemDesired2Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirementQuestion2Please list candidates email address.Question3Please list the city and state where candidate currently resides.Question4Candidate must be paid BETWEEN BR and BR if selected for engagement. The provider markup for this position is 19%. Do you accept this requirementQuestion5Work Schedule is Monday to Friday 8:00AM to 4:30PM (37.5 hours a week with no overtime required). Do you accept this requirementQuestion6Only candidates living in IN will be considered for this role. Please confirm your candidate lives in IN.Question7This position requires a passed fingerprint and background check. Please confirm the resource understands this requirement.Question8This position has a remote work schedule. If the DCS policy changes to a hybrid work schedule the resource will be required to work onsite. Please confirm the resource understands this requirement. Question9The selected resource will be required to attend an onsite meeting once a month. Please confirm the resource understands this requirement.Question10Positions will be longer term and last after 6/30/24. Please confirm the resource understands the possibility of a longer duration.Question11Equipment is provided however in person pick up of equipment unless otherwise specified. Do you accept this requirementQuestion12There will be addition background checks and security training once hired/onsite. Do you accept this requirement