Senior Software Engineer (PowerBI)

About the position

The Senior PowerBI Developer contributes to analyze, design, develop, test reports to improve the decision-making process for the organization. Provides guidance in developing various analytical and operation dashboards, research/recommend new technologies, techniques, proof of concepts, follow best practices and standards. This role is highly visible and collaborative, providing guidance on various dashboards/reports and projects associated with the senior executive team.

Responsibilities

• Analyze business requirements into technical requirements for business reporting and dashboards.
• Design, develop and maintain reports in PowerBI.
• Develop reports with multiple data sources, complex queries, views, stored procedures, and automation.
• Provide detailed source analysis and data mappings/transformations to BI developers to implement new data sources and integrations.
• Configure all BI systems/environments to deliver BI solutions including data quality issues and defects to determine the root cause.
• Develop, implement, coordinate user testing plans in QA/UAT environments to validate BI solutions.
• Perform daily/weekly deployments from lower to higher environments, validate post deployment changes to ensure established Release Management Process followed.
• Assist development teams with analysis, design for new or existing systems.
• Play role of Subject Matter Expert for business units and provide detailed information on data availability, location, lineage, and quality.
• Provide support for incident management, track daily ticket queue, and prioritize the solutions.
• Perform peer reviews to ensure conformity to standards and quality.
• Work with other IT team members, implement new standards, new technology, and tactical solutions driving the business strategy forward.
• Adhere to full SDLC (System Development Lifecycle) process, track obsolescence/release date of new products, stay abreast of new technology.
• Responsible for implementing security on developed PowerBI dashboards in accordance with pre-established architecture.
• Responsible for maintaining existing PowerBI analytical/operational dashboards and ensure all dashboard refreshed including underline reports as per daily/weekly schedule.
• Responsible for designing and developing PowerBI reports, analytical/operational dashboards including data set ingestion and transformation, Data Modeling, Data Analysis Expressions (DAX) using appropriate report templates depicting status of key performance indicators (KPIs) and other important business metrics for an organization to make data driven decisions.
• Collaborate proactively with functional users, analysts, and other team members to gather business requirements for reporting.
• Understand business requirements, determine implementation strategy, and translate into reports that conform to best practices and standards.
• Document new reports and update the dashboard reports in IT Handbook.
• Troubleshoot and resolve technical/performance query issues, optimize report performance within defined SLA.

Requirements

• Bachelor's degree in engineering/computer science or related field.
• Overall, 8-10 years of SQL development experience on Microsoft products.
• 4 - 6 years of experience in PowerBI report design, development, testing, implementations of data, reports and dashboards using BI tools.
• Demonstrates ability to motivate and lead others and able to make decisions in a rapidly growing environment.
• Exposure to Azure and Machine Learning (ML) is a huge plus.
• Experience with design patterns in the creation of architectural and database design deliverables.
• Experience with Microsoft Business Intelligence Suite (TSQL, SSIS, SSRS), exemplary general IT knowledge (applications development, deployment, testing, operations, documentation, standards, best practices, security, hardware etc.).
• Demonstrated ability to interface effectively and collaborate with internal teams and management to develop solutions.
• Excellent time management, communication, presentation, and documentation skills.
• Knowledge of full system development Life Cycle process.

Benefits

• 401k
• Dental Insurance
• Disability Insurance
• Health Insurance
• Life Insurance
• Paid Time off
• Vision Insurance