Note: The job is a remote job and is open to candidates in USA. Mutual of Omaha Mortgage is seeking a Sr. Business Intelligence Reporting Analyst to enhance their Power BI reporting environment. The role focuses on developing impactful dashboards and reports to provide actionable insights for business leaders, ensuring data quality and effective communication of findings.
Responsibilities
- Build effective and efficient reports and dashboards using best practices in data presentation and design language
- Migrate existing reporting inventory to a centralized semantic model
- Leverage Valtrune to complete full data and report validation
- Automate/streamline manual processes
- Use advanced SQL techniques and multi-stage transformation methodologies to normalize, cleanse, and standardize inconsistent datasets
- Infer and establish relationships between disparate data sources and systems of record to support unified reporting and analytics
- Transform raw source data into reporting-layer-ready objects, including the creation of synthetic keys derived from non-standardized attributes
- Update semantic models to support new reporting needs
- Monitor model efficiency and implement changes as needed to optimize performance
- Identify pertinent trends to share with leaders
- Proactively dive headfirst into data to offer deeper insights into high/low performing KPIs
- Document report development processes for business contingency purposes
- Maintain semantic model documentation, including data sources and table relationships
- Maintain an index of all active reports, including data lineage, purpose, and audience
- Maintain reporting changelog
Skills
- 4+ years' experience in a data or business intelligence focused role
- 3+ years creating BI dashboards and reports with a focus on data visualization and storytelling with a high proficiency using Power BI
- 3+ years writing SQL queries for data mining
- Ability to independently understand data through business context, exploration, and logical connections
- Advanced level proficiency with Power BI
- Building efficient semantic models
- Understand/create dynamic measures using DAX
- Power Query for data sourcing/transformation
- Row-level security implementation
- Calculation groups
- Data visualization
- Performance Analyzer
- DAX Studio
- Intermediate level proficiency with SQL (T-SQL)
- Standard select queries
- Joins across multivariate datasets including multiple keys
- Data normalization
- Window functions and methods
- Strong written and verbal communication skills
- Mortgage experience preferred
- Familiarity with Databricks Data Warehouse a plus
Benefits
- Vacation — Vacation hours accrue on a per pay period basis. Balance maximums are based on years of service.
- Paid Sick Time — 40 hours of paid sick time after 90 days of employment. State sick time requirements will be added as needed.
- 9Paid Holidays + 1 Cultural Celebration Day (Floating Holiday)
- Multiple PPO Medical Plans, as well as HDHP eligible plan.
- Dental Coverage
- Vision Coverage
- Company Paid Life Insurance
- 401K with a generous employer match
- Additional Benefits including Optional Life, FSA, Pet Insurance etc.
- Free Legal Services
- Employee Loan Program
- 100% Remote
Company Overview