Information Resource Group
IN-DCS-Analyst/Programmer Specialist
Information Resource Group, Indianapolis, Indiana, us, 46262
Resource will be responsible for the activities of an Application Systems Application Analyst/Programmer of Master Data Management team of State of Indiana's child welfare system, which is built on PostgreSQL/Ruby on Rails/SQL Server/ASP .Net Platform.
This system is currently beingrebuilt on Salesforce and MuleSoft platform . Resource will work under thedirection of the Indiana Department of Child Services (DCS), Child Welfare (CW)IT Office.
Responsibilities of this rolewill include:•Design and develop interactive and dynamic reportsfor 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) ExperienceRequired6YearsStrong programming skills in languages like T-SQL, PL/pgSQL or other relevant languagesRequired4YearsExperience with data migration, ETL processes, and data transformation using SSIS or similar Required4YearsMicrosoft SQL Server Reporting Services (SSRS) AdvancedRequired4YearsMicrosoft SQL/Postgres Database Required4YearsMaster Data Management Required4YearsData Analytics and Reporting Required4YearsProficient in Atlassian tools (Jira/Confluence)Required1YearsMicrosoft SQL Server Integration Services (SSIS) AdvancedRequired0Microsoft SQL Server Analysis Services (SSAS) AdvancedRequired0Experience with TableauDesired0Experience with other ETL ToolsDesired0Experience with MuleSoftDesired0Experience with Salesforce DataDesired0Knowledge of Child Welfare Information SystemDesired0Questions
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 agree to this requirement?Question2What is your candidate's email address?Question3Where does your candidate currently reside (City & State)?Question4If selected for engagement, your candidate's hourly Pay Rate must be BETWEEN $35.06 and $41.20. The Provider Markup for this position is 19%. Do you agree to these requirements?Question5Work Schedule is Monday to Friday 8:00AM to 4:30PM (40 hours a week with no overtime required). Do you accept this requirement?Question6This 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.Question7The selected resource will be required to attend an onsite meeting once a month. Please confirm the resource understands this requirement.Question8Resource will be required to pass a Fingerprint background check. Please confirm the resource understands this requirement.Question9Resource will have addition background checks and security training, once hired onsite. Please confirm the resource understands this requirement.Question10Resource must currently reside in the State of Indiana. Please confirm the resource understands this requirement.Question11Resource will be required to pick up equipment in person, unless otherwise specified. Please confirm the resource understands this requirement.Question12This position has no overtime requirements. Please confirm the resource understands this requirement.
This system is currently beingrebuilt on Salesforce and MuleSoft platform . Resource will work under thedirection of the Indiana Department of Child Services (DCS), Child Welfare (CW)IT Office.
Responsibilities of this rolewill include:•Design and develop interactive and dynamic reportsfor 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) ExperienceRequired6YearsStrong programming skills in languages like T-SQL, PL/pgSQL or other relevant languagesRequired4YearsExperience with data migration, ETL processes, and data transformation using SSIS or similar Required4YearsMicrosoft SQL Server Reporting Services (SSRS) AdvancedRequired4YearsMicrosoft SQL/Postgres Database Required4YearsMaster Data Management Required4YearsData Analytics and Reporting Required4YearsProficient in Atlassian tools (Jira/Confluence)Required1YearsMicrosoft SQL Server Integration Services (SSIS) AdvancedRequired0Microsoft SQL Server Analysis Services (SSAS) AdvancedRequired0Experience with TableauDesired0Experience with other ETL ToolsDesired0Experience with MuleSoftDesired0Experience with Salesforce DataDesired0Knowledge of Child Welfare Information SystemDesired0Questions
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 agree to this requirement?Question2What is your candidate's email address?Question3Where does your candidate currently reside (City & State)?Question4If selected for engagement, your candidate's hourly Pay Rate must be BETWEEN $35.06 and $41.20. The Provider Markup for this position is 19%. Do you agree to these requirements?Question5Work Schedule is Monday to Friday 8:00AM to 4:30PM (40 hours a week with no overtime required). Do you accept this requirement?Question6This 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.Question7The selected resource will be required to attend an onsite meeting once a month. Please confirm the resource understands this requirement.Question8Resource will be required to pass a Fingerprint background check. Please confirm the resource understands this requirement.Question9Resource will have addition background checks and security training, once hired onsite. Please confirm the resource understands this requirement.Question10Resource must currently reside in the State of Indiana. Please confirm the resource understands this requirement.Question11Resource will be required to pick up equipment in person, unless otherwise specified. Please confirm the resource understands this requirement.Question12This position has no overtime requirements. Please confirm the resource understands this requirement.