Genesis10
Data Solutions Engineer
Genesis10, Milwaukee, Wisconsin, United States, 53244
JOB REQUIREMENTS: Genesis10 is currently seeking a Data Solutions Engineer to work a hybrid schedule (3 days onsite, 2 days remote) with our client for a contract with our client out of Milwaukee, WI. Summary: The Data Solutions Engineer is responsible for designing, implementing, and maintaining the organization\'s data infrastructure, supporting business intelligence, reporting, and integration needs. This role combines data architecture, application integration (native, custom, EDI/ETL, API, etc), and BI reporting, with an understanding of ERP systems and business operations in a manufacturing environment. The ideal candidate is skilled in SQL, SSIS, Power BI, and reporting tools, with foundational software development skills and experience. Responsibilities: Data Architecture & Infrastructure Design Design and oversee data architecture that supports scalability, performance, and reliability for business applications and reporting. Develop and document data models, schemas, and workflows to support integration across SaaS applications, ERP, EDI, and reporting systems. Ensure data architecture aligns with organizational goals and best practices for data governance, security, and lifecycle management. Data Integration & Development Design and manage ETL processes using SQL Server Integration Services (SSIS) and create/modify APIs to facilitate seamless data exchange across systems. Develop and maintain EDI workflows for data exchange with external partners, including document translation, mapping, and ERP integration. Create custom C# scripts within SSIS packages and leverage programming languages such as Python or other approaches for API-based data integrations. Use data cataloging tools (e.g., Dataedo) to document data lineage, ensuring comprehensive data governance and traceability. Reporting & Analytics Develop SQL Server Reporting Services (SSRS) reports and Power BI dashboards to provide actionable insights to stakeholders. Collaborate with business units to identify reporting needs and design solutions aligned with strategic objectives and manufacturing operations. Implement Python scripts (or other approaches) within Power BI for advanced data analysis and report customization. ERP Systems, Business Systems, & API Integration Facilitate integration between ERP, EDI, and other business systems via APIs, ensuring data consistency and availability. Collaborate with ERP administrators to enhance reporting capabilities and streamline data flows. Work on data-related projects within ERP and business applications, focusing on API and system integration points. Data Governance & Cataloging Implement data governance practices and maintain documentation on data flows using tools like Dataedo, ensuring data lineage and compliance. Ensure compliance with data security and privacy standards, especially regarding... For full info follow application link. Genesis10 is an Equal Opportunity Employer/Minorities/Female/Disabled/Veteran ***** APPLICATION INSTRUCTIONS: Apply Online: ipc.us/t/71C1B8CD55A54A4C