Contractor: Developer (DBA) – Publication Sales (Pub Sales), Production Team Support

Engagement Summary

Engagement Type: This is an independent contractor engagement, not an employment position, and does not include employee benefits. The expected term of the engagement is approximately 24 months, subject to the terms of the contractor agreement.

The Developer (DBA) – Pub Sales Production Team Support contractor provides support to the Production Team of Publication Sales (Pub Sales) at ANSI.  The services this engagement (estimated at approximately 21- 28 hours per week) will cover include:

SQL Catalog and related SQL DBs – tool/process development, loading and maintenance
SQL Catalog and related SQL DBs are the repository for all standards-related metadata for the Pub Sales business and related internal users.

·       Extensive on-going collaboration with the Production team on the building, refining, extension and maintenance of tools and processes to maintain and expand these SQL DBs and their data

·       Troubleshooting with daily SQL Catalog loading processes

Automated Content Distribution

·       With Pub Sales / Production team providing the input on business requirements, maintain the set of solutions that automates the delivery of content to all subscription customers (on both Legacy Standards Connect and Northstar Standards Connect subscription platforms).  

New Subscription Products Maintenance and Delivery

·       With the release of Northstar subscription platform, ANSI has developed nearly 4,000 in-house subscriptions products (“Pre-Defined Collections” and “Block Collections”) that for the first time we will be building, maintaining and making available to customers via our Catalog directly in the subscription platform.  The contractor will maintain and, if necessary, extend the tools that allow for the Pub Sales team to load and maintain these products. 

Northstar Customer Migration and Pricing

·       Support migration of customers on ANSI’s legacy subscription platform to the new Northstar subscription platform as follows:

·               Troubleshoot any issues with Pre-Defined Collections and Standards Blocks, as having these new products in place is a critical component of customer migration

·               Migrate customer contacts, alerts, favorites, and lists.

·               Pricing Engine Deployment for Northstar subscription platform (this is an already coded automated pricing solution)

Project Apollo – formerly Catalog Clean-Up

·       Building and testing tools that allow for the in-place manipulation of critical publisher metadata such as Document Number, Publisher Acronym, and cross-references between documents.  These tools are in the process of being designed, tested, and deployed in collaboration with the Pub Sales Production team.

Other

·       Alert Mechanisms: Maintain and troubleshoot the email alerting mechanism for web store, Legacy Standards Connect, and now Northstar Standards Connect.

·       Web Store SQL Search: Maintain the SQL Full Text Search on the ANSI Web Store.

·       Elastic Search: Support critical elements of the Elastic Search powering search on Northstar subscription platform.

·       FileOpen integrations for Web Store, Legacy Standards Connect, Northstar Standards Connect, and IBR Portal: This involves supporting the integration between ANSI’s document delivery and DRM solution from FileOpen Systems and our retail, subscription, and other platforms/sites. 

·       Royalty processing solutions: Maintain the more complex elements of ANSI’s royalty landscape, including integrations with Microsoft Dynamics GP accounting solution.

·       Northstar Microservices: Database design and backend development for all non-CRM microservices.

Overall, this engagement calls for a professional developer who can understand ANSI’s publication sales processes and support the systems, databases and functions that are related. 

Scope of Services

Management of Databases: Management, tuning and related maintenance associated with the SQL databases and related processes.

Maintenance of Content and Subscription Products: Working with the Production Team, maintain the content and subscription products

Maintenance of Microservices: Maintenance of microservices related to NorthStar and other Pub Sales applications including the catalogs.

SQL Full Text Search and Elastic Search: Working with SQL Full Text Search and Elastic search to support search functionality on ANSI web store, Legacy subscription platform and Northstar subscription platform.

Cross-Functional Collaboration: Partner with other IT team members, Pub Sales staff, other ANSI staff, and vendors to provide services and systems to ANSI.

Skills and Qualifications

Required Qualifications & Skills

Experience: 2-4+ years of IT software development, database management, SQL full text search, Elastic search and microservices.

Business Acumen: Strong understanding of enterprise subscription business models, digital product delivery, ecommerce, customer lifecycle management, entitlements and access management, CRM, customer service, and enterprise customer requirements.

Technical Acumen: Strong SQL, SQL Full Text search, Elastic Search, ecommerce and microservices skills. Strong foundational knowledge of system architecture, APIs, data flows, and cloud environments (AWS, Azure, or GCP).  Knowledge of Single Sign On (SSO) and related functions.

Domain Knowledge: Knowledge of standards, technical document publishing, manufacturing, digital content delivery, ISO/IEC technologies, or SMART standards is preferred. Ability to quickly develop expertise in ANSI’s products, licensing models, customers, and standards delivery ecosystem is essential.

Soft Skills: Strong written/verbal communication across technical and non-technical groups.

Key Performance Indicators

·       Timely Delivery: Ability to deliver services in a timely and accurate manner as outlined by the schedule defined by Pub Sales Production Team.

·       Accurate and Complete Work: Ability to deliver and support Pub Sales Production Team with accurate and complete solutions and work products. Low error rates.

·       Client Satisfaction (CSAT): Feedback and retention scores from enterprise customers and stakeholders.

Internal ANSI / ANAB Information Security Responsibilities

·       Attend/complete assigned information security training by the designated completion date.

·       Read and adhere to published ISMS policies and procedures.

·       Report timely any observed violations of ISMS policy - or known encroachments on information security - to your department leader and/or the Information Technology Department.

Education and Experience

• undefined

• Bachelor’s degree in Computer Science, Information Technology, Business Administration, or equivalent practical experience. 

·       Minimum 2+ years of relevant experience as a developer, DBA or equivalent role.

• Extensive experience in SQL, SQL Full text Search, Elastic Search, microservices, and ecommerce related services.

• Experience in a fast-paced non-profit or professional services environment strongly preferred.

• Knowledge of standards industry, manufacturing or process-oriented business preferred.

Other Qualifications

·       Hands-on background in software development, DBA, or microservices engineering.

·       Experience in a maintenance, break / fix, or other support role.

·       Domain expertise in specific tech stacks or enterprise systems (e.g., CRM, ERP, custom microservices, SharePoint).

• Superior verbal and written communication skills.

• Proficiency in Microsoft Office Suite (Outlook, Word, Excel, PowerPoint) and collaboration platforms (Teams, Zoom, WebEx).

• Strong interpersonal skills and the ability to build relationships across all organizational levels.

The contract rate will be $54.95 per hour.

This description summarizes the anticipated scope of services and is not exhaustive. Any changes to the scope of services will be agreed in writing between ANSI and the contractor.

ANSI does not discriminate in the selection or engagement of contractors because of race, gender identity or expression, color, national origin or ancestry, religion, creed, age, marital status, sex, sexual orientation, citizenship or authorized alien status, genetics, disability status, protected veteran status, or any other consideration protected by federal, state, or local laws. ANSI policy also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics. This policy applies to all aspects of contractor selection and engagement.

Important Notice for Applicants: Protect Yourself from Fraudulent Postings

We are aware of fraudulent job postings falsely claiming to represent our company. These scams may mirror our legitimate job listings and direct candidates to fake interview links or request personal information. Here's how to spot legitimate opportunities:

·       Verify jobs at www.ansi.org

·       Apply through our official Workday system at https://ansi.wd1.myworkdayjobs.com/ANSI_Careers

·       We won’t ask for an interview via Zoom links or texts.

·       We would never ask for payment

·       We won’t ask for sensitive, personal information early in an application process.

·       All communication comes from official company emails (@ansi.org).

We prioritize your security and use only official channels.  If you see a suspicious posting, please report it to the job board.