Technical Business Analyst-Data Architecture & Loyalty Systems

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Technical Business Analyst-Data Architect & Loyalty Systems, offering a 6-month hybrid contract in Chicago, IL, with a pay rate of $65-$70/hr. Requires 6+ years of experience in loyalty systems, strong SQL, and data architecture skills.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
560
-
πŸ—“οΈ - Date discovered
September 11, 2025
πŸ•’ - Project duration
More than 6 months
-
🏝️ - Location type
Hybrid
-
πŸ“„ - Contract type
Unknown
-
πŸ”’ - Security clearance
Yes
-
πŸ“ - Location detailed
Chicago, IL
-
🧠 - Skills detailed
#Data Modeling #Kafka (Apache Kafka) #EDW (Enterprise Data Warehouse) #Cloud #Data Warehouse #Data Pipeline #Databases #Snowflake #Documentation #A/B Testing #Airflow #GDPR (General Data Protection Regulation) #Business Analysis #Computer Science #Data Privacy #API (Application Programming Interface) #Data Engineering #Data Integration #Data Governance #"ETL (Extract #Transform #Load)" #Data Science #Data Mapping #Fivetran #Oracle #Azure #BigQuery #Redshift #Security #CRM (Customer Relationship Management) #Physical Data Model #SQL Server #Talend #Data Architecture #dbt (data build tool) #Scala #SQL (Structured Query Language) #Data Orchestration #ERWin #AWS (Amazon Web Services) #Synapse #Microservices #Compliance #DevOps
Role description
Akkodis is seeking a Senior Technical Business Analyst- Data Architect & Loyalty Systems for a 6-month contract with a client in Chicago, IL 60606-Hybrid. Title – Senior Technical Business Analyst -Data Architect & Loyalty Systems Location: Chicago, IL 60606-Hybrid Contract: 6-month contract Pay Range: $65/hr. - $70/hr. (The rate may be negotiable based on experience, education, geographic location, and other factors) Purpose We are seeking a highly skilled Senior Technical Business Analyst / Data Architect to support our Loyalty Systems. This role involves deep technical engagement with internal systems, data architecture, and collaboration with business teams to drive data integration and system enhancements. Position Responsibilities 1. Business Analysis Responsibilities β€’ Partner with stakeholders across product, marketing, CRM, and IT to gather, analyze, and prioritize business requirements related to loyalty program capabilities (e.g., accrual, redemption, tiering, member lifecycle). β€’ Translate business needs into detailed technical specifications and solution designs. β€’ Document system and process flows, data mappings, and interface specifications for loyalty system integrations. β€’ Analyse loyalty program performance, customer data, and behavioural metrics to inform system design and enhancements. β€’ Support stakeholder alignment by leading workshops and presenting solution designs. 1. Data Architecture Responsibilities: β€’ Lead the design and implementation of end-to-end data architectures supporting loyalty programs, including customer profiles, transactional history, engagement metrics, and campaign data. β€’ Design and maintain conceptual, logical, and physical data models for loyalty ecosystems. β€’ Define data integration strategies and oversee data flow design between loyalty platforms, CRM, POS, mobile apps, and enterprise data warehouses. β€’ Ensure alignment of loyalty data models with enterprise architecture and data governance standards. β€’ Collaborate with data engineers, developers, and DevOps teams to ensure solutions are robust, scalable, and optimized for performance. β€’ Evaluate new loyalty platforms or enhancements and provide architectural recommendations. Required Skills β€’ Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field. β€’ 6+ years of experience in business analysis and data architecture roles, with significant focus on customer loyalty systems or CRM platforms. β€’ Deep experience with loyalty business processes: point accrual/redemption, member tiers, campaign targeting, personalization, breakage analysis, etc. β€’ Strong SQL skills and experience with cloud data platforms (e.g., Snowflake, BigQuery, Azure Synapse, AWS Redshift). β€’ Proficiency in data modeling tools (e.g., ER/Studio, Lucidchart, dbt, ERwin). β€’ Experience working with API integrations, event-based data pipelines, and microservices architecture. β€’ Familiarity with enterprise loyalty platforms (e.g., Salesforce Loyalty, Oracle Loyalty Cloud, Comarch, SessionM, Annex Cloud, Kobie, etc.). β€’ Experience with tools like Airbyte, dbt, Airflow, Fivetran, or Talend for data orchestration. β€’ Proven ability to act as a bridge between technical teams and business stakeholders. β€’ Strong documentation, communication, and presentation skills. Preferred Skills β€’ Experience in high-volume, customer-centric industries (retail, travel, hospitality, QSR). β€’ Familiarity with customer identity resolution, real-time personalization, or CDPs (Customer Data Platforms). β€’ Understanding of data privacy and compliance regulations (GDPR, CCPA). β€’ Knowledge of A/B testing, attribution modeling, and predictive analytics in loyalty contexts. Education Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field required, and 6+ years of experience in business analysis and data architecture roles. Tools & Technologies: β€’ Databases: SQL, SQL Server β€’ Messaging & Streaming: Kafka β€’ Cloud Platforms: AWS, Azure β€’ Data Warehousing: Snowflake β€’ Data Orchestration & ETL Tools β€’ Experience with tools like Airbnb, Airbyte, dbt, Airflow, Fivetran, or Talend for data orchestration. Equal Opportunity Employer/Veterans/Disabled Benefit offerings include medical, dental, vision, term life insurance, short-term disability insurance, additional voluntary benefits, commuter benefits, and a 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State, or local law; and Holiday pay upon meeting eligibility criteria. To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable: Β· The California Fair Chance Act Β· Los Angeles City Fair Chance Ordinance Β· Los Angeles County Fair Chance Ordinance for Employers Β· San Francisco Fair Chance Ordinance