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 of this role will 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.
Requirements
Information Technology (IT) Experience Required: 6 Years
Strong programming skills in languages like T-SQL, PL/pgSQL or other relevant languages Required:4Years
Experience with data migration, ETL processes, and data transformation using SSIS or similar Required: 4 Years
Microsoft SQL Server Reporting Services (SSRS) Advanced Required:4 Years
Microsoft SQL/Postgres Database Required: 4 Years
Master Data Management Required: 4 Years
Data Analytics and Reporting Required: 4 Years
Proficient in Atlassian tools (Jira/Confluence) Required: 1 Years
Microsoft SQL Server Integration Services (SSIS) Advanced Required
Microsoft SQL Server Analysis Services (SSAS) Advanced Required
Experience with Tableau Desired
Experience with other ETL Tools Desired
Experience with MuleSoft Desired
Experience with Salesforce Data Desired
Knowledge of Child Welfare Information System