Data Engineer Consultant

LanceSoft Inc

CA(remote)

Apply

JOB DETAILS

SALARY

JOB TYPE

Full-time

SKILLS

Analysis Skills, Best Practices, Cloud Computing, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cost Effectiveness Analysis, Cross-Functional, Data Analysis, Data Management, Data Modeling, Data Quality, Data Science, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Engineering Consulting, GitHub, International Operations, Maintain Compliance, Multitasking, Performance Analysis, Performance Management, Performance Tuning/Optimization, Problem Solving Skills, Quality Assurance, SQL (Structured Query Language), Scalable System Development, Snowflake Schema, Source Code/Configuration Management (SCM), Star Schema, Team Player, Test Automation, Testing, Usability Engineering, Validation Testing

LOCATION

POSTED

30+ days ago

Pay Rate: $85/hr Title: Data Engineer Consultant Location: Remote US Duration: 6 months JOB DESCRIPTION Job Title: Data Engineer Consultant 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. 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. 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. Strong communication skills for cross-functional collaboration. Ability to work independently and manage multiple priorities. Why Join Us? Work on high-impact projects that shape global operations and decision-making. Collaborate with a world-class data team using modern tools and methodologies. Opportunity to innovate and influence data engineering standards and practices.

About the Company

LanceSoft Inc

We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc).

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.

COMPANY SIZE

2,000 to 2,499 employees

INDUSTRY

Staffing/Employment Agencies

FOUNDED

2000

WEBSITE

http://www.lancesoft.com/

Resume Resources

Free Resume Templates Free Resume Builder