Business Intelligence Developer (Fabric)

Other Jobs To Apply

No other job posts for this day.

<p>Description</p><p><b>Business Intelligence (BI) Developer</b> </p><div><p><b>Growth, Engagements and Insight; IT and Product Development</b>  <br><b>Location: Nationwide US (Remote - Home Office) </b> </p><p></p><p><b>Please read before applying:</b> Due to the high volume of applications, we kindly ask that candidates list their specific experience with a minimum of 2 years with Fabric, Azure Databricks, or an equivalent ETL tool. Please be advised Microsoft Fabric experience is strongly preferred. At this time, ICF is unable to provide employment visa sponsorship for this position. Candidates must have permanent work authorization in the U.S.</p><p></p><p><b>Ready to make a difference?</b>  </p><p>We’re seeking a Business Intelligence <b>(BI) Developer</b> with a <b>passion for collaboration and creating impactful data reporting solutions</b>. 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. </p><p>  </p><p>You’ll have the opportunity to <b>tap into our team’s established best practices and proven development methodologies</b> to streamline your efforts and ensure high-quality results.  The team’s Data Analysts will provide initial requirements, but <b>your insights and feedback</b> will help evolve both the technical solution and the overall development process.  Additionally, <b>your expertise will be invaluable in continuing to modernize our team’s capabilities</b>, 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 meet not only <i>current</i> client needs but also the efficient integration of new features and/or data sources to meet <i>future</i> client needs. </p><p></p><p><b>Why you will love working here:</b>   </p><ul><li><p><b>Quality of life: </b>Flexible workplace arrangements, work-life balance<b> </b> </p></li></ul><ul><li><p><b>Investment in the community: </b>Donation matching, volunteer opportunities  </p></li></ul><ul><li><p><b>Investment in you: </b>Tuition reimbursement, access to professional development resources, 401k matching, Employee Stock Purchase Plan  </p></li></ul><ul><li><p><b>And many, many more </b><i>(Ask your recruiter for more details!)</i><b> </b> </p></li></ul><p></p><p><b>What you will be doing:</b>  </p><ul><li><p>Data analysts will share requirements and documentation so the BI Developer can provide feedback, suggesting alternative designs/solutions when appropriate. </p></li></ul><ul><li><p>You will be building data lakes, optimizing ETL pipelines, plus managing databases with SQL, all to provide actionable customer insights. </p></li></ul><ul><li><p>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. </p></li></ul><ul><li><p>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. </p></li></ul><p>  </p><p><b>What we need you to have (minimum qualifications): </b>   </p><ul><li><p>Bachelor's degree in computer science, IT, Data, Science, Math or related fields. *<i>Applicants can substitute one year of related experience for one year of education. </i></p></li></ul><ul><li><p>2+ years with Fabric, Azure Databricks, or an equivalent ETL tool.</p></li></ul><ul><li><p>2+ years of experience working with SQL Server (e.g., query tuning, writing procedures/functions, building views).</p></li></ul><ul><li><p>2+ years of experience in SQL querying and scripting, with experience optimizing complex queries for performance and scalability. </p></li></ul><ul><li><p>2+ years of experience working with BI tools (e.g., Power BI/Tableau). </p></li></ul><ul><li><p>Must be able to pass a Motor Vehicle Record (MVR) check and Background Checks including Drug Screenings.</p></li></ul><p></p><p><b>What we would like you to have:</b>  </p><ul><li><p>Experience in rapidly maintaining, supporting, and producing regular reporting deliverables for a variety of audiences. SSRS highly preferred.</p></li></ul><ul><li><p>Exposure to the utility, energy, and/or energy efficiency sectors. </p></li></ul><ul><li><p>Strong understanding of database structures, normalization, and data modeling, including how to streamline and automate repetitive tasks. </p></li></ul><ul><li><p>Experience modernizing from legacy BI systems into cloud-based applications/platforms, including creating technical documentation and architectural diagrams. </p></li></ul><ul><li><p>Experience using Fabric, Azure, Python, PySpark, Hadoop. </p></li></ul></div><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:left"><u><b>Working at ICF</b></u></p>ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.<p style="text-align:inherit"></p><p style="text-align:inherit"></p><div><p><span><span>We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer</span><span>.</span><span><span> </span></span><span>Together, our employees are empowered to share their<span> </span></span><span>expertise</span><span><span> </span>and collaborate with others to achieve personal and professional goals. For more information, please read our </span></span><a href="https://www.icf.com/legal/equal-employment-opportunity" target="_blank"><u><span>EEO</span></u></a><span><span><span> </span>policy.</span></span></p><p></p><p><span>We will consider for employment qualified applicants with arrest and conviction records.</span></p><p><span> </span></p><p><span><span>Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with<span> </span></span><span>sincerely held</span><span><span> </span>religious beliefs, in all phases of the application and employment process. To request<span> </span></span><span>an accommodation,</span><span><span> </span>please email </span></span><a href="mailto:Candidateaccommodation@icf.com" target="_blank"><u><span><span><span><span><span><span><span><span><span><span>Candidateaccommodation@icf.com</span></span></span></span></span></span></span></span></span></span></u></a><span><span> and we will be happy to<span> </span></span><span>assist</span><span>. All information you provide will be kept confidential and will be used only to the extent<span> </span></span><span>required</span><span><span> </span>to provide needed reasonable accommodations. </span></span><span> </span></p></div><div><p></p></div><div><p><span><span>Read more about </span></span><a href="https://www.eeoc.gov/sites/default/files/2022-10/EEOC_KnowYourRights_screen_reader_10_20.pdf" target="_blank"><u><span>workplace discrimination righ</span><span>t</span><span>s</span></u></a><span><span><span> </span>or our benefit offerings which are included in the </span></span><a href="https://www.icf.com/legal/equal-employment-opportunity" target="_blank"><u><span>Transparency in (Benefits) Coverage</span><span><span> </span></span><span>Act.</span></u></a><span> </span></p></div><p></p><p style="text-align:inherit"> </p><p style="text-align:inherit"></p><div><b><u>Candidate AI Usage Policy</u></b></div><div><div><p style="text-align:left"><span><span>At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or<span> </span></span><span>assist</span><span><span> </span>with responses during interviews (whether in-person or virtual) is not<span> </span></span><span>permitted</span><span>. This policy is in place to<span> </span></span><span>maintain</span><span><span> </span>the integrity and authenticity of the interview process. </span></span><span> </span></p><p style="text-align:inherit"></p></div><div><p style="text-align:left"><span><span>However, we understand that some candidates may require accommodation</span><span><span> that involves the use of AI. </span>If<span> </span></span><span>such an</span><span><span> </span>accommodation is needed, candidates are instructed to contact us in advance at </span></span><a target="_blank" href="mailto:candidateaccommodation@icf.com"><u><span><span><span><span><span><span><span><span><span><span><span><span><span><span><span><span><span><span><span><span class="WIO0">candidateaccommodation@icf.com</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></u></a><span><span>. We<span> </span></span><span>are dedicated to providing</span><span><span> </span>the necessary support to ensure that all candidates have an equal opportunity to succeed.</span></span> <span><span> </span></span></p></div></div><p style="text-align:inherit"><br> </p><p style="text-align:left"><b>Pay Range</b><span> - There are multiple factors that are considered in determining final </span><span>pay</span><span> for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. </span></p><p style="text-align:inherit"></p><p style="text-align:left"><span>The pay range for this position </span><span>based on full-time employment </span><span>is</span>:</p>$74,090.00 - $125,954.00<p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p>Nationwide Remote Office (US99)

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...