Senior Data Analyst Job at Jobs via Dice in Brooklyn

Overview

Senior Data Analyst | Fraud/AML squad within Enterprise Data and Information Services (EDIS). The Senior Data Analyst will build robust enterprise data pipelines to support reporting, analytics, and business insights that drive critical business decisions. The role includes data mapping and delivering vital information to the consumer population for multiple data assets.

Essential Job Functions

• Own attribution mapping details for data elements from source systems to the target Fraud, AML, and various marts within the data supply chain (DSC).
• Independently translate business requirements into detailed mapping documents, develop and unit test datasets, build maintainable code for reusable delivery, and perform peer code reviews. Provide mentorship and training for less experienced business and data analysts.
• Provide continuous improvement ideas to reduce expenses, improve efficiency, and elevate quality.
• Assess the technical viability of new and emerging data solutions, providing design guidance, technical recommendations, performance optimization, and development insights.
• Contribute to technical documentation, specifications, and project artifacts for developing data solutions.
• Adhere to and identify standards and best practices to extend beyond the Fraud/AML Squad.
• Provide input into Data Models and Entity Relationship Diagrams and use those documents to build efficient SQL.
• Create and enhance context diagrams for data solutions to maintain auditability.
• Provide all business rules, transformation logic, derived column expressions, SQL, etc. to build mapping documents.
• Participate and give feedback in Mapping Review Sessions and Data Architecture Review Sessions.
• Demonstrate knowledge of portfolio planning, project prioritization, and remediation planning activities.
• Show strong knowledge of Risk Management practices associated with Financial Institutions or financial data.

Qualifications

• Education: Master\'s Degree with 5+ years of data analytics experience, or Bachelor\'s Degree with 8+ years of data analytics experience, or equivalent military/work experience.
• 3+ years of SQL experience.
• Experience in Google Cloud Platform, notably BigQuery.
• Extensive experience analyzing and interpreting business data using various techniques, including automation for data quality validations.
• Strong written and verbal communication skills.
• Experience with Agile Methodologies, Jira, and Confluence.
• Attention to detail and quality focus; ability to handle multiple priorities simultaneously.
• Experience in AML, Fraud, or Financial Industry is a plus.
• Experience in Ab Initio or ETL tooling is a plus.

Additional Information

Be an influencer with other resources in KTOS including Data Architects, Developers, and Enterprise Testers to help drive design, development, and testing based on requirements. Be an influencer with the Line of Business including Business Analysts and SMEs to ensure business requirements are clear and meet business needs. Leverage metadata to provide insight into source system data. Understand source systems to prepare detailed mapping documents for Developers. Lead work with application system business users and SMEs to finalize requirements and translate them into technical mapping documents. Provide status updates to Project Managers and estimate effort. Contribute to Data Models and ER Diagrams to build efficient SQL. Understand programming concepts and apply them to mapping design. Provide all business rules and logic to mapping documents. Participate in Mapping Review Sessions and Data Architecture Review Sessions.

EOE Statement: Apex Systems is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, creed, sex, age, sexual orientation, gender identity, national origin, ancestry, citizenship, disability, or protected veteran status. Apex will consider qualified applicants with criminal histories in a manner consistent with applicable law. If you require an accommodation, contact our Employee Services Department.

Apex Benefits Overview: Apex offers medical, dental, vision, life, disability, and other insurance plans, an ESPP, a 401K with company match, an HSA on the HDHP plan, an Employee Assistance Program with up to 8 free counseling sessions, corporate discounts, and other perks. On-demand training, certification prep, and access to technical and leadership courses are available after 6 months of tenure, with certification discounts and additional programs for associations. A full list of benefits and resources is available in the Welcome Packet.