Description

Support the Master Data Management team in transitioning a child welfare system from PostgreSQL and SQL Server to Salesforce and MuleSoft. Own the design, development, and integration of data solutions while ensuring high performance and data quality.

Responsibilities

• Design and develop interactive, dynamic reports for business intelligence using SSRS or similar tools.
• Integrate data from various sources into a unified system using ETL processes.
• Assist in the design and implementation of Master Data Management solutions.
• Identify and resolve performance bottlenecks and data quality issues through query optimization.
• Adhere to SQL development best practices while meeting project deadlines in a remote capacity.

Required Skills

• 6+ years of Information Technology experience.
• 5 years of advanced experience with Microsoft SQL Server and PostgreSQL.
• 4 years of experience with ETL processes using SSIS or similar tools.
• 4 years of experience with SSRS or other reporting tools.
• 4 years of proficiency writing complex SQL queries, stored procedures, and functions (T-SQL, PL/pgSQL).
• 2 years of experience with database design, schema creation, and maintenance.
• 2 years of experience with SQL Server indexing, partitioning, and security.
• 2 years of experience in performance tuning and query optimization.
• 2 years of experience with data migration and transformation using SSIS.

Preferred Skills

• 4 years of experience with Tableau.
• 2 years of experience with Salesforce data.

Key Skills

Education

Any Graduate