Job Title
ETL Data Analyst

Job Description
Effective Tuesday, January 4, 2022, all U.S.-based employees are required to be fully vaccinated against COVID as a condition of employment at Philips*. Employees may request a reasonable accommodation. *Montana employees are currently excluded from this requirement at this time.

If you are a Colorado resident and this role is a field-based or remote role, you may be eligible to receive additional information about the compensation and benefits for this role, which we will provide upon request. You may contact 888-367-7223, option 5, for assistance.

*** US work authorization is a precondition of employment. The company will not consider candidates who require sponsorship for a work-authorized visa.

*** Company relocation benefits will not be provided for this position. For this position, you will reside in or within commuting distance to our Alpharetta, GA office.

In this role, you have the opportunity to make life better

Looking at the challenges the world is facing today Philips' purpose has never been more relevant. So, whatever your role, if you share our passion for helping others, you'll be working towards creating a better and fairer future for all.

We are seeking a highly motivated ETL Data Analyst who has strong analytical skills with the ability to collect, organize, analyze, and interpret significant amounts of information to support Tableau CRM, Tableau and QlikSense dashboards and projects for the Philips North America Health Systems business

You are responsible for (but not limited to)

Business Intelligence and Data Analysis- 60% of time includes the following activities:

• Perform data analysis, produce data samples/prototypes and produce ad-hoc reports.
• Obtain and analyze data by accessing multiple sources, including SAP and data warehouses to enable agile data analysis and data preparation for front end BI implementation in Salesforce Einstein analytics, Tableau and other reports
• Act as the Azure SME for data sourcing as new projects are kicked-off.
• Identifies trends and issues in data using advanced analysis techniques. Provides technical and analytical assessments of issues facing the business and presents findings to key stakeholders.
• Filter and clean data by reviewing reports, dashboards, and performance indicators to locate and correct problems.
• Partner and collaborate with IT, Product owners and BI Analysts to provide input to project timelines, scope, and risks for Business Intelligence initiatives
• Developing a clear understanding of system landscape, data repositories and its interrelationships
• Assists with customizing existing reports and data manipulation
• Assists in verification of data loading and manage the Quality of the data sets.
• Develop reports and processes to continuously monitor data quality and integrity issues and problems
• Locate and define new process improvement opportunities.
• Utilize LEAN and Kaizen concepts to identify and implement data driven continuous improvement initiatives

Quality Assurance, Testing, and Documentation- 25% of time includes the following activities:

• Create and maintain technical documentation including specifications, data flows, data mapping and data dictionaries. Keep documentation up to date on any existing report changes. Facilitate training & rollout of new tools
• Develop and perform standard queries to ensure data quality, identify data inconsistencies, missing data and resolve as needed
• Regularly conducts daily and weekly reviews of data quality reports and resolves data issues and problems
• Create training and internal QA/UAT documentation, perform quality assurance and ongoing monitoring of current reports and data for accuracy and usage
• Perform extensive data unit testing and quality assurance (QA). Troubleshoot issues and work cross-functionally towards a solution
• Respond and resolve all assigned feedbacks (all priorities) within the set thresholds (business days)

Leadership- 15% of time includes the following activities:

• Demonstrate the ability to lead small cross functional project teams
• Provide guidance/governance on best practices and approaches to design, implement and sustain effective data driven analytics solutions
• Perform post project reviews with project team from BIS and IT, identify best practices and learning's and implement in project execution process to improve future project execution
• Promote Philips values and leadership goals
• Act as mentor for others in the business

To succeed in this role, you should have the following skills and experience:

• Minimum of 5+ years as a Data Analyst.
• Bachelor's degree within a technical related field (i.e., Mathematics, Statistics, Economics, Computer Science or Information Management). Master's degree in above fields preferred
• Technical expertise regarding data models, database design development, ETL, data mining and segmentation techniques.
• Intermediate to advanced knowledge of providing BI data solution on Azure PaaS using Azure SQL Database, Azure Analysis Services, Azure Automation, Azure Data Factory, Azure Data Lake and Blob Storage.
• Design the Azure Data bricks to process the ETL transformation using Python notebooks (Python is required). Working knowledge on Data Science using Azure ML Ops would be a plus.
• Intermediate to advanced knowledge of Data Warehousing for ETL, identifying metrics, dimensions (and slowing changing dimensions), hierarchies and knowledge of design of dimensional schema (Star, Snowflake) would be an added advantage.
• Expertise in qualitative and quantitative analysis.
• Well-versed in producing datasets and reports for analysis using SQL & SSIS, SSRS or other reporting tools verifying their accuracy and providing insights
• Experience in creation of technical specifications and project documentation and translating functional requirements into detailed technical requirements.
• Experience using Microsoft Excel, Power Point, Project, Access and Visio.
• Advanced knowledge of SQL and SOQL/SAQL (needed) and JSON (preferred).
• Experience in working with several groups of data and users simultaneously.
• Experience in being innovative and having strong analytic skills.
• Demonstrated ability to provide strong time management skills.
• Has strong verbal & written communication skills.
• Experience in problem solving, critical thinking and priority setting

Philips is a global leader in health technology, committed to improving billions of lives worldwide and striving to make the world healthier and more sustainable through innovation. Driven by the vision of a better tomorrow. But it's not just what we do, it's who we are. We are 80,000, wonderfully unique individuals, with two things in common: An unwavering sense of purpose and a relentless determination to deliver on our customers' needs. It's what inspires us to create meaningful solutions - the kind that make a real difference - when it matters most.

The world and our customers' needs are changing faster than ever before and while we are proud of what we do already, we know we can do more. That's why we need you, to help us tackle increasingly complex challenges posed by ever evolving health and well-being needs.

How we work at Philips

Our newly adopted hybrid work concept fuses flexibility withcollaboration to deliver great outcomes for our people andour customers.We areembracing an approach wherein wespend more time together than apart - which for full-timeemployees translates to an average of at least 3 daysworking from the office and up to 2 days from home - forour hybrid roles. Hybrid work flexibility means people can meet the changingdemands of work and home in the most balanced,productive, and healthy way.

Our hybrid working model is defined in 3 ways:

• We believe in the importance ofimpactful collaboration:There's a certain energy when everyone's in the same roomthat can heighten idea generation and creative frictionneeded for problem-solving.
• Weembrace flexibility: Choosing where, when, and how towork can vary according to task and team schedules.Flexibilityisn'toffice or online, it means choosing the spacethat works best for you, your teams, and our customers on acase-by-case basis.
• We want tobe at our best: The way wework,and ourworkspaces are designed to support our well-being, offercareer advancement opportunities, and enable us to be atour best.

Why should you join Philips?

Working at Philips is more than a job. It's a calling to create a healthier society through meaningful work, focused on innovative, customer-first health technology solutions. Help us improve the health and well-being of billions of people, every year. Ultimately creating a career that no one could have planned for. Even you.

Visit our careers website to explore what it's like working at Philips, read stories from our employee blog, find information about our recruitment process and answers to some frequently asked questions.

It is the policy of Philips to provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to race, color, ethnicity, religion, gender, pregnancy/childbirth, age, national origin, sexual orientation, gender identity or expression, disability or perceived disability, genetic information, citizenship, veteran or military status or a person's relationship or association with a protected veteran, including spouses and other family members, marital or domestic partner status, or any other category protected by federal, state and/or local laws.

As an equal opportunity employer, Philips is committed to a diverse workforce. In order to ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Veterans' Readjustment Act of 1974, and Title I of the Americans with Disabilities Act of 1990, applicants that require accommodation in the job application process may contact 888-367-7223, option 5, for assistance.

Equal Employment and Opportunity Employer/Disabled/Veteran

#LI-PH1