Power Bi Developer with AWS

Role & responsibilities

Responsibilities

• Design, Develop, and maintain reports and dashboards within Power BI and Salesforce in a timely manner based on the needs of the business.
• Build and maintain Power BI data models, including relationships, calculated columns, and measures.
• Automate data refresh schedules and ensure the reports are up-to-date with the latest information.
• Work with data sources such as SQL databases, Excel, SharePoint, and other external APIs to gather, transform, and load data for reporting.
• Work tickets assigned to you via Jira through our Analytics Sprint planning process. Providing visible progress and closed-loop communication through updates on the tickets.
• Work with stakeholders to solve through requirements and achieve a clear understanding on requests.
• Managing and manipulating data and views to meet the needs of the business
• W orking backwards through metrics and reports to understand filters for the purpose of recreating, improving upon and/or consolidating them
• Help maintain our data dictionary, reporting index, and any other internal documentation used to provide visibility to our reporting stack to our internal teams
• Provide feedback to our Data and Operations teams on the states of our data and data sources for opportunities to improve data integrity or gain efficiencies in gathering data.
• Conduct training sessions or provide support to end-users on using Power BI reports effectively.
• Stay updated on Power BI updates, best practices, and new features to improve the efficiency and effectiveness of reporting processes.
• Will be working various cloud software including Salesforce, NetSuite, Hubspot and more.

Requirements

• Bachelor's degree in a relevant field (e.g., Computer Science, Mathematics, Statistics, Business Analytics).
• Familiarity with writing/reading SQL Queries and PostgreSQL Database.
• 1 year + with using AWS ETL tools, AWS Glue, AWS S3 and AWS RDS.
• At least 2- 3 year of experience building reports and dashboards in Power BI, using DAX, and PowerQuery.
• Experience 2 year of Python.
• 2 years + experience with data warehousing concepts and ETL (Extract, Transform, Load) processes.
• Experience building and delivering business metrics and key performance indicators
• Experience navigating a CRM in order to review and understand business cases for data and report requests
• Familiar with reading/updating Entity Relationship Diagrams (ERDs)
• Performs ongoing monitoring and improvements of reports and BI solutions
• Ability to work with stakeholders to understand problems, gather requirements, present rationale, and explain technical logic to the team
• Must be excellent at writing and contributing to the internal documentation and knowledge bases
• Excellent troubleshooting and research skills
• Excellent listening and communications skills, both verbal and written.
• Action-oriented, customer-focused, with effective prioritization, goal setting and time management skills.
• 1 Year + Experience in using Salesforce Reporting and Salesforce Objects
• 1 Year + Experience in using NetSuite Reporting and datasets.
• Outstanding interpersonal skills; projection of professional image and credibility; teamwork oriented and inclusive.
• Must be authorized to work in the United States
• Related Certifications is a plus
• At least 1 year of experience in IT or managed services is preferred
• Experience working at or with Managed Service Providers or MSP channel products is a big plus