Data Warehouse Developer

New England Life Care (NELC) is one of the fastest growing home infusion therapy services companies in New England and is the region’s only non-profit home infusion provider. NELC is a hospital collaborative serving more than 70 hospital systems in Maine, New Hampshire, and Massachusetts. NELC was created by local hospitals to ensure their patients have access to a provider that reflects their commitment to excellence in patient care, quality, and service. Like our owner hospitals, NELC provides patient focused care.

New England Life Care has and continues to build a diverse, inclusive, and authentic workplace, so if you’re energized by this opportunity, you may be the person we are looking for!

New England Life Care is hiring a full-time Data Warehouse Developer to join our growing team! This position is full-time, Monday – Friday position.

Job Summary: New England Life Care is currently seeking qualified candidates for a Data Warehouse Developer. The Data Warehouse Developer plays a critical role in ongoing efforts to build and maintain data integration and warehousing solutions to support both business intelligence and analytical applications for decision-making. Candidate will provide support to departments with outstanding organizational, communication, and problem-solving skills.

**Currently only hiring for remote positions in the following states: Maine, Massachusetts, Connecticut, Rhode Island, New Hampshire, and Vermont**

**Not hiring individuals that reside outside of Maine, Massachusetts, Connecticut, Rhode Island, New Hampshire, and Vermont**

Benefits:

• Health Insurance
• Dental Insurance
• Vision Insurance
• Generous employer-matched 403b savings program
• Company paid: Life insurance, Short- and long-term disability insurance
• Paid Time Off
• And much more!

Primary Job Responsibilities:

• Assist with creating warehouse designs/structures that enable easy, natural end-user access with selected business intelligence platform(s).
• Design, automate, schedule, and load jobs necessary to extract core data from multiple data sources and environments into the data warehouse.
• Provide recommendations in the selection of DBMS, ETL, and associated tools appropriate for current and future needs of the decision support system.
• Ensure efficient processing on an ongoing basis including data consistency of data attributes, naming conventions, and element value types.
• Possess knowledge regarding data content/definitions and the use of business intelligence tools such as Microsoft Power BI.
• Hands-on development experience in ETL (Extract, Transform & Load), using tools such as SAS Enterprise Guide, Informatica, or DataStage.
• Able to identify next steps when given an assignment or task and asks question when unsure, to prevent unnecessary delays in responses and timelines.
• Advocate for our internal and external customers and serve as the conduit with multiple teams and vendors through which requirements flow to deliver solutions.
• Translate conceptual customer requirements into functional requirements in a clear manner that is comprehensible; Ability to collaborate with cross-functional software teams to ensure development aligns with the requirements.
• Ability to work in a fast-paced department independently or in a team and handle multiple tasks with competing priorities; work with interruptions and deal effectively with confidential information.

Additional Job-Related Duties:

• Follows NELC policies and procedures in the normal conduction of company business.
• Strong understanding of SDLC methodology.
• Assures that professional practice complies with state and federal regulations including, but not limited to the HIPAA Privacy and Security regulations and NELC’s Corporate Compliance Program.
• Strong organizational and communication skills to build and foster effective relationships; interfaces effectively with all levels of the organization; works cooperatively within a group; accepts constructive feedback.
• Displays good judgment; takes the initiative rather than waiting to be told; make practical suggestions; learns from past experiences and uses those insights to handle new situations effectively; defines problems logically and develops appropriate solutions; uses creative approaches.
• Participates in company Performance Improvement Program via appropriate completion of Occurrence Reports and Customer Complaints and the offering of recommendations for improvements based on trends noted.
• Participates in orientation and training of new personnel as needed.
• Participates in ongoing professional development via regular attendance at department meetings, in-services, and other educational programs pertinent to his/her job.
• Performs other duties / projects as assigned by direct supervisor.
• Travel to remote sites as needed

Educational Requirements:

• Bachelor’s degree in computer science, information systems, engineering, or other related discipline and/or equivalent combination of education and relevant experience.
• 3+ years of related experience – including testing, debugging, documenting and/or maintaining applications or using applications in a business setting, healthcare background preferred.
• Experience programming in SAS or SPSS.
• Ability to extract and merge data from multiple platforms; experience with creating a Data Warehouse, including the steps involved in the “lifecycle” of its development.

Regulatory Requirements:

• Knowledge of HIPAA Privacy and Security requirements.
• Working knowledge of federal / state fraud and abuse laws required.
• Valid driver’s license with excellent driving record required.

Skills:

• Strong SQL programming skills and related database experience.
• Knowledge and understanding of DBMS technology and ETL processes.
• Excellent customer service, communication, and organizational skills required.
• Must be self-motivated and able to work independently and in conjunction with team members.
• Capability to think out-of-the-box to create new solutions as needed.

EOE