Associate Systems Integration & Data Automati
RemoteHunter · United States
- Hybrid
- Full-time
- $95,000 / year
- United States
Job highlights
- Support and expand technical infrastructure for library services.
- Automate workflows and enhance data accessibility with AI.
- Maintain SharePoint and optimize PostgreSQL database performance.
- Collaborate cross-functionally on technical solutions.
- Develop inventive technical architecture proposals.
About the role
About Our Client
The organization operates trusted brands such as Junior Library Guild, Library Journal, School Library Journal, The Horn Book, and AKJ Education. It supports librarians by providing expert book reviews, collection development services, and timely coverage of trends and issues in the library profession. The organization also hosts events to foster connection and professional growth within the library community.About the Opportunity
The Associate Systems Integration & Data Automation Engineer role is responsible for supporting, maintaining, and expanding the technical infrastructure that underpins core workflows. This position ensures system reliability, improves existing tools, and leverages data and emerging technologies to enhance organizational operations. The role is key to advancing automation, data accessibility, and technology integration across the team.Responsibilities
- Maintain and secure the Virtual Book Room built on SharePoint with PowerShell-driven automation
- Optimize PostgreSQL queries, structure, and logic for improved database performance
- Design and implement improvements to the technology stack, focusing on automation, workflows, security, and integrations
- Evaluate and apply AI tools to streamline processes and enhance data access for editorial and operational use
- Develop and refine data automations for internal stakeholders, collaborating cross-functionally to ensure accurate and accessible data
- Independently execute technical implementations while regularly collaborating on requirements and direction
Requirements
- Expertise in cybersecurity best practices related to programming, automation, databases, and AI
- Advanced PowerShell scripting skills for automation, system building, debugging, and process improvements
- Experience with Python, JavaScript, Ruby, or other scripting languages for automation and data transformation
- Proven ability to build and maintain SharePoint automated systems, including integrations and workflow automation
- Experience using Power BI or Tableau for dashboard and report creation
- Strong proficiency in PostgreSQL, including database design, query optimization, stored procedures, and troubleshooting
- Ability to develop AI-enabled workflows and agents; experience with Copilot in production preferred
- Familiarity with automation architecture, REST APIs/webhooks, and Git
- Experience collaborating across departments and solving complex technical challenges independently
- Strong communication skills to document systems and convey technical concepts to non-technical stakeholders
- Organizational skills to prioritize and manage multiple projects simultaneously
- Knowledge of library environments is strongly preferred
- Ability to contribute to the overall technical architecture with inventive and practical solutions aligned with editorial priorities
Education and Certifications (preferred but not required)
- Microsoft Azure certifications (such as Azure Administrator, Data Engineer, or DevOps Engineer)
- Microsoft 365 or SharePoint certifications
- Database certifications focused on PostgreSQL or relational database management
- Certifications in automation, DevOps, infrastructure-as-code tools (e.g., Terraform)
- Experience or certification in AI/ML technologies or applied AI solutions
- Foundational security or systems certifications (e.g., CompTIA Security+)
- Equivalent combinations of education, experience, and technical expertise will also be considered
Pay Range and Compensation Package
The pay range and compensation package for this role will be determined based on the candidate’s experience, skills, and other relevant factors.Equal Opportunity Statement
Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.Note
RemoteHunter is not the Employer of Record (EOR) for this role. Our purpose in this opportunity is to connect exceptional candidates with leading employers. We help job seekers worldwide discover roles that match their goals and guide them to complete their full application directly through the hiring company’s career page or ATS.Key skills/competency
- Associate Systems Integration and Data Automation Engineer
- SharePoint
- PowerShell
- PostgreSQL
- Automation
- AI Tools
- Data Transformation
- REST APIs
- Cybersecurity
- Cross-functional Collaboration
Skills & topics
- Associate Systems Integration & Data Automation Engineer
- SharePoint
- PowerShell
- PostgreSQL
- Automation
- Data Automation
- Systems Integration
- AI
- Cybersecurity
- Data Transformation
- Python
- Scripting
- Database Performance
- REST APIs
- Dashboarding
- Power BI
- Tableau
- Cloud
- DevOps
- Library Technology
How to get hired
- Tailor your resume: Highlight your PowerShell scripting, PostgreSQL optimization, and SharePoint automation skills. Quantify achievements where possible.
- Craft a strong cover letter: Emphasize your understanding of data transformation, AI integration, and cybersecurity best practices.
- Prepare for technical questions: Be ready to discuss your experience with automation architecture, REST APIs, and database design.
- Showcase problem-solving: Prepare examples of how you've independently solved complex technical challenges and collaborated across departments.
- Demonstrate cultural fit: Research the client's brands and express interest in supporting the library community.
Technical preparation
Master PowerShell for automation and system building.,Optimize PostgreSQL queries and database structure.,Build and integrate SharePoint automated systems.,Familiarize with AI tools and REST APIs.
Behavioral questions
Describe a complex technical challenge you solved.,How do you collaborate with non-technical teams?,How do you manage multiple projects simultaneously?,How do you stay updated on new technologies?
Frequently asked questions
- What are the key technical skills required for the Associate Systems Integration & Data Automation Engineer role at this library services organization?
- For the Associate Systems Integration & Data Automation Engineer position, key technical skills include advanced PowerShell scripting, PostgreSQL database optimization, SharePoint automation, experience with scripting languages like Python, and knowledge of cybersecurity best practices. Familiarity with AI tools, REST APIs, and dashboarding tools like Power BI or Tableau is also crucial. Experience in a library environment is preferred.
- How important is prior experience with AI and machine learning for this Associate Systems Integration & Data Automation Engineer job?
- While not strictly mandatory, the ability to develop AI-enabled workflows and agents is a significant plus, with experience using tools like Copilot in production being preferred. The role involves evaluating and applying AI tools to streamline processes and enhance data access, indicating a strong emphasis on AI integration for this Associate Systems Integration & Data Automation Engineer position.
- Does this Associate Systems Integration & Data Automation Engineer position offer remote work flexibility?
- Yes, the job title 'Associate Systems Integration & Data Automation Engineer' and the mention of RemoteHunter in the description suggest this is a remote position. RemoteHunter specializes in connecting candidates with employers globally, often facilitating remote opportunities.
- What kind of experience is valued for the Associate Systems Integration & Data Automation Engineer role, beyond technical skills?
- Beyond technical proficiencies, this Associate Systems Integration & Data Automation Engineer role values experience collaborating across departments, the ability to solve complex technical challenges independently, strong communication skills for documenting systems and explaining technical concepts to non-technical audiences, and excellent organizational skills for managing multiple projects.
- Are specific Microsoft Azure or M365 certifications required for the Associate Systems Integration & Data Automation Engineer position?
- Microsoft Azure certifications (like Azure Administrator, Data Engineer, or DevOps Engineer), Microsoft 365 or SharePoint certifications are preferred but not strictly required for the Associate Systems Integration & Data Automation Engineer role. Equivalent combinations of education, experience, and technical expertise will also be considered.
- What is the primary goal of the Associate Systems Integration & Data Automation Engineer in supporting the library services organization?
- The primary goal for the Associate Systems Integration & Data Automation Engineer is to support, maintain, and expand the technical infrastructure that underpins core workflows, ensuring system reliability, improving existing tools, and leveraging data and emerging technologies like AI to enhance organizational operations and advance automation.