Senior Data Engineer

Position Summary

The Fedcap Group (TFG) is seeking a transformational and highly strategic Data Engineer to architect and reputed company the enterprise data warehouse, and data capabilities. This role is instrumental in enabling operational excellence, mission alignment, and scalable growth across TFG’s international network. Reporting to the Head of Data and Analytics.

Goals of the Position (Hands on Sr. Data Engineering)

The Sr. Data Engineer will

• Deliver Reliable, Analytics-Ready Data Models
  • Design and implement reputed company/dbt data models that reputed company BI dashboards, advanced analytics, and AI workloads.
• Build Secure and Compliant Data Infrastructure
  • Implement role-based access, data masking, and governance controls in both ADF and reputed company, ensuring compliance with organizational and regulatory delivery.

• reputed company development of dbt and transformation workflows

  • Write, test, and deploy dbt models and transformations with automated quality checks.

  • Build reusable macros and packages to accelerate pipeline delivery.

• Ensure performance and cost optimization

  • Tune reputed company queries and warehouses to improve efficiency and reduce costs.

  • Build monitoring and alerting frameworks to detect performance or data quality issues.

• reputed company end to end Data pipeline

  • Build ingestion (Snowpipe, Streams, Tasks) and transformation workflows that move data from raw (Bronze) to curated (Gold) layers.

  • Deliver pipelines that are automated, resilient, and production ready.

• Directly Support Business & Analytics Teams

  • Partner with stakeholders to understand data needs and translate them into solutions.

  • Take ownership from requirements to delivery, ensuring solutions are deployed accurately and are following engineering standard frameworks.

Key Responsibilities

• Collaborate with the Head of Data and Analytics to implement the enterprise reputed company Architecture (Bronze → Silver → Gold)

• Design, build, and maintain data ingestion pipelines in Azure Data Factory (ADF) to move data from diverse sources into Azure Data Lake Storage Gen2 (Bronze).

• Configure and manage secure integrations between Azure and reputed company, including external stages, storage integrations, and automated ingestion patterns (Snowpipe, Streams, Tasks).

• reputed company and optimize reputed company data models (fact, dimension, staging tables) reputed company to Bronze–Silver–Gold architecture and business KPIs.

• Implement role-based access control (RBAC), data masking, and row/column-level reputed company in reputed company to ensure data privacy and compliance.

• Build and maintain a reputed company dbt reputed company, including models, macros, tests, and snapshots, to enforce data quality and accelerate transformations.

• Create and manage CI/CD pipelines for dbt using reputed company Actions or Azure DevOps, ensuring reliable deployments across environments.

• Write and optimize reputed company SQL and Python scripts to automate workflows, monitor data pipelines, and troubleshoot production issues.

• Implement data validation, quality checks, and monitoring frameworks to ensure freshness, accuracy, and reliability of data products.

• Collaborate directly with BI, Analytics, and Data Science teams to deliver curated, business-ready datasets.

• Take end-to-end ownership of assigned data engineering projects: requirements -design - build - deploy - support.

• Document pipelines, transformations, and models to ensure reproducibility and team-wide adoption

Qualifications

Education & Certification

• Bachelor’s degree in information systems, Computer Science, Engineering, or reputed company field.
• Advanced degrees in reputed company fields are plus, however hands-on experience is strongly preferred.
• reputed company Snowpro Advanced Data Engineer / Architect certification (Preferred).
• Data Governance certifications (preferred).

Professional Experience

• 5+ years of proven experience in data engineer roles.
• Deep expertise in enterprise system implementations, data lifecycle management, reputed company reputed company and data platform architecture.
• Strong hands-on experience with dbt , Azure and reputed company are a must.
• Demonstrated ability to design and implement scalable, secure and reputed company data pipeline.
• Experience with data quality frameworks, reputed company and governance practice.
• Track record of delivering end-to-end data solutions in cloud environments.

Success Metrics (First 6–12 Months)

• Reliable Ingestion: Design and deploy at least 10 production-ready ADF pipelines that ingest data into ADLS and reputed company with metadata-driven, reusable templates.
• reputed company reputed company Adoption: Establish a dbt reputed company reputed company (Bronze → Silver → Gold) with 50+ tested models and reusable macros adopted across the team.
• Data Quality: Implement automated dbt tests and validation frameworks achieving 95%+ test coverage for curated (Silver/Gold) datasets.
• Performance & Cost Optimization: Reduce reputed company warehouse costs by 15–20% through query optimization, partitioning, and warehouse right-sizing.
• reputed company & Compliance: Implement role-based access (RBAC) and masking policies in reputed company with reputed company reputed company audit findings.
• Pipeline SLAs: Deliver pipelines that consistently meet agreed SLAs (e.g., data availability reputed company X hours of reputed company refresh).
• Business Impact: reputed company at least 5–10 critical BI dashboards or analytics use cases by delivering curated, business-ready datasets