Requirements:
- Bachelor's degree in Computer Science, Information Systems, or related field.
- 5+ years of experience in data integration, reporting, or data warehousing roles.
- Strong hands-on experience with Microsoft SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).
- Proficient in SQL, including query optimization, stored procedures, and troubleshooting.
- Solid understanding of data warehousing concepts, database design, and ETL best practices.
- Experience with data profiling, reconciliation, and data governance processes.
- Familiarity with Power BI or other visualization tools is a plus.
- Strong analytical and communication skills, with the ability to collaborate effectively across business and technical teams.
Responsibilities:
- Design, develop, and maintain robust data integration workflows using SSIS to consolidate information from multiple sources into the data warehouse.
- Build and optimize operational and analytical reports using SSRS, providing actionable insights for business users.
- Collaborate with Business Analysts, Data Architects, and stakeholders to translate business needs into technical solutions.
- Optimize data pipelines for performance, scalability, and reliability, ensuring seamless data movement and transformation.
- Perform data validation, profiling, and reconciliation to maintain high data quality and integrity.
- Maintain and enhance existing data integration and reporting systems to align with evolving business requirements.
- Document data mappings, workflows, and architecture for ongoing system improvement and audit readiness.