LendingTree

Analyst, Reporting & Analytics

Posted on: 17 Oct 2021

Charlotte, NC

Job Description

Requirements

2+ years of experience working as a professional in a reporting or data analytics capacity
2+ years of experience writing SQL Queries, Functions and Procedures (any DB - MSSQL, Oracle, Teradata)
2+ years of experience in Tableau for design and development of interactive dashboards
Experience writing automation jobs in Python, PowerShell or other scripting language
Expertise in gathering business requirements and devising reporting solutions
Can lead meetings and communicate effectively to move projects forward
Ability to solve problems creatively and efficiently without increasing technical debt
Advanced knowledge on usage of Tableau Parameters, Dashboard Actions and Data Blending
Experience publishing Tableau workbooks in production environment
Proficient at writing optimized queries on large volume of data
Good understanding of Data warehouse/Data-mart concepts
Knowledge of ETL and experience with at least one ETL tool (e.g. SSIS)
Knowledge of HIVE or other Non-relational Databases
Motivated self-starter, with meticulous attention to detail

 Job Responsibilities

Work collaboratively with cross-functional teams to define, design, and develop data and reporting solutions
Help manage a production Tableau server and report environment with 300+ users
Create and manage Tableau incremental and full data extracts as per requirement for use by business users
Write queries to pull data from a SQL Data Warehouse as well as Data Like
Propose creative workarounds considering the limitations of Tableau
Ensure data accuracy and integrity across multiple systems and reports; work with tech and BI teams to resolve data inconsistencies
Write scripts in Python, PowerShell and SQL as needed to manage data flows
Build advanced Tableau Reports and Visualizations, and, as needed, help business users do the same
Provide production support for critical data sources and dashboards
Assist business users with ad-hoc analytics and reporting
Training and Documentation as needed

LendingTree

Charlotte, NC

LendingTree, Inc., through its subsidiary, LendingTree, LLC, operates an online loan marketplace for consumers seeking loans in the United States. Its mortgage products comprise purchase and refinance products. The company also provides information, tools, and access to various conditional loan offers for non-mortgage products, including auto loans, credit cards, home equity loans, personal loans, reverse mortgages, small business loans, and student loans. In addition, it offers information, tools, and access to other products, including deposit accounts; credit repair, through which consumers obtain assistance improving their credit profiles; debt relief services, through which consumers obtain assistance negotiating existing loans; and home improvement services, through which consumers have the opportunity to research and find home improvement professional services.

Further, the company provides personal credit data, through which consumers gain insights into how prospective lenders and other third parties view their credit profiles; real estate brokerage services, through which consumers are matched with local realtors who assist them in their home purchase or sale efforts; and various insurance products, including home and automobile, through which consumers are matched with insurance lead aggregators to obtain insurance offers. Additionally, it operates CompareCards, an online source for side-by-side credit card comparison shopping; SimpleTuition, an online marketing platform for student loans; MagnifyMoney, a consumer facing media property that offers editorial content, expert commentary, tools, and resources; and SnapCap, an online platform, which connects business owners with lenders. The company was formerly known as Tree.com, Inc. and changed its name to LendingTree, Inc. in January 2015. LendingTree, Inc. was founded in 1996 and is headquartered in Charlotte, North Carolina.