Syntricate Technologies
Analyst/Programmer Specialist
Syntricate Technologies, Indianapolis, Indiana, 46262
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 Dat Desired Knowledge of Child Welfare Information System Desired