Senior BI Analyst

This job is with JLL, an inclusive employer and a member of my Gwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

JLL empowers you to shape a brighter way .
Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people  and empowering them to  thrive, grow meaningful careers and to find a place where they belong.  Whether you've got deep experience in commercial real estate, skilled trades or technology, or you're looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.
Senior Business Intelligence Analyst :  Remote in the US - only
We are seeking an experienced Senior Business Intelligence Analyst to design, develop, and optimize enterprise-scale data solutions. This role combines deep technical expertise in modern data engineering with advanced analytics capabilities to drive data-driven decision making across the organization. The ideal candidate will architect robust ETL/ELT pipelines, leverage Databricks for scalable data processing, and create sophisticated Power BI solutions while implementing intelligent automation through Power Automate.
Here is some of what you'll do:
Data Pipeline Architecture & Development  Design, build, and maintain production-grade automated data pipelines extracting from APIs, databases, flat files, and third-party systems with comprehensive error handling, monitoring, alerting, and continuous performance optimization through query tuning and parallel processing.
Databricks Development & Optimization  Develop scalable data processing solutions using Databricks notebooks (PySpark, Scala, SQL) with modular workflows for incremental loads and complex transformations. Implement optimal cluster configurations, Delta Lake for ACID transactions, Unity Catalog for governance, and Job Scheduling for production orchestration.
Power BI Development & Analytics  Design enterprise Power BI solutions including interactive dashboards, paginated reports, and embedded analytics. Build optimized semantic models using DAX, implement row-level security, manage workspace governance, and establish organizational best practices.
Power Automate Cloud Flows  Build automation solutions using cloud flows (automated, instant, scheduled) that integrate with Microsoft 365, Azure services, and third-party platforms. Design approval workflows integrated with Teams and Outlook following best practices for error handling and performance.
Robotic Process Automation  Apply Power Automate Desktop for RPA scenarios to reduce manual effort and streamline business processes with maintainable, optimized solutions.
Data Transformation & Quality  Transform data according to complex business logic, enforce data quality validations, and execute multi-stage transformations while loading into target analytical environments.
Stakeholder Collaboration  Partner with business stakeholders to translate analytical requirements into technical solutions and document data architectures, pipeline designs, and technical specifications.
Team Leadership & Knowledge Sharing  Mentor junior team members and promote best practices across the BI team for all development and deployment activities.
Here is who we are looking for:
Technical Skills
ETL/ELT Development:  Proven experience designing and implementing production data pipelines with demonstrated expertise in performance optimization, error handling, and monitoring

Databricks Proficiency:  Strong hands-on experience with Databricks notebooks using PySpark, Scala, or SQL; practical knowledge of Delta Lake, Unity Catalog, cluster configuration, and job orchestration

Power BI Expertise:  Advanced skills in Power BI development including semantic modeling, DAX, report design, and workspace management

Power Automate:  Demonstrated ability to build cloud flows across automated, instant, and scheduled triggers; experience with Microsoft 365 and Azure connectors; knowledge of Power Automate Desktop for RPA implementations

Pro…