Data Engineer

location: new brighton, mn MUST be onsite

duration: 1 year+

We are currently seeking a data analyst or engineer who will report to the Enterprise Project Management Office (EPMO) team. This role will specifically provide support for the FSM Implementation and key stakeholders across the organization, including being accountable for end-to-end data migration planning and execution across project workstreams. The role will create, update, and continuously improve our data migration processes and tools as well as support work stream leaders in data validation and testing as required. This position will work closely with Project Manager and team to engage stakeholders across operating companies, corporate functions, and vendor partners to successfully deliver project objectives and outcomes.

Responsibilities:

1. Support a standardized data migration process flow including utilizing tools or developing templates for data extraction, mapping, transformation, cleansing, loading and validation
2. Responsible for executing this process for their respective project within assigned timelines
3. Collaborate with technical and non-technical partners, including a business analyst and subject matter experts across functional business areas
4. Collaborate with other Data Team members on the design and implementation of data connections, storage, and access in the alignment of the data strategy set forth by leadership
5. Familiar with APIs and SQL, comfortable applying logic-based transformations, and knowledgeable about database architecture
6. Learn aspects of software systems including data structures, configurations, and business processes applicable to support data management and loading in the system
7. Support the Operating Companies and other IT workstreams to solution data migration within the business systems
8. Assist in developing data cleansing efforts (including automation) to support better project implementations and conversions of companies onto or between business systems
9. Assist in developing and organizing templates for master data and transactional data migration and cleansing
10. Ensure solutions, configurations, and processes are sustainable and scalable
11. Support partnerships to maintain relationships and ensure initiatives are completed successfully
12. Engage the user community to support Operating Companies' clean data initiatives and ensure proper systems use through training, support, standard processes, and feedback loops
13. Help maintain user community communication, training documentation, and resources, ensuring these living documents are readily available and updated as necessary
14. Build and maintain a repository of documentation to support future initiatives, following the enterprise standards
15. Other duties as needed or assigned

Qualifications:

1. 2+ years of data migration, cleansing, testing, imports, and exports and business process knowledge
2. Minimum 2+ years working in an IT environment independently and in teams
3. Top tools or preference of tools for this project where experience would be preferred include: WebApps (AS400), Astea/IFS, Service Titan
4. Experience working in a remote or hybrid delivery model
5. Bachelor's degree in information technology, computer science, data analytics or a related field preferred
6. Proficient in SQL
7. Proficient in Microsoft Excel and other data cleansing/migration tools with ability to use Excel as a reporting and analytics tool
8. Experience using Tableau/Power BI, SharePoint and the Microsoft Tool Suite
9. Experience with ERP data conversion, de-duping, and cleansing, including data cleansing best practices and approaches to improve data quality
10. Excellent analytical skills and aptitude for critical thinking, problem-solving, and decision-making skills
11. Excellent communication and interpersonal skills
12. Data-driven and analytical approach
13. Strong attention to detail and organization skills
14. Excellent communication and interpersonal skills
15. Ability to handle and prioritize multiple tasks in a fast-paced environment
16. Strong character, ethics, commitment, and reliability

Required experience includes WebApps, ERP system(s), data exporting, data cleansing, validating data and MDM. Field Services Management (FSM) is a preferred, but not required.