Power BI Developer - Amman, Jordan
Avertra is a global integration service, product development, and consultancy organization focused on the energy and utility industry. We attract and hire the industry’s most innovative and experienced problem solvers, each dedicated to our mission of helping our clients realize the full value of their investments in IT and in Avertra.
Avertra’s industry-leading process knowledge and technology expertise combined with influences from consumer-centric industries have resulted in the genesis of our innovative User Xperience Unification (UXU) framework, which is available throughout our MiUtility platform of solutions for:
-Call center optimization
-Omni-channel customer engagement
-Mobile workforce management
-Meter reading
And much more!!
POSITION OVERVIEW
The Power BI Developer will be responsible for creating and deploying visually appealing and highly interactive Microsoft Power BI based reports and dashboards for external and internal use in Avertra products, as well as creating supporting queries, connections, and statements.
JOB RESPONSIBILITIES
- Responsible for planning, designing, developing, implementing and maintaining Microsoft Power BI dashboard and reports
- Design and develop data-driven views, reports, objects, hierarchies, filters, dashboards, metrics and visualizations and on the Microsoft Power BI platform based on users’ requirements
- Create T-SQL queries, set up data connections and refresh schedules using Power BI gateways, and writing DAX and R statements as necessary
- Comfortable with extracting data from multiple data sources by configuring Power BI gateways, and using M scripting to connect and refresh the data
- Research, review, and analyze the effectiveness and efficiency of existing report procedures and develop strategies for enhancing or further leveraging these processes
- Coordinate and perform in-depth tests, including end-user reviews, for modified and new reports and other processes
- Automate data cleansing processes
- Write efficient reports by following internal and industry standards and BI methodologies
- Work with a Team of Business Analysts and Business Partners to review and understand the requirements and translate them into visualizations and KPIs in a report
- Communicate and collaborate with teams across the globe to action these requirements and deliver the required reports
- Format reports in a simplistic, self-explanatory, and visually appealing way as to ensure answers to questions asked are clear and evident
- Possess a solid understanding of Software Development Lifecycle (SDLC) and version/source control disciplines
- Define functional and technical docs based on data availability, quality, and profiling on source data systems
COMPETENCIES
- Proficient in translating user requirements into creative and interactive visual dashboards, catering to all level of Management including Tech Execs
- Comfortable in dealing with all levels of business partners and management
- Knowledge of all Power BI technologies including data modeling, embedding, publishing to SharePoint and Power BI apps
- Knowledge of all “flavors” of Power BI desktop software and Power BI gateways
- Strong understanding of Row Level Security, report parameters, and permissions
- Familiarity with SQL Server stack (SSMS, SSRS, SSIS, SSAS) and related Microsoft tools such as Power Pivot and SharePoint services
- Experience in writing T-SQL queries to get the necessary data
- Solid knowledge on data modeling using Excel spreadsheets, Power BI models and using DAX, M or SQL
- Proven experience in ETL tools, SQL development and query performance tuning
- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
- Proven experience with report writing and technical requirements analysis, business process modeling/mapping, methodology development, and data modelling
- Solid understanding of relational database concepts
- Good knowledge on data preparation, quality and governance frameworks
- Comfortable in a fast-paced, dynamic work environment
- Ability to manage multiple tasks simultaneously; pays close attention to detail
- Exceptional oral and written communications skills
- Ability to work both independently and as part of a team
- Ability to work effectively with technical and business staff across geographic areas
EDUCATION
- Bachelor’s on CS, IT or relevant field
EXPERIENCE
- 3+ years of experience of Power BI experience
KNOWLEGDE, SKILLS, & ABILITIES
- Arch Principles of Design
- Business Operations & Processes
- Data Analytics
- Data Modeling
- Database Performance
- Data Warehousing
- Security & Compliance
- Project & Program Management Methodologies
- Product/Software Development Lifecycle (SDLC)
- Development of Best Practices
- Strategic Planning
- Troubleshooting & Defect Triage