Position:
Business Intelligence Analyst/SQL Developer
Location:
Jeffersonville, IN
Job Id:
722
# of Openings:
0
Our Company:
PharmaCord is a leading provider in pharmaceutical patient support services. Our services are sponsored by our pharmaceutical company clients. Together, we are committed to compassionately providing patients with support services during their journey on therapy.
We deliver our services through our talented team of benefit specialists, nurses, pharmacists, case managers, pharmacy techs, program managers, and other incredibly talented team members who are supported by world-class proprietary technology systems developed internally by our team of engineers, system architects, coding professionals and data scientists.
We are PharmaCord, a purpose-driven organization on a rapid growth journey.
Our Team:
Our team is highly motivated and passionate about providing the highest quality customer support to our patients. We look for individuals interested in growing with our company and working in an exciting, open and collegial work environment. We seek problem solvers who are compassionate, have high integrity and demonstrate grit. Our colleagues are enthusiastic team members who love what they do and are passionate about making a difference through their work. We take initiative, exhibit pride in our accomplishments, and are trusted to work independently while collaborating to share ideas, support, and resources.
The Business Intelligence Analyst/ SQL Developer will be responsible for developing reports and dashboards in Microsoft Power BI and writing SQL queries and procedures to support those reports and dashboards. The Business Intelligence Analyst/ SQL Developer will also work on development that deals with sending and receiving flat file data feeds (inbound and outbound) or creating ad-hoc reports by writing SQL queries. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills, since you will be working directly with pharmaceutical clients as well as internal business users.
Must be capable of working independently and collaboratively.
A typical day in the life of an Business Intelligence Analyst/SQL Developer will include the following:
The responsibilities include, but are not limited to the following:
- Work on developing innovative visualizations in Microsoft Power BI as well as SQL queries or procedures to feed those visualizations, which ultimately comprise the report or dashboard used by clients.
- Create custom reports and modify existing queries and reports to enhance organizational productivity or supply data to clients
- Perform predictive modeling, data analysis, correlation analysis, and regression analysis as required to glean insights from rich patient data
- Analyze existing SQL queries for performance improvements and modifying existing queries as required
- Experience with Microsoft Power BI Premium reporting tool or R would be a plus but not required
Requirements:
- Bachelor’s Degree and a minimum of 5 years of professional work experience in a mid-sized or large corporate Information Technology environment.
- Exceptional relationship management skills and the ability to build and grow connections with people.
- Highly organized and detail-oriented, with the ability to keep multiple projects and client engagements active at once.
- Comfort with ambiguity and ability to navigate uncertainty.
- All employees working onsite in a PharmaCord facility are strongly encouraged to be vaccinated against COVID-19
- We are located in Jeffersonville, IN. You must be willing to work in this area; PharmaCord does reimburse for tolls if applicable, at the frequent user rate. This rate is applied after 40 trips per month (valued at 678.60 per year)
Physical Demands & Work Environment:
- Occasional local travel may be required with the remaining time dedicated to working at the corporate office. This position is based in Louisville, KY/Jeffersonville, IN and would expect the candidate to either be local or willing to relocate.
- While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to sit, use hands to type, handle or feel; and reach with hands and arms. Must be able to type 35 WPM with 97% accuracy.
- Ability to sit for extended periods of time
- This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, etc.
Once you land this position, you’ll get to enjoy:
Our Benefits & Perks
- Affordable Medical, Dental, and Vision benefits with no premium increases in 4 years
- Concierge Medical Clinic free of cost for those enrolled in a PharmaCord medical plan (including dependents)
- 401(k) company match
- Wellness discounts on health premium
- HSA employer contribution
- Company paid Short-term Disability (STD)
- Company paid and voluntary Life Insurance options
- Voluntary Life, AD&D and Long-Term Disability Insurances
- Paid Parental Leave of Absence
- Wellness and Employee Assistance Programs
- PTO benefits, flex days and paid holidays
- Employee Referral Program
- Ambassador Program
- Tuition reimbursement program
- And more
A Career You'll Love
- Working for PharmaCord - voted Best Places to Work in Kentucky for 2019 and 2021.
- Voted Best Companies for Employee Happiness, Best Companies for Women and Culture by Comparably in 2023.
- Work for a company that values diversity and makes deliberate efforts to create in inclusive workplace.
- Opportunities for advancement with a company that supports personal and professional growth.
- Playing a crucial part in the lives of our patients, physicians, and pharmacies by enhancing the patient services experience.
Any offer of employment is contingent on completion of a background check to company standard. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.At PharmaCord, we don’t just accept difference – we celebrate it, support it and we thrive on it for the benefit of our employees, our products, and our community.
PharmaCord is proud to be an equal opportunity employer.In order to maintain a safe workplace for our team members, PharmaCord strongly recommends that all employees are vaccinated against COVID-19. PharmaCord is unable to sponsor employees at this time.
Want to learn more about us? Find us on LinkedIn, Glassdoor, Twitter & Facebook!
Apply for this Position
//below URL is also hard code in "CareerSiteSecurityHeaderFilter.java".
(function() {window.IndeedApply||function(f,g){function h(){var a=c.getElementById("indeed-apply-js").attributes["data-indeed-apply-qs"],b="";a&&""!=a.value&&(b="&"+a.value);return[""].join("")}var b=window,c=document,d=document.location.href;b.IndeedApply=b.IndeedApply||{};var b=c.body,m=/^https:\/\//.test(d),k;if(!b)return k=arguments.callee,setTimeout(function(){k(f, g)},100);var d=c.createElement("div"),a=c.createElement("iframe"),e;d.style.display="none";b.insertBefore(d,b.firstChild).id="indeed-apply-iframe-holder";a.frameBorder="0";a.id="indeed-apply-iframe";a.allowTransparency="true";d.appendChild(a);try{a.contentWindow.document.open()}catch(n){e="javascript:var d=document.open();d.domain='"+c.domain+"';",a.src=e+"void(0);"}try{var l=a.contentWindow.document;l.write(h());l.close()}catch(p){a.src=e+'d.write("'+h().replace(/"/g,'\\"')+'");d.close();'}}
("https://apply.indeed.com/indeedapply/env?","https://apply.indeed.com/indeedapply/env?https=1");})();
var gnewtonOnIndeedApplyClick = function() {
if (!('parentIFrame' in window))
return;
var initialHeight, height = initialHeight = height = $nQuery('#gnewtonCareerBody').height();
var interval = setInterval(function() {
var el = $nQuery('.indeed-apply-popup');
if (!el.is(':visible')) {
clearInterval(interval);
$nQuery('#gnewtonCareerBody').height(initialHeight);
} else {
height = Math.max(height, el.offset().top + el.height());
$nQuery('#gnewtonCareerBody').height(height);
}
}, 100);
};
