Data Solutions Engineer

Genesis10 - Milwaukee, WI

Full-time

Milwaukee, WI

Professional, Scientific, and Technical Services

About the position

The Data Solutions Engineer is responsible for designing, implementing, and maintaining the organization's data infrastructure to support business intelligence, reporting, and integration needs. This role combines data architecture, application integration, and BI reporting, with a focus on ERP systems and business operations in a manufacturing environment.

Responsibilities

• 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.
• Design and manage ETL processes using SQL Server Integration Services (SSIS) and create/modify APIs for 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 for API-based data integrations.
• Use data cataloging tools (e.g., Dataedo) to document data lineage, ensuring comprehensive data governance and traceability.
• 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 within Power BI for advanced data analysis and report customization.
• 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.
• Implement data governance practices and maintain documentation on data flows using tools like Dataedo, ensuring data lineage and compliance.

Requirements

• Skilled in SQL, SSIS, Power BI, and reporting tools.
• Foundational software development skills and experience.
• Understanding of ERP systems and business operations in a manufacturing environment.