The Data Analytics Lead Analyst is needed to manage professional teams and departments within the Mortgage and Personal Loans area, integrating expertise and contributing to data analytics standards. The role requires ensuring the quality, timeliness, and delivery of end results for the department, with potential involvement in planning, budgeting, and policy formulation.
Requirements
- Experience with big data processing technology (e.g., Hadoop, Apache Spark, Pyspark, Python, Scala, HDFS, Hive, Impala etc.,), data warehouse technical architecture, infrastructure components, and reporting/analytic tools and environments.
- Big Data Platforms: Cloudera / Horton Works / Snowflake / AWS EMR / RedShift/ AWS Glue.
- Database, data warehouse or data lake solutions.
- Experience building data pipelines or automated ETL processes.
- One or more scripting language (e.g., Python, Scala, Shell Scripting).
- Experience with Build Tools, Version Control, Unit Test, Monitoring, Change Management to support DevOps.
- Scheduling tools like Autosys, Airflow etc.,
- Knowledge of writing and optimizing SQL queries with large-scale, complex datasets.
- Data visualization tools like Tableau, Cognos, Qlickview, AWS QuickSight etc
- Familiarity with any NOSQL databases (HBase, MongoDB, Couchbase, Cassandra, and Neo4j) will be a plus.
- 6+ years’ experience using tools for Data warehousing, Data Lake and cloud technologies
Responsibilities
- Integrates subject matter and industry expertise within Lending (Mortgage and Personal Loans).
- Contributes to data analytics standards around which others will operate.
- Articulate the basic differences between datatypes (e.g. JSON/NoSQL, Relational etc.,).
- Basic implications of different implementation decisions (e.g., distributed processing, parallel processing).
- Designing and implementing a data schema (e.g., normalization/de-normalization, relational model vs dimensional model, partitioning).
- Monitor and troubleshoot operational or data issues in the data pipelines.
Other
- Accomplishes results through the management of professional team(s) and department(s).
- Developed communication and diplomacy skills are required in order to guide, influence and convince others, in particular colleagues in other areas and occasional external customers.
- Has responsibility for volume, quality, timeliness and delivery of end results of an area.
- May have responsibility for planning, budgeting and policy formulation within area of expertise.
- Involved in short-term planning resource planning.
