Bhaal fucked around with this message at 20:42 on Aug 3, 2012

• Comfortable knowledge of relational databases. Understanding of relatively simple data-draw SQL queries (select with a few joins), or if not syntax then at least how to manipulate and interpret reporting tools. You're the one assisting account managers translate what we have in the database into a specific report, rolled up number, or spreadsheet that is delivered to the client (when such reports are requested off the cuff and don't exist within our standard fare of automated reports).
  
• Strong communication and correspondence skills. Typically you won't have too much exposure to clients but often a response to a client will be waiting on you.
  
• Strong organizational skills and workflow management. We have tools for ticketing and project management which will help immensely but nonetheless you'll have to effectively manage your time so that eg. you'll know the degree of confidence you can say yes or no to committing to some new request and its proposed timeline.
  
• Documentation and creating/deconstructing a processes to find weaknesses and coming up with improvements.
  
• Familiarity with code (php in particular) is a big plus.
  
• Strong ability with excel manipulation, knowing how to import/export a CSV, etc.

• work with customer service reps and account managers to facilitate anything needed out of IT for day to day, week to week operations
  
• Work with account managers (and sometimes directly with clients) to decide on contract specs, interpret their requirements into what we can offer, etc
  
• Provide custom reporting requests and oversee automated reporting to ensure all goes smoothly
  
• Do some prep work for new clients, be present for new client launches, assist account managers with email campaigns
  
• Process census files from clients. There is a tool that does all the heavy lifting but this always will require a keen human element since it's accepting sensitive data from 3rd parties who don't always have their act together
  
• A number of daily maintenance activities that come up in the normal course of things. Sometimes the lab work company send us corrupted or obviously-manually-manipulated data that can't be processed automatically
  
• Process Improvement. Identify what could be factored out of your workload via smarter ways of handing off tasks, some new code to automate something, etc. Work with developers and others to produce a spec, etc.

• PHP experience is preferred, but really any sort of background can fit. This is where I give the standard spiel about the language not mattering as much as the affinity of the developer to adapt and so on.
  
• Ability to learn/follow HIPAA compliance, no matter how annoying it is. As well as SASS/SOX and a bunch of other standards that we are beholden to. You have access to personal info and medical data for many many people so you have to learn and play by the rules or we all get burned. A lot of this is already handled systemically, we have processes for testing/deploying and signoffs, so as a developer this mostly boils do don't do anything stupid, no cowboy poo poo, no developing on production, don't take copies of the database off site and so on. We have to give you enough access to technically be able to do these things, but you've got to have the self discipline even though as a culture we're small, fast and loose with a lot of other stuff. It's common sense I know but it's also complete zero tolerance.
  
• LAMP stack familiarity is a giant plus. Working with Zend's platform is even better because that's us.
  
• SVN, if you are familiar with git that's great as we would like to move to git eventually but for right now we're in the cutting edge of 2004 when it comes to version control
  
• Query skills, basic query optimization, and the ability to create/debug large and intricate queries when the need arises.

• A zend-framework backend application, a backbone.js frontend application, and a MySQL/galera db cluster (we have a DBA so you won't have to have much exposure to the underbelly of all that).
  
• The app has a user portal, admin portal and client (employer) portal, with active development especially in the latter two
  
• Freely weigh in on new features, implementation approaches, and so on. We want people who can move beyond just executing task lists and will make that sort of growth available
  
• A small team of 3-4 developers with me as your leader and firewall to parse requests and requirements coming in from the company and clients.

Bhaal fucked around with this message at 18:10 on Nov 6, 2013

Bhaal fucked around with this message at 20:23 on Jul 1, 2014