Responsibilities :
- 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.
Requirements :
- BE/B-Tech / ME/ MTech in CSE or MCA
- 10+ years of rich experience in Power BI, ETL and experience with migration of existing reports from OAC/OAS/OBIEE.
- Strong expertise in Data import, Data modeling, Calculated columns, measures, custom visuals, KPI and scorecard implementation and tables, Data transformation
- Experience in designing interactive dashboards, tooltips, bookmarks, slicers, Custom Visuals, KPI and scorecard implementation.
- Good understanding of Oracle EBS R12 data model (tables)
- Strong Understanding of Data Warehouse principles and practices.
- Expertise in designing reports with Single as well as Multiple data sources and databases.
- Expertise in robust scheduling and monitoring processes, Power BI REST API, Paginated reports.
- Expertise with Oracle SQL Developer or similar query tools and strong understanding of SQL and its concepts.
- Experience in the manufacturing industry is a plus.
- Strong team player, partnering with senior/executive management and individual contributors.
- Excellent presentation/communication skills.
- Exceptional problem-solving skills.
Top Skills
What We Do
Universal Electronics Inc. (NASDAQ: UEIC) is the worldwide leader in universal control and sensing technologies for the smart home. Its broad portfolio of over 300 pending and current patents includes the world’s most complete database to connect and control thousands of entertainment viewing devices. The company designs, develops, manufactures and ships over 500 innovative products that are used by the world’s leading brands in the audio video, subscription broadcasting, connected home, tablet and smart phone markets. With a global network of design and development services, UEI’s many first-to-market innovations have helped transform the home entertainment control industry over the past 25 years. In 2015, it expanded its product and technology platform to include home automation, intelligent sensing and security.