Live chat
Philips Electronics North America

Business Systems Analyst- SQL ETL

Philips Electronics North America - Bothell, WA

Business Systems Analyst- SQL ETL

in

Bothell

Washington

We welcome you to join Philips as an experienced Business Systems Analyst reporting directly into the Senior Manager, Sales Operations in Bothell, WA.

We simplify healthcare by focusing on the people in the care cycle - patients and care providers. Through combining human insights and clinical expertise, we aim to improve patient outcomes while lowering the burden on the healthcare system. Philips delivers advanced solutions for both health professionals, to meet the needs of patients, and empowered consumers for affordable healthcare whether in hospital or at home.

Your Role

This role will be responsible for designing, building and maintaining databases for a fast paced reporting team. They will have the ability to work with large and complex volume data sets and must have a clear understanding of the full database systems. This position demands both business analysis and reporting expertise with ownership of the business need for data quality assurance processes required to support critical business intelligence initiatives.

Your Profile

-8 years of experience in SQL programming in T-SQL building stored procedures and jobs

-5 years data integration and ETL experience with SQL Server Integration Services (SSIS) or other industry leading tools including ability to configure SQL Server agent

-5 years of experience in designing and developing ETL processes including naming conventions, connection to variety of systems and processing of large volume of data

5 years of experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain the mapping information

-Extensive Microsoft BI stack experience: SQL Analysis Service (SSAS), Integration Service (SSIS), SQL Reporting Services (SSRS), Reporting tools (Excel, PowerPivot).

-Strong understanding of data integration, quality and validation

-Experience with SQL Reporting Services (SSRS) and Reporting tools (Excel, PowerPivot)

-4 years of experience extracting data from Salesforce.com database objects using API calls via SSIS, DataLoader, and other ETL tools; familiarity with SOQL (Salesforce SQL)

-Experience designing and developing with SSAS projects

-Understanding of MDM, Data warehouse / Data mart

-8 years IT industry experience

-Clear understanding and experience with Microsoft platforms, including Windows operating systems for both desktop and server.

-Experience in logical and physical data modeling

Knowledge of physical database administration with SQL Server a plus

-Experience with SQL Server in a VMWARE or AWS environment

-Experience moving data across different types of databases

-Excellent performance tuning and TSQL skills

-SQL Automation experience

-Good with Data Warehousing Concepts

-2-3 years of Tableau experience

-Excellent written and verbal communication skills and be able to interact with multiple IT teams and business partners both formally and informally

Key Skills

-A self-managed “doer” and self-starter who works well in a fast-paced, dynamic, team-oriented environment

-Solid written and verbal communication and organization skills

-Strong documentation skills

-Able to work in an ambiguous environment with complex undocumented business logic and data flow

Must be a creative solution oriented person

Our Offer

This Business Systems Analyst role will give you the opportunity to take your career to the next level in a global organization that is backed by a stable 120 year legacy of innovation. Here, you’ll go as far and as wide as you aspire. We make sure of it through support of a formal development planning process, as well as countless opportunities to expand your knowledge and skill set through resources such as the Learning@Philips program, tuition reimbursement and/or mentor relationships.

Philips is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex (including pregnancy), sexual orientation, gender identity, national origin, genetic information, creed, citizenship, disability, protected veteran or marital status.

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.

We welcome you to join Philips as an experienced Business Systems Analyst

reporting directly to the Senior Manager, Sales Operations in Bothell, WA

We simplify healthcare by focusing on the people in the care cycle - patients and care providers. Through combining human insights and clinical expertise, we aim to improve patient outcomes while lowering the burden on the healthcare system. Philips delivers advanced solutions for both health professionals, to meet the needs of patients, and empowered consumers for affordable healthcare whether in a hospital or at home.

In this role, you have the opportunity to…

Design, build and maintain databases for a fast-paced reporting team by using your clear understanding of full database systems to work with large and complex volume data sets.

Provide ownership of the business need for data quality assurance processes required to support critical business intelligence initiatives while, lending your business analysis and reporting expertise.

Manage and deliver on client expectations around project activities, timelines, deliverables, and outcomes.

Provide targeted communication (verbal and written), to internal and external constituents.

Bring your proven analytical and process redesign, problem-solving, and quantitative reasoning and workflow skills.

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

Bachelor’s degree, minimum, (preferably in software development, business analytics or data science)​ along with:

Excellent written and verbal communication skills with the ability to interact with multiple IT teams and business partners (formally and informally)

An ambiguous mindset is required; the ability to follow and understand complex undocumented business logic and data flow, then provide a creative solution

Ability to self-manage “doer” and self-starter working well in a fast-paced, dynamic, diverse group of professionals and personalities in a team environment.

8 years’ of experience with:

IT industry experience paired with SQL programming in T-SQL, building stored procedures and jobs

Extensive Microsoft BI stack experience: SQL Analysis Service (SSAS), Integration Service (SSIS), SQL Reporting Services (SSRS), Reporting tools (Excel, PowerPivot)

MS Office applications, including Word, PowerPoint, Excel, and Outlook.

Microsoft platforms, including Windows operating systems for both desktop and server.

​2 years’ of experience with:

Data integration and ETL experience with SQL Server Integration Services (SSIS) or other industry-leading tools including ability to configure SQL Server agent

Designing and developing ETL processes including naming conventions, connection to variety of systems and processing of large volume of data

Identifying and mapping data elements across multiple systems including creating templates and best practices to maintain the mapping information

Extracting data from Salesforce.com database objects using API calls via SSIS, Data Loader, and other ETL tools; familiarity with SOQL (Salesforce SQL)

Data integration, quality and validation and Physical database administration with SQL Server, a plus

Intermediate experience with:

Tableau, Qlik, Microsoft PowerBI and other advanced analytics and visualization tools.

SQL Server in a VMWare or AWS environment and SQL Automation

Development with Python and/or R (or other common languages and their structure)

MDM, Data Warehouse or Data Mart

In return, we offer you

We offer you a dynamic working environment in an innovative business, which offers you excellent opportunities to further develop and fully exploit your talents. This job comes with a competitive salary, excellent benefits, and up-to-date training.

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 improving 3 billion lives a year by delivering innovative solutions across the health continuum at http://www.philips.com/b-dam/corporate/corporateblog/2016/Philips

Chronic

Disease_5.jpg . Our people experience a variety of unexpected moments when their lives and careers come together in meaningful ways.

To find out more about what it’s like working for Philips at a personal level, visit the Working at Philips page at http://www.philips.com/a-w/careers/healthtech/working-at-philips/working-at-philips.html on our career website, where you can read stories from our employee blog at http://www.usa.philips.com/a-w/our-people/life-at-philips.html . Once there, you can also learn about our recruitment process at http://www.philips.com/a-w/careers/healthtech.html , or find answers to some of the frequently asked questions at http://www.philips.com/a-w/careers/healthtech/faq.html .

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

Philips is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex (including pregnancy), sexual orientation, gender identity, national origin, genetic information, creed, citizenship, disability, and protected veteran or marital status.

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.

#LI-PH1

Apply Now

Philips

Philips Jobs

Apply Now

Share

7 days 18 hours ago

Philips Electronics North America

apply

Business Systems Analyst- SQL ETL Philips Electronics North America - Bothell, WA, United States

   

Location: Bothell, WA

Company Profile:
Since the introduction of the first Philips light bulb more than 120 years ago, innovation and a people-centric approach have always been at the core of our company.