SAS Administrator of Research Data Warehouse Job in Boston, Massachusetts Us
Who we are
Harvard Pilgrim is a not-for-profit health plan and a full-service benefits company serving members in Massachusetts, New Hampshire, Maine and beyond. We make health care work better. We recognize diversity's impact and importance for our workforce, customers and providers, and through our contributions to the communities we serve. It's part of the way we do business.
What we value
Harvard Pilgrim believes that greatness is built from the inside out. It's created by individuals who share common goals, and who support and rely on one another to achieve them. Our core values guide us in how we treat, respond to and interact with our customers, business partners and one another.
Who we hire
We hire the best and brightest-talented individuals who value innovation, creativity and communication in the workplace. Harvard Pilgrim believes that by attracting, retaining and engaging diversetalent, we gain a sustained competitive advantage for continued growth.
Our employees bring Harvard Pilgrim's mission, values and brand to life in an inclusive and supportive environment where they are respected and valued for their contributions. Being part of the Harvard Pilgrim team means that you excel at what you do. You're dedicated to your work and continually look for new ways to serve your customers better.
What we offer
We do our best to support our employees in making the most of their lives both inside and outside of work. At Harvard Pilgrim, we know that a talented, engaged and inclusive workforce is our greatest strength. We have an excellent benefit package and are "T" accessible.Some of our benefits include:
* A comprehensive work and life benefits program, including medical and dental benefits, time away from work, retirement, financial protection and on-site fitness centers.
* Opportunities to learn and grow, build relationships, share your opinions and do what you do best every day.
* Ways to serve and give back to the communities where you live, work and play - through grants, fundraising and volunteering.
JOB SUMMARY:
The SAS Research Data Warehouse Administrator of the Research Services Data Center (RSDC) will be responsible for the development and maintenance of the Virtual Data Warehouse (VDW). The VDW is HPHCIs research data warehouse, and is sourced from HPHCs Enterprise Data Warehouse (EDW). The SAS Data Warehouse Administrator will function as HPHCIs VDW manager and will be responsible for ensuring that the VDW conforms to HMO Research Network specifications.
The SAS Data Warehouse Administrator will develop and maintain the optimal database solution to meet current and future business objectives. S/he will be the primary liaison with technology teams in other business units. The SAS Data Warehouse Administrator will develop a thorough understanding of the EDW and lead quality assurance testing and user acceptance testing for HPHCI.
The SAS Data Warehouse Administrator will represent HPHCI in HMO Research Network data management and development activities. S/he will work collaboratively with the VDW Oversight Committee, Operations and Technical Leads in RSDC, and support all RSDC programmer/ analysts, project managers and investigators in troubleshooting and effectively addressing their VDW-related questions. S/he will ensure efficient and effective communications.
The SAS Data Warehouse Administrator will be required to master the VDW content and to have technical expertise, interpersonal skills to negotiate solutions, and the ability to work on multiple projects at the same time.
Essential Functions:
- Lead the development and maintenance of the Virtual Data Warehouse (VDW). Implement the optimal database solution to meet current and future business objectives. Evaluate new technologies and products. Research and propose cost effective technical solutions to address challenges.
- Function as HPHCIs VDW manager and be responsible for ensuring that the VDW conforms to HMO Research Network specifications. Represent HPHCI in HMO Research Network data management and development activities.
- Function as HPHCIs business unit expert on the HPHC Enterprise Data Warehouse (EDW). Participate on data stewardship committees, lead data warehouse testing for business unit and integration of new data to ensure research data requirements. Participate in development of test strategies and plans, execute test procedures, and report results.
- Create and maintain up-to-date technical and operational documentation.
- Develop working knowledge of and facility in accessing data from all available data sources including: clinical information systems, automated medical records, hospital claims, outpatient claims, pharmacy, enrollment, provider, employer, and benefits data.
- Perform data management, programming and analysis activities for research studies.
- Use good judgment and practice in working with highly confidential information. Follow all applicable privacy and confidentiality procedures in daily work.
- Bachelors degree in a related field (i.e. computer programming, information systems, health sciences)
- 8+ years of practical experience programming and/or managing data in a health care and/or data warehousing environment, or an equivalent combination of education and experience.
- Advanced SAS programming skills, including proficiency in Base SAS, SAS MACROS SAS/ACCESS to relational databases, SAS/CONNECT, SAS/ETS, SAS/GRAPH, SAS/STAT.
- A demonstrated knowledge of relational database management systems including TERADATA, ORACLE and SQL SERVER. Expertise in ETL processes, performance tuning, query optimization and data migration. Management of large databases (measured in terabytes).
- Ability to work with business units to understand their challenges and develop appropriate technical solutions.
- Experience retrieving, manipulating and analyzing data on UNIX or Linux operating systems.
- Demonstrated ability to resolve problems in a timely manner. Strong leadership and planning skills. Ability to effectively multitask in a fast-paced and changing environment.
- Excellent interpersonal, oral, and written communication skills.
- Demonstrated ability to work both independently and as part of a team.
Organizational Relationships/Scope:
- Works directly with internal and external constituents such as: RSDC Leads, HPHCI executives, HMO Research Network partners, and HPHCs business community, and will frequently represent HPHCI to external constituents.
- Reports to the Manager of Administration Systems.
If you'd like to join Harvard Pilgrim, we'd like to hear from you!
Please visit www.harvardpilgrim.org to set up a job agent.
Harvard Pilgrim supports individuals in reaching their full potential by supporting equal employment opportunities and an environment that actively values diversity and inclusion. Harvard Pilgrim complies with all applicable laws concerning hiring and employment practices and is firmly committed to fostering and maintaining a workplace free from discrimination. We pledge to hire, train, and promote our employees without regard to race, religion, gender, gender identity, age, national origin, sexual orientation, disability, veteran status or any other category protected by applicable law.
