Senior Data Analyst

1 Month ago • 6 Years + • Data Analysis

Job Summary

Job Description

Brillio is seeking experienced Data Analysts for an application modernization effort within their Finance organization, specifically focusing on modernizing the Single Family Corporate Data Warehouse (SF CDW). The role involves identifying critical system dependencies and assisting in the modernization of legacy data platforms and workflows. Responsibilities include collaborating with teams to identify application dependencies, analyzing business requirements and ETL code, defining data requirements, developing mapping documents, creating complex SQL scripts for data analysis and migration, assisting with source system mapping to Nexus, and supporting the transformation of legacy data into the new EBM format. The role requires strong analytical skills, comfort with large-scale enterprise systems, and expertise in data mapping, ETL, and data warehousing.
Must have:
  • Minimum of 6+ years of experience in data analysis, data warehousing.
  • Strong understanding of ETL processes and ability to interpret ETL code.
  • Hands-on experience with DataStage, Informatica, SAS, Python.
  • Proficiency in SQL for data analysis, validation, and script development.
  • Solid understanding of enterprise-scale systems and data environments.
  • Excellent analytical skills and attention to detail.
  • Strong communication and collaboration skills.
Good to have:
  • Familiarity with Corporate Data Warehouses (especially CDW).
  • Prior experience in finance and accounting data flows.
  • Exposure to modernization or data migration initiatives.
  • Knowledge of Nexus platform and EBM data formats.

Job Details

About Brillio:

Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.

Consultant

Primary Skills

    • experience in data analysis, data warehousing, ETL processes, SQL, DataStage, Informatica, SAS, and Python.

Job requirements


    • Location: Mclean, VA (5 Days Onsite)
    • Job Type: Contract
    • Experience: 6+ Years Start Date: ASAP

    • Role:
    • As part of a major initiative to modernize the Single Family Corporate Data Warehouse (SF CDW), we are launching a significant application modernization effort within our Finance organization.
    • To ensure a seamless transition and reduce disruption, we are seeking experienced Data Analysts who can help identify critical system dependencies and assist in modernizing legacy data platforms and workflows.
    • This role is ideal for candidates who are highly analytical, comfortable working across large-scale enterprise systems, and have a strong background in data mapping, ETL, and data warehousing.

    • Key Responsibilities:
    • Collaborate with cross-functional teams to identify application and system dependencies on the current CDW platform.
    • Analyze and interpret Business Requirement Specifications (BRS) and ETL code to support modernization goals.
    • Work with stakeholders to define data requirements for Finance and Accounting systems.
    • Develop detailed mapping documents capturing data flows, transformations, and system interactions.
    • Create and validate complex SQL scripts to assist with data analysis and migration.
    • Assist in mapping source systems to Nexus and defining derivation logic as part of the modernization effort.
    • Support the transformation of legacy data into the new EBM format.
    • Ensure clear documentation and traceability of all data lineage and mapping efforts.

    • Required Qualifications:
    • Minimum of 6+ years of experience in data analysis, data warehousing, or related fields.
    • Strong understanding of ETL processes and ability to read and interpret ETL code.
    • Hands-on experience with tools such as DataStage, Informatica, SAS, and Python.
    • Proficiency in SQL for data analysis, validation, and script development.
    • Solid understanding of enterprise-scale systems and data environments.
    • Excellent analytical skills and attention to detail.
    • Strong communication and collaboration skills.

    • Preferred Skills:
    • Familiarity with Corporate Data Warehouses (especially CDW).
    • Prior experience in finance and accounting data flows.
    • Exposure to modernization or data migration initiatives.
    • Knowledge of Nexus platform and EBM data formats is a plus.

    • Know more about:
      Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
       
      Equal Employment Opportunity Declaration
      Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
       
      #LI-SR1

Similar Jobs

Apple - Engineering Project Manager - Test Technologies

Apple

Cupertino, California, United States (On-Site)
4 Weeks ago
techholding - Senior QA Manager / QA Manager - Contractor

techholding

Mexico (Remote)
1 Month ago
Razer - Digital Marketing Specialist

Razer

Shah Alam, Selangor, Malaysia (On-Site)
1 Year ago
Cognite - Senior Data Engineer

Cognite

Bengaluru, Karnataka, India (Hybrid)
11 Months ago
Aristocrat - Third Party Risk Manager

Aristocrat

Las Vegas, Nevada, United States (Hybrid)
2 Months ago
Say games - Marketing Data Analyst

Say games

Limassol, Limassol, Cyprus (Hybrid)
3 Months ago
Experian - Full Analyst Data (Product Focus)

Experian

Blumenau, State Of Santa Catarina, Brazil (On-Site)
1 Month ago
Kin. - Staff Data Engineer

Kin.

United States (Remote)
1 Month ago
Comscore - Senior Data Analyst

Comscore

Pune, Maharashtra, India (On-Site)
2 Months ago
Cognite - Senior Data Scientist

Cognite

Bengaluru, Karnataka, India (Hybrid)
10 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Qualcomm - Staff Physical Design Engineer

Qualcomm

Noida, Uttar Pradesh, India (On-Site)
3 Months ago
Autodesk - Senior Principal Construction Research Scientist

Autodesk

Toronto, Ontario, Canada (Hybrid)
2 Months ago
Fliff - Data Scientist

Fliff

Austin, Texas, United States (On-Site)
1 Year ago
lifechruh - Senior Project Manager

lifechruh

Edmond, Oklahoma, United States (On-Site)
2 Weeks ago
Hike - Senior Software Development Engineer iOS

Hike

India (Remote)
3 Weeks ago
Adyen - Account Manager

Adyen

Paris, Île-de-France, France (On-Site)
2 Months ago
Vercel - Manager, Customer Support Engineering

Vercel

(Remote)
1 Month ago
QS Quacquarelli Symonds  - Manager- Global Workplace

QS Quacquarelli Symonds

Bengaluru, Karnataka, India (Hybrid)
2 Weeks ago
Workato - Senior UX Designer (Builder Experience)

Workato

Palo Alto, California, United States (On-Site)
1 Month ago
eBay - Billing Analyst

eBay

Austin, Texas, United States (Hybrid)
2 Weeks ago

Get notifed when new similar jobs are uploaded

Jobs in McLean, Virginia, United States

Jane Street - Puzzles and Games Producer

Jane Street

New York, United States (On-Site)
2 Months ago
Techstars - Startup Community Operations Associate

Techstars

Tuscaloosa, Alabama, United States (Hybrid)
3 Weeks ago
Nintendo - Coordinator, Technical and Supply Chain Services (Bilingual Japanese)

Nintendo

Redmond, Washington, United States (On-Site)
6 Months ago
Passive Logic - Weather Simulation Engineer

Passive Logic

Salt Lake City, Utah, United States (On-Site)
7 Months ago
Scientific Games - Senior Field Service Engineer

Scientific Games

Georgia, United States (Remote)
6 Months ago
Adyen - Senior Software Engineer - iOS

Adyen

Chicago, Illinois, United States (Hybrid)
1 Month ago
Cadence - Senior Software Engineer, GPU Rendering

Cadence

Burlington, Massachusetts, United States (On-Site)
1 Month ago
Microsoft - Technical Program Manager, AI

Microsoft

Mountain View, California, United States (Hybrid)
3 Months ago
Interface AI - Customer Success Manager

Interface AI

San Jose, California, United States (On-Site)
2 Months ago
The Walt Disney Company - Senior Software Engineer - C++/Rust

The Walt Disney Company

Bristol, Connecticut, United States (On-Site)
3 Months ago

Get notifed when new similar jobs are uploaded

Data Analysis Jobs

zeta - Data Reliability Engineer II

zeta

Hyderabad, Telangana, India (On-Site)
9 Months ago
ISS Stoxx - Economic Value Added Data Analyst

ISS Stoxx

Mumbai, Maharashtra, India (On-Site)
1 Month ago
Ziff Davis - Data Engineer II

Ziff Davis

United Kingdom (Remote)
1 Month ago
YouGov - VP Analytics, Data Products

YouGov

United States (Remote)
2 Months ago
CrazyLabs - Data Engineer

CrazyLabs

Skopje, Greater Skopje, North Macedonia (On-Site)
2 Weeks ago
Jam City - Senior Data Analyst

Jam City

Toronto, Ontario, Canada (On-Site)
1 Year ago
London stock Exchange - Data Scientist

London stock Exchange

Bengaluru, Karnataka, India (On-Site)
1 Year ago
Hawkeye Innovations - Senior Data Test Automation Engineer

Hawkeye Innovations

Budapest, Hungary (Hybrid)
3 Months ago
GoTo Group - Senior Software Engineer - Big Data

GoTo Group

Bengaluru, Karnataka, India (Remote)
2 Months ago

Get notifed when new similar jobs are uploaded

About The Company

Bengaluru, Karnataka, India (Hybrid)

Dallas, Texas, United States (Hybrid)

Irving, Texas, United States (Hybrid)

Bengaluru, Karnataka, India (Hybrid)

Bengaluru, Karnataka, India (Hybrid)

Bengaluru, Karnataka, India (Hybrid)

Austin, Texas, United States (Hybrid)

Alameda, California, United States (On-Site)

Ashburn, Virginia, United States (On-Site)

View All Jobs

Get notified when new jobs are added by Brillio

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug