Source description
About the role
Formulate automated reports and dashboards using Power BI and other reporting tools.
Understand business requirements to set functional specifications for reporting applications.
You should be familiar with SSRS and TSQL, Power Query, Power BI, and there are just a few of the tools and systems on the MS SQL Server BI Stack.
Exhibit a foundational understanding of database concepts such relational database architecture, multidimensional database design, and more
Design data models that transform raw data into insightful knowledge by understanding business requirements in the context of BI.
Develop technical specifications from business needs and choose a deadline for work completion.
Make charts and data documentation that include descriptions of the techniques, parameters, models, and relationships.
Developing Power BI desktop to create dashboards, KPI scorecards, and visual reports.
Experience in migrating OBIEE/OAC reports to Power BI reporting tool.
Establish row-level security on data and comprehend Power BI's application security layer models.
Examine, comprehend, and study business needs as they relate to business intelligence.
Design and map data models to transform raw data into insightful information.
Create dynamic and eye-catching dashboards and reports using Power BI.
Make necessary tactical and technological adjustments to enhance current business intelligence systems.
Integrate data, alter data, and connect to data sources for business intelligence.
Responsible for full lifecycle knowledge and support of OAC including business analysis, design, development, ETL, testing, deployment, and support.
Manages the Power BI environment and its underlying data, ensuring performance, security, and data integrity, while also developing and troubleshooting reports and dashboards. Responsibilities include data modeling, Power Query development, user access management, data refresh scheduling.
Identify and resolve technical issues related to Power BI reports, dashboards, data gateways, and data refresh processes.
like Power Query.
· Optimize the performance of Power BI solutions and underlying databases through indexing, query tuning, and capacity planning.
Ensure that Business Intelligence services meet the required service support levels.
Works with Internal Audit and supports SOX compliance requirements related to auditable applications.
Some international travel may be required to support global business requirements.
More at Universal Electronics