ICF is seeking a Business Intelligence (BI) Developer to support fast-evolving business needs by delivering timely and insightful data reporting solutions, while also modernizing the team's capabilities with cloud-based solutions and industry-leading practices.
Requirements
- 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).
- 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
- You will be building data lakes, optimizing ETL pipelines, plus managing databases with SQL, all to provide actionable customer insights.
- Your work will be delivered on client specified timeframes (e.g., weekly, monthly, quarterly) but can also be quick turnaround support, especially when creating ad hoc tools.
- Your daily tasks will be highly varied and could include helping maintain data integrity across a wide variety of energy efficiency programs, troubleshooting data quality issues and communicating their impacts, supporting ongoing custom report maintenance, etc.
- providing architectural guidance for cloud-based solutions using industry-leading development and security practices.
- 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.
- Data analysts will share requirements and documentation so the BI Developer can provide feedback, suggesting alternative designs/solutions when appropriate.
Other
- passion for collaboration and creating impactful data reporting solutions
- tap into our team’s established best practices and proven development methodologies
- your insights and feedback will help evolve both the technical solution and the overall development process.
- Must be able to pass a Motor Vehicle Record (MVR) check and Background Check including a Drug Screening
- Experience in rapidly maintaining, supporting, and producing regular reporting deliverables for a variety of audiences.
