Job Description
Role: Power BI Developer
Location: Remote
Type: Contract
Job description:
- Work with department leaders to establish Key Performance Indicators and methods of dashboard that present relevant and useful data.
- Be responsible for the diagnosis and support of Power BI reporting solutions, including investigation of data issues, data validation, scalability, balancing and row level security implementation
- Design new Power BI Dashboard and SSAS cube solutions from requirements and from an understanding of organizational business needs.
- Create and deliver standards on defining, crafting, and documenting reference PBI architecture
- Develop Hierarchy SSAS model to allow advanced drill-through capabilities.
- Use SSAS, Power BI and Excel: Pivot Table, Power Query, Power Pivot, and Data Models to capture information from various sources and deliver information to the end user.
- Act as a Power BI, visualization, and dash-boarding domain expert
- Through Power BI software development activities and collective understanding of the enterprise-wide business needs, promote the use of self-service products.
- Define and document standard processes for dashboards and self-service reporting tools.
- Perform unit and integration test, participate in report validation and QA of reporting and data analytics.
- Dedicated to creating quality reports and applications and accountable for doing whatever is vital towards that end.
- Collaborate and technically mentor other developers and analysts for successful project delivery
How will you get here?
- BS/MS in Computer Science or equivalently technical disciplines; years of professional experience may be considered in lieu of degree
- 7+ years of working experience in delivering and architecting Power BI solutions.
- 4+ years if extensive experience with SSAS Tabular and DAX
- Experience with Microsoft Fabrics
- Knowledge of MDX, M Query and Power Query
- 4+ years of experience in building dashboards using Microsoft Power BI
- knowledge of T-SQL and SQL Server
- Extensive experience with SSAS tabular model security, Partition and automation process.
- Strong Analysis skill using SQL
- Expertise in using advance level calculations on the data set with experience in handling multi-million data sets
- Working knowledge of data warehouse concepts, relational database design and data modeling
- Good communication skills and should be focus on details on data analysis and mapping
- Look beyond the detailed requirements to understand what the business is trying to do / don't get lost in the details
- Develop and maintain documentation to our standards / provide feedback on standards where they can be improved
- Familiar with Cognos Analytics is preferred.
- Experience in Power BI data analytics & visualizations against Data lake and Oracle DWs
- Experience in Oracle, SQL Server or AWS Redshift, AWS S3 type databases
- Experience in Microsoft SSAS Multidimensional and SSAS Tabular Models.
- Strong analytical experience with database in writing complex queries, query optimization, debugging, user defined functions, views, indexes etc.
- Knowledge with source control systems such as Git, Bitbucket, and Jenkins build and continuous integration tools.
- Knowledge of using JIRA for Project related activities
Knowledge, Skills, Abilities:
- Highly dedicated, execution-focused, with a willingness to do "what it takes" to deliver results as you will be expected to rapidly cover a considerable amount of demands on data integration
- Critical Thinking - Think big picture. Set priorities aligned with major goals. Encourage innovation by backing good people who take thoughtful risks.
- Critical Thinking - Question conventional wisdom by identifying assumptions made that cause actions or inaction. Strive to inject independent thinking, checking biases, promotes action and decision-making.
- Communication - communicate effectively in the way reach audiences with ease, clarity, and visibility: one-to-one, small group, full staff, email, social media, and of course, listening.
- Provide organizational support for relationship to develop partnership, establish relationships, and promote collaboration to cultivate and strengthen a network for the exchange of ideas
- Problem-solving (analytical)
Job Tags
Contract work, Work experience placement, Remote job,