Analyst/Programmer Specialist

Agency Interview Type:

Webcam only

Work Arrangement:

Remote

The selected resource will be required to attend an onsite meeting once a month. 

Short Description:

Resource will be responsible for the activities of an Application Systems Application Analyst/Programmer of Master Data Management team., 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 .

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
Expertise Rating
Move

Information Technology (IT) Experience
Required
 
Years
 
 

Strong programming skills in languages like T-SQL, PL/pgSQL or other relevant languages
Required
 
Years
 
 

Experience with data migration, ETL processes, and data transformation using SSIS or similar
Required
 
Years
 
 

Microsoft SQL Server Reporting Services (SSRS) Advanced
Required
 
Years
 
 

Microsoft SQL/Postgres Database
Required
 
Years
 
 

Master Data Management
Required
 
Years
 
 

Data Analytics and Reporting
Required
 
Years
 
 

Proficient in Atlassian tools (Jira/Confluence)
Required
 
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
Desired