Data Solutions Engineer

The Data Solutions Engineer is responsible for building managing and optimizing data pipelines to support business initiatives.

RESPONSIBILITY LEVEL:

The Data Solutions Engineer is responsible for building managing and optimizing data pipelines to support business initiatives. This role oversees moving pipelines into production ensures compliance with data governance and security standards and enables integrated reusable data processes.

As a central resource the data engineer works with IT and business units to deliver analytics and data science solutions requiring innovation problem-solving and collaboration. The role also promotes effective data management practices and improves understanding of data and analytics. Success is measured by how well data capabilities are integrated and aligned with business outcomes.

Implements organization s goals may provide input into strategic goals for IT. Conducts research evaluates data and reports on findings supporting the development and implementation of policies procedures and programs. Has familiarity with the IT budget may provide input into spending decisions particularly as pertains to vendors systems and projects. Typically works on projects and initiatives that span 12 months 2 years.

PRINCIPAL DUTIES:

1. Oversee the operations pertaining to all aspects of data pipelines including the creation maintenance and optimization of organization data capabilities and demands.

2. Optimize existing ETL processes data integration and data pipeline flows. Perform advanced troubleshooting root cause analysis and resolution of integration or data integrity issues. Provide production support including analysis design implementation and testing.

3. Support enterprise data initiatives such as data warehouses AI workflows and reporting needs by enabling governed reliable data that drives business decisions and maximizes the value of data as a strategic asset.

4. Oversee data governance data quality and security standards for new and existing data pipelines while directing the design and documentation of data mappings interface specifications and system dependencies; lead testing validation and deployment of integration solutions across environments and ensure effective knowledge transfer to internal teams.

5. Develop relationships with stakeholders and subject matter experts across the organization to enhance requirements for various data initiatives and consumption needs.

6. Promote the available data resources and expertise to business unit leaders to educate around the benefits in leveraging data as an asset to achieving their business goals.

7. Leverage modern tools techniques and architectures to automate common repetitive and tedious data tasks to minimize manual and error-prone processes and increase productivity.

8. Project and Change Management: Effectively plans and manages own work to reliably complete routine job responsibilities and special assignments. May serve as a team member or subject matter expert on formal projects or within the department. Effectively engages in change affecting her/him communicating appropriately with supervisor. Follows through on learning skill building and practice necessary to adapt to change.

9. Problem Solving: Light supervision; works independently. Periodic review of work by manager or senior coworker. Solves problems of moderate to advanced complexity; able to identify root cause interpret data and resolve issues.

10. Technical Skill: Understands and applies professional principles and skills within area of specialization to modify processes to resolve situations.

11. Community Engagement: Champions Goodwills community engagement initiatives and serves as an ambassador for Goodwill in the wider community.

12. Responsible for completing other duties/responsibilities as assigned.

REQUIREMENTS:

1. Two years of college education or experience equivalency and a minimum of 3 years experience in data management disciplines including data integration data modeling data optimization and data quality.

2. Proficient in database programming and scripting languages like SQL and Python with advanced proficiency for querying manipulating data and troubleshooting.

3. Advanced knowledge of data formats (JSON XML CSV) data mapping and transformation logic.

4. Proven expertise in designing managing and supporting integrations using APIs ETL processes or middleware platforms between multiple enterprise applications (ERP CRM digital channels data warehousing).

5. Demonstrated experience working with large heterogeneous datasets to build and optimize data pipelines architectures and integrated datasets using traditional data integration technologies (ETL/ELT data replication/CDC message-oriented data movement API integration) along with hands-on expertise in ETL and data pipeline tools and frameworks and a proven ability to engineer robust ETL and pipeline workflows.

6. Experience with Cloud Platforms; Azure and/or AWS and strong familiarity with as-a-Service solutions specifically cloud data solutions.

7. Experience working with popular data discovery analytics and BI software tools for semantic-layer-based data discovery.

8. Proven experience working in cross-functional teams and collaborating with business stakeholders in support of departmental and/or multi-departmental data management and analytics initiatives.

9. Previous experience with software engineering principles is strongly desired.

CORE CULTURAL COMPETENCIES:

1. Customer Focus: Independently anticipate and meet customer needs while searching for ways to improve customer service. Internalize customer feedback and follow up with customer to ensure problems are solved by providing innovative ideas to meet their future needs.

2. Values Differences: Seeks out the diverse perspectives and talents of others striving to work effectively with others who have different perspectives backgrounds or styles. Behave with sensitivity towards differences in cultural norms expectations and ways of communicating. Challenge stereotyping or offensive comments.

3. Communicates Effectively: Shares information and updates with others while ensuring a clear concise and professional communication through reports documentation written and other communications. Listens with interest to what others have to say.

4. Situational Adaptability: Demonstrates flexibility of responses to different situations through adapting to the changing needs conditions priorities or opportunities. Monitors how well an approach is working to see if a change is needed recognizing cues that suggest a change in approach or behavior is needed.

5. Drives Results: Demonstrates a strong drive to achieve meaningful results through driving tasks to successful completion and closure. Sets high standards for own performance showing determination in the face of obstacles and setbacks.

6. Ensures Accountability: Takes responsibility and ownership for successes and failures in own work. Monitors progress of performance and changes approach accordingly following through on commitments.

PHYSICAL/SENSORY DEMANDS:

Job requires the following: remain stationary for sustained periods of time; ability to move about to accomplish tasks; must be able to operate a computer or similar technology which typically involves substantial motions of wrist hands and/or fingers; visual acuity to perform activities such as preparing data operating equipment or review thoroughness of work; ability to communicate with others and exchange information. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

When determining placement within the salary range for this position Goodwill Greater Milwaukee & Chicago considers education experience internal equity market demands and other qualifying criteria. It is not typical for individuals to be hired at or near the top of the rage for their role and compensation decisions are dependent on facts and circumstances of each case.

Certain roles are eligible to participate in an incentive plan. Participation in this plan does not guarantee an incentive payment and is subject to the terms and conditions of the plan which are subject to change.

In addition to compensation we offer a competitive benefit program that may include medical dental vision short and long-term disability life insurance retirement plan paid time off (PTO) and more. The specifics of each benefit package will vary depending on factors such as full or part time jobs contracted temporary or other job categories.

Equal Opportunity Employer

(SEW)

Required Experience:

IC