PowerBi Developer - Brethren Mutual Insurance Company

A Power BI developer has complete knowledge of the BI system. They are responsible for the development and administration of BI tools. And their main duty is to transform raw data into meaningful insights. This is accomplished through interactive and user-friendly dashboards and reports. Power BI professionals are expected to perform a wide range of tasks such as reporting, building dashboards, building data models, analyzing datasets, and administration of Power BI tools.

Essential Duties

• Develops operational reports.
• Builds automated reports and dashboards with the help of Power BI and other reporting tools.
• Understands business requirements to set functional specifications for reporting applications.
• Uses tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX.
• Shapes data into reporting and analytics solutions.
• Creates functional reporting.
• Demonstrates knowledge of database fundamentals such as multidimensional database design and relational database design.
• Understands business requirements in the BI context and design data models to convert raw data to meaningful insights.
• Creates dashboards and visual interactive reports using Power BI.
• Identifies KPIs with clear objectives and monitors them consistently.
• Analyzes data and presents it through reports that can help in decision-making.
• Converts business requirements into technical specifications and decides the timeline to accomplish tasks.
• Designs, develops, and deploys Power BI scripts and performs efficient detailed analysis.
• Performs SQL querying for best results.
• Makes technical changes to existing BI systems in order to enhance their working.

Basic Qualifications:

• Power BI developers should have skills in business intelligence, data science, and data analytics with prior knowledge in data integration, data modeling, data warehousing, and presentation concepts.
• BI tools: Skills in BI tools and BI systems, such as Power BI, SAP, Tableau, etc., creating data-rich dashboards, implementing Row-level Security (RLS) in Power BI, writing DAX expressions, developing custom BI products with scripting and programming languages such as R, Python, etc.
• Experience in data-specific roles: A minimum experience of two or three years working with BI tools or any data-specific role with a sound knowledge of database management, data modeling, business intelligence, SQL querying, data warehousing, and online analytical processing (OLAP.)
• Microsoft BI stack: In-depth understanding and experience with Microsoft BI stacks such as Power Pivot, SSIS, SSRS, and SSAS.
• Data analytics: The ability to drill down data and visualize it in the best possible way through charts, reports, or dashboards.
• Software development skills: Understanding of software development architecture as well as technical aspects.

Required Experience

• BS or MS in computer science or information system along with work experience in a related field.
• Over five years of experience in data preparation, data gateway, and data warehousing projects
• Over five years of experience working with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, and SSIS
• Three to four years of experience with a self-service tool such as Power BI or Tableau
• Understanding of JavaScript, CSS, SQL, and other JavaScript libraries