Job Overview:
Pay Range: $50hr - $55hr
Requirement/Must Have:
- Strong experience in MS SQL Server (SQL, Stored Procedures, Views, Functions, Performance Tuning).
- Proficiency in Python for data engineering and automation.
- Hands-on experience with Google BigQuery.
- Experience developing data pipelines using Google Cloud Dataflow (Apache Beam).
- Knowledge of GCP services such as Cloud Storage, Pub/Sub, Cloud Composer, IAM, and Monitoring.
- Strong understanding of ETL/ELT, Data Warehousing, and Data Modeling concepts.
- Experience with source control tools such as Git.
- Knowledge of Agile/Scrum methodologies.
Responsibilities:
- Design, develop, and maintain scalable ETL/ELT pipelines using GCP Dataflow and Python.
- Develop and optimize BigQuery datasets, tables, views, partitioning, and clustering strategies.
- Create and maintain complex SQL queries, stored procedures, functions, and database objects in MS SQL Server.
- Migrate and integrate data from on-premises databases and various source systems into GCP.
- Implement data quality, validation, reconciliation, and monitoring frameworks.
- Work with Cloud Storage (GCS), BigQuery, Dataflow, and Composer/Airflow for end-to-end data processing.
- Analyze performance bottlenecks and optimize large-scale data workloads.
- Build reusable Python components for data ingestion, transformation, and automation.
- Collaborate with business stakeholders, architects, and data analysts to understand requirements.
- Ensure data security, governance, and compliance standards are followed.
Benefits
Our Benefits Include:
- Medical, Dental, and Vision Insurance
- 401(k) Retirement Plan
- Health Savings Account (HSA)
- Disability Insurance (Short-Term and Long-Term)
- Life and AD&D Insurance
- Paid Sick Leave (where required by applicable state or local law)
- Supplemental Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Employee Wellness Programs
- Employee Assistance Program (EAP)
- Career Growth and Professional Development Opportunities
Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.
About Cynet Systems
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.
As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.