Senior Software Engineer (PowerBI)

Extraordinary Careers. Endless Possibilities.

With the nation's largest home infusion provider, there is no limit to the growth of your career.

Option Care Health, Inc. is the largest independent home and alternate site infusion services provider in the United States. With over 8,000 team members including 5,000 clinicians, we work compassionately to elevate standards of care for patients with acute and chronic conditions in all 50 states. Through our clinical leadership, expertise and national scale, Option Care Health is re-imagining the infusion care experience for patients, customers and employees.

As a two-year recipient of the Gallup Exceptional Workplace Award, we recognize that part of being extraordinary is building a thriving workforce that is as unique as the patients and communities we serve. Join a company that is taking action to develop a culture that is inclusive, respectful, engaging and rewarding for all team members. Our organization requires extraordinary people to provide extraordinary care, so we are investing in a culture that attracts, hires and retains the best and brightest talent in healthcare.

Job Description Summary:
The Senior PowerBI Developer contributes to analyze, design, develop, test reports to improve the decision-making process for the organization. Provides guidance in developing various analytical and operation dashboards, research/recommend new technologies, techniques, proof of concepts, follow best practices and standards. This role is highly visible and collaborative, provide guidance on various dashboards/reports and projects associated with senior executive team.
Job Description:

Job Responsibilities (listed in order of importance and/or time spent)

• Analyze business requirements into technical requirements for business reporting and dashboards.
• Design, develop and maintain reports in PowerBI. Reports with multiple data sources, complex queries, views, stored procedures, and automation.
• Development experience in BI tool MS Power BI, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS)
• Advanced DAX (Data Analysis Expressions ) knowledge and performance tuning of Tabular models.
• Provide detailed source analysis and data mappings/transformations to BI developers to implement new data sources and integrations.
• Configure all BI systems/environments to deliver BI solutions including data quality issues and defects to determine the root cause
• Develop, implement, coordinate user testing plans in QA/UAT environments to validate BI solutions.
• Perform daily/weekly deployments from lower to higher environments, validate post deployment changes to ensure established Release Management Process followed.
• Assist development teams with analysis, design for new or existing systems.
• Play role of Subject Matter Expert for business units and provide detailed information on data availability, location, lineage, and quality.
• Provide support for incident management, track daily ticket queue, and prioritize the solutions.
• Perform peer reviews to ensure conformity to standards and quality.
• Work with other IT team members, implement new standards, new technology, and tactical solutions driving the business strategy forward.
• Adhere full SDLC (System Development Lifecycle) process, track obsolescence/release date of new products, stay abreast of new technology.
• Responsible for implementing security on developed PowerBI dashboards in accordance with pre-established architecture.
• Responsible for maintaining existing PowerBI analytical/operational dashboards and ensure all dashboard refreshed including underline reports as per daily/weekly schedule.
• Responsible for Designing and developing PowerBI reports, analytical/operational dashboards including data set ingestion and transformation, Data Modeling, Data Analysis Expressions (DAX) using appropriate report templates depicting status of key performance indicators (KPIs) and other important business metrics for an organization to make data driven decisions.
• Collaborate proactively with functional users, analysts, and other team members to gather business requirements for reporting.
• Understand business requirements, determine implementation strategy, and translate into reports that conform to best practices and standards.
• Document new reports and update the dashboard reports in IT Handbook.
• Troubleshoot and resolve technical/performance query issues, optimize report performance within defined SLA.

Supervisory Responsibilities

Does this position have supervisory responsibilities?

(i.e. hiring, recommending/approving promotions and pay increases, scheduling, performance reviews, discipline, etc.)

No - X

Yes

Basic Education and/or Experience Requirements

• Bachelor's degree in engineering/computer science or related field
• Overall, 8-10 years of SQL development experience on Microsoft products.
• 4 - 6 years of experience in PowerBI report design, development, testing, implementations of data, reports and dashboards using BI tools.
• Demonstrates ability to motivate and lead others and able to make decisions in a rapidly growing environment
• Exposure to Azure and Machine Learning (ML) is a huge plus

Basic Qualifications

• Experience with design patterns in the creation of architectural and database design deliverables.
• Experience with Microsoft Business Intelligence Suite (TSQL, SSIS, SSRS), exemplary general IT knowledge (applications development, deployment, testing, operations, documentation, standards, best practices, security, hardware etc.).
• Demonstrated ability to interface effectively and collaborate with internal teams and management to develop solutions.
• Excellent time management, communication, presentation, and documentation skills.
• Knowledge of full system development Life Cycle process

Travel Requirements: (if required)

N/A

Preferred Qualifications & Interests (PQIs)

Due to state pay transparency laws, the full range for the position is below:

Salary to be determined by the applicant's education, experience, knowledge, skills, and abilities, as well as internal equity and alignment with market data.

Pay Range is $89,097.02-$148,495.03

Benefits:

-401k

-Dental Insurance

-Disability Insurance

-Health Insurance

-Life Insurance

-Paid Time off

-Vision Insurance

Option Care Health subscribes to a policy of equal employment opportunity, making employment available without regard to race, color, religion, national origin, citizenship status according to the Immigration Reform and Control Act of 1986, sex, sexual orientation, gender identity, age, disability, veteran status, or genetic information.