Analyst/Programmer Specialist - Smart Gauge Staffing LLC
Indianapolis, IN 46204
About the Job
Short Description:
Resource will be responsible for the activities of an Application Systems Application Analyst/Programmer of Master Data Management team of ***'s child welfare system, which is built on PostgreSQL/Ruby on Rails/SQL Server/ASP .Net Platform.
Complete Description:
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.
Skills:
| Skill | Required / Desired | Amount of Experience |
|---|---|---|
| Information Technology (IT) Experience | Required | 6 Years |
| Strong programming skills in languages like T-SQL, PL/pgSQL or other relevant languages | Required | 4 Years |
| 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 Year |
| 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 | Desired |
Questions:
- Work Schedule is Monday to Friday 8:00AM to 4:30PM (40 hours a week with no overtime required). Do you accept this requirement?
- This 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.
- The selected resource will be required to attend an onsite meeting once a month. Please confirm the resource understands this requirement.
- Resource will be required to pass a Fingerprint background check. Please confirm the resource understands this requirement.
- Resource will have additional background checks and security training, once hired onsite. Please confirm the resource understands this requirement.
- Resource will be required to pick up equipment in person, unless otherwise specified. Please confirm the resource understands this requirement.
- This position has no overtime requirements. Please confirm the resource understands this requirement.
Agency Interview Type:
Webcam only
Work Arrangement:
Remote
Source : Smart Gauge Staffing LLC
