Business Intelligence Developer

At a Glance:

Statement of Interest: Yes

Contact: Wayne Robertson

The Opportunity:

The Business Intelligence Developer will work with the BI Architects, Data Engineers, and other BI Developers on the team in designing and developing enterprise data models in our data warehouse used by our Private Client Group business. Our team extracts data from operational systems to our Azure Data Lake/Synapse environment, builds dimension and fact tables, and creates tabular models for use in Power BI. The scope of responsibilities will include eliciting requirements from various stakeholders, modeling the data into dimension and fact tables, implementation of tabular models, including DAX calculated measures and columns and securing the model through RBAC and roles. Responsible for operational support, incident investigation, and problem management, including logging, instrumentation, performance analysis, cross team collaboration, and process improvements. You will collaborate with the business on data visualization and report generation to meet reporting needs. You will report to the Business Intelligence Team Leader.

The Day-to-Day:

• Based on evaluation, recommend, implement, maintain, support, and improve business intelligence solutions, including designing, coding, testing, and deployment of datasets, data models, dashboards, and reports
• Independently manage product issues such as defects, patches, and upgrades, including deployment, testing, and post-production validation
• Define, guide, and deliver medium-to-large business intelligence projects from beginning to end, with guidance from BI Architects
• Test business intelligence solutions, including creating and implementing test plans/cases/scripts
• Provide operational support and incident management for assigned systems, including proactively update internal clients and relevant parties on status changes and issues encountered
• Author and maintain accurate and up-to-date documentation for processes, procedures, and dashboard/report designs

Your Qualifications:

• 5+ years' experience with business intelligence methods and tools such as Power BI
• Advanced knowledge in programming languages such as SQL, R, DAX/MDX, or Python
• Experience with Azure Synapse, or equivalent cloud database technology
• Strong experience with tabular model design for large models in Analysis Services/Power BI
• Bachelor's degree or equivalent combination of education/experience

Compensation:

• $85,000 - $135,000 base salary per year in the state of WA – New hires should expect to start at the lower end of the range depending on experience
• Eligible for a discretionary bonus based on firm and individual performance

We will conduct a preliminary screen of applicants based on qualifications, performance and manager feedback. Those who meet the hiring manager’s requirements will be moved forward in the process by participating in an interview. If you’d like to know more about the role, feel free to get in touch with Wayne Robertson.

FISHER INVESTMENTS IS AN EQUAL OPPORTUNITY EMPLOYER