Business Intelligence Engineer II

Working in three main modes on our Business Intelligence team:

• Problem-solving and solution design
• Act as part private investigator, part anthropologist while working to map real-world activity and processes to systems and data.
• Act as an internal consultant while working collaboratively with business partners to design the best way to make people's decisions better and their lives easier.
• As a Business Intelligence Engineer II, provide input on larger-scale roadmaps and cross-domain data.
• Data modeling
• Use dbt, a SQL-based framework for defining data transformations, to build and extend core data models in our Snowflake data warehouse.
• Develop the backend models for Power BI datasets, using DAX and the full range of tooling available in the Power BI service.
• As a Business Intelligence Engineer II, apply domain knowledge to expand schemas and add larger DAG segments.
• Visualization and product development
• Make apps and dashboards in Power BI, targeting hundreds to thousands of users globally.
• Have the freedom to explore other solutions as needed, even if they're not part of our core stack.
• As a Business Intelligence Engineer II, develop high quality visuals with minimal coaching.

• Use an engineering-driven approach: automate, test, use version control, optimize performance, measure outcomes.
• Other duties as assigned.

PHYSICAL REQUIREMENTS

• Job requires the ability to use vision, adjust focus and work on a standard computer screen.
• Job may require extended sitting or standing, use of standard office equipment.
• Job will require presence on-site at the assigned work location.

[The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.]

OTHER SKILLS AND ABILITIES

• 2+ years using SQL—you should be fluent at reading and writing SQL, able to develop straightforward solutions without a lot of comments on code structure & approach.
• 2+ years building dashboards or with visualization & designing user experiences.
• Experience designing KPIs: you understand and can communicate the impacts of selecting one metric over another.
• Experience with dbt
• Deep knowledge of SQL
• 2+ years of experience with Power BI
• Experience with Python or R

EDUCATION AND EXPERIENCE

• Quantitative bachelors’ degree preferred but not required.
• 4+ years of experience in a quantitative or highly technical role (data analyst/scientist, BI engineer/developer, data or software engineer, etc)

CERTIFICATION AND LICENSES

Professional certification may be required in some areas.