Job Description
Position Overview:
We are seeking a skilled and motivated Data Engineer / Database Engineer to support our
growing team providing an enterprise data warehouse and visualization environment. The
ideal candidate will have hands-on experience with Microsoft SQL Server, ETL pipelines,
and cloud-based data ingestion tools-especially AWS Glue. You will be responsible for
maintaining and enhancing our database systems, enabling near real-time data pipelines
from source databases (Oracle, SQL, etc) to Microsoft SQL Server, and ensuring secure,
efficient, and scalable data access.
Key Responsibilities:
Support and maintain Microsoft SQL Server environments, with flexibility to adapt to
alternative database platforms as the architecture evolves.
Design and implement data pipelines using AWS Glue for efficient and scalable data
ingestion.
Build and maintain a near real-time data ingestion framework from Oracle
databases to Microsoft SQL Server.
Develop and manage ETL processes, including incremental/delta-based extraction
of raw data from source systems.
Build and optimize relational database schemas, ensuring performance, scalability,
and data integrity.
Implement and manage fine-grained roles and permissions in SQL Server to enforce
data security and access control policies.
Work closely with Data Analysts, Software Engineers, and other stakeholders to
ensure data systems meet business requirements.
Monitor and troubleshoot data pipelines and workflows to ensure reliability and
consistency.
Required Skills
Qualifications:
Proven experience with Microsoft SQL Server administration and development.
Proficiency in ETL/ELT concepts and experience with tools like AWS Glue, Apache
Spark, or equivalent.
Solid understanding of Oracle database systems and data extraction methodologies
(especially delta/change data capture techniques).
Experience with cloud data platforms, particularly AWS (S3, Glue, RDS, etc.).
Strong SQL skills and experience with role-based access control in database
systems.
Familiarity with scripting or programming languages (e.g., Python, Shell) for
automation and data processing.
Ability to work independently and communicate effectively in a collaborative team
environment.
Desired Skills
Preferred Skills (Not Required):
Proficiency with Oracle GoldenGate or equivalent CDC (Change Data Capture) tools
for real-time replication.
Experience with modern data architectures (e.g., Data Vault 2.0).
Knowledge of CI/CD practices for data engineering.
Exposure to data cataloging and metadata management tools.
Additional Details
Crimson Phoenix considers people our most important asset. Our goal is to attract, retain, and motivate exceptional individuals from every background who share our commitment to the customer, our passion for the mission, our delight for innovation, and our determination to achieve excellence in everything we do.
We offer phenomenal benefits to our employees, allowing them to focus on the mission, knowing that Crimson Phoenix is focused on them!
Compensation & Benefits: This position has an anticipated salary range of $127,399-$196,000 per year. Actual compensation will be determined based on factors including experience, qualifications, skills, education, certifications, and business needs. Crimson Phoenix offers a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) with company match, generous paid time off, company-paid life and disability insurance, tuition reimbursement, professional development opportunities, employee recognition programs, and a culture that supports continuous learning and career growth.
Click APPLY to be contacted about this position and find out more details.
We are a small, growth-oriented, federal contractor that delivers professional services in support of the Intelligence & Federal Community. Located outside of Washington D.C., we are a fast-paced group due to the customers' diversity, types of projects, environments, and roles we support. To learn more, please visit ;br>
Crimson Phoenix is an Equal Opportunity and Affirmative Action Employer. We welcome and encourage diversity in our workforce.
It is the policy of Crimson Phoenix to provide equal employment opportunity to all employees and qualified applicants without regard to race, color, religion, national origin, sex, age, disability, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected characteristic under federal, state or local law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10441024
- Position Id: 8bf7e8dac715801e0b66b80ad708aab0
- Posted 30+ days ago
Never miss an opportunity! Create an alert based on the job you applied for.
