Business Intelligence Principal Analyst _3116

Business Intelligence Principal Analyst

• May telecommute

• Gather the reporting requirements

• Design and develop ETL scripts using SQL, T-SQL ,SSIS, Azure Data Factory (ADF)

• Design the Data models like Conceptual Data Models (CDM), Logical Data Models (LDM), and Physical Data Models (PDM)

• Participate in the Data warehouse build

• Perform production support and resolve ETL & Reporting incidents

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

• Identify and test for bugs and bottlenecks in the data solutions that were developed

JOB REQUIREMENTS:

• Bachelor's in Engineering, computer science, or related, or any foreign equivalencies

Prior experience must include:

• 6yrs exp w/gathering the business requirements from stakeholders and convert them to technical reporting requirements
• 6 yrs exp w/designing and developing ETL scripts using SQL, T-SQL ,SSIS, Azure Data Factory (ADF)
• 6 yrs exp w/designing the Data models like Conceptual Data Models (CDM), Logical Data Models (LDM), and Physical Data Models (PDM)
• 6 yrs exp w/participating in the Data warehouse build in SQL technologies
• 6 yrs exp w/performing production support and resolving ETL & Reporting incidents
• 6 yrs exp w/ensuring performance and quality in ETL packages, Stored Procedures and Azure Data Factory pipelines
• 6 yrs exp w/identifying and testing for bugs and bottlenecks in the data solutions that were developed
• 4 yrs exp w/ Microsoft PowerBI data modeling and dashboard development
• 4 yrs exp w/SDLC products (JIRA, Confluence, Github, etc) or similar agile project management tools
• 4 yrs exp w/ change release management using Azure DevOps or Bitbucket
• 4 yrs exp w/ Cloud migration methodologies and processes including tools like Azure Data Factory, Azure Synapse, Event Hub, etc
• 4 yrs exp w/ designing the data warehouse using Snowflake

Why Join Us?

• Full compensation/benefits package for employees working over 30 hours/week

• 401(k) with company match

• Paid time off and holiday pay

• Enjoy complex work that makes a difference in the lives of those we serve

• Career development and advancement opportunities across a nationwide network

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