Data Engineer - Mid
Crimson Phoenix
- Springfield, Missouri, United States
- Springfield, Missouri, United States
Über
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
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.
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.
Benefits
Dollar for dollar 6% 401k match, with immediate vestment
Paid Time Off (PTO)
Multiple Medical Plans from which you can choose.
Flexible Spending Account (FSA) option
Vision / Dental
Paid for Short‑term / Long‑term Disability
Paid for Group Life Insurance
Employee recognition for anniversaries, birthdays, and customer kudos!
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.
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.