Data Engineer III - Snowflake, United States - MedImpact

Description

Exemption Status:

United States of America (Exempt)$92,036 - $127,700 - $163,364 "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

Responsible for the development and administration of data structures, data ingestion processes, and maintenance of the data warehouse.

The Data Engineer is responsible for the design and development of data structures and data ingestion processes and solutions based on business requirements.

This role will be working closely with the business to gather requirements and translate into a viable solution to solve complex business challenges.

The Data Engineer will understand various database technology platforms and data relationships to develop and enhance data ingestion processes and data structures that supply data for internal and external reporting solutions.

Essential Duties and Responsibilities

include the following. Other duties may be assigned.
Analyze existing data ingestion processes (SSIS and stored procedures) to identify inefficiencies and areas for improvement.

Develops queries, functions, stored procedures, data marts, and views to support reporting and data extraction, utilizing standards and best practices to ensure data accuracy and security.

Use demonstrated experience to develop SSISI packages, workflows, and stored procedures to supply data for our reporting solutions.

Excellent data modeling experience creating fact tables, dimensional tables, and data marts.

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 SQL, Azure and Snowflake.

Interpret SSRS and Power BI reports to thoroughly understand data sources and identify upstream gaps in data ingestion.

Ensure that changes to data structures and pipelines are tracked and documented effectively.

Work with infrastructure team members to coordinate deployment of new data structures in lower environments and production systems.

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 to IT) 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 or MS degree in Computer Science, Information Technology, or related field required. Proficient (5+ years) in Developing Power BI solutions, reports, and dashboards. Expertise in using advance level calculations on the data set. Experience working on Power BI reports with large volumes of data. Knowledge of how to connect Power BI to various data sources (on-perm, cloud) and transform data. Ability to communicate with technical and non-technical users to provide business solutions. Ability to function independently and manage multiple projects. Self-motivated and attention to detail. SDLC and Agile methodologies.
Computer Skills –

Demonstrable skills required in the following areas:
Fluid with .NET Framework, .NET Core, C#, Entity Framework Core.

Advanced proficiency with ETL Framework, 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

Proficiency in Python programming language

Certificates, Licenses, Registrations
Microsoft Power BI 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.
Language Skills
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the public.
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.
Reasoning Ability

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.

Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
Competencies
To perform the job successfully, an individual should demonstrate the following competencies:
Customer and Quality Focus -

Actively demonstrates a personal concern for understanding client needs, ensuring the quality of products and services, maintains a high level of customer satisfaction, and contributes to continuous improvement of products and processes.

Adaptability -

Adjusts quickly to evolving situations by integrating new information, remaining flexible, recognizing, and implementing necessary changes and taking advantage of opportunities presented by new developments.

Analytical -

Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs work flows and procedures.

Innovation -

Displays original thinking and creativity; Meets challenges with resourcefulness; Generates suggestions for improving work; Develops innovative approaches and ideas; Presents ideas and information in a manner that gets others' attention.

Interpersonal Effectiveness -

Demonstrates good people skills by showing a commitment to teamwork, resolving conflicts effectively and with respect for others' viewpoints, respecting differences and building strong relationships and networks.

Initiative -

Proactively gathers and analyzes information, assesses situations and identifies challenges and opportunities, sees what needs to be done and takes appropriate action.

Job-specific Expertise -

Demonstrates solid command of relevant knowledge, skills, techniques and technologies, keeps current with recent developments and best practices in the field, and establishes self as the go-to person for up-to-date knowledge in his or her area.

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.

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

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.

Who is MedImpact? MedImpact was founded more than three decades ago by a pharmacist and independent drug store owner who saw firsthand how families struggled with the high cost of prescriptions, and how it impacted their lives, financial security, and health.

So he started MedImpact to make prescription benefits understandable and accessible.

While we have grown to be one of the leading PBMs in America, we remain as committed to these principles today as we did when it all began.

#J-18808-Ljbffr