Design, develop, and maintain SSIS packages for automated data extraction, transformation, loading, validation, file processing, and database integration across on-premises and cloud environments. Build SSIS Script Tasks using C#/.NET to automate custom processing, exception handling, email notifications, workflow monitoring, and operational alerts. Implement robust error handling, logging, debugging, and data validation mechanisms within ETL workflows to identify failures, improve data quality, and support reliable production processing. Develop and maintain SSRS reports (.RDL) using Visual Studio/SSDT, including dataset configuration, SQL query development, parameters, sorting, formatting, authentication, and report rendering. Primary work location is Farmington Hills, MI, but relocation is possible.