PowerBI Architect

About Tufts Medicine:

Tufts Medicine is a leading integrated health system bringing together the best of academic and community healthcare to deliver exceptional, connected and accessible care experiences to consumers across Massachusetts. The health system is the principal teaching affiliate for Tufts University School of Medicine. The strong relationship between Tufts Medicine and Tufts University School of Medicine is evident in our governance, academic and research structure. Tufts Medicine is comprised of the following clinical entities:

·       Tufts Medicine Professional Group (TMPG)

·       Tufts Medicine Integrated Network (TMIN)

·       Tufts Medical Center

·       Lowell General Hospital

·       MelroseWakefield Hospital, Lawrence Memorial Hospital of Medford

·       Tufts Care at Home

Job Overview 

Reporting to the Director Productivity, Analytics and Support you will support the deployment of enterprise-wide Business Intelligence solutions that are cross-functional and of mid-level complexity. You will be responsible for collaborating with team members to develop and design BI Reports and analytics initiatives for end users using a variety of data sources to support enterprise objectives.  

Job Description 

Minimum Qualifications: 

1. Bachelor’s degree in Information Technology or related field. 

2. Two (2) years of healthcare IT experience utilizing data analytic tools such as Power BI or Tableau. 

Preferred Qualifications: 

1. Four (4) years of healthcare IT experience. 

Duties and Responsibilities: The duties and responsibilities listed below are intended to describe the general nature of work and are not intended to be an all-inclusive list.  Other duties and responsibilities may be assigned. 

1. Builds solutions on enterprise data warehouse systems. 

2. Contributes to team projects, with the objective of becoming more technically proficient 

3. Provides technical assistance for data warehouse systems content and initiatives. 

4. Acts as an escalation path for any enterprise analytics and reporting concerns. 

5. Works with teammates to plan proactively for new data warehouse systems features that would improve the state of the enterprise analytics program. 

6. Shares best practices based on lessons learned at other organizations. 

7. Maintains existing policy and procedures for code reuse, documentation, and testing. 

8. Writes design documentation, and functional requirements and specifications with guidance. 

9. Works collaboratively with others in meeting user expectations and team deadlines. 

10. Writes medium-to-complex code. 

11. Participates in test case scenarios and support. 

12. Participates in some after-hours on call support, to troubleshoot and resolve system issues escalated by the Help Desk. 

13. With managerial oversight, leads smaller and/or less complex initiatives and projects.  

13. Builds enhancements to current database and warehouses using appropriate programming language and/or technical tools. 

14. Participates in detailed testing of report databases, data marts, views and warehouses in general 

15. Responds to data issues reported by users; research and resolve issues in a timely fashion 

Physical Requirements:  

1. Frequent sitting, occasional standing & walking, and lifting of 5-10 lbs.    

2. Mental requirements will be intense at times with involvement in many concurrent multi-faceted projects. 

3. Requires manual dexterity using fine hand manipulation to operate a computer keyboard or related equipment. 

4. Requires ability to see computer screen, monitoring equipment and reports.   

Skills & Abilities: 

1. Excellent customer service orientation. 

2. Flexibility and can-do attitude. 

3. Strong interpersonal skills demonstrated through prior work experience. 

4. Able to translate business requirements into technical specifications. 

5. Works collaboratively in a small, cross-functional team. 

6. Self manages to complete tasks on time and support other team members in product and platform development. 

7. Critical thinking and problem-solving skills. 

8. Flexibility and eagerness to learn new technical skills to meet emerging needs. 

9. Basic understanding of software development life cycle. 

10. Advanced beginner in reporting and dashboard development using PowerBI, Python, and SQL. 

11. Advanced beginner in data querying using tools like Management Studio, Jupyter and Databricks Notebooks. 

12. Technical programming skills demonstrated through prior IT experience. 

Job Profile Summary 

​ This role focuses on the design, development, and implementation of information technology (IT) solutions in order to meet the organization's needs through new and existing applications, systems architecture, network systems and applications infrastructure and the management of the IT infrastructure.  In addition, this role focuses on performing the following Analytics related duties: Performs complex data research and analysis to support business operations, creates data mining architectures/models/protocols, statistical reporting, and data analysis methodologies to identify trends in large data sets, researches and applies knowledge of existing and emerging data science principles, theories, and techniques to inform business decisions, and may conduct scientific research projects with the goal of breaking new ground in data analytics.    A professional individual contributor role that may direct the work of other lower level professionals or manage processes and programs.  The majority of time is spent overseeing the design, implementation or delivery of processes, programs and policies using specialized knowledge and skills typically acquired through advanced education.   An experienced level role that applies practical knowledge of job area typically obtained through advanced education and work experience.  Works independently with general supervision, problems faced are difficult but typically not complex, and may influence others within the job area through explanation of facts, policies and practices.