Data Solutions Engineer

$135,200 - $156,000/Yr

Nesco Resource - Milwaukee, WI

Full-time - Mid Level

Milwaukee, WI

Administrative and Support 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 requires a combination of data architecture, application integration, and BI reporting, with a strong understanding of ERP systems and business operations in a manufacturing environment. The ideal candidate will possess skills in SQL, SSIS, Power BI, and foundational software development, contributing to the organization's data-driven decision-making processes.

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.
• Ensure compliance with data security and privacy standards, especially regarding sensitive or manufacturing-specific data.
• Work closely with data analysts, software developers, and business stakeholders to support data-driven projects.
• Mentor junior team members on best practices in data integration, architecture, API development, and reporting.

Requirements

• Bachelor's degree in Computer Science, Data Science, Information Systems, or related field.
• Minimum of 5 years in data architecture, data integration, reporting, and API development, with strong experience in ETL, EDI, and ERP systems.
• Proficiency in SQL and SQL Server Integration Services (SSIS).
• Experience with C# scripting in SSIS packages and API development using Python, Java, or similar languages.
• Expertise in EDI processes and standards, particularly for ERP integration.
• Strong background in data architecture principles and data modeling.
• Proficiency in SQL Server Reporting Services (SSRS) and Power BI.
• Familiarity with data cataloging tools (e.g., Dataedo) and data lineage documentation.
• Understanding of ERP systems and integration through APIs and other means.
• Strong analytical and problem-solving skills.
• Excellent communication skills for cross-departmental collaboration.
• Ability to manage multiple projects and adapt to shifting priorities.

Nice-to-haves

• Experience with manufacturing industry processes and systems.
• Advanced knowledge of ERP data structures and integration for data analytics and reporting.

Benefits

• MEC (Minimum Essential Coverage) plan that encompasses Medical, Vision, Dental, 401K, and EAP (Employee Assistance Program) services.