Business Intelligence Developer

• Build, maintain, and automate dashboards, reports, and data models using Power BI and other visualization tools.
• Design, build, and maintain data ETL pipelines from sources such as SQL databases, SharePoint, and Excel.
• Optimize and refine existing SQL queries and dashboards while maintaining accurate documentation for client dashboards and associated SQL queries.
• Collaborate with clients and technical resources to understand and integrate business requirements into effective data visualizations.
• Translate complex data findings into clear, digestible insights for stakeholders to support data-driven decision-making.
• Ensure data accuracy, consistency, and integrity across reports and dashboards.

• At least 4 years of experience working with large datasets in a Data Visualization tool like Power BI, Tableau, Qlik.
• Advanced understanding of SQL including query optimization, common table expressions (CTEs), and complex joins for deep-dive analysis
• Advanced proficiency in Excel for standard data analysis tasks (pivot tables, VLOOKUP, complex formulas)
• Excellent communication skills with the ability to gather requirements, present solutions, and translate complex data findings into clear insights for non-technical stakeholders.
• Bachelor’s degree is required, with major in Data Science, Computer Science, Statistics, or a related field preferred
• Be a U.S. citizen able to pass a background investigation by the client agency. DHS clearance with CBP or ICE preferred.
• Experience developing in Python (Pandas) for data analysis is preferred. 
• Experience developing PowerApps and Power Automate solutions is preferred.

Benefits:
• 401(k)
• 401(k) contribution
• Medical insurance
• Dental insurance
• Vision insurance
• Life & Disability Insurance
• Flexible Spending Account
• Paid time off
• Professional development 
• Employee assistance program
• Work-life balance