Lead Data Analyst->> Analyzes application requirements and develops conceptual, logical and first-cut physical database designs (data models). Creates associated data model documentation such as entity and attribute definitions and formats. Assists in logical data designs to deliver stable and flexible high performance data solutions. Investigates and corrects data discrepancies by reconciling faulty codes. Provides data element naming consistent with standards and conventions and ensures that data dictionaries are maintained across multiple database environments (mainframe, distributed systems). Ensures data content/quality by planning and conducting moderately complex data warehouse system tests, monitoring test results and taking required corrective action. Acts as a liaison to data owners to establish necessary data stewardship responsibilities (accountability for a particular data element/verifying accuracy of the data element before loading it into the database) and procedures. Analyzes and designs data models, logical databases and relational database definitions using both forward and backward engineering techniques. Seeks opportunities to promote data sharing, and to reduce redundant data processes within the corporation by identifying common structures across application areas. Contributes to the achievement of related teams' objectives.
Additional Responsibilities:This role will be responsible for analyzing data to assist in building and maintaining and Data Lake. Strong analytical background and problem solving skills using statistical analysis is required. This role will work with business clients, IT to collect, clarify and translate business requirements into functional and technical requirements documentation, process models, and data models to build the data lake and enable BI and Analytics for internal and external customers. The role will grow to apply data analytics /data science to provide insights and business intelligence to discover the information hidden in vast amounts of data, and help us make smarter decisions to deliver actionable insights. The ideal candidate should be proficient in technical languages and will have a demonstrated track record of successfully working with structured and big data systems. This role will interface with business stakeholders to solve complex business problems using many available data analysis techniques. Additional Details:
Bachelor's degree in computer science or a related discipline, or equivalent work experience required. 4-6 years of experience in data modeling, data warehousing, data entity analysis, logical and relational database design, or an equivalent combination of education and work experience required, experience in the securities or financial services industry is a plus.
Experience in a SQL intensive role
Common data science libraries (Python or R)
Data visualization tools - D3.js, High Charts, etc
Statistics skills such as: distributions, statistical testing, regression etc.
Hadoop, Vertica, Alteryx and Tableau