Help to drive strategic Enterprise Data Warehouse projects.
Follow and advise on industry standards and advances on data driven technologies and tools.
Analyze data to determine relationships between large datasets.
Create complex end-to-end data flow diagrams and logical data models.
Develop basic - intermediate SQL scripts for various reporting and ad-hoc analysis.
Document data requirements, source to target data mapping, collaboration with technology teams, design, development, testing, and deployments.
Document system of record data models and map to business process.
Data mapping specification designs, data feed specifications, data analysis and data comparison.
Develop and document data remediation requirements and plans.
Adhere to Agile principles and philosophies (Scrum or Kanban, as applicable) in fulfillment of the role.
Responsible for reporting risks that are identified to the appropriate team and/or management.
Additionally, responsible for managing, monitoring and reporting risks within the scope of your work area, to include, but not limited to Information Security risks.
Must be detailed focus with the ability to detect patterns and possible solutions from large volumes of data.
Mentor less tenured data analysts.
Perform other duties as assigned.

Requirements

College degree in Analytics, Data Science, Data Management, CIS or equivalent training and/or experience.
2+ years’ experience as a data analyst or equivalent position where working with data is a primary responsibility.
2+ years’ experience with data technologies, process, data mapping tools with highly complex and integrated business models.
Basic to intermediate SQL skills
Familiarity with Databricks.
Basic knowledge of Snowflake is a plus
Data Warehousing methodologies and modeling
Financial industry knowledge.

Benefits

Competitive wages
Medical with telemedicine
Dental and Vision
Basic and Optional Life Insurance
Paid Time Off (PTO)
Maternity, Parental, Family Care
Community Volunteer Time Off
12 Paid Holidays
Company Paid Disability Insurance
401k (with employer match)
Health Savings Accounts (HSA) with company provided contributions
Flexible Spending Accounts (FSA)
Supplemental Insurance
Mental Health and Well-being: Employee Assistance Program (EAP)
Tuition Reimbursement
Wellness program

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata analysisdata mappingdata modelingdata flow diagramsdata remediationdata comparisondata warehousing methodologiesdata technologiesdata requirements documentation

Soft Skills

detail-orientedpattern detectionmentoringcollaborationrisk management

Certifications

college degree in Analyticscollege degree in Data Sciencecollege degree in Data Managementcollege degree in CIS