Sevita is a mission-based organization dedicated to providing high quality services to those we serve. Therefore, to deliver on our mission, Sevita expects every employee to perform his or her job first and foremost in accordance with the Company’s mission.

SUMMARY

The Business Intelligence Architect will focus on implementing data driven analytics culture by standardizing BI technologies, development lifecycle & processes across Sevita. They will work directly with stakeholders and team members to define, design and deliver actionable insights while working with ETL developers and BI developers in an agile environment.

The Business Intelligence Architect position is a remote role.

ESSENTIAL JOB FUNCTIONS

To perform this job successfully, an individual must be able to satisfactorily perform each essential function listed below.

• Design, develop, implement, and support highly complex BI applications of strategic or functional importance including: integration with data sources; highly automated data refresh processes; best-in-class data visualizations, dashboards, and reports that communicate critical insights to drive decision making.

• Rich experience in architecting the Data warehouses/Data marts

• Must have rich experience designing and building Conceptual Data Models (CDM), Logical Data Models (LDM), Physical Data Models (PDM), Data Warehouses and Data Marts.

• Execute roadmap of business focused BI initiatives with a clear understanding of all deliverables and associated deadlines

• Expert in designing, developing Power BI Architecture & Dashboards

• Develop and maintain data management standards, and documentation of current data sources, raw data, data marts, transformations, and report specifications

• Oversee data quality including validation, cleansing/scrubbing, ETL methods, etc.

• Formulate and recommend standards for achieving maximum performance and efficiency of the data ecosystem

• Participate in data integration, business intelligence (BI) and enterprise information management programs by rationalizing data processing to support reuse.

• Ensure best possible performance and quality in ETL packages, Stored Procedures and SQL.

• Performs additional duties and activities as required.

The requirements listed below are representative of the knowledge, skill, and/or abilities required to perform the job.

• 12 years’ experience in data warehouse/BI intelligence architecture, design and development. Significant experience as BI/DW architect on several BI/DW initiatives

• Data security at a macro and micro level (platform, row-level, encryption, etc.)

• Rich Data/Dimensional modeling expertise

• Experience with Master Data Management, Data Governance, and/or Enterprise Information Management

• Expert knowledge of Azure tools and services centered around data and analytics (Data Lake, Data Factory, Azure Databricks, Azure SQL etc.)

• Excellent understanding of Microsoft Power BI and other Microsoft BI platforms (SSRS, SSAS & SSIS)

• Expert in BI Report & Dashboard development

• Experience designing and building complete ETL processes moving and transforming data from ODS, Staging and Data Warehousing

• Experience with reporting and visualization tools (PowerBI & SSRS)

Education and Experience:

• Bachelor’s Degree in computer science or related field required.

• 12 or more years’ experience managing and designing systems in an enterprise infrastructure environment required.

Certificates, Licenses, and Registrations:

• Vendor certification (Azure cloud, AWS cloud,etc.) preferred.

Other Skills and Abilities:

• Experience working with Cubes & MDX is a huge plus

• Exposure to Big Data technologies (i.e.: Hadoop, ElasticSearch, MongoDB)

• Experience with ETL tools like Kettle is a plus

• Experience with Jira, Confluence, EasyVista or similar application preferred.

• Experience with MySQL, SQL Server and Cache preferred.

• Application experience with Apache, Tomcat and/or IIS

Other Requirements:

• This is a remote role, but travel will be required as needed.

Physical Requirements:

Sedentary work. Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move

objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

AMERICANS WITH DISABILITIES ACT STATEMENT

External and internal applicants, as well as position incumbents who become disabled, must be able to perform the essential job functions either unaided or with assistance of a reasonable accommodations to be determined on a case by case basis.

Sevita is a leading provider of home and community-based specialized health care. We believe that everyone deserves to live a full, more independent life. We provide people with quality services and individualized supports that lead to growth and independence, regardless of the physical, intellectual, or behavioral challenges they face. We’ve made this our mission for more than 50 years. With Corporate operations located in the Boston Seaport, Lawrence, Massachusetts and Edina, Minnesota, today, our 40,000 team members continue to innovate and enhance care for the 50,000 individuals we serve.
Equal Opportunity Employer, including disability/vets