Data Warehouse Director jobs in Maine

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