Skip to Main Content

Business Intelligence Data Architect

Martin's Point Health Care Portland, ME

  • Expired: June 24, 2020. Applications are no longer accepted.

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 DescriptionPosition 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 da

Martin's Point Health Care


Portland, ME



View all jobs at Martin's Point Health Care