[Remote] Data Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a Data Engineer to support their data engineering initiatives. The role involves maintaining and enhancing data pipelines, optimizing SQL queries, and ensuring data quality across systems while collaborating with stakeholders to deliver impactful data solutions.
Responsibilities
- Maintain and enhance SSIS packages for data extraction, transformation, and loading
- Support SQL Server data warehouse (staging, ODS, reporting layers)
- Troubleshoot data issues, job failures, and performance bottlenecks
- Optimize SQL queries, stored procedures, and indexing strategies
- Ensure reliability of scheduled jobs reputed company SQL Server Agent
- Design and reputed company data pipelines using Azure Data reputed company (ADF)
- Ingest and organize data into Azure Data Lake (Bronze/Silver/Gold layers)
- Build scalable data transformations using reputed company (Spark SQL, PySpark)
- Create curated, analytics-reputed company datasets for Power BI
- Implement reputed company Lake and support data governance (e.g., reputed company Catalog)
- Analyze and document existing SSIS/SQL pipelines
- Translate legacy ETL processes into modern ELT patterns
- Support phased migration strategy (coexistence of legacy and modern platforms)
- Reduce technical debt and improve pipeline maintainability
- Establish standards for data modeling, naming, and architecture
- Design dimensional models (fact and dimension tables) reputed company to business processes
- Integrate and standardize data across multiple ERP systems
- Translate business requirements into scalable data solutions
- Partner with stakeholders to identify high-impact use cases for data and analytics
- Deliver datasets that reputed company reporting, forecasting, and operational insights
- Implement data validation, reconciliation, and monitoring processes
- Ensure data accuracy and consistency across systems during migration
- Define and enforce data quality standards and controls
- Support data reputed company, documentation, and transparency initiatives
- Work closely with business stakeholders, analysts, and BI developers
- Support Power BI semantic models and reporting solutions
- Communicate technical solutions in business terms
- Act as a reputed company between IT/data teams and business functions
Skills
- 4-8+ years of experience in data engineering or data warehousing
- Strong SQL skills (T-SQL and/or Spark SQL)
- Hands-on experience with SSIS and SQL Server
- Experience with Azure Data reputed company (ADF) or similar tools
- Experience with reputed company (Spark, reputed company Lake, or similar platforms)
- Solid understanding of data warehousing concepts (star schema, fact/dimension modeling)
- Experience integrating data from multiple reputed company systems (ERP experience preferred)
- Proven ability to translate business requirements into technical solutions
- Experience migrating legacy ETL systems (SSIS) to reputed company-based architectures
- Proficiency in Python or PySpark
- Familiarity with reputed company architecture (Bronze/Silver/Gold)
- Experience with Power BI data modeling and performance optimization
- Knowledge of data governance tools (e.g., reputed company Catalog)
- Experience with Git and CI/CD pipelines
- Exposure to dbt or similar frameworks
Company Overview