What are the responsibilities and job description for the Senior Manager-Data Analyst, Software Engineering II position at Equitable Services?
Senior Manager-Data Analyst, Software Engineering II ( 2500003T )
Primary Location : UNITED STATES-NC-Charlotte
Organization : Equitable
Schedule : Full-time
Description
Equitable Financial Life Insurance Company seeks a Senior Manager - Data Analyst, Software Engineering II for its Charlotte, NC location.
Duties :
Create and enhance data products for all finance consumers such as Business Users, Actuarial Analysts, and Modelers.
Work directly with a team of Data Engineers, Data Analysts, and Business Stakeholders to assemble data from various data sources, develop process workflows (ETL) and automation to pipeline data for downstream analysis and consumption by Financial and Actuarial models and / or other related downstream Business Stakeholders or use cases.
Identify and define IT data controls to ensure the resiliency, accuracy, and completeness of data products.
Evaluate complex business problems and provide subject matter knowledge proficiency for technology initiatives.
Collaborate with technical personnel, members of the Data Analytics team, and business partners to assemble data from various sources into datasets to analyze the information to solve business problems and improve business efficiency.
Analyze Business Requirements through data mining, data quality checks, and data validation of raw data elements for the required enhancements for data product design.
Explore data to find its meaning and relationship to insurance products for solving business problems, including analysis of complex data and large data sets using tools such as Hue, Hive, and Impala.
Develop complex SQL / HQL queries to join multiple high-volume datasets, apply complex data transformations and filtering, and then produce output datasets in Hadoop Data Lake platform or in Enterprise Data Warehouse (EDW) using tools such as Hive, Impala and SQL.
Use query optimization techniques to achieve high query output performance.
Develop data dashboards and reports using visualization tools such as Tableau or PowerBI
Document technical and business definitions and document data lineage of automation process.
Create source to target mapping documents to capture the transformation and filtering applied to produce new datasets.
Perform technical testing and support business acceptance testing as a member of development project teams.
Test data products to ensure it is accurate and complete. Identify test cases and document test results.
Qualifications
Requires a Bachelor’s or foreign equivalent degree in Computer Science, Electronic Engineering, Information Systems, or a related IT field plus at least 2 years of progressive post-Baccalaureate experience as a Data Analyst, Systems Analyst, Data Engineer or related position involving Data Analysis and exploration, Data Mining, Data Science and Big Data Technologies (Hive / Impala). Experience. must include : SQL, HQL, Python, Data Lake, Enterprise Data Warehouse (EDW), Oracle; Business Intelligence; Requirements Analysis; Data Validation / Testing; Data Documentation; Data Visualization in Tableau or PowerBI; Agile Methodology; and Change Management. Tools- Archer, Service NOW. 40 hours / week. Salary is $110,000-$123,000. Partial remote work schedule is available. Direct applicants only. Applicants refer to job code SI1730 and send resume to Equitable Financial Life Insurance Company, Attn : Mark Berkowsky, 1345 Avenue of the Americas, New York, NY 10105 or search job title through EOE M / F / D / V.
Req ID : 2500003T
Salary : $110,000 - $123,000
