Data Engineer II

Position Summary

The Data Engineer II is responsible for transforming data that can be easily analyzed. The position will be responsible for expanding and optimizing our data and data pipeline for our Association partners. The Data Engineer II will provide technical support for the ingestion and transformation of data sources through FPI’s Azure subscription.

• Independently assemble large, complex data sets that meet end user business requirements.
• Proactively identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re‑designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources with minimal supervision.
• Serve as a technical resource to organizational stakeholders to assist with data‑related technical issues and support their data infrastructure needs.
• Partner with data and analytics experts to strive for greater functionality in our data systems.
• Apply data governance practices and contribute to the development of standards and best practices. This includes data quality, data management, data policies, business process management, and risk management surrounding the handling of organizational data.
• Other related duties as assigned.

• Bachelor's degree in computer science or MIS, and 2+ years’ experience in data modeling and cloud technologies. Strong working experience with the Azure technology stack including:
• Databricks
• Data Factory
• SQL
• Python
• Power BI (Business Intelligence)
• Strong organization, analytical, and communication skills.
• Proficiency in the following technologies:
  Microsoft Office Suite.
• Strong customer service focus (data consumers as customers).
• Knowledge and proficiency in Artificial Intelligence concepts and technologies, including or similar to ChatGPT, Claude, Windsurf, Perplexity AI, Grok, Gemini

• Ability to report to work in person and to attend work-related functions/activities.
• Ability to work at a desk and use a computer for extended periods.
• Ability to lift, carry, and move objects up to 10 pounds occasionally.
• Ability to occasionally travel as required.
• Ability to type and utilize various software programs efficiently and operate general office equipment.
• Ability to work in an office setting with moderate noise levels.
• Additional physical demands include, but may not be limited to, frequent talking or hearing, occasional push/pull, stoop/kneel, bend/twist, and reach to retrieve or move items in a typical office environment.
• Must be able to work scheduled hours and overtime as needed.
• This role has been designated as either a hybrid role, which gives employees the opportunity to work from home on Mondays and Fridays and working in the office on Tuesday, Wednesday, and Thursday, or a remote role, which means the employee will work entirely offsite.
• Exceptions to the designated work arrangement may be made based on business needs.
• Please note that the Company retains the right to change a position’s designation at any time.
• Ability to concentrate and focus on details when reviewing documents, analyzing data, and performing computer-based tasks.
• Ability to manage multiple tasks and deadlines while maintaining accuracy and efficiency.
• Ability to problem‑solve efficiently and make sound decisions.
• Ability to manage job‑related stress and interactions with clients, colleagues, or external parties.
• Ability to communicate ideas clearly in both verbal and written form.
• Ability to work with others in a collegial and collaborative manner

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of their position.

• All roles require periodic travel to Springfield, MA for company meetings, events, and…