Power BI Consultant /Madison NJ , 12 Months Contract
Job title: Power BI Consultant /Madison NJ , 12 Months Contract in Madison, NJ at Suncap Technology
Company: Suncap Technology
Job description: USA/New Jersey
Remote : OK but occasional presence in Madison NJ facility is requiredSKILL- Power BI
TEX – 9 + yearsWe are looking for a consultant resource with the following expertise:
- Experience in data preparation, data gateway and data warehousing projects
- Deep understanding and experience in utilization of Pharmaceutical Data assets: IQVIA NPA, XPT, LAAD, Patient HUB Data, Veeva CRM Data, Customer and Product Master
- Proven experience in prototyping, designing, and requirement analysis in Power BI
- Experience and familiarity with Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, SSIS)
- Experience working with a self BI-service tool – must have Power BI and preferably Sigma Computing
- Experience in SQL and accessing data from Snowflake Cloud DW. At least basic knowledge and skills for secondary tools such as Microsoft Azure, PolyBase, Visual Studio, etc.
- Experience in building Analysis Services reporting models.
- Experience in working in AWS environment S3, Athena, Glue & Redshift
- Experienced in implementation of row level security and familiar with application security layer models in Power BI.
- Expertise in using advance level calculations on the data set.
- Able to develop tabular and multidimensional models that are compatible with current data warehouse standards.
- Experienced in developing, publishing and scheduling Power BI reports as per the business requirements.
- Proficiency in DAX queries in Power BI desktop
- Experience in Power BI API automation and proven experience in custom visuals development in Power BI
- Experienced with Power BI integration in other applications using embedded analytics (Power BI SaaS services)
- Experience in design thinking methodology and project documentation. Proficient in Agile and Kanban boards, Jira and Confluence
- Fluent in English (written and verbal)
- Support the Enterprise Analytics solution in Power Bi development and solution delivery
- Support LEO Pharma US commercial functions in the definition and implementation of information needs to enable business strategies by working directly with business stakeholders
- Translate functional specifications and business requirements into architectural designs that include complex data models and front- end visualizations
- Develop Power BI reports based on the functional requirements and solution documents
- Maintain existing Power BI dashboards and reports
- Support users and act as 2nd level and 3rd level support
- Propose and implement potential improvements for existing dashboards
- Maintain data models and transformation rules
- Anticipate future analytics needs in solution designs and reference architecture
- Ensure accurate and up-to-date project and solution life cycle documentation
- Select appropriated technology components to realize solution designs
- Execute development tasks according to plan and selected methodology