Summary:
This position is meant to service custom reporting requests (internal and external) that require direct interaction with database systems. It is not primarily meant for database development, but does require creative application of existing systems, especially via SQL programming.
Responsibilities:
* Guide conversations with non-technical users to understand business needs.
* Requires effective English communication.
* Review reporting requests, which often lack technical detail, and collaborate with internal partners to translate business needs into technical specifications.
* Design, create, and distribute custom reports.
* Perform research in reporting systems and leverage software and coding tools, especially SQL programming, to provide needed reporting.
* Contribute to team-wide training, quality review, and maintenance tasks.
* Contribute to the smooth function of the team as a whole by sharing knowledge in team chat, and assisting with debugging and upkeep of reports.
* Address supporting duties, e.g. email and ticket management, and team meetings.
* Participate in team and departmental protocols, communication, and knowledge-sharing, to ensure the smooth function of the team as a whole.
Education:
* Bachelor's Degree in a math, science, or business-related field or an equivalent combination of education, related certifications, and work experience (especially in SQL programming).
Knowledge and Skills:
* Proficiency in Microsoft Office (especially MS Excel).
* Proficiency in line-by-line programming, especially SQL (at minimum, candidates should have certifications or work experience demonstrating familiarity with SQL beyond the level of a casual or side study - any proficiency beyond that is not required, but is a strong plus).
* Strong logical capability (logical reasoning skills will assist candidates with on-the-job learning, and are more important than SQL experience or certifications).
* Clear communication in both verbal and written form (candidates will need to collaborate with non-technical partners—typically in American English—in order to identify effective solutions to business needs).
* Ability to follow instructions carefully.
* Ability to follow team protocols and manage multiple projects at once.
Experience:
* At least 3 years in a professional environment (preferred).
* Any experience in roles requiring SQL programming is a plus.
Decision Making/Interaction:
* Day-to-day: Consultative Analytics personnel. Collaborate and communicate with fellow team members to identify solutions to requests, execute on them, and support team health. Decision-making mostly focused on individual requests.
* Internal interactions: Broadspire requesters. Respond to requests submitted by partners in Client Services, Medical Management, Claim Operations, Information Technology, and other departments. Not a leadership role, but requires clear verbal and written communication to manage requests with non-technical partners.
* External interactions: Client requesters. Nature of interaction similar to internal interactions. Client interactions are expected to be infrequent, and it is expected that the candidate will typically reach out to management for support in such situations.
