What are the responsibilities and job description for the Data Engineer position at Clark Davis Associates?
*Must be a US Citizen or GC holder
*No C2C
Data Engineer
Position Summary
We are seeking a skilled Data Engineer to design, build, and maintain scalable data solutions that support reporting, analytics, and business intelligence initiatives. The ideal candidate has strong SQL expertise, experience with cloud-based data platforms, and a background in developing ETL/ELT pipelines and optimizing database performance.
Key Responsibilities
- Design and maintain relational databases and cloud data warehouse solutions.
- Develop and optimize advanced SQL queries, stored procedures, and data models.
- Build and automate ETL/ELT pipelines using SQL, Python, and cloud-native tools.
- Monitor and improve database performance through indexing, partitioning, and query tuning.
- Ensure data quality, integrity, and security across systems.
- Maintain technical documentation for databases, workflows, and integrations.
- Collaborate with cross-functional teams to support analytics and reporting needs.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- 5 years of experience in data engineering or database development.
- Strong SQL skills including query optimization, CTEs, and window functions.
- Experience with SQL Server, PostgreSQL, Oracle, or similar RDBMS platforms.
- Hands-on experience with Azure Data Services, Azure Data Factory, or SSIS.
- Proficiency in Python for scripting and data transformation.
- Strong analytical and problem-solving skills.
Preferred Qualifications
- Experience with NoSQL databases such as MongoDB or Cosmos DB.
- Familiarity with Spark, Kafka, or other big data technologies.
- Azure Data Engineer or related cloud certifications.
Salary : $130,000 - $140,000