Principal IT Data Analyst
$115,775–$166,000 year
On-siteSmithfield, Rhode Island, United States
Job Summary
Develop and maintain curated data repositories for an enterprise analytics platform, analyzing complex datasets from demographics and investments using SQL, Python, and Tableau. Translate divisional initiatives into business solutions by designing new systems, documenting formal specifications, and recommending changes to project development policies. Mentor analysts on large and complex project documentation while monitoring document quality and communicating findings to senior management. Execute end-to-end data analysis, profiling, and modeling across Legal, Risk, & Compliance functions, utilizing tools like Snowflake, Oracle, and PowerBI. Perform data wrangling, visualization, and machine learning model development to evaluate risk scores within an Agile financial services environment.
Required Qualifications
- Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent)
- Five (5) years of experience as a Principal IT Data Analyst (or closely related occupation) performing data analysis, profiling, and modeling across Legal, Risk, & Compliance functions within the financial domain, using SQL, PL/SQL, and Python
- Master's degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent)
- Three (3) years of experience as a Principal IT Data Analyst (or closely related occupation) performing data analysis, profiling, and modeling across Legal, Risk, & Compliance functions within the financial domain, using SQL, PL/SQL, and Python
- Demonstrated Expertise translating business requirements into data driven solutions (to create conceptual, logical and physical models) using SAP Power Designer
- Supporting unstructured and semi structured data storage design patterns using AWS-S3, Kafka, and Snowflake
- Parsing out attributes from data to identify patterns, using SQL, KSQL, or PL/SQL
- Analyzing, evaluating, and creating data objects based on relational or dimensional data models in Oracle, Snowflake, MySQL, and PostgreSQL
- Developing data profiling frameworks using SQL and Python
- Performing end-to-end data analysis and sourcing (to target data mapping) using Oracle, Snowflake, and ICEDQ
- Establishing governance and dictionary data practices using Alation and Collibra
- Designing and implementing data movement processes for data warehouses or datalakes by developing mappings and extract, transform, load (ETL) workflows, using Informatica, Apache Nifi, or Control-M
- Deploying code changes using Github or Jenkins
- Performing application testing to write stored procedure using PL/SQL and Python adhering to coding standards
- Optimizing SQL queries and batch processes using Oracle, Snowflake, NiFi, and DBT
- Performing data wrangling using Python, R, Alteryx, and Jupyter Notebook
- Performing data visualization using BI tools (PowerBI, tableau, and Excel)
- Developing Machine Learning (ML) models using Artificial Intelligent (AI)/ML algorithm (decision tree model, k-Nearest Neighbors (KNN) model, Binary tree model, and Linear and Logistic regression data model) and Python and R to evaluate external and internal risk scores
- Performing story creation, backlog refinement, and sprint planning according to Agile methodologies (Jira), within a financial services compliance environment
- Valid driver's license
- Must be able to lift 50 lbs
- Must be available for weekend shifts
- Must be able to effectively lead and coach others
- Strong attention to detail
- Order to Cash
- Procure to Pay
- Supply Chain
- Customers
- Suppliers
Desired Qualifications
- Master's degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Principal IT Data Analyst (or closely related occupation) performing data analysis, profiling, and modeling across Legal, Risk, & Compliance functions within the financial domain, using SQL, PL/SQL, and Python
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.