Microsoft Power BI Developer
Summary/Objective
Avantive is looking for a strong Microsoft Power BI Developer/Architect who will be responsible for: Architecting, designing, and developing Business Intelligence (BI) solutions with Microsoft Power BI to meet new and existing business demands and ensuring integrity of design through to implementation.
Essential Duties and Responsibilities
- Architecting, designing and developing Business Intelligence (BI) solutions with Microsoft Power BI to meet new and existing business demands and ensuring integrity of design through to implementation.
- Implementing standards and best practices for the effective and efficient delivery of enterprise BI, including operational reporting, dash boarding, and business analytics across the spectrum of descriptive to prescriptive
- Serving as expert technical resource to collaborate on components required to meet business objectives.
- Assisting in development of BI roadmap at enterprise-wide and business area level.
- Having strong analytical and interpretive skills to recognize and comprehend complex issues, process changes, and industry dynamics affecting the data being analyzed and visualized
Job requirements and qualifications:
- Problem analysis & solution development with exceptional analytical ability
- Excellent knowledge of SQL – Code design, development, and Testing for MS SQL Server
- Report Generation, Analysis & Documentation
- Designing ETL packages, databases and ensuring their stability, reliability, and performance
- Proficiency with SQL and hands on experience in procedures, function, and performance tuning.
- Knowledge of programming discipline, design methods, and documentation techniques
- Knowledge of best practices when dealing with relational database.
- Capable of troubleshooting common database issues
- Understanding of potential blocking, deadlocking and write code to avoid those situations
- Understanding of security issues such as SQL injection while writing code
- Knowledge of programming discipline, design methods, and documentation techniques
- Experience in ETL development
- Expert knowledge of SSIS and SSRS
- Working experience of Database administration will be given preferences.
- Bachelor’s degree or equivalent combination of training/certifications and experience.
Job Responsibilities/Availability
- 7-10 years in BI/DW and Data Visualization design, development, and implementation.
- Exposure on SQL DB will be added advantage.
- Expert knowledge working directly with Microsoft Power BI and Azure.
- Expert knowledge of MS-Excel and tools working with large data se
- Exceptional analytical ability
- Good working knowledge of MS SQL, ETL tool etc.
- Experience in optimizing Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability, and standardization.
- Exposure with other Data Visualization and BI tools (Tableau, Qlik, SAP BOBJ, Cognos, MSTR) and Microsoft Reporting tools SSRS & SSAS
- Experience in architecting/developing BI reporting from multiple database platforms, including SQL Server
- Expertise in working closely with business and IT stakeholders to define problems and design data visualization solutions in a team environment.
- Experience with Azure, AWS or other cloud providers
- Provide guidance to other team members regarding BI reporting best/standard practices
- Expert knowledge of Key Performance Indicators (KPIs), data structures, hierarchies, business rule complexities
- Data visualization expertise, ability to tell a clear story using the most relevant data attributes
- Effective presenter who can deliver solution in a way that makes sense for requestor and addresses their primary needs
- Ability to document a clear set of requirements that can be interpreted by both business partners and data engineering
- Knowledge of the System Development Life Cycle, Agile/SCRUM methodologies
- Results-driven with the ability to take initiatives, handle multiple tasks and shifting priorities and meet deadlines.
- Familiar with Higher Education business domain preferred
- BI reporting from SQL data cube & Dynamics GP preferred.
- Power BI Exam Certification – preferred.
Job Type:Full Time
Academic: Bachelor’s degree or equivalent
For any direct assistance you can also connect with us on hrnoida@avantivesolutions.com
