Business Intelligence Developer

ICF•Reston, VA

17h•Remote

About The Position

Business Intelligence (BI) D eveloper Growth, Engagements and Insight; IT and Product Development Location: Nationwide US (Remote – Home Office) Ready to make a difference? We’re seeking a Business Intelligence ( BI ) Developer with a p assion for collaboration and creating impactful data reporting solutions . In this role, you’ll 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’ll 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 w ill 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’ll help us efficiently design and deploy scalable analytics solutions structured to m eet not only current client needs but also the efficient integration of new features and/or data sources to meet future client needs . Why you will love working here: Quality of life: Flexible workplace arrangements, work-life balance Investment in the community: Donation matching, volunteer opportunities Investment in you: Tuition reimbursement, access to professional development resources, 401k matching, Employee Stock Purchase Plan And many, many more (Ask your recruiter for more details!)

Requirements

Bachelor's degree in (Computer Science, IT, Data, Science, Math or related fields) (or applicants can substitute one year of related experience for one year of education)
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 Check including a Drug Screening

Nice To Haves

Experience in rapidly maintaining , supporting, and producing regular reporting deliverables for a variety of audiences
SSRS Highly Preffered
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

Data analysts will share requirements and documentation so the BI Developer c an provide feedback, suggesting alternative designs /solutions when appropriate
Build ing data lakes
Optimizing ETL pipelines, plus managing databases with SQL , all to provide actionable customer insights
Deliver work on client specified timeframes (e.g., weekly, monthly, quarterly) but can a lso be quick tu rnaround support, especially when creating ad hoc tools
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