Data Engineer
Washington, DC - Remote
Full Time Senior-level / Expert Clearance required USD 100K
We are looking for a Data Warehouse Engineer who has experience in data warehousing, data modeling, and database administration of highly scalable data management systems.
Possesses a proven track record of successfully managing large datasets and delivering scalable data warehousing solutions.
Assignments may be broad in nature, requiring originality and innovation in determining how to accomplish tasks.
Mechanicode is a remote-first company, and this role will be 100% remote.
W2-Salary: 100-110k
Required
- Must be a U.S citizen or green-card holder
- 5+ years of professional experience
- Ability to pass a background check and obtain a public trust security clearance
Essential Skills, Experience, and Competencies:
- Proficient with Python
- Proficiency in SQL and familiarity with data warehousing technologies such as Oracle, SQL Server, Snowflake, or AWS Redshift.
- Strong knowledge of database management, data modeling, and ETL processes.
- Develop ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized data warehouse.
- Develop and optimize complex SQL queries to extract insights and support business decisions.
- Create reports and visualizations that make data accessible and understandable to non-technical stakeholders.
- Ability to analyze complex data sets to identify trends, patterns, and anomalies.
- Develop database solutions to store and retrieve client data, ensuring system scalability, security, performance, and reliability.
- Experience working with cloud providers like AWS or Azure.
- Expert in basic git actions like cloning, creating branches, navigating between branches, staging code for commit, committing code, resetting, and merging.
- Proven ability to work under pressure and in fast-paced environments.
Nice to Have
- AWS/Azure Certifications
Interview Steps
- Preliminary Technical Screen
- Hackerrank
- Hackerrank Review
- Client Interview
Why Mechanicode?
Mechanicode’s vision is to bring peace of mind with technology.
We do so by building self-healing cloud infrastructure, resilient enough to withstand failures and sufficiently predictable to resolve issues without human intervention.
We do that by having automation as the cornerstone of our cloud solutions, significantly improving workforce attrition, and introducing agile rapid development conventions that improve the developer's experience
About Mechanicode
Mechanicode a Cloud Digital services firm providing comprehensive DevSecOps, Cloud Native Engineering, IT Modernization & Automation services.
Founded by a former USDS engineer, Mechanicode has 13 years of experience developing innovative automation solutions improving the feedback loop in the developer experience, and using AWS/Azure Certified best practices for clients.
Mechanicode has experience in both the public and private sectors, providing modernization services that engage Agile best practices, scalable cloud architectures, and continuous integration & deployment standards.
Tags: Agile Architecture AWS Azure Data management Data warehouse Data Warehousing Engineering ETL Git Oracle Python Redshift Security Snowflake SQL
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Business Intelligence Engineer jobs
- Open Data Engineer II jobs
- Open Lead Data Analyst jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Principal Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Junior Data Engineer jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Data quality-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open NLP-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Consulting-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Data warehouse-related jobs