Business Intelligence (BI) Developer Location: Nationwide US (Remote - Home Office) We're seeking a Business Intelligence (BI) Developer with a passion 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 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'll 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.
What you will be doing: - Data analysts will share requirements and documentation so the BI Developer can provide feedback, suggesting alternative designs/solutions when appropriate.
- 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.
- You may also build data lakes, optimize ETL pipelines, and manage databases with SQL, all to provide actionable customer insights.
What we need you to have (minimum qualifications): - 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) and SQL Server Reporting Services (SSRS).
- 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).
- Must be able to pass a Background Check including a Drug Screening.
What we would like you to have: - Experience in rapidly maintaining, supporting, and producing regular reporting deliverables for a variety of audiences.
- 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, DataBricks.
Bot and Third-Party ApplicationsPlease note that this application must be submitted directly by the applicant for consideration. Failure to do so may result in the application being excluded for consideration. Applicants needing an accommodation for disability or religious purposes in connection with the application process should contact [redacted] for assistance.
Pay Range - There are multiple factors that are considered in determining final pay 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.
The pay range for this position based on full-time employment is:
$74,090.00 - $125,954.00
Nationwide Remote Office (US99)
