Business Intelligence Data Architect

Join Martin's Point Health Care - an innovative, not-for-profit health care organization offering care and coverage to the people of Maine and beyond. As a joined force of "people caring for people," Martin's Point employees are on a mission to transform our health care system while creating a healthier community. Martin's Point employees enjoy an organizational culture of trust and respect, where our values - taking care of ourselves and others, continuous learning, helping each other, and having fun - are brought to life every day. Join us and find out for yourself why Martin's Point has been certified as a "Great Place to Work" since 2015.
Position Summary Martin's Point is seeking another BI Data Architect to add to its growing team! We're looking for candidates with a minimum of 3 years experience writing T_SQL code and familiarity with SSIS and other ETL tools. Work history in healthcare setting is also highly desirable. Should your work experience support these requirements and you'd like to join a Great Place to Work...where caring is our culture...DON'T WAIT...and, APPLY TODAY for immediate consideration!Job Description
Position Summary:
Martin's Point maintains a data warehouse containing data from all aspects of its' operations. Utilizing various data manipulation tools as well as an enterprise business intelligence platform the Informatics Department provides business intelligence and analytic services to Martin's Point. Informatics develops structures to store data as an asset beginning with the Data Architecture team and supplies that data, through the delivery of reports, analyses and consultation by the BI Reporting team.

Informatics supplies analysis and reports to all departments at Martins' Point from the executive level to the management team as well as frontline staff, all with the goal of improving performance throughout the organization.

A member of the BI Architecture team, the Senior BI Data Architect s responsible for the architecture, design, development, and maintenance of the data warehouse; data marts, staging and archival databases through the life cycle: from business requirements to development of logical design, translation to physical design, ETL architecture and code development, and on through implementation and maintenance. This position reports to the Manager, BI Architecture.

Key Outcomes:
+ Architects, designs and develops enterprise data warehouse, data mart, operational and other miscellaneous components required for BI applications using stored procedures, functions, views, and other ETL Tools as appropriate.
+ Assists BI development team in the design of database solutions. Work with business owners and business users to understand and translate user requirements into practical data models
+ Reviews database architectures and designs to ensure data integrity and quality, performance, management, scalability, etc.
+ Designs, develops and implements conceptual data models for BI solutions
+ Validates ETL processes by developing and executing test plans and scenarios to ensure viability of code prior to implementation in production
+ Designs, develops and deploys back-end systems to support operational and analytical reporting
+ Creates and maintain documentation of processes, reports, applications, and procedures
+ Maintains the data warehouse metadata repository
+ Supports the data warehouse loads and other processes in conjunction with other members of the architecture team.
+ Optimizes programmed code for best possible speed and performance
+ Maintains all data warehouse and other processes and respond to critical data warehouse issues during off hours
+ Makes and maintains recommendations for architecture solutions that support business and technical requirements and that provide for scalability and availability of data and resources.
+ Establishes best practices for BI solutions and ensures that they are being effectively applied
+ Works as technical lead for cross-departmental, multi-platform database development projects
+ Leads development teams in the design of database solutions. Work with business owners and business users to understand and translate user requirements into practical data models

Education/Experience:
Bachelor's degree in computer science, information technology, management systems or related discipline
Four years of experience in data warehousing, including extensive experience working with ETL processes, OLAP structures, SQL coding and dimensional modeling
Four years of experience in health care industry, from payer or provider perspective
Experience with SSIS or other ETL tools such as Informatica
Experience with data modeling and metadata concepts
At least four years of experience writing T-SQL code and procedures

We are an equal opportunity/affirmative action employer.
Do you have a question about careers at Martin's Point Health Care? Contact us at: jobinquiries@martinspoint.org
Martin's Point Health Care is a progressive, not-for-profit organization providing primary care and health insurance plans to the people of Maine and beyond. The organization owns and operates seven primary care health care centers with over 70 health care providers in Maine and New Hampshire and accepts most major insurance plans. Martin's Point also administers two health plans: Generations Advantage, the largest Medicare Advantage plan in Maine, and the US Family Health Plan (TRICARE Prime) for military families and retirees throughout New England. For more information, visit https://careers.martinspoint.org.