Title: Junior Software Engineer (SQL, .NET, Quadient Inspire Designer)
Reporting into: CTO
The role involves:
· Ensuring that the current automated projects execute successfully, investigate issues, resolve bugs and streamline executions using SQL server and .NET skills.
· Take responsibility for the day-to-day operations of the automated data processing pipelines.
· The creation of automated data pipelines using our proprietary ADPS system (SQL-based).
· The role requires supporting our clients, account managers and sales representatives using our technical skills to query the transactional data and provide solutions and answers to multiple requirements and queries.
· Implementation of new .NET applications for internal use and maintenance of existing applications.
· Setup and maintenance of Quadient Inspire Designer workflows, data manipulation using third-party and proprietary software and the day to day production of mail merged letters, labels, envelopes and postcards.
· Create and maintain reports and dashboards in SQL server reporting services (SSRS) and Power Bi.
Attention to detail is vital.
We will be working to tight deadlines whilst taking a methodical and proactive approach.
Duties and Key Responsibilities:
· At least 3 years’ experience with T-SQL.
· Experience with SSRS and/or Power Bi is beneficial, but not required
· At least 3 years’ experience with C#, .NET and Visual Studio.
· Experience with HTML, CSS, APIs and web development is beneficial, but not required.
· Experience with Quadient Inspire solutions (Designer, Content Manager, Interactive) beneficial, but not required. Full technical training to be provided.
· Two or three years minimum experience in a similar role.
· Good all-round knowledge of IT and an understanding of Microsoft Word and Excel.
· As a Team Player you will need to work with other members of the Development, Data Services, Operations and Client Services Departments to ensure jobs are prioritised and effectively completed.
· Create automated data processing pipelines using our ADPS solution (Automated Data Processing System) and maintain existing projects.
· Receive customer data in a variety of formats, TXT, CSV, Excel, PDF, XML.
· Manipulate customer data in Quadient Inspire Designer through modules and scripting to create mail pieces, e.g., Letters, Envelopes, Invoices, Bills, Statements, Postcards, Transactional Mail pieces, Booklets, etc. and integrate Inspire Designer workflows into automated processes.
· Process data through various systems to screen against Goneaways, Deceased, PAF (Postcode Address File), Deduplication, MPS (Mailing Preference Service) and Mailsort to generate the best/cheapest postage routes in the UK and overseas and automate these activities in ADPS if required.
· Mail pieces can be a straightforward letter with just a name and address added or dynamic letters where we must bring in variable images, paragraphs, tables, signatures, and variable letter artworks. The mail piece document composition is driven by the data processing we perform prior to setting up the document, this means we must add various fields to the data through scripting and modules to drive the conditions.
· With most jobs we add various barcodes to the data/doc comp to drive printers and enclosing machines so the mail piece can be inserted along with pre-printed flyers, brochures, catalogues, etc. and to ensure integrity/reconciliation.
· Each individual job can range from 100 Letters to 1 million letters so attention to detail is vital and communicating with the data processing and account manager teams to ensure the correct instructions are followed.
Personality Attributes
• Accuracy – Excellent attention to detail.
• Teamwork – to be a positive team member and help contribute to a happy and positive business culture. Complete tasks without the need for close supervision.
• Can-do attitude – enthusiastic, motivated, driven, flexibility to tasks and hours of work. Demonstrate desire to learn more and improve and accept ownership and responsibility for your own career progression.
• Problem-solving attitude and logical thinking skills – to understand and resolve data processing issues it’s necessary to be able to dig into long and complex scripts and understand how certain outcomes unfolded.