Business Intelligence Developer (Fabric)

ICF•Reston, VA

2d•$74,090 - $125,954•Remote

About The Position

We are seeking a Business Intelligence (BI) Developer with a passion for collaboration and creating impactful data reporting solutions. In this role, you will work closely with a varied range of business owners to support their fast-evolving needs, delivering timely and insightful analytics while expertly juggling multiple priorities. You will have the opportunity to tap into our team’s established best practices and proven development methodologies to streamline your efforts and ensure high-quality results. The team’s Data Analysts will provide initial requirements, but your insights and feedback will help evolve both the technical solution and the overall development process. Additionally, your expertise will be invaluable in continuing to modernize our team’s capabilities, as you provide architectural guidance for cloud-based solutions using industry-leading development and security practices. By applying your knowledge, you will help us efficiently design and deploy scalable analytics solutions structured to meet not only current client needs but also the efficient integration of new features and/or data sources to meet future client needs.

Requirements

Bachelor's degree in computer science, IT, Data, Science, Math or related fields. Applicants can substitute one year of related experience for one year of education.
2+ years with Fabric, Azure Databricks, or an equivalent ETL tool.
2+ years of experience working with SQL Server (e.g., query tuning, writing procedures/functions, building views).
2+ years of experience in SQL querying and scripting, with experience optimizing complex queries for performance and scalability.
2+ years of experience working with BI tools (e.g., Power BI/Tableau).
Must be able to pass a Motor Vehicle Record (MVR) check and Background Checks including Drug Screenings.
Permanent work authorization in the U.S. (ICF is unable to provide employment visa sponsorship).

Nice To Haves

Experience in rapidly maintaining, supporting, and producing regular reporting deliverables for a variety of audiences.
SSRS highly preferred.
Exposure to the utility, energy, and/or energy efficiency sectors.
Strong understanding of database structures, normalization, and data modeling, including how to streamline and automate repetitive tasks.
Experience modernizing from legacy BI systems into cloud-based applications/platforms, including creating technical documentation and architectural diagrams.
Experience using Fabric, Azure, Python, PySpark, Hadoop.

Responsibilities

Provide feedback on requirements and documentation from Data Analysts, suggesting alternative designs/solutions when appropriate.
Build data lakes, optimize ETL pipelines, and manage databases with SQL to provide actionable customer insights.
Deliver work on client specified timeframes (e.g., weekly, monthly, quarterly) and provide quick turnaround support, especially when creating ad hoc tools.
Help maintain data integrity across a wide variety of energy efficiency programs.
Troubleshoot data quality issues and communicate their impacts.
Support ongoing custom report maintenance.