Power BI Specialist

Job Description:

We are hiring for a Senior Power BI Specialist to work in our Flexible Load Management (FLM) Analytics practice. As a Power BI specialist within the team, you will be responsible for creating Power BI visualization of outputs to meet project needs and to design and automate the integration of in-house model outputs into Power BI interfaces. You will part of the FLM Analytics team that is a powerhouse of analytical capabilities.  We support utilities and/or government agencies boost their FLM programs to meet the demands of the future. As part of your role, you will have an opportunity to apply your prior industry experience, gain exposure to major projects, interact with experts and clients in the field, and develop/enhance your consulting skills to complement your Power BI visualization skills.

ICF has over 50 years of experience advising utilities on a variety of areas, including integrated resource planning, distributed energy resources, utility customer programs, environmental strategies, and a host of other issues. The FLM Analytics team is a leader in US Utility DER space. Our ability to connect the implementation experience and deep domain expertise with advanced analytics, allows us to help utilities plan, design and implement best-in-class FLM programs.

Key Responsibilities

• Lead the development of internal- and external-facing Power BI dashboards and interactive visual reports
• Design and deploy Power BI scripts that aid decision making, with capabilities of performing detailed analytics built-in
• Write efficient DAX queries on-demand to customize visuals and to calculate Key Performance Indices, as per project needs
• Prepare design methodologies and project documentation
• Work with project managers to present dashboards as part of client deliverables and for marketing/business development

Basic Qualifications

• Bachelor’s degree with 3 to 5 years of project working experience on Microsoft Power BI
• Hands-on professional with thorough knowledge of scripting, data source integration and advanced visual development in Power BI
• Strong quantitative and analytical skills, including programming experience in writing DAX queries
• Strong writing and communication skills

Preferred Skills/Experience

• Exposure to data and dashboard development in the energy domain
• Strong experience working with cloud-based computing services such as Azure
• A deep understanding of, and ability to use and explain all aspects of, relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards.
• Good understanding of the processes of data quality, data cleansing and data transformation. Upload of Power BI reports to Power BI online service, implement security and audit.
• MS-Excel, R/Python, Alteyrx/Tableu

 Professional Skills

• Demonstrates trustworthiness and upholds the highest ethical standards
• Ensures that information flows effectively to others
• Identifies, collects, and analyzes the information needed to solve a problem effectively
• Clearly expresses ideas, thoughts, and concepts in writing
• Organizes written work in a manner that is clear, easy to follow, and tailored for the intended audience
• Ability to work independently and as part of a team in a fast-paced environment

Working at ICF:

Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth.

We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy.

About ICF

ICF (NASDAQ:ICFI) is a global consulting services company with over 7,000 full- and part-time employees, but we are not your typical consultants. At ICF, business analysts and policy specialists work together with digital strategists, data scientists and creatives. We combine unmatched industry expertise with cutting-edge engagement capabilities to help organizations solve their most complex challenges. Since 1969, public and private sector clients have worked with ICF to navigate change and shape the future. Learn more at icf.com.

Working at ICF

Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth.

New Delhi, India (II77)