Purpose:

At ICM Controls, we are looking for a data developer who will be responsible for developing, managing, and maintaining our data architecture, including reporting and visualizations. The data developer will work with our IT team and stakeholders from other business functions to design, develop, and maintain our data architecture, as well as our data warehouse and data mart. The Data Developer will also be responsible for developing ETL processes to load data into our data warehouse and data mart. The ideal candidate will have experience with data modeling, data warehousing, and ETL development. He or she will also be skilled in SQL and have experience with at least one programming language.

Duties & Responsibilities

• Works closely with IT Team and functional stakeholders to educate on process and submitting requests for new databases, schemas, migrations, etc.
• Participates in peer reviews and on project teams to ensure data quality standards.
• Supports the creation of manufactured data in multiple test environments for all levels of development and testing.
• Develops and improves standards and processes as required to increase the efficiency of requirements, design, development, testing, load, and deployment activities.
• Create and maintain Epicor BPMs that require C#.
• Create and maintain advance form customizations which may require C#.
• Perform Data Management Tool (DMT) loads for existing mass updates and data conversions for new acquisitions.
• Write complex reports using SSRS or other applicable technology and maintain the reporting environment.
• Support data requirements for new implementation or upgrade to Epicor ERP
• Support data requirements for our paperless office projects
• Develop Epicor BAQs, BPMs, UD fields, dashboards, forms, reports, and customizations to maximize the utilization of Epicor.
• Work closely with the ERP team in design, implementation, and execution of data requirements for Epicor business processes.
• Assess and manage user needs for dashboards and reports.
• Suggest process improvements where inefficient processes or activities may be occurring and develop and present solutions to the ERP team members.
• Maintain and improve upon user training and work instruction documentation for data products.
• Participate in ad-hoc or special projects as required.
• Modify data-related systems and processes as necessary to enhance/improve system functionality.
• Writes and maintains documentation to describe program development, logic, coding, testing, changes, and corrections.
• Provides technical assistance by responding to inquiries from others regarding errors, problems, or questions about programs.
• Monitors performance of programs after implementation.
• Must be able to set priorities, manage multiple tasks, and be willing to put forth the effort required to resolve problems to ensure quality data solutions.
• Create data extracts for Tableau or other data visualization solutions.
• Design, develop, and maintain data warehouses, ETL processes, and reporting solutions.
• Understand business needs and translate them into technical requirements.
• Design and implement dimensional data models that are optimized for performance and flexibility.
• Develop high-performance code for data transformation and manipulation.
• Work with the IT team and stakeholders from other business functions to create efficient and effective reports and dashboards.
• Perform root cause analysis of data issues and recommend corrective actions.
• Monitor ETL jobs and troubleshoot issues as needed.
• Keep abreast of new features in SQL Server and other relevant technologies.
• Participate in code reviews and provide feedback to other team members.
• Assist in the training of new team members as needed.
• Adhere to company coding standards and best practices.
• Proactively identify opportunities for process improvement

Qualifications:

• Bachelor’s degree in computer science, information technology, or related field
• 3+ years professional experience working with databases (SQL, MySQL, etc.)
• Experience developing data-driven applications using programming languages such as Java, Python, PHP, etc.
• Strong analytical and critical thinking skills
• Diligence and accuracy.
• Excellent communication and collaboration skills

Preferred Skills and Qualifications

• Master’s degree in computer science, information technology, or related field
• 5+ years professional experience working with databases.
• Experience leading a team of developers.
• Experience with big data platforms such as Hadoop, Spark, etc.
• Knowledge of statistical analysis and data mining
• Fluent with Tableau and PowerBI
• Experience with Epicor ERP data architecture
• Experience with Crystal Reports

Skills: – Good time management skills and demonstrated efficiency in providing engineering support on multiple concurrent projects; Demonstrated people skills, both inside and outside the project team; Creative thinking with the ability to make decisions and execute effectively. Ability to understand and explain technical problems. Business related computer skills including working knowledge of Microsoft Office. Familiarity in a variety of manufacturing engineering concepts as well as effective implementation of process improvements.

Essential Behavioral Competencies:

Attention to Detail: Working with information which will be received in various forms (graphs, text, verbal, alpha-numeric, involving color, shapes) - compare information, identify inconsistencies, note missing, out of sequence or unclear information; dates and deadlines conscious; monitor and inspect defective or worn tools and materials; monitoring output to achieve desired targets and quality standards.

Multi-tasking: Manages diverse, simultaneous projects of varying complexities. In a continuous flow and deadline-oriented environment, oversee and respond, plan, and manage work processes and resources.

Adaptability/Flexibility: Maintains composure and ably responds to changing priorities or schedules, resource availability, unexpected/unanticipated work interruptions as may occur, adaptations and/or changes imposed at request of Management, Sales or other parts of the organization; employs sound judgment and sense of urgency; positively receives and applies corrective counseling and/or training requiring change in work processes and approach.

Communication: Strong written, oral, verbal and reading comprehension especially of technical materials, with ability to recognize relevance of and properly apply information; strong written skills to define, document procedures and processes and create reports.

Collaboration: Personal conduct contributes to a harmonious and productive workplace; committed to the success of others; communicates information at appropriate time to appropriate people which enables operations to run smoothly and productively; invites participation and input from other sources to arrive at best solutions and to foster cooperative, team oriented climate; committed to and actively supports principles of equal opportunity, values workforce diversity and supports a harassment free workplace.

Organization: Employs planning which considers and anticipates variables; planning enables reliability in achieving objectives, meeting deadlines and overall work responsibilities; effectively uses time and resources; records, documentation, training, or other essential materials are maintained in readily retrievable order.

Problem Analysis/Problem Solving: Participates in troubleshooting of complex manufacturing and technical issues leveraging data, knowledge, theory tangential indicators, equipment, and other sources. Ability to apply technology to solve market problems and profitably.

Self–Direction: Self-starter with minimal supervision; positive approach, self-motivated, creative with ability to work on own initiative.

Conflict Resolution: Vigilant to situations which give rise to conflict and manages own and others’ behavior to mitigate conflict; leads by example to demonstrate how to work through differences effectively and respectfully.

Team Building - mentors, coaches, and inspires others to overcome obstacles, persevere in efforts, accept accountability for and execute responsibilities; personal behavior elicits respect, responsiveness from others.

Safety Awareness: Recognizes and takes action to remove and/or avoid creation of hazards.

KEY RELATIONSHIPS:

· Reports to: ICM CIO

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Referral program
• Vision insurance

Experience level:

• 5 years

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Ability to commute/relocate:

• Syracuse, NY 13212: Reliably commute or planning to relocate before starting work (Required)

Education:

• Bachelor's (Required)

Experience:

• Quality or Supply Chain: 5 years (Required)

Work Location: One location

rave-on-records.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, rave-on-records.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, rave-on-records.com is the ideal place to find your next job.