ESSENTIAL JOB FUNCTIONS
Designs, develops, and maintains enterprise BI solutions. Utilizes Business Intelligence technology to meet operational and business needs through modern reporting solutions. Uses an engineering-driven approach: automate, test, use version control, optimize performance, measure outcomes.
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.
- 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.
-
Extend existing datasets to generate data for BI projects.
- 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.
-
Develop high quality visuals using best practices.
- Other duties as assigned.
PHYSICAL REQUIREMENTS
- Job may require extended sitting or standing, use of standard office equipment.
- Job requires the ability to use vision, adjust focus and work on a standard computer screen.
- Use of audio-visual equipment is required.
OTHER SKILLS/ABILITIES
-
Proficient in SQL: Write correct, well-structured queries following team style guides
- Proficient in Power BI: Understand core concepts including data modeling, Power Query, and DAX fundamentals
- Familiarity with dbt: Able to extend existing data models and follow established patterns
- Experience designing and communicating KPIs, including trade-offs between measurement approaches
- Analytical thinking: Consider costs, benefits, risks, and trade-offs when