Senior Data Analyst - R01552965

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:

DAI:

Know what it’s like to work and grow at Brillio:

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

$40 - $50 an hour

Know what it’s like to work and grow at Brillio: Click here