Description:
• Write requirements and documentation.
• Experience building Reports/Dashboards using Agile methodologies.
• Understanding of Microsoft Power BI desktop and other popular BI tools
• Hands-on experience in data preparation, data gateway and data warehousing projects
• Experience in connecting to data sources, importing data, and transforming data for Business Intelligence
• Proficient in both Power BI languages - M and DAX
• Experience in developing user-friendly and insightful visual reports, dashboards and KPI scorecards using Power BI desktop
• Develop (create new and update existing), publish, schedule reports and dashboards
• Experience in designing, implementing, and executing test cases
• Assist business users with using published reports/dashboard and performing ad hoc data analysis.
• Provide input on level of detail needed to outline report designs
• Offer best-practice recommendations for creating reports and dashboards within Power BI
• Participate in creating internal documentation.
• BSA Resource requires advanced Microsoft Excel skills.
• Must be able to create Pivot Tables and use VLOOKUP's to merge / determine variables between sheets, etc.
• Capabilities to access databases and have a strong understanding of SQL (2-3 yrs).
• Must be able to connect to datasets and build interactive reports.
Soft Skills
• Share’s information and knowledge freely, offering support and cooperation
• Anticipates problems, resistance or likely objections and takes action to resolve them.
• Interacts well on teams and can also work independently
• Executes duties in a timely, efficient manner
EDUCATION AND EXPERIENCE:
• Bachelor’s degree in computer science, information systems or a closely related field.
• 4+ years development experience with Microsoft Power BI
• 1-2 years’ experience in writing SQL (or similar)
Experience with ServiceNow (ITSM) in extracting data is desired. Will pull data from different sources together to produce metric reports for senior management.
The resource must be capable of needing minimal instruction, able to work independently, good communication skills and ability to capture reporting requirements and create reports.
Bachelor’s degree in computer science,