Data Entry Question and Answer

$150 $49

Remote Question and Answer

$150 $49

Virtual Assistant Question and Answer

$150 $49

Content Moderator Question and Answer

$150 $49

Customer Service Question and Answer

$150 $49

Video Game Tester Question and Answer

$150 $49

Sr. Business Intelligence Reporting Analyst (Power BI)

Other Jobs To Apply

No other job posts for this day.

<p><strong>Sr. Business Intelligence Reporting Analyst (Power BI) </strong></p><p>Compensation Range: $90,000 - $105,000 </p><p><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">The Mortgage Business Intelligence & Analytics team oversees all activities and functions involved with the company’s Business Intelligence platform, giving mortgage company business leaders access to reliable, actionable data to better manage and understand the business and drive company growth. </span></span></span><br><br><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">We are seeking a Sr. Business Intelligence Reporting Analyst to drive the development of our Power BI reporting environment. The Reporting Analyst will be responsible for creating impactful dashboards and reports which deliver meaningful data to our business leaders to achieve organizational goals. This role will do more than compile tabular data; this role will have an opportunity to use data to tell a story, and help our team, as well as business leaders, derive meaningful insights.  </span></span></span><br><br><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">The right candidate will have a strong background with Power BI. They will be detail oriented, with the ability to infer business needs and develop reporting solutions using data visualization best practices including leveraging Gestalt principles, Storytelling with Data, and visualization selection principals. They will proactively run data quality checks to ensure the integrity of the information being delivered. Self-motivated with an eagerness to learn, becoming a subject matter expert to coincide with technical fluency. Stays abreast of the latest Power BI features and identifies the right opportunities for implementation. </span></span></span><br><br><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><b>What you will be doing: </b></span></span></span><br><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><i>Report Development (50%) </i></span></span></span></p><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Build effective and efficient reports and dashboards using best practices in data presentation and design language </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Migrate existing reporting inventory to a centralized semantic model </span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Leverage Valtrune to complete full data and report validation</span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Automate/streamline manual processes </span></span></span></span></li></ul><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><i>Data Transformation/Preparation (20%)</i></span></span></span><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span style="font-family:Aptos, sans-serif;">Use advanced SQL techniques and multi-stage transformation methodologies to normalize, cleanse, and standardize inconsistent datasets</span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span style="font-family:Aptos, sans-serif;">Infer and establish relationships between disparate data sources and systems of record to support unified reporting and analytics</span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:115%;"><span style="font-family:Aptos, sans-serif;">Transform raw source data into reporting-layer-ready objects, including the creation of synthetic keys derived from non-standardized attributes</span></span></span></li></ul><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><i>Semantic Model Maintenance (15%) </i></span></span></span><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Update semantic models to support new reporting needs </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Monitor model efficiency and implement changes as needed to optimize performance </span></span></span></span></li></ul><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><i>Analysis (10%) </i></span></span></span><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Identify pertinent trends to share with leaders </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Proactively dive headfirst into data to offer deeper insights into high/low performing KPIs </span></span></span></span></li></ul><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><i>Documentation (5%) </i></span></span></span><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Document report development processes for business contingency purposes </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Maintain semantic model documentation, including data sources and table relationships </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Maintain an index of all active reports, including data lineage, purpose, and audience </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Maintain reporting changelog </span></span></span></span></li></ul><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><b>Qualifications </b></span></span></span><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">4+ years’ experience in a data or business intelligence focused role </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">3+ years creating BI dashboards and reports with a focus on data visualization and storytelling with a high proficiency using Power BI </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">3+ years writing SQL queries for data mining </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Ability to independently understand data through business context, exploration, and logical connections </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Mortgage experience preferred </span></span></span></span></li></ul><br><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;"><b>Required Skills </b></span></span></span><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Advanced level proficiency with Power BI: </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Building efficient semantic models </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Understand/create dynamic measures using DAX </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Power Query for data sourcing/transformation </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Row-level security implementation </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Calculation groups </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Data visualization </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Performance Analyzer </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">DAX Studio </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Intermediate level proficiency with SQL (T-SQL): </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Standard select queries </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Joins across multivariate datasets including multiple keys </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Data normalization </span></span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-left:32px;margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Window functions and methods </span></span></span></span></li><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Familiarity with Databricks Data Warehouse a plus</span></span></span></li></ul><ul style="margin-bottom:11px;"><li style="margin-bottom:11px;"><span style="font-size:11pt;"><span><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">Strong written and verbal communication skills </span></span></span></span></li></ul><p><br><span style="font-size:11pt;"><span style="line-height:107%;"><span style="font-family:Aptos, sans-serif;">This opportunity is fully remote with the option to work from our offices in San Diego, CA, Irvine, CA, or Omaha, NE for those who prefer an office environment. You will be joining a dynamic, fully remote team which is distributed across pacific and central time zones and supporting our business across all US time zones.</span></span></span><br><br><br><i>Mutual of Omaha Mortgage is an Equal Opportunity Employer, and we encourage diverse, talented, qualified applicants to apply. We offer an extensive compensation package. Benefits include: </i></p><ul><li>Vacation — Vacation hours accrue on a per pay period basis. Balance maximums are based on years of service. </li><li>Paid Sick Time — 40 hours of paid sick time after 90 days of employment. State sick time requirements will be added as needed. </li><li>9 Paid Holidays + 1 Cultural Celebration Day (Floating Holiday) </li><li>Multiple PPO Medical Plans, as well as HDHP eligible plan. </li><li>Dental Coverage </li><li>Vision Coverage </li><li>Company Paid Life Insurance </li><li>401K with a generous employer match </li><li>Additional Benefits including – Optional Life, FSA, Pet Insurance etc. </li><li>Free Legal Services </li><li>Employee Loan Program </li><li>100% Remote</li></ul>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...