Job Description: Power BI Engineer

Position Overview: We are seeking a skilled Power BI Engineer with 4-8 years of experience to deliver impactful dashboards and reports using Smartsheet / SQL / SSRS. The ideal candidate will have a strong background in data modeling, visualization, and data transformation, with a focus on providing actionable insights to drive business decisions.

Key Responsibilities:

• Data Modeling: Design and optimize data models that support dynamic reports and dashboards.

• Dashboard Development: Create interactive and visually compelling dashboards in Power BI, leveraging Smartsheet data.

• Smartsheet Expertise: Utilize Smartsheet effectively to visualize and analyze data, ensuring seamless integration with Power BI.

• DAX Mastery: Utilize DAX (Data Analysis Expressions) for advanced calculations and data manipulation within Power BI.

• Data Transformation: Transform raw data into an analyzable format, ensuring data integrity and relevance.

• Data Source Connectivity: Connect to various data sources, including databases, cloud services, and APIs, to consolidate data for analysis.

• Power Query: Employ Power Query for data extraction and transformation to streamline reporting processes.

• SQL Proficiency: Write efficient SQL queries to extract and manipulate data from databases.

• SSRS Development: Design and develop reports using SQL Server Reporting Services (SSRS) to meet business reporting needs.

• Problem Solving: Apply critical thinking to address complex data challenges and optimize reporting solutions.

• Effective Communication: Collaborate with business stakeholders to gather requirements and present insights clearly and concisely.

• Continuous Learning: Stay updated on Power BI, SSRS, and industry best practices to enhance reporting capabilities.

Technical Skills:

• Proficiency in Smartsheet and its integration with Power BI.

• Advanced knowledge of DAX for complex data calculations.

• Strong skills in data transformation and preparation techniques.

• Experience with Power Query for ETL processes.

• Familiarity with SQL for querying and managing databases.

• Expertise in SSRS for creating, deploying, and managing reports.

• Understanding of data warehousing concepts and best practices.

• Experience with other BI tools (e.g., Tableau, Qlik) is a plus.

• Knowledge of data governance and data quality practices.

Behavioral Skills:

• Excellent communication and interpersonal skills, with the ability to interact effectively with clients and team members.

• Proactive attitude and strong sense of accountability for deliverables.

• Willingness to learn new tools and technologies in the BI space.

• Strong organizational skills and attention to detail.

Education:

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.

Certifications (Preferred):

• Microsoft Certified: Data Analyst Associate

• Relevant certifications in Power BI, SSRS, SQL, or data analytics.