**enviri Corporation** (Formerly known as Harsco Corporation) is a market-leading, global provider of environmental solutions for industrial, retail and medical waste streams, and innovative equipment and technology for the rail sector. We have an unrivalled breadth of experience across the globe and an impressive reputation stretching back more than a century. Based in Camp Hill, PA, with more than 13,000 employees and the company operates in more than 30 countries. **About Harsco GSC** Harsco GSC handles a wide range of services, finance and accounting shared services, global HR shared services, providing IT Service and helpdesk support and market research support to Harsco globally. We are Operating since 2008 & Serving 30+ Countries. + Ensure the EDW is running efficiently, performing regular updates, backups, and troubleshooting any issues that arise. + Design and implement dimensional models (star and snowflake schemas) to facilitate efficient querying and reporting. + Implement data validation and cleansing procedures to maintain high data quality and integrity. + Optimize database performance through indexing, query optimization, and other techniques. + Gather business requirements for enhancement, customizations and develop technical requirement documents. Should be able to provide solution technically. + Prepare estimate based upon the custom requirement and prepare project schedule. + Engage in business meetings to understand and review the feasibility of the business requirements. + Responsible for gap analysis of functional flows, provide solution design, perform POCs and demo for the Gaps solution from standard solution sets as well customized solutions. + Work closely with Microsoft support team and should be able to create service request as and when required for business-critical issues. + Should be able to redefine and make technical/strategic changes to enhance existing Business Intelligence systems. + Involve in post implementation support to provide solution for production issues or for any other maintenance activities which might also involve change management process. + Maintain comprehensive documentation of data models, ETL processes, and other relevant procedures. + BSc/MSc degree in computer science or any branch of Engineering. **Experience:** + Strong experience with SQL, database management systems (e.g., SQL Server, Oracle, MySQL), and ETL tools (e.g., ADF, SSIS, Informatica). + Proven experience in designing and implementing dimensional models for data warehousing. + Extensive experience in maintaining and optimizing large-scale data warehouses. + Strong analytical and problem-solving skills to troubleshoot data issues and optimize performance. + Excellent problem solving, Critical and Analytical thinking skills. + Strong t-SQL skills with experience in Azure SQL DB + DevOps, CI/CD, and Automation experience strongly preferred. + Able to interact with team members collaboratively. + Experience handling Structured and unstructured data. + Ability to manage multiple tasks and projects simultaneously, meeting deadlines and delivering high-quality work. + Willingness to learn new technologies. + Excellent oral & written communication / articulating skills **Preferred:** + Experience working with the Dbt transformation framework (core or cloud) + Familiarity with business intelligence tools (e.g., Power BI, Tableau) for data visualization and reporting. + Microsoft Certified: Power BI Data Analyst Associate + Microsoft Certified: Azure Administrator Associate **Disclaimer** The information about this job description given above has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.