BI Manager

ABOUT LAFAYETTE SOFTWARE

Most of what we build is back-office software for property managers, including lease tracking, work orders and tenant payments. The product is a mobile app plus a React web dashboard, with a Python and PostgreSQL backend on AWS. Founded in 2003, we now have 110 employees.

THE ROLE

You'll work with department heads to define KPIs and build reporting they can trust without calling us first. Lafayette Software is standardizing on Power BI. This hire will rebuild old Excel and SSRS reports and retire the ones nobody opens. This is an in-person role at our Lafayette location.

DAY TO DAY

• Gather requirements from business users and turn them into report mockups
• Design star schemas with fact and dimension tables in the warehouse
• Train business users on self-service reporting
• Write stored procedures, views and T-SQL for reporting datasets
• Document data definitions, measures and report owners

YOU HAVE

• 8-10 years of BI or reporting development experience
• Strong T-SQL or equivalent SQL skills
• Good visual sense for dashboards: layout, color, labeling
• Ability to turn loosely worded business requests into specific report requirements
• Experience with ETL tools such as SSIS, Azure Data Factory or Informatica
• Bachelor's degree in information systems, computer science, finance or equivalent experience

ALSO HELPFUL

• Looker and LookML

WHY WORK WITH US

• Health insurance
• 401(k) with company match
• Three weeks of PTO to start
• Vision insurance
• Referral program
• Life insurance
• Professional development budget

If this sounds like a fit, apply with a resume. A cover letter is optional.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Lafayette Software.