Power BI Developer
A successful candidate will be a key member of the Commercial Excellence team, who will combine strong technical skills with business acumen and effective communication skills to bring complex data-driven solutions to life. ▪ The role requires an individual who has built end-to-end BI solutions and is highly motivated to take the responsibility for BI solutions from conception through to successful delivery. ▪ The BI expert will engage with multiple stakeholders within the organization to collect, organize, analyze and disseminate significant amounts of information with unparalleled attention to detail and accuracy. ▪ A natural self-starter, you have a passion for using data to drive business decisions, are comfortable with writing SQL queries, data mining and visualization techniques, and are at home partnering with end users to deliver solutions. ▪ You will provide us with crucial insight into how we are performing as an organization, and if we are on track with our strategic goals.
Responsible for designing, developing, and deploying Business Analytics Dashboards using Microsoft BI technologies including SQL Server, Power BI, Excel etc. ▪ Analyze external data sources like Salesforce, Pendo, Intacct to integrate with existing datasets and relate a comprehensive BI story. ▪ Build compelling, interactive and actionable reporting on top of structured data models that helps in deriving meaningful business insights from large, complex datasets. ▪ Supporting the full BI lifecycle from requirements analysis through design & development, and through release and support/maintenance phases ▪ Gather requirements and design reports/custom sales analysis tools for the Commercial Operations, Marketing & Sales teams. ▪ Some of the reports that will be required but not limited to this set are: ▪ Daily/weekly/monthly performance reports for key performance indicators and provide analytics on them. ▪ Sales reports for monthly/quarterly/annual forecasting for area wise Business Reviews. ▪ Gather, publish & maintain information related to historical, current and future performance. ▪ Compile and analyze data on historical sales and trends to forecast future trends. ▪ Collaborate on identified ad hoc business problem-solving requests. ▪ Train team members/ users on Power BI tool, dashboards and reports, as required by Commercial Excellence team.
Four-year degree in Business, Accounting or Finance. Advanced degree preferred. ▪ 5+ years of combined experience in business, accounting, or finance. ▪ Experience with Data Analysis and Visualization of Power BI Dashboards ▪ Experience with data integration of Power BI with Salesforce.com, Oracle DBs, SQL Server, and Excel. Technical Skills: ▪ Mandatory: Power BI Advanced capabilities, Salesforce.com, Advanced Excel, SQL queries knowledge ▪ Additional Preferred: Azure Data Lake, Python, Microsoft Office Tool
DealerSocket is a leading provider of software for the automotive industry. Our mission is to drive the future of automotive, by simplifying the experience for its customers and partners with a suite of seamlessly integrated products. DealerSocket’s suite of products includes advanced Customer Relationship Management (CRM), innovative Digital Marketing and Websites, robust Vehicle Inventory Management, insightful Analytics Reporting, and solutions to streamline dealer operations such as Desking, Credit Reporting, Compliance, and a Dealer Management System (DMS) for dealers of all sizes. To put it simply: we help dealers sell and service vehicles more profitably, while improving their customers’ experience. The DealerSocket Team is more than 1,000 employees strong, serving nearly 8,000 dealerships. Visit careers.dealersocket.com to learn more about how you can join our winning team!