POWER BI Consultant
Chicago, IL and Indianapolis, IN
3-6 Months
Infosys
Responsibilities :
· Work with data from mixed sources to support reporting and self-service data needs
o Mixed sources include: Azure Delta Lake, SSAS/OLAP cubes, Azure Analysis Services views or data models, on-prem SQL data warehouse, Power BI datasets, multiple on-prem SQL databases
· Create data models/cubes/datamarts to support reporting and self-service data needs. This includes proper analysis and data modeling to form the data properly for use. This also includes coordination with Data Engineering team.
· Create sustainable and scalable datasets in Power BI
· Make informed design decisions as to the best method to use for each report (i.e. keep in SSRS or convert to Power BI or other form based on use)
· Convert existing SSRS and SQL stored procedure reports to Power BI (dashboards and paginated reports, minor visualizations)
· Create new Power BI reports to meet new requirements
· Update existing Power BI dashboards/reports with new data source(s)
· Update existing SSRS reports with new data source(s)
· Unit testing of work before turning it over for QA team
· Create/update design documentation for all development tasks
· Create/update source to target documentation
· Create/update technical diagrams to support report strategy and overall design of reporting platform, data sources, data model designs, etc.
· Participate in code peer review process and contribute to the improvement of the collective work the team produces
Experience/skills needed:
· Must be a thought-leader that can evaluate the situation and make thoughtful recommendations for report strategy/design using the components we have available and make proposals for obtaining additional components where needed.
· Must be able to recommend and establish development standards where they do not exist and improve existing ones where needed (examples: report development, data modeling techniques, Power BI dataset standards, etc.)
· Strong Power BI development (built dashboards, paginated reports, datasets and dataflows, etc.)
· Must have strong DAX and Power Query experience
· Must have T-SQL, SQL stored procedures, SSRS experience
· Experience working with different schemas (other than Star schema)
· Experience working with different types of data sources for a single report (other than SQL, SharePoint, or Excel files)
· Must have experience building reports from cubes or data marts
· Must have data modeling knowledge and experience
o Not just creating datasets in Power BI, actual data modeling forming the data into workable datamarts, cubes, etc. to be used as basis for reporting and user self-service.
o Experience with tabular models
· Nice to have integration experience (SSIS, Azure Data Factory, etc.)
Prefer to have experience with more than one data warehouse
Bhaskar kumar Koppisetti
Email :kumar.koppisetti@3sbc.com
Hangout : bhaskarkumar3sbc@gmail.com
An E-Verified Company
Note: If you are not able to reach me over the phone please email me , I will reply to you ASAP.
To be removed from our mailing list reply with "remove@3sbc.com" and include your "original email address/addresses" in the subject heading. Include complete address/addresses and/or domain to be removed. We will immediately update it accordingly. We apologize for the inconvenience if any caused. Please consider the environment before printing this email. Go Green
You received this message because you are subscribed to the Google Groups "hotrequirements223" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hotrequirements223+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hotrequirements223/3ad1824c-374c-417d-bdec-72e4ce7833a6n%40googlegroups.com.
No comments:
Post a Comment
Thanks
Gigagiglet
gigagiglet.blogspot.com