Power Bi Analyst

Summary

The Power BI Analyst will be responsible for designing, developing, and maintaining business intelligence solutions. Crafting and executing queries upon request for data, presenting information through reports and visualization. Your Power BI capability will focus on converting business and client reporting requirements to meet the overall needs of the organization.
Candidate Profile

• Bachelor's (Preferred)
• SQL: 1 year (Preferred)
• Business Analysis: 1 year (Preferred)

Competencies:

• Business Acumen
• Communication
• Consultation
• Critical Evaluation
• Relationship Management
• Ethical Practice

Duties and Responsibilities:

• Design, publish and maintain Power BI data models with over 45 interrelated tables connected
• Implementing a data model that works seamlessly in Direct Query or Import mode
• Merging/Joining Queries (M Language) in order to filter useful data to make visuals on a high granular level
• Establishing dynamic table relations with desired Cross filtering directions.
• Implementing measures in DAX that filter out values from different tables to display calculations
• Visuals with Level Filters that maintain data consistency across interactive/dynamic pages
• Setup automated data refresh of dashboards to show the updated values from source data
• Slicer Selections and Syncing across report pages
• Translate business needs to technical specifications
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems
• Collaborate with teams to integrate systems
• Develop and update technical documentation
• Performs other duties as required

Qualifications:

In-depth understanding of the following:

• Data Connections: Gateways, SSMS, Connection Types and their nuances
• Data Modellng, Merging and Joining tables, Cross Filtering Techniques, PowerQuery (M language)
• Visualization: Power BI Desktop, Advanced Visual Interactions, Visual Level Filters, Measures (DAX), Action Buttons, Bookmarks and Custom Themes
• Sharing/Publishing: Power BI Service, Data Refresh Schedules, Embedded Power BI Reports
• DAX and Power Query M, implementing this for developing Power BI custom connectors for Language Detection
• Programming Language: Python and R
• Industry experience is preferred
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving aptitude

Job Type:

• Full-Time

Salary:

• $22.00/Hour (Plus Benefits)

Location:

• Dallas, TX

Benefits:

• Free Individual Health Insurance
• Free Training (Program specific)
• Paid Vacation
• Paid Company Holidays
• Education Assistance/Reimbursement (Toward first degree - Bachelors/Associates)
• Individual Mentor
• 401k Retirement Savings
• Interest free loans (Case basis)
• Benefits valued at up to $25,000.00 annually