Solution Architecture and Strategy:
o Collaborate with stakeholders to define the long-term BI strategy, including selecting appropriate tools and technologies.
o Design and develop data models, ETL (Extract, Transform, Load) packages, OLAP (Online Analytical Processing) cubes, and reports utilizing Power BI, while adhering to best practices.
o Document source-to-target mappings, data dictionaries, and database design.
o Work with APIs and tools like Postman to build and test APIs, integrating them seamlessly into the overall architecture.
2. Data Modeling and Governance:
o Develop and maintain reference architectures for reports based on various data sources (Data Warehouse, SharePoint, etc.).
o Ensure adherence to data governance standards, including proper data refreshes and publishing of common dataset hierarchies.
o Implement security measures to protect sensitive data.
3. Technical Leadership and Collaboration:
o Lead technical reviews of reports and dashboards before production deployment.
o Optimize data flows by identifying areas for improvement.
o Provide hands-on guidance to users in optimizing their data models and reports, ensuring efficient performance and usability
4. Power BI Premium Capacity Management:
o Manage Power BI Premium capacity, including allocation, monitoring, and optimization.
o Allocate workspaces effectively based on business needs.
o Ensure efficient utilization of resources within the Premium capacity
5. User Support and Community Engagement:
o Address user questions related to Power BI and other BI technologies within the organization.
o Proactively troubleshoot and fix data model issues for users when necessary.
o Organize monthly community calls to support, train, and guide citizen developers, fostering a strong BI community.
Come join our global, inclusive & diverse team
Our purpose is to improve the quality of life of everyone we touch through our innovative motion systems. We are a truly global team bound together by our shared values. Our culture is built on the diversity, knowledge, skills, creativity, and talents that each employee brings to the company. Our people are our company’s most valuable asset. We are committed to providing an inclusive, diverse and equitable workplace where employees of different backgrounds feel valued and respected, regardless of their age, gender, race, ethnicity or religious background. We are committed to inspiring our employees to grow, act with ownership and find fulfilment and meaning in the work they do.
Skills Required
- Experience designing and developing Power BI reports and data models
- Experience managing Power BI Premium capacity (allocation, monitoring, optimization)
- Design and develop ETL packages and OLAP cubes
- Experience working with APIs and using Postman to build and test integrations
- Experience with Data Warehouse and SharePoint as data sources
- Document source-to-target mappings, data dictionaries, and database design
- Implement data governance and security measures for sensitive data
- Provide technical leadership, conduct reviews, and train/support users and citizen developers
What We Do
Johnson Electric is a global manufacturer of motion products, control systems, flexible interconnects, electric motors, actuators, motion subsystems, and related electromechanical components. Established in Hong Kong, the company serves more than 1,500 customers across automotive, industrial, medical, smart metering, appliances, home automation, power tools, and other markets. Its operations span 20 countries and four continents, supporting applications that improve movement, control, and connectivity.








