LanceSoft, Inc. ยท 2 months ago
Data Engineer Consultant
Varies, CA
Full-time
Hybrid
Mid LevelLanceSoft, Inc. is seeking a highly skilled Data Engineer Consultant to design, build, and optimize scalable data pipelines that power advanced analytics and business insights. The role involves collaborating with cross-functional teams and leveraging cutting-edge tools to ensure data integrity, performance, and usability across the organization.
Information Technology
Responsibilities
Architect and maintain robust, automated pipelines for ingesting, transforming, and delivering data from diverse sources using modern ELT frameworks
Develop modular, reusable, and well-documented transformations in DBT, ensuring adherence to best practices for maintainability and scalability
Manage code repositories in GitHub, implement branching strategies, and contribute to automated testing and deployment workflows
Write optimized, complex SQL queries leveraging Common Table Expressions (CTEs) and window functions to improve clarity and performance
Design and implement dimensional models, star schemas, and dynamic tables to support analytics and reporting needs
Continuously monitor and tune data pipelines for efficiency, scalability, and cost-effectiveness in cloud environments (e.g., Snowflake)
Build robust testing frameworks for data validation, schema checks, and transformation accuracy to ensure reliability
Maintain comprehensive documentation of data flows, models, and processes to promote transparency and knowledge sharing
Work closely with data scientists, analysts, and business stakeholders to understand requirements and deliver high-quality solutions
Qualification
Required
Design, build, and optimize scalable data pipelines
Collaborate with cross-functional teams
Ensure data integrity, performance, and usability
Architect and maintain robust, automated pipelines for ingesting, transforming, and delivering data
Develop modular, reusable, and well-documented transformations in DBT
Manage code repositories in GitHub and implement branching strategies
Write optimized, complex SQL queries leveraging Common Table Expressions (CTEs) and window functions
Design and implement dimensional models, star schemas, and dynamic tables
Continuously monitor and tune data pipelines for efficiency, scalability, and cost-effectiveness
Build robust testing frameworks for data validation, schema checks, and transformation accuracy
Maintain comprehensive documentation of data flows, models, and processes
Work closely with data scientists, analysts, and business stakeholders
Preferred
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
Excellent problem-solving and analytical abilities
Strong communication skills for cross-functional collaboration
Ability to work independently and manage multiple priorities
Company
LanceSoft, Inc.
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele.
Founded in 2000
5001-10000 employees
H1B Sponsorship
LanceSoft, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (55)
2024 (32)
2023 (23)
2022 (25)
2021 (60)
2020 (80)
Funding
Current Stage
Late StageLeadership Team
Ram Karuppusamy
Chairman & CEO
Simon Dealy
Chief Financial Officer
Company data provided by crunchbase