Lead BI Data Engineer

About Providence

Providence, one of the US's largest not-for-profit healthcare systems, is committed to high quality, compassionate healthcare for all. Driven by the belief that health is a human right and the vision, 'Health for a better world', Providence and its 121,000 caregivers strive to provide everyone access to affordable quality care and services.

Providence has a network of 51 hospitals, 1,000+ care clinics, senior services, supportive housing, and other health and educational services in the US.

Providence India is bringing to fruition the transformational shift of the healthcare ecosystem to Health 2.0. The India center will have focused efforts around healthcare technology and innovation, and play a vital role in driving digital transformation of health systems for improved patient outcomes and experiences, caregiver efficiency, and running the business of Providence at scale.

Why Us?

• Best In-class Benefits
• Inclusive Leadership
• Reimagining Healthcare
• Competitive Pay
• Supportive Reporting Relation

Job Summary:

We are seeking a skilled and experienced BI Analytics professional to join our team. The ideal candidate will have 4 to 5 years of experience in business intelligence and analytics, with proficiency in Power BI, data modeling, SQL, Snowflake, and DAX. The candidate should have knowledge of various domains within cyber security and have prior experience in creating CISO Dashboards using relevant Cyber Security Metrics. The candidate should be adept at collaborating with business stakeholders, developing ETL processes, and creating BI solutions. A strong understanding of data visualization, the best practices, excellent problem-solving, and analytical skills are essential.

Key Responsibilities:

• Design, Develop, and Maintain BI Solutions: Create and manage reports, scorecards, and dashboards using Power BI to effectively tell the story of the data and highlight anomalies.
• Develop and optimize data models for reporting, ensuring scalability, performance, and usability.
• Connect to various data sources, including SQL databases, APIs, Excel, cloud platforms, and flat files to extract, transform, and load (ETL) data into Power BI.
• Utilize DAX (Data Analysis Expressions) in Power BI for complex calculations for data transformation.
• Data Modeling and SQL: Develop and maintain data models, write complex SQL queries, and ensure data integrity and accuracy.
• ETL Processes: Design and implement ETL processes to acquire, aggregate, cleanse, organize, and manage large complex datasets from multiple sources.
• Collaborate with Business Stakeholders: Work closely with business stakeholders to understand their requirements and translate them into actionable insights and BI solutions.
• Data Visualization: Apply best practices in data visualization to create intuitive and insightful dashboards and reports.
• Problem-Solving and Analytical Skills: Employ critical thinking and creative problem-solving to address data or analytics limitations and escalate issues to leadership when appropriate.
• Documentation and Communication: Prepare effective presentations, document analytical findings, and communicate results to stakeholders and leadership.

Required Skills and Qualifications:

• Experience: 4 to 5 years of experience in business intelligence and analytics, Power BI development.
• Bachelor's degree in computer science, Information Systems
• Technical Proficiency: Strong proficiency in Power BI, SQL, and Snowflake.
• Advanced proficiency in Power BI for developing reports, dashboards, and using Power Query and DAX for data manipulation and analysis.
• Strong SQL skills for querying, transforming, and integrating data from databases (SQL Server, Oracle, etc.).
• Data Modeling: Expertise in data modeling and understanding of data visualization best practices.
• ETL Processes: Experience in designing and implementing ETL processes.
• Collaboration: Ability to collaborate effectively with business stakeholders and cross-functional teams.
• Analytical Skills: Excellent problem-solving and analytical skills.
• Communication: Strong communication skills, both written and verbal, with the ability to present complex data insights in a clear and concise manner.

Preferred Qualifications:

• Certifications: Relevant certifications in Power BI, or other BI tools.
• Industry Knowledge: Familiarity with the healthcare industry and Cyber security

Providence's vision to create 'Health for a Better World' aids us to provide a fair and equitable workplace for all in our employment, whether temporary, part-time or full time, and to promote individuality and diversity of thought and background, and acknowledge its role in the organization's success. This makes us committed towards equal employment opportunities, regardless of race, religion or belief, color, ancestry, disability, marital status, gender, sexual orientation, age, nationality, ethnic origin, pregnancy, or related needs, mental or sensory disability, HIV Status, or any other category protected by applicable law. In furtherance to our mission in building a more inclusive and equitable environment, we shall, from time to time, undertake programs to assist, uplift and empower underrepresented groups including but not limited to Women, PWD (Persons with Disabilities), LGTBQ+ (Lesbian, Gay, Transgender, Bisexual or Queer), Veterans and others. We strive to address all forms of discrimination or harassment and provide a safe and confidential process to report any misconduct.

Contact our Integrity hotline also, read our Code of Conduct.