Business Intelligence Senior Analyst

Sevita is a provider of home and community-based specialized health care services. The Business Intelligence Senior Analyst will design, develop, and support complex business intelligence applications, dashboards, data models, and cloud-based data platforms. The role also involves building scalable ETL/ELT pipelines, orchestrating data workflows, implementing CI/CD, and maintaining data quality and governance standards.

Responsibilities:

• 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 understanding the Data warehouses/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 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
• 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
• Design, develop, and maintain scalable ETL/ELT data pipelines using Azure Data Factory
• Develop metadata-driven and reusable ADF pipelines for API, database, file, and cloud-based data sources
• Implement data ingestion into Snowflake Raw, Staging, Data Warehouse, and Information Mart layers
• Develop robust data transformation processes using SQL and dbt
• Implement incremental loading, CDC, error handling, restart ability, logging, and operational monitoring
• Optimize data pipelines for performance, scalability, reliability, and cost
• Design and develop Snowflake databases, schemas, tables, views, stored procedures, and tasks
• Develop scalable data warehouse models following enterprise data architecture standards
• Implement Snowflake security including RBAC, roles, warehouses, masking policies, and secure data access
• Perform SQL tuning and Snowflake performance optimization
• Monitor Snowflake workloads and identify opportunities for compute and storage optimization
• Develop data models supporting analytics, reporting, and downstream applications
• Develop and maintain dbt models, macros, tests, sources, snapshots, and documentation
• Implement modular and reusable transformation frameworks using dbt
• Establish data quality checks and testing using dbt
• Implement incremental models and dependency management
• Follow best practices for dbt project structure, naming conventions, documentation, and model governance
• Work with Data Architects and Analytics teams to implement dimensional and analytical data models
• Design and develop Apache Airflow DAGs for end-to-end data orchestration
• Orchestrate workflows across Azure Data Factory, Snowflake, dbt, APIs, and other data services
• Implement scheduling, dependencies, retries, failure handling, alerts, and operational monitoring
• Develop reusable Airflow operators, connections, variables, and configuration where appropriate
• Integrate Airflow with enterprise data platforms and external services
• Troubleshoot and resolve pipeline and orchestration failures
• Implement CI/CD pipelines using Azure DevOps for data engineering code and infrastructure
• Manage source control using Git and establish branching, pull-request, and code-review practices
• Automate deployment of ADF pipelines, dbt projects, Snowflake objects, and Airflow code across environments
• Support development, QA/UAT, and production deployment processes
• Implement automated testing and deployment validation
• Participate in release management, change control, and production support
• Implement data quality validations throughout the data pipeline
• Identify and resolve data completeness, accuracy, consistency, and integrity issues
• Implement monitoring and alerting for pipeline failures and data quality issues
• Follow enterprise standards for data security, governance, metadata, and regulatory compliance
• Collaborate with Data Architecture and Data Governance teams to implement data standards
• Travel as needed

Requirements:

• Rich experience in understanding the Data warehouses/Data marts
• Expert in designing, developing Power BI Dashboards
• We are seeking an experienced Senior Data Engineer with approximately 7 years of experience in designing, developing, and supporting modern cloud-based data platforms
• The ideal candidate will have strong hands-on experience with Azure Data Factory (ADF), Snowflake, dbt, Apache Airflow, SQL, and Azure DevOps CI/CD
• Bachelor's Degree in computer science or related field required
• 7 or more years' experience managing and designing systems in an enterprise infrastructure environment required
• Python for data engineering and automation
• REST API integration
• Kafka or other streaming technologies
• Snowflake security and RBAC
• Infrastructure-as-Code concepts
• Power BI and semantic models
• Azure Functions or Logic Apps
• Experience with Agile/Scrum development methodologies
• Vendor certification (Azure cloud, Snowflake, DBT etc.) preferred
• Experience with Jira, Confluence, EasyVista or similar application preferred
• Experience with MySQL, SQL Server and Cache preferred
• Datacoves or similar modern data engineering platforms