Falcon Smart IT (FalconSmartIT) · 2 hours ago
Senior Data Analyst
Philadelphia, PA
Contract
Onsite
Senior LevelFalcon Smart IT is seeking a Senior Data Analyst who combines strong data analysis and data mapping expertise with the ability to design scalable middleware and integration architectures. This hands-on role involves translating complex business requirements into clear data models and integration designs to support system interoperability.
Information Technology & Services
Hiring Manager
Harinii Suriyakumar
Responsibilities
Analyze source system data structures and business rules across multiple platforms
Design logical and physical data models, including canonical data models where appropriate
Create and maintain source-to-target data mapping specifications
Define data transformation rules, validations, defaults, and lookup logic
Perform data profiling and quality analysis to identify gaps, anomalies, and inconsistencies
Ensure data lineage, traceability, and auditability across integrations
Design middleware-based integration solutions (API-led, event-driven, batch, or hybrid)
Define integration patterns (synchronous/asynchronous, pub-sub, request/response)
Design APIs, message schemas, and versioning strategies
Establish error handling, retry, logging, and monitoring standards
Ensure integrations meet performance, scalability, and security requirements
Collaborate with engineering teams to ensure designs are implemented correctly
Produce clear architecture artifacts (data flow diagrams, integration diagrams, sequence flows)
Document integration standards, data contracts, and mapping logic
Participate in design reviews and provide architectural guidance
Evaluate tradeoffs between simplicity, scalability, and long-term maintainability
Partner with business stakeholders to clarify requirements and resolve data definition conflicts
Translate business rules into technical specifications engineers can implement
Facilitate data mapping and integration design workshops
Act as a bridge between business, data, and engineering teams
Qualification
Required
Insurance Background Required
Strong experience in data analysis, data modeling, and data mapping
Advanced SQL skills (joins, CTEs, window functions)
Proven experience designing middleware or integration architectures
Solid understanding of API design (REST/JSON; SOAP/XML a plus)
Experience working with at least one integration platform (e.g., MuleSoft, Boomi, Azure Integration Services, AWS, Kafka, or similar)
Strong understanding of data quality, validation, and governance concepts
Experience with integration patterns (hub-and-spoke, event-driven, batch, near-real-time)
Knowledge of schema evolution, versioning, and backward compatibility
Familiarity with security concepts (OAuth 2.0, API keys, encryption in transit)
Experience designing for failure, retries, and idempotency
Excellent written and verbal communication skills
Ability to explain complex technical concepts to non-technical audiences
Strong analytical thinking and problem-solving skills
Comfortable pushing back on unclear or conflicting requirements
Company
Falcon Smart IT (FalconSmartIT)
Global Specialist IT Recruitment Agency Leader in Digital Transformation , Business IT Solutions and IT Recruitment Specialists Falcon Smart IT is a Specialist recruitment agency can quickly find you highly skilled IT professionals who are the best fit for your project or full-time hiring needs.
Founded in 2019
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase