Description

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

Responsibilities

• Design and develop interactive, dynamic reports for business intelligence.
• Integrate data from various sources into a unified system.
• Identify and resolve performance bottlenecks and data quality issues.
• Adhere to SQL development best practices while meeting project deadlines.

Required Skills

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

Preferred Skills

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

Key Skills

Education

Any Graduate