Data Analyst

Communicate with business users and conduct thorough study and analysis of business processes to gather, identify and ascertain needs and requirements in business intelligence analysis, marketing campaigns and customer accounts management. Understand business intent behind each incoming marketing campaigns designed to drive superior customer acquisition, engagement and management. Responsible and accountable for data requirements of campaign in terms of sourcing, analyzing, processing and delivering data. Perform data extraction, transformation, manipulation and refinery of customer related data; move data between production systems and across multiple platforms. Perform segmentation analytics for each campaign using database technologies present both on premise including SQL, Teradata, UNIX; Cloud platform using AWS (Amazon Web Services) technologies; Big data technologies including Spark/Pyspark, Cassandra, Python and Redshift. Work on SAS (Statistical Analysis System) programs to understand current logic and convert to newer technologies using Python, SQL and AWS. Perform data sanity checks and quality checks through data pipeline; ensure all legal compliances are met and fairness in treatment principles are applied to all test subjects present in company's segmentation population through the date pipeline by designing validation test cases and executing them. Drive statistical analytics, post processing and result reporting to leadership team after completion of campaign utilizing Tableau, Elk and Python GraphX libraries. Build insights out of exploratory data analysis on a multi -dimensional data layer constructed on customer accounts to study attrition modeling and other advanced analytics use cases for strategic decision making, using Python Machine Learning APIs like scikit-learn and advanced SQL. Interface with fulfillment team, technical team and digital infrastructure team to identify appropriate channels of communication. Build analytics infrastructure for big data processing on AWS Cloud platform to streamline and automate recurring campaigns; schedule data processing clusters that perform data segmentation, data hand off and statistical analytics required for result reporting. Utilize big data technologies including Spark/Pyspark, Cassandra, Python and Redshift. Automate daily and weekly refresh of tables by scheduling in UNIX server; seamless updating Tableau dashboards of different Deposit Products; reporting on monetary Inflows and Outflows. Work Location Various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate. Minimum Requirements Education: Master Computer Science or Business Analytics Experience: One (1) year. Experience must include work with Tableau, SQL, Python. Why Should You Apply? Health Benefits Referral Program Excellent growth and advancement opportunities As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.