Hello,
Hope you are doing great!
This is Azhar Tariq from ApTask.
We have urgent requirements with one of our client’s, please review the job description below and let me know if you have any relevant candidates on your bench, Kindly share.
Need 12+ Years of Candidates
Kindly help me with work authorization status and DL location with resume
Need Experience in finance OR Banking domain in Recent Project
Need Experience on Snowflake, SQL, Power BI and ETL
Title: SR Data Analyst
Location: Remote
Duration: Long Term Contract
We are looking for a Data Analyst (Snowflake / SQL) to support data analysis, data profiling, lineage validation, reporting, and regulatory data initiatives. The role will involve working with large and complex datasets in Snowflake, analysing source-to-target data flows, validating report and data lineage, identifying data quality issues, and supporting the onboarding and maintenance of regulatory reports.
The ideal candidate should have strong SQL and data analysis capabilities, a good understanding of data flows and lineage, and the ability to work with both business and technical stakeholders to investigate data issues and translate reporting requirements into actionable data requirements.
Key Responsibilities
- Analyse data across source systems, transformation layers, data warehouses, and reporting platforms using advanced SQL.
- Perform data profiling, validation, reconciliation, and exploratory analysis to understand data structures, relationships, completeness, and quality.
- Analyse and validate source-to-target mappings, ensuring that data is correctly mapped through different stages of the data flow.
- Validate report-to-source lineage, including the flow of data from source systems through transformations to final reports.
- Trace data elements across systems to support impact analysis, issue investigation, and regulatory reporting requirements.
- Support the onboarding of new regulatory reports by analysing data requirements, source systems, mappings, transformations, and reporting logic.
- Review existing reports and data flows to identify lineage gaps, inconsistencies, or undocumented transformations.
- Perform data quality assessments and investigate issues related to completeness, accuracy, consistency, timeliness, and validity.
- Conduct root cause analysis for data and reporting issues and work with technology and business teams to identify appropriate remediation.
- Develop SQL queries and analytical outputs to support data investigations, reporting requirements, and governance activities.
- Create and maintain analytical metrics, operational reports, and dashboards to communicate data quality and reporting outcomes.
- Support audit, risk, compliance, and regulatory reporting activities, including data validation and evidence preparation.
- Interpret business requirements, reporting specifications, and BRDs and translate them into data and analytical requirements.
- Work closely with Data Analysts, Business Analysts, Data Engineers, Data Governance teams, Report Owners, and business stakeholders.
- Document data findings, mappings, lineage, business rules, analytical logic, and issue-resolution outcomes.
- Contribute to continuous improvement of data analysis, reporting, and data quality processes.
Required Skills & Experience
- Strong hands-on experience with SQL, including complex joins, subqueries, CTEs, aggregations, window functions, and data validation queries.
- Python coding skills
- Experience working with Snowflake or a comparable cloud data warehouse.
- Strong experience in data analysis and data profiling.
- Understanding of data lineage, data flows, source-to-target mappings, and data transformations.
- Experience investigating data quality issues and performing root cause analysis.
- Ability to analyse large datasets and identify patterns, anomalies, inconsistencies, and data gaps.
- Experience working with business and technical requirements and interpreting BRDs, reporting specifications, and data requirements.
- Good understanding of reporting and data processes within enterprise environments.
- Experience supporting regulatory reporting, risk, compliance, or audit-related data activities is preferred.
- Strong documentation and communication skills.
- Ability to collaborate effectively with technical teams, business users, data owners, and reporting stakeholders.
Preferred Skills
- Experience with Power BI or other BI/reporting tools.
- Experience working with regulatory reporting datasets and controls.
- Exposure to data governance, metadata management, or data catalog platforms.
- Experience with financial services, banking, insurance, or other highly regulated industries.
- Knowledge of ETL/ELT concepts and modern cloud data architectures.
- Familiarity with data reconciliation and control frameworks.
- Experience working with data lineage or data discovery tools.
Key Deliverables
- Accurate and validated source-to-target mappings.
- Documented and validated report and data lineage.
- Data profiling and quality assessment outputs.
- Root-cause analysis and resolution of data issues.
- Data requirements and mapping documentation for regulatory reports.
- Data validation and reconciliation results.
- Audit and regulatory evidence.
- Meaningful data quality and reporting metrics.
- Clear documentation of data flows, transformations, and business rules.
What Success Looks Like
- Success in this role means that stakeholders can confidently understand where reporting data originates, how it is transformed, how it reaches the final report, and whether the underlying data is accurate and complete.
- The analyst should be able to independently investigate a data issue, trace it through the relevant data flow using SQL, identify the likely root cause, document the findings, and work with the appropriate teams toward resolution.
Regards,
Azhar Tariq
IT recruiter
ApTask is a global, diversity certified staffing and recruiting company that specializes in IT, finance and accounting, and blockchain developer placements.
Fintech Consulting LLC DBA ApTask
Connect: Azhart@aptask.com
Address: 120 Wood Ave South, Iselin, NJ 08830
| 
| 
|
| 
Candidate Data Collection Disclaimer:
At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
This e-mail and any attachments may be confidential, proprietary or legally privileged. Any review, use, disclosure, distribution or copying of this e-mail is prohibited except by or on behalf of the intended recipient. If you received this message in error or are not the intended recipient, please delete or destroy the e-mail message and any attachments or copies and notify the sender of the erroneous delivery by return e-mail. It shall not attach any liability on the sender or ApTask or its affiliates. Any views or opinions presented in this email are solely those of the sender and may not necessarily reflect the opinions of ApTask or its affiliates.
