IN-DCS - Analyst / Programmer Specialist

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.

Candidate must be currently located in Indiana to be considered for this position.

Responsibilities of this role will include :

• Design and develop interactive and dynamic reports for business intelligence.
• Maintenance and Operations on current reports which may require modifications.
• 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.

Required / Desired Skills

SkillRequired / DesiredAmountof ExperienceInformation Technology Experience Required6YearsData Analytics and ReportingRequired4YearsExperience in Postgres SQLRequired4YearsStrong programming skills in languages like T-SQL, PL / pgSQL or other relevant languagesRequired4YearsExperience with data migration, ETL processes and data transformation using SSISRequired4YearsMaster Data Management Required4YearsMicrosoft SQL Server Reporting Services (SSRS)Required4YearsKnowledge of reports deployment, scheduling and security in SSRSRequired4YearsAtlassian ToolsRequired1YearsExperience with databases design, schema creation and maintenance Highly desired0Microsoft SQL Server Analysis Services (SSAS) including the lastest versionsHighly desired0Knowledge of Tableau and Power BIDesired0

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 agree to this requirement?Question2Please provide the candidate's email address.Question3Please provide the City & State the candidate currently resides.Question4If selected for engagement, your candidate's hourly Pay Rate must be BETWEEN and . The Provider Markup for this position is 19%. Do you agree to these requirements?Question5Work schedule is Monday to Friday 8 : 00AM to 5 : 00PM working 40 hours per week. Please confirm the resource understands the work schedule.Question6The selected resource will be required to work full-time on-site. Please confirm the resource understands this requirement.Question7This position requires a passed fingerprint and background check prior to the start date. Please confirm the resource understands this requirement.Question8Candidate must be currently located in Indiana to be considered for this position. Please confirm.