Data Integration Specialist

Data Integration Specialist

To develop efficient ad hoc queries, build reusable tools, support data validation and offer insightful guidance, while ensuring data accuracy and accessibility, and user-friendly visualizations to empower internal and external stakeholders with information.

The Data Integration Specialist supports our vision of "people serving people, not transactions" by ensuring that the data powering our services is accurate, accessible, and reliable. This role advances our mission of professionals serving with innovation and enthusiasm by developing reusable tools, validating complex data, and creating user-friendly visualizations that empower both internal teams and external stakeholders. By taking ownership of data accuracy, evolving with purpose through problem-solving and continuous improvement, and serving with passion in every collaboration, the Data Integration Specialist strengthens trust and ensures the Treasurer's Office delivers clear and meaningful information to stakeholders and the community at large.

Examples Of Duties

Leadership Responsibilities : Demonstrates buy-in to our vision, mission and values in their day-to-day work and in a manner that fosters fulfillment of our culture statement. Exercises situational and operational awareness to proactively identify potential issues and blind spots and address them appropriately. Engages in Meetings with Purpose consistently and productively, maximizing opportunities to share information, feedback, and suggestions in a professional and constructive manner. Supports team efforts to ensure accurate and timely data reporting. Provides mentorship and shares knowledge of best practices for reporting and data visualization with other team members. Contributes to continuous improvement initiatives, identifying and addressing process inefficiencies.

Relationship Responsibilities : Acts as a liaison between the organization and external vendors to ensure data integrity and accuracy. Collaborates with other teams to understand reporting needs and create intuitive, user-friendly data tools. Demonstrates professional support, verbal and written, to both internal and external stakeholders that is in accordance with Beaufort County Treasurer policies and procedures. Exercises timely follow-through on the resolution of issues / exceptions, taking ownership regardless of the source. Gauges, anticipates, reacts and meets the needs of others in a manner that creates a positive environment and best reflects our team culture, vision, mission and values. Successfully communicates technical findings and recommendations to non-technical stakeholders.

Task Responsibilities : Develops advanced SQL queries to address ad hoc data requests efficiently, leveraging a strong understanding of relational databases and entity-relationship diagrams (ERDs). Facilitates timely and accurate data transfers to external vendors in compliance with established standards. Enhances reporting by implementing interactive features such as slicers, parameters, and measures in Power BI. Works with internal teams to develop reusable tools such as SSRS reports Validates data to ensure accuracy and reliability, especially for large-scale reporting projects such as end-of-year and annual reports. Maintains documentation of processes, ensuring transparency and scalability in reporting tools.

General Responsibilities : Possesses a growth mindset with a focus on personal and team development and attends training sessions as appropriate. Maintains a comprehensive, current knowledge of applicable laws and regulations, Office technologies, and attends training sessions, as appropriate. Assists in the training and onboarding of new staff and contributes to peer development through knowledge sharing and mentorship. Demonstrates flexibility and adaptability in response to evolving priorities and the operational needs of the Treasurer's Office. Assists in the training and onboarding of new staff and contributes to peer development through knowledge sharing and mentorship. Participates in cross-training initiatives as directed, to provide departmental support and ensure operational continuity across functional areas. Stays informed on emerging trends in data visualization and accessibility, refining solutions to improve usability. When appropriate, prepares and updates operating procedures and / or policies. Performs other related duties as required.

Typical Qualifications

Minimum Qualifications :

• Bachelors degree in Data Analytics, Business, or a related field; or equivalent professional certification in data visualization or analytics, required.
• At least 2 years of experience with SQL and relational databases, with a strong understanding of entity-relationship diagrams.
• At least 5 years of professional experience in data visualization, reporting, or a related field.
• Possesses a valid driver's license.
• Proficiency in tools like Power BI, including building interactive features such as slicers and parameters.
• Excellent organizational skills with the ability to prioritize and manage multiple projects effectively.
• Significant experience with Microsoft Office, particularly Excel, and professional communication, both verbal and written.