Data Analyst - SQL and SAP

JOB DESCRIPTION: Position: SQL Writer Department: Supply Chain Requirement BS/MS degree in Computer Science, Engineering, or related field Deep knowledge and experience with SQL, database design/structures, ELT design patterns, and data structures 7+ years’ experience designing and developing solutions for data systems, services, and platforms including writing comprehensive queries, and a deep understanding of database structure and table relationships Experience in Data Profiling and Data Analysis to investigate and validate data accuracy Extensive Knowledge on SAP Functional specific to the Data structure architecture as well as knowledge in SAP BODS ETL and Data Quality Design, development, and delivery Ability to perform data validation, cleansing and transformation Experience with Microsoft Power BI and Power Query Data Modeling, including DAX Deep knowledge of Microsoft solutions including Power apps, SharePoint and Power automate Strong user focus, strong interpersonal skills, results-orientation, and business analysis skills. Purpose of Position: Develop solutions to create complex data management, and analysis including dashboards, ad-hoc reports, and extracts using programming languages and tools such as SQL, Excel, Power BI, Power apps, etc. Provide and automate the report and delivery of daily, weekly, monthly information for the different areas of the company and senior management team. It includes developing additional solutions along with maintaining and modifying existing reports. Work on projects that are designed to increase and improve access to information and reduce errors. Job Duties Support users by developing solutions that include reports, dashboards, data modeling, and processes to continually monitor data quality and integrity across the company. Provide the information that allows leaders to make business decisions based on information tools and data access. Develop solutions to create complex data management and analysis that ensure the complete and correct use of ERP data information Maintain and manage data generated in both ERP and CRM. Work with other staff members to write and optimize data management and generate SQL statements as needed. Troubleshoot common database problems Working Conditions: Requires steel-toed safety shoes, eye protection and hair covering required in all production and maintenance areas · Office environment · Limited lifting · Limited nose exposure when required to be on the plant four Show more Show less