BI Report Developer

Position: BI Developer Location: REMOTE – but must live in PST / MST / CST Duration: 6 month contract, possible extensions Must Haves: • 3+ years of experience as a report writer / BI developer • Experience developing Power BI reports and dashboards from scratch • Experience troubleshooting and maintaining SSRS reports • Hands-on experience with Power BI data connectivity (connecting to various data sources) • Proficiency with Power BI Advanced Editor (M code / Power Query transformations) • Experience writing DAX (Data Analysis Expressions) for calculated columns, measures, and advanced analytics • Strong experience working with large-scale SQL datasets (millions of rows), including performance optimization and efficient data handling without direct database access • Ability to work with data sources and staging environments to model and transform data for reporting purposes • Experience working with Sharepoint as a data source Plusses: • Government experience • Experience working with permit data • Experience training / mentoring other employees on Power BI Day-to-Day Responsibilities: Power BI Responsibilities • Build and maintain Power BI dashboards and reports based on business needs • Connect to various data sources using Power BI’s data connectivity tools • Use Power BI Advanced Editor (M code) for complex data transformations • Ensure data accuracy and integrity in Power BI reports • Collaborate with stakeholders to gather reporting requirements and deliver insights • Provide support and troubleshooting for Power BI-related issues SSRS Responsibilities • Update and maintain existing SSRS reports to ensure accuracy and relevance • Run SQL queries to gather data for report generation • Modify SQL scripts to meet specific reporting needs • Troubleshoot and resolve SSRS-related issues • Document report development processes and maintain detailed records of client requirements Collaboration & Communication • Work closely with the environmental planning group to develop reports for environmental services • Collaborate with a small team of three, including one senior member • Communicate regularly with clients to understand reporting needs and provide updates Compensation: $45-51hr Exact compensation may vary based on several factors, including skills, experience, and education. Employees in this role will enjoy a comprehensive benefits package starting on day one of employment, including options for medical, dental, and vision insurance. Eligibility to enroll in the 401(k) retirement plan begins after 90 days of employment. Additionally, employees in this role will have access to paid sick leave and other paid time off benefits as required under the applicable law of the worksite location.