Exemption Status:
United States of America (Exempt)
$95,717 - $132,808 - $169,898
“Pay scale information is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any selected candidate or employee, which is always dependent on actual experience, education, qualifications, and other factors. A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate.”
This position is not eligible for Sponsorship.
MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team!
Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare.
At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution!
Job Description
Summary
Responsible for the development and administration of data pipelines, the data warehouse, and BI tools. Transform raw data into meaningful insights. This is accomplished through interactive and user-friendly dashboards and reports.
The Data Engineer III role is responsible for the design and development of enterprise data solutions based on business requirements. Work closely with the business to gather requirements and translate into a viable solution to solve complex business challenges. This role will understand various database technology platforms and data relationships to develop robust reporting and analytic services. In addition, the role will adhere to and serve as a data warehouse resource for the organization. This role will also be responsible for the development and administration of BI tools.
Essential Duties and Responsibilities include the following. Other duties may be assigned.
-
Interprets and executes data project requests. Presents report data in Power BI in a meaningful way, accessible and clear for individuals at all levels of understanding.
-
Develops queries, functions, stored procedures, and views to support reporting and data extraction, utilizing standards and best practices to ensure data accuracy and security.
-
Significant experience developing reports and dashboards using Power BI and up to date with the current version of Power BI and its capabilities.
-
Experience with various database platforms and cloud technology including Azure and Snowflake.
-
Design, develop, and optimize complex SQL Server solutions, including stored procedures, SSIS packages, and views and other database objects.
-
Participates in team-based problem solving and multidisciplinary team use of various data-driven process improvement techniques.
-
Develops best practice procedures for end users to facilitate the use of reporting tools and applications.
-
Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products.
-
Adopts new techniques and technologies.
-
Assists with mentoring and training of less experienced IT staff members.
Supervisory Responsibilities
No supervisory responsibilities
Client Responsibilities
This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education and/or Experience
BS/BA and 6+ years’ experience or equivalent combination of education and experience, and 2 years of SME in respective areas
Computer Skills
-
Advanced SSIS development skills, including parameterization, and partition switching.
-
Strong experience in building and maintaining CI/CD pipelines in Azure DevOps
-
Advanced proficiency with ETL and ELT frameworks, SQL, and SQL Server Reporting Services (SSRS) for the generation and extraction of data for use in analytics and reporting.
-
Proficient in creating complex DAX queries in Power BI Desktop & Report Builder.
-
Strong knowledge of Power BI Report Builder tool.
-
Strong knowledge of Power BI service.
-
Ensure code quality with Test Driven Development/ unit testing.
Familiarity with the following is desirable.
-
Real-time data streaming experience
-
Familiarity with healthcare data standards (HL7, X12 EDI, HIPAA compliance)
-
Proficiency in Python programming language
-
Proficiency in Azure and Azure DevOps
Certificates, Licenses, Registrations
Microsoft Azure Data Engineer Certification is highly desirable
Other Skills and Abilities
-
Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams.
-
Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences.
-
Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines.
Reasoning Ability
-
Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
-
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Mathematical Skills
-
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.
-
Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
Language Skills
-
Ability to effectively present information in one-on-one and small group situations to customers, clients, and other employees of the organization.
-
Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization.
Competencies To perform the job successfully, an individual should demonstrate the following competencies:
-
Composure
-
Decision Quality
-
Organizational Agility
-
Problem Solving
-
Customer Focus
-
Drive for Results
-
Peer Relations
-
Time Management
-
Dealing with Ambiguity
-
Learning on the Fly
-
Political Savvy
Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is regularly required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds.
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
This position may regularly be exposed to or encounter moving mechanical parts, high, precarious places, fumes or airborne particles, toxic or caustic chemicals, outdoor weather conditions, risk of electrical shock or vibration. The noise level in the work environment is usually moderate (examples: business office with computers and printers, light traffic).
Work Location
This position works remote location with management approval based on business requirements). Must provide adequate support to internal clients; be available for regular interactions and coordination of work with other employees, colleagues, clients, or vendors; as well as be available to facilitate effective decisions through collaboration with stakeholders.
Working Hours
This is an exempt level position requiring the incumbent to work the hours required to fully accomplish job responsibilities and reasonable meet deadlines for work deliverables. The individual must have the flexibility to work beyond traditional hours and be able to work nights, weekends or on holidays as required. Work hours may be changed from time to time to meet the needs of the business. Typical core business hours are Monday through Friday from 8:00am to 5:00pm.
Travel
This position requires no travel however attendance maybe required at various local conferences and meetings.
The Perks:
-
Medical / Dental / Vision / Wellness Programs
-
Paid Time Off / Company Paid Holidays
-
Incentive Compensation
-
401K with Company match
-
Life and Disability Insurance
-
Tuition Reimbursement
-
Employee Referral Bonus
To explore all that MedImpact has to offer, and the greatness you can bring to our teams, please submit your resume to
www.medimpact.com/careers
MedImpact, is a privately-held pharmacy benefit manager (PBM) headquartered in San Diego,
California. Our solutions and services positively influence healthcare outcomes and expenditures, improving the position of our clients in the market. MedImpact offers high-value solutions to payers, providers and consumers of healthcare in the U.S. and foreign markets.
Equal Opportunity Employer, Male/Female/Disabilities/Veterans
OSHA/ADA:
To perform this job successfully, the successful candidate must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Disclaimer:
The above
statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.
