Power BI Developer

Do you have a passion for innovative ideas and groundbreaking discoveries? With over $1 billion invested annually in R&D, at Thermo Fisher Scientific you’ll help solve some of the world’s toughest challenges, from giving cancer patients hope, ensuring safe drinking water and helping law enforcement tackle cases through forensics. We empower our teams to put science into meaningful action and give our R&D colleagues the autonomy, resources, and tools they need to take science a step beyond.

Job Title: Power BI Developer

Location: Carlsbad, CA - Remote

What will you do?

• Work with department leaders to establish Key Performance Indicators and methods of dashboard that present relevant and useful data.
• Be responsible for the diagnosis and support of Power BI reporting solutions, including investigation of data issues, data validation, scalability, balancing and row level security implementation
• Design new Power BI Dashboard and SSAS cube solutions from requirements and from an understanding of organizational business needs.
• Create and deliver standards on defining, crafting, and documenting reference PBI architecture
• Develop Hierarchy SSAS model to allow advanced drill-through capabilities.
• Use SSAS, Power BI and Excel: Pivot Table, Power Query, Power Pivot, and Data Models to capture information from various sources and deliver information to the end user.
• Act as a Power BI, visualization, and dash-boarding domain expert
• Through Power BI software development activities and collective understanding of the enterprise-wide business needs, promote the use of self-service products.
• Define and document standard processes for dashboards and self-service reporting tools.
• Perform unit and integration test, participate in report validation and QA of reporting and data analytics.
• Dedicated to creating quality reports and applications and accountable for doing whatever is vital towards that end.
• Collaborate and technically mentor other developers and analysts for successful project delivery

How will you get here?

• BS/MS in Computer Science or equivalently technical disciplines; years of professional experience may be considered in lieu of degree
• 5 years of working experience in delivering Power BI solutions.
• 4 years if extensive experience with SSAS Tabular and DAX
• Knowledge of MDX, M Query and Power Query
• 4 years of experience in building dashboards using Microsoft Power BI
• In-depth knowledge of T-SQL and SQL Server
• Extensive experience with SSAS tabular model security, Partition and automation process.
• Strong database Analysis skill using SQL
• Expertise in using advance level calculations on the data set with experience in handling multi-million data sets
• Working knowledge of data warehouse concepts, relational database design and data modeling
• Good communication skills and should be focus on details on data analysis and mapping
• Look beyond the detailed requirements to understand what the business is trying to do / don’t get lost in the details
• Develop and maintain documentation to our standards / provide feedback on standards where they can be improved
• Familiar with Cognos Analytics is preferred.
• Experience in Power BI data analytics & visualizations against Data lake and Oracle DWs
• Experience in Oracle, SQL Server or AWS Redshift, AWS S3 type databases
• Experience in Microsoft SSAS Multidimensional and SSAS Tabular Models.
• Knowledge in Python and common python libraries.
• Strong analytical experience with database in writing complex queries, query optimization, debugging, user defined functions, views, indexes etc.
• Knowledge with source control systems such as Git, Bitbucket, and Jenkins build and continuous integration tools.
• Knowledge of using JIRA for Project related activities

Knowledge, Skills, Abilities

• Highly dedicated, execution-focused, with a willingness to do "what it takes” to deliver results as you will be expected to rapidly cover a considerable amount of demands on data integration
• Critical Thinking - Think big picture. Set priorities aligned with major goals. Encourage innovation by backing good people who take thoughtful risks.
• Critical Thinking - Question conventional wisdom by identifying assumptions made that cause actions or inaction. Strive to inject independent thinking, checking biases, promotes action and decision-making.
• Communication - communicate effectively in the way reach audiences with ease, clarity, and visibility: one-to-one, small group, full staff, email, social media, and of course, listening.
• Provide organizational support for relationship to develop partnership, establish relationships, and promote collaboration to cultivate and strengthen a network for the exchange of ideas
• Problem-solving (analytical)

Our Mission is to enable our customers to make the world healthier, cleaner, and safer. Watch as our colleagues explain 5 reasons to work with us. As one global team of 100,000 colleagues, we share a common set of values - Integrity, Intensity, Innovation, and Involvement - working together to accelerate research, solve complex scientific challenges, drive technological innovation, and support patients in need. #StartYourStory at Thermo Fisher Scientific, where diverse experiences, backgrounds and perspectives are valued.

Apply today! http://jobs.thermofisher.com

Thermo Fisher Scientific is an EEO/Affirmative Action Employer and does not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other legally protected status

Salary : $1 - $0