Senior BI Analyst

JLL•Portland, OR

1d•$66,000 - $110,000•Remote

About The Position

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 Programming: Proficiency in Python, SQL, and at least one additional language (Scala, R, or similar) Cloud Platforms: Experience with Azure data services and cloud-native architectures Professional Experience 5+ years of experience in business intelligence, data engineering, or analytics roles Proven track record delivering enterprise-scale data solutions Experience working in Agile development environments Strong portfolio demonstrating technical depth across required technology stack Soft Skills Excellent analytical and problem-solving abilities with attention to detail Strong communication skills with ability to explain complex technical concepts to non-technical audiences Collaborative mindset with experience working across functional teams Self-motivated with ability to manage multiple priorities and projects simultaneously Preferred Qualifications Education & Certifications Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or related field. Azure certifications (Data Engineer Associate, Databricks certifications) and Microsoft certifications (Power BI Data Analyst, Power Platform certifications). Technical Knowledge & Best Practices Experience with version control systems (Git, Azure DevOps), CI/CD practices for BI and data engineering workflows, data governance frameworks, and metadata management. Industry Experience Experience in commercial real estate or property management industries. Shedule: Monday - Friday day shift Pay $66,000-110,000 depending on experience and location, with a 7.5% targeted bonus of the annual salary This position does not provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship. Estimated compensation for this position: 66,000.00 – 110,000.00 USD per year This range is an estimate and actual compensation may differ. Final compensation packages are determined by various considerations including but not limited to candidate qualifications, location, market conditions, and internal considerations. Location: Remote –Charlotte, NC, Chicago, IL, Milwaukee, WI, Phoenix, AZ, Portland, OR, St. Paul, MN, Tampa, FL If this job description resonates with you, we encourage you to apply, even if you don’t meet all the requirements. We’re interested in getting to know you and what you bring to the table! Personalized benefits that support personal well-being and growth: JLL recognizes the impact that the workplace can have on your wellness, so we offer a supportive culture and comprehensive benefits package that prioritizes mental, physical and emotional health. Some of these benefits may include: 401(k) plan with matching company contributions Comprehensive Medical, Dental & Vision Care Paid parental leave at 100% of salary Paid Time Off and Company Holidays Early access to earned wages through Daily Pay At JLL, we harness the power of artificial intelligence (AI) to efficiently accelerate meaningful connections between candidates and opportunities. Using AI capabilities, we analyze your application for relevant skills, experiences, and qualifications to generate valuable insights about how your unique profile aligns with the specific requirements of the role you're pursuing. JLL Privacy Notice Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely. For more information about how JLL processes your personal data, please view our Candidate Privacy Statement. For additional details please see our career site pages for each country. For candidates in the United States, please see a full copy of our Equal Employment Opportunity policy here. Jones Lang LaSalle (“JLL”) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process – including the online application and/or overall selection process – you may email us at [email protected]. This email is only to request an accommodation. Please direct any other general recruiting inquiries to our Contact Us page > I want to work for JLL. Pursuant to the Arizona Civil Rights Act, criminal convictions are not an absolute bar to employment. Pursuant to Illinois Law, applicants are not obligated to disclose sealed or expunged records of conviction or arrest. Pursuant to Columbia, SC ordinance, this position is subject to a background check for any convictions directly related to its duties and responsibilities. Only job-related convictions will be considered and will not automatically disqualify the candidate. California Residents only If you are a California resident as defined in the California Consumer Privacy Act (CCPA) please view our Supplemental Privacy Statement which describes your rights and disclosures about your personal information. If you are viewing this on a mobile device you may want to view the CCPA version on a larger device. Pursuant to the Los Angeles Fair Chance Initiative for Hiring Ordinance, JLL will consider for employment all qualified Applicants, including those with Criminal Histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. Accepting applications on an ongoing basis until candidate identified. Activate your Personal Job Alerts now and receive opportunities as soon as they are advertised. If you're a current JLL employee, please apply using the Internal Career Site At JLL, we give you the opportunity, knowledge and tools to own your success, because we value what makes each of us unique. We help our people thrive, grow meaningful careers and find a place where they belong. Together, we strive to be exceptional and shape a better world. For over 200 years, JLL (NYSE: JLL), a leading global commercial real estate and investment management company, has helped clients buy, build, occupy, manage and invest in a variety of commercial, industrial, hotel, residential and retail properties. A Fortune 500® company with operations in over 80 countries around the world, our employees bring the power of a global platform combined with local expertise. Driven by our purpose to shape the future of real estate for a better world, we help our clients, people and communities SEE A BRIGHTER WAYSM. JLL is the brand name, and a registered trademark, of Jones Lang LaSalle Incorporated. For further information, visit jll.com.

Requirements

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
Programming: Proficiency in Python, SQL, and at least one additional language (Scala, R, or similar)
Cloud Platforms: Experience with Azure data services and cloud-native architectures
5+ years of experience in business intelligence, data engineering, or analytics roles
Proven track record delivering enterprise-scale data solutions
Experience working in Agile development environments
Strong portfolio demonstrating technical depth across required technology stack
Excellent analytical and problem-solving abilities with attention to detail
Strong communication skills with ability to explain complex technical concepts to non-technical audiences
Collaborative mindset with experience working across functional teams
Self-motivated with ability to manage multiple priorities and projects simultaneously

Nice To Haves

Azure certifications (Data Engineer Associate, Databricks certifications) and Microsoft certifications (Power BI Data Analyst, Power Platform certifications).
Experience with version control systems (Git, Azure DevOps), CI/CD practices for BI and data engineering workflows, data governance frameworks, and metadata management.
Experience in commercial real estate or property management industries.

Responsibilities

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.