** Data Warehouse Engineer (Remote)**
**Job Category****:** Other **Requisition Number****:** DATAW04584 Showing 1 location **Job Details**
**Description**
MedInsight is one of the healthcare industrys most highly regarded platforms for data warehousing and healthcare analytics. Just over 20 years ago we were founded on the premise of building trust in data to help health plans, employers, government and community providers as well as ACOs and third-party administrators do more with cost and care management. MedInsight ultimately helps drive better outcomes for patients while reducing waste in the healthcare space.
Now more than ever, data and analytics are paramount to the success of care providers, payors and patient outcomes. The solutions and standalone products provided by MedInsight offer clients the flexibility and power to balance technology, expertise and support. Over 300 leading healthcare organizations in the US have come to rely on MedInsight for our data and analytics.
MedInsight is a subsidiary of Milliman; a global, employee-owned consultancy providing actuarial consulting, retirement funding and healthcare financing, enterprise risk management and regulatory compliance, data analytics and business transformation as well as a range of other consulting and technology solutions. Built on the foundations of driving innovation and providing expert and elegant solutions for clients, we continue to break bounds in our 7th decade in business.
**Position Summary**
The Torch Insight Engineering team is looking for a Data Warehouse Engineer to support a variety of healthcare engineering projects. We are interested in people that are excited about developing new solutions, working in a fast-paced environment, and collaborating with individuals outside of the engineering team to solve problems. The ideal candidate is a rockstar SQL and ETL engineer that loves to work with large data sets, has a strong sense of ownership in their work, enjoys developing a highly performant data warehouse, and is an innovative self-starter. This person is eager to expand their knowledge and is always combing the internet to find new ways to solve new and existing problems. The healthcare technology space is constantly evolving, so it is essential for success that candidates be able to learn new processes/technologies and to adapt quickly.
**This position is a fully remote, work-from-home position.**
* Join an award-winning firm with a track record of growth backed by a marketplace powerhouse.
* Be part of the expansion and evolution of an analytics and research team in a data-driven company.
* Enjoy significant visibility and be recognized for your wins.
* Work-from-home with flexible schedule
**Essential Responsibilities**
* Maintain and update existing data sets directly from a variety of sources
* Transform data into clean, modeled data
* Work with engineering team to develop and integrate new data tables into warehouse
* Troubleshoot and improve existing data warehouse code
* Build ad-hoc SQL queries and views for client requests
**Travel** **Responsibilities**
* This position is a fully remote, work-from-home position. Quarterly nationwide travel may be required when safe to do so.
*Due to COVID-19 precautions, MedInsight team members are on a travel freeze.
**Required Qualifications**
* 2+ years of ETL engineering experience, including relevant school experience
* Strong ETL engineering techniques including data profiling and data cleaning
* Experience working with large data sets
* Ability to troubleshoot and optimize complex SQL queries
* Ability to use complex documentation and build logical data conclusions and structures
* An understanding of general data warehousing, and business intelligence best practices
* Excellent communication and collaboration skills
* Desire and ability to work remotely
**Preferred Qualifications**
* Bachelors degree, preferably in statistics, mathematics, computer science, information systems, finance, economics, engineering, or related fields.
* Masters degree is a plus
* Strong experience with Microsoft SQL Server (T-SQL)
* Experience with US Healthcare concepts and data
* Experience optimizing performance within a data warehouse
* Exposure to general business intelligence (BI) practices including data visualization, data analysis, and data integration
* Experience working with OLAP Cubes
* Experience building solutions leveraging the cloud (Azure, AWS, etc.)
* Bachelors or Masters degree in Technology/Engineering/Computer Applications.
* Experience with Python, Scala, or other big data technologies
* Experience with statistical packages, such as R or Stata
**Desired Experience and Traits**
* Self-motivated, organized, and adaptable adept at planning and execution, capable of prioritizing and accomplishing goals across a spectrum of concurrent tasks for varying stakeholders.
* Consultative and confident approach: Critical thinker, able to effectively comprehend complex business issues and develop solutions and communications that work for varying stakeholders.
* Detail-oriented: Recognizes that the small things make all the difference and pays attention to everything.
* Collaborative: Demonstrated ability to work with engineering and analytics teams to discuss technical concepts, make tradeoffs, and evaluate new ideas.
* Intellectually curious: Desire and ability to learn new skills, systems and processes, and interest in exploring data credibility and advanced analytic approaches.
* Energetic, optimistic, and hard-working: Maintains a can-do attitude and is unrelenting in the pursuit of excellence.
Above all else, we are looking for someone who can become part of a high-trust, high-responsibility team and who can grow and contribute in high-value ways. Viable candidates will have an interest in healthcare analytics, healthcare operations, and/or healthcare markets. Candidates must have strong quantitative, analytical, data visualization, and presentation skills, as well as an enthusiasm for learning. It is essential for candidates to possess the ability to learn new processes/technologies, and to adapt quickly in the constantly evolving healthcare technology space.
**Benefits:**
* Medical & Dental
* Vision
* Group Term Life Insurance
* Supplemental Life Insurance (Including Spouse/Domestic Partner & Dependent)
* AD&D
* Short & Long-Term Disability
* Paid Parental Leave
* FSA (Health Care Flexible Spending Account or Dependent Care Flexible Spending Account)
* Adoption Benefit
* Identity Theft Protection
* Retirement Program: 401(k)
* Paid Time Off (PTO)
* Access to free training through Millimans Learning & Development department
**Qualifications**
**Skills**
**Behaviors**
**:**
**Motivations**
**:**
**Education**
**Experience**
**Licenses & Certifications**
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR 60-1.35(c)
...PROJECT ENGINEER SUMMER INTERNSHIP: The goal of the summer internship is to provide the intern with office experience typical of project managers and field experience typical of field engineers while providing the individual with an opportunity to learn about...
**Housekeeper $15+/hour - $250 SIGN ON BONUS!****Department:** Facilities **Location:** Pittsburgh, PA **Housekeeper with luxury hotel... ..., and Asia * Quarterly awards and team recognition * Paid time off with roll-over and holiday pay with flexible floating holidays...
...Services Summary Responsible for building implementing and administrating multiple identity security solutions hosted in Salesforce Okta Azure which includes onboarding new enterprise applications within identity standards strengthening user access and access...
...ABOUT JOYBA BUBBLE TEA The Brand Theres a reason we love boba. Not only is it bright... ...media and on campus. We're looking for Ambassadors who are outgoing, fun, and inspire their... .... Applicants must be legally eligible to work in the US and possess a valid SSN. HOW...
...opportunities for you, thats right, YOU! If inside you're saying "Im in" please continue... The Dispatcher is responsible for attaining maximum utilization of remote and on-site technical resources through daily dispatch of service requests. Responsibilities...