Job Url: https://www.linkedin.com/jobs/search/?currentJobId=4326822058&distance=25.0&f_AL=true&f_TPR=r86400&f_WT=2&geoId=103644278&keywords=software%20engineer&origin=JOB_SEARCH_PAGE_JOB_FILTER&spellCorrectionEnabled=true&start=100 Job Description: Apps IT Limited Share Show more options Sr Data Engineer  United States · 17 minutes ago · 6 applicants Promoted by hirer · Company review time is typically 1 week Remote Matches your job preferences, workplace type is Remote. Contract Easy Apply Save Save Sr Data Engineer  at Apps IT Limited Sr Data Engineer Apps IT Limited · United States (Remote) Easy Apply Save Save Sr Data Engineer  at Apps IT Limited Show more options Job match summary not available This job post doesn't have enough information to generate a match summary. Get personalized tips to stand out to hirers Practice mock interviews personalized to every role and get custom feedback Try Premium for PKR0 Meet the hiring team Tahura Khatoon 3rd Sr Delivery Consultant Job poster Message About the job APPS IT is looking for Sr Data Engineer Consultant-Remote opportunity! Job Title: Sr Data Engineer Location: Remote Duration: 6+ months (Possible extension) Overview: We are seeking a highly skilled Data Engineer Consultant to design, build, and optimize scalable data pipelines that power advanced analytics and business insights. This role is ideal for someone passionate about transforming raw data into actionable intelligence through modern data engineering practices. You will collaborate with cross-functional teams, leverage cutting-edge tools, and ensure data integrity, performance, and usability across the organization. Role Expectation: The project requires reviewing the existing layers of Views in the data warehouse and convert them to materialized tables and convert the view logic into ELT pipelines. Reverse engineering the views, modeling the tables and then building the load process is central to the success of the project Preferred Qualifications: Technical Skills: •Proficiency in SQL, DBT, and GitHub workflows. •Experience with Snowflake or similar cloud data warehouses. •Familiarity with Fivetran or other ingestion tools. •Strong understanding of data modeling principles and ETL/ELT best practices. Soft Skills: •Excellent problem-solving and analytical abilities. •Ability to work independently and manage multiple priorities. Key Responsibilities: • Data Pipeline Development: Architect and maintain robust, automated pipelines for ingesting, transforming, and delivering data from diverse sources using modern ELT frameworks. • DBT Expertise: Develop modular, reusable, and well-documented transformations in DBT, ensuring adherence to best practices for maintainability and scalability. • Version Control & CI/CD: Manage code repositories in GitHub, implement branching strategies, and contribute to automated testing and deployment workflows. • Advanced SQL Engineering: Write optimized, complex SQL queries leveraging Common Table Expressions (CTEs) and window functions to improve clarity and performance. • Data Modeling: Design and implement dimensional models, star schemas, and dynamic tables to support analytics and reporting needs. • Performance Optimization: Continuously monitor and tune data pipelines for efficiency, scalability, and cost-effectiveness in cloud environments (e.g., Snowflake). • Testing & Quality Assurance: Build robust testing frameworks for data validation, schema checks, and transformation accuracy to ensure reliability. • Documentation & Standards: Maintain comprehensive documentation of data flows, models, and processes to promote transparency and knowledge sharing. • Collaboration: Work closely with data scientists, analysts, and business stakeholders to understand requirements and deliver high-quality solutions.