Description

You will support the Master Data Management team for the State of Indiana's child welfare system, focusing on data integration, reporting, and system performance.

This role is remote.

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.
• Identify and resolve performance bottlenecks and data quality issues within the database environment.
• Write complex SQL queries, stored procedures, and functions while adhering to best practices.
• Maintain database schema, indexing, and security protocols to ensure system stability.

Required Skills

• 6 years of IT experience with advanced proficiency in Microsoft SQL Server and PostgreSQL.
• 4 years of experience with ETL tools such as SSIS or similar platforms.
• 4 years of experience writing complex SQL queries, stored procedures, and functions in T-SQL and PL/pgSQL.
• 4 years of experience with SSRS or other reporting tools.
• 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.

Preferred Skills

• 4 years of experience with Tableau.
• Experience with MuleSoft Anypoint Platform and troubleshooting.
• Experience with Salesforce Data.

Key Skills

Education

Any Graduate