PowerBI Developer

Coda Search│Staffing; Toledo (OH); On-site; USD 65,000 - 95,000; Full time

Job summary

Coda Search│Staffing is seeking a dedicated Power BI Reporting Specialist to design, develop, and maintain dynamic Power BI reports and dashboards for various stakeholders. The role emphasizes advanced features like drill-downs, custom visuals, and data interactivity to drive informed decisions.

The ideal candidate will have a minimum of 3 years of Power BI experience, strong SQL and DAX skills, and a solid foundation in data modeling and ETL.

Qualifications

• Bachelor's degree in CS/IS/Analytics or related field.
• At least 3 years of Power BI experience in a professional setting.
• Proven track record of complex Power BI reports and dashboards.
• Strong understanding of Power BI Desktop, Service, and Mobile, plus Power Query Editor, data modeling and DAX.
• Mastering DAX for measures and optimized data models.
• Solid SQL for querying databases and large datasets; efficient queries and joins.
• Knowledge of data modeling, relationships, hierarchies, normalization, and ETL processes.

Responsibilities

• Design, develop, and maintain Power BI reports and dashboards.
• Utilize drill-downs, custom visuals, and data interactivity for insights.
• Collaborate with stakeholders to gather requirements and ensure report needs are met.
• Perform data analysis and provide actionable insights for decision making.
• Maintain data accuracy and integrity across reports and dashboards.
• Keep reports up-to-date with latest Power BI features and best practices.
• Create and maintain documentation and user guides for reports.

Skills

Power BI

DAX

SQL

ETL

Data modeling

Visualization

Performance optimization

Python

R

Education

Bachelor's degree in Computer Science, Information Systems, Business Analytics, or related field

Tools

Power BI Desktop

Power BI Service

Power BI Mobile

Job description

SUMMARY

We are seeking a dedicated and skilled Power BI Reporting Specialist to join our team. The ideal candidate will focus exclusively on creating comprehensive and dynamic Power BI reports. These reports must fully leverage the capabilities of Power BI, including drill-down features, graphics, and other advanced tools.

KEY RESPONSIBILITIES

• Design, develop, and maintain Power BI reports and dashboards.
• Ensure that all reports are visually appealing, user-friendly, and utilize advanced Power BI features such as drill-down, custom visuals, and data interactivity.
• Collaborate with stakeholders to gather requirements and ensure that the reports meet their specific needs.
• Perform data analysis and provide insights to improve decision-making processes.
• Maintain data accuracy and integrity across all reports and dashboards.
• Keep up to date with the latest Power BI features and best practices to continually improve report functionality and performance.
• Create and maintain documentation related to report development and user guides to support users in utilizing the reports effectively.

OTHER DUTIES

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of this employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

MINIMUM REQUIREMENTS

• Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
• Minimum of 3 years of experience working with Power BI in a professional setting.
• Proven track record of creating complex and dynamic Power BI reports and dashboards.
• Expertise in Power BI: Strong understanding of Power BI Desktop, Power BI Service, and Power BI Mobile. Familiarity with the Power Query Editor, data modeling, and DAX (Data Analysis Expressions) is essential.
• Data Analysis Expressions (DAX): Mastering DAX for creating complex measures, calculated columns, and optimizing data models is crucial.
• SQL (Structured Query Language): Solid grasp of SQL for querying databases, extracting relevant data, and integrating it into Power BI. Ability to write efficient queries and joins to work with large datasets.
• Data Modeling: Knowledge of data modeling principles, including relationships, hierarchies, and normalization, to organize and structure data for accurate reporting and analysis.
• ETL (Extract, Transform, Load) Processes: Familiarity with ETL processes for importing, cleaning, and transforming data from various sources
• Visualization Best Practices: Keen eye for design and understanding of visualization best practices to create intuitive and impactful reports.
• Performance Optimization: Skills in optimizing the performance of Power BI reports and dashboards, including techniques like query folding, reducing data load times, and using performance analyzer tools within Power BI.

Preferred but not Required:

• Scripting Languages: Knowledge of programming languages like Python or R for advanced data manipulation, statistical analysis, and integrating machine learning models into Power BI reports Beneficial
• Understanding of APIs and Data Sources: Familiarity with APIs and connecting Power BI to various data sources (such as databases, cloud services, and web APIs) for creating dynamic and real-time dashboards Beneficial

This role is onsite M-F. Relocation available