> Markdown version of [/jobs/ext/2243007-advanced-sql-developer-data-engineer-python-snowflake-bi-mclean-va-onsite](https://www.wearedevelopers.com/jobs/ext/2243007-advanced-sql-developer-data-engineer-python-snowflake-bi-mclean-va-onsite). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Advanced SQL Developer / Data Engineer (Python, Snowflake, BI) - McLean VA (Onsite)

- **Company:** Lorven Technologies Inc
- **Location:** McLean, VA, United States
- **Salary:** $128,590.0 - $180,783.0
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Airflow, Amazon Web Services, Business Analytics Applications, Data Analysis, Microsoft Azure, Business Intelligence Development, Big Data, Code Review, Databases, Continuous Integration, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Migration, Data Mining, Data Warehousing, Relational Databases, Database Design, Database Development, Database Security, DevOps, Disaster Recovery, Revision Control Systems, Python (Programming Language), PostgreSQL, Machine Learning, Microsoft SQL Server, MySQL, Oracle (Applications), Performance Tuning, Scrum Methodology, Query Optimization, Power BI, SQL Stored Procedures, SQL Databases, Tableau (Software), Qliksense, Data Processing, Scripting, Freeform SQL, Azure Data Factory, Sql Optimization, Snowflake, Database Optimization, Apache Spark, Database Performance, Indexer, Git, Data Lakes, Pyspark, Information Technology, DataFlux, Performance Monitor, Qlikview, Data Management, Looker Analytics, Data Pipelines, Alteryx
- **Published:** August 26, 2026
- **Apply:** https://www.careerjet.com/jobad/usc29c75458aaf4fdb66a76b9b2b2c571f

## About the Role

* Strong expertise in Advanced SQL including query optimization, indexing, partitioning, and performance tuning.
 * Hands-on experience with Snowflake Data Warehouse.
 * Proficiency in Python for data engineering and automation.
 * Experience with BI tools such as Power BI, Tableau, Qlik, or Looker.
 * Strong understanding of ETL/ELT processes and data integration.
 * Experience working with relational and dimensional data models.
 * Knowledge of cloud platforms such as AWS, Azure, or GCP.
 * Experience with version control tools such as Git.

Database Skills

 * Database design and administration.
 * Data modeling and schema design.
 * Backup and recovery management.
 * Database security and access control.
 * Performance monitoring and tuning., * Bachelor's degree in Computer Science, Information Technology, Data Science, or related field.
 * 5+ years of experience in SQL Development, Data Engineering, or BI Development.
 * Snowflake certification is a plus.
 * Experience with data orchestration tools such as Airflow, Azure Data Factory, or Informatica.
 * Knowledge of Agile/Scrum methodologies.

Key Competencies

 * Strong analytical and problem-solving skills.
 * Excellent communication and stakeholder management abilities.
 * Attention to detail and commitment to data quality.
 * Ability to manage multiple projects and priorities.
 * Continuous learning mindset and adaptability to new technologies.

Experience Required
10+ years of experience in:

 * Advanced SQL Development
 * Snowflake Data Warehousing
 * Python Programming
 * Business Intelligence Reporting
 * Database Administration & Management

Nice to Have

 * Data Lake and Big Data experience.
 * Knowledge of Spark or PySpark.
 * Experience with Machine Learning data pipelines.
 * Exposure to DevOps and CI/CD practices., Alteryx Developer (DataFlux Migration) McLean, VA 6+ months Job Summary We are seeking an experienced and meticulous Alteryx Developer to join our data engineering team…
 + 2 months ago

## Description

We are seeking a highly skilled and detail-oriented Advanced SQL Developer / Data Engineer with strong expertise in SQL, Business Intelligence (BI) tools, Python, Snowflake, and Database Management. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining enterprise data solutions, data pipelines, reporting dashboards, and database systems to support business decision-making and analytics initiatives. Key Responsibilities SQL Development & Optimization

 * Design, develop, and maintain complex SQL queries, stored procedures, functions, triggers, and views.
 * Optimize database performance through query tuning and indexing strategies.
 * Perform data extraction, transformation, and loading (ETL/ELT) activities.
 * Troubleshoot and resolve database-related issues and performance bottlenecks.

Snowflake Data Warehouse Management

 * Design and manage Snowflake data warehouse environments.
 * Develop and optimize Snowflake data models, schemas, and database objects.
 * Implement data loading, transformation, and orchestration processes.
 * Monitor Snowflake usage, performance, and cost optimization.

Python Development

 * Develop Python scripts and automation solutions for data processing and reporting.
 * Build scalable ETL pipelines using Python.
 * Perform data analysis, cleansing, validation, and transformation.
 * Integrate data from multiple sources using APIs and Python-based frameworks.

Business Intelligence & Reporting

 * Develop and maintain dashboards, reports, and visualizations using BI tools such as:

 * Power BI
 * Tableau
 * Qlik Sense/View
 * Looker (preferred)
 * Gather reporting requirements from stakeholders and translate them into actionable analytics solutions.
 * Ensure data accuracy and consistency across reporting platforms.

Database Administration & Management

 * Manage and maintain relational databases including SQL Server, Oracle, PostgreSQL, or MySQL.
 * Implement backup, recovery, security, and disaster recovery strategies.
 * Monitor database health and ensure optimal system performance.
 * Establish data governance and data quality standards.

Collaboration & Stakeholder Engagement

 * Work closely with business teams, analysts, architects, and developers.
 * Support data migration, modernization, and cloud transformation initiatives.
 * Participate in code reviews and contribute to best practices for data engineering and analytics.


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform)
- [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of)
- [Branch your database like your code:  How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)
- [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)
- [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)
- [Find a Developer Job: 12 Best Job Sites For Developers](https://www.wearedevelopers.com/magazine/165-find-a-developer-job-12-best-job-sites-for-developers)