Role & Company Overview
📋 Role Overview & Responsibilities
CNA Search is looking for a Data Engineer for a Direct Hire position. This role is in Atlanta and will be Hybrid Work Schedule. The ideal candidate should have a strong background in SQL Server. Must be US/GreenCard.
- Manage multiple enterprise databases across cloud and on-prem environments.
- Design and develop solutions to support multiple data-related functions.
- Assist development teams with database architecture to ensure models are following best practices.
- Work with stakeholders to develop a database migration strategy in-line with company’s long-term storage goals.
- Ensure data integrity and quality in database systems.
- Maintain standard policies for database development activities.
- Prepare documentation regarding database design, configuration and change management tasks.
- Mentor members of the database administrator team to manage the company databases effectively.
- Develop database functions, scripts, stored procedures and triggers to support application development and operations.
- Perform space management, archiving, partitioning and compression techniques for performance and manageability.
- Provide training aid to other teams on topics related to data management.
- Develop tools to automate database tasks such as deployments, data corrections, integrity checks, and usage statistics.
- Query optimization, including regular tuning of indexes.
- Troubleshoot SQL Server Problems as they occur (including after-hours and weekends) in relation to our in-house products.
- Use Agile development practices to refine User and Technical stories.
The database engineer will possess in-depth knowledge of our database structures, our business applications, and data flow dependencies between operational systems. This individual is a proficient coder that can work to automate routine database tasks and troubleshoot issues in high pressure business critical production environments. Bachelor’s degree in areas such as computer science, engineering or information systems5-7 years of related work experience3+ years MS SQL Server experienceExceptional T-SQL skills, specifically with the use of sub-queries, aggregate functions and joins. Deep understanding of the principles involved in a relational database (indexing, triggers, execution plans, etc.)Working with the Microsoft .NET Framework and Visual StudioWorking with RESTful applicationsExperience developing and monitoring ETL servicesFamiliarity with SSAS, SSRS, and SSIS is a plusProven background authoring and maintaining ETL jobs from various data sourcesWorking with SQL Server data-tier applications (DAC and DACPAC)Working with SaaS applications and Continuous Integration + Continuous Deployment modelScripting/Programming experience (PowerShell, Perl, Python, etc.)Strong attention to detail is a must as the job will involve lengthy operations against live production data. Accounting industry background or a willingness to procure industry knowledge through independent research.
Frequently Asked Questions
How do I apply for the Data Engineer position at CNA Search? ▼
Click the “Apply for this Position” button on this page to submit your application directly to CNA Search without recruitment intermediary fees.
Is this position eligible for remote work or visa sponsorship? ▼
This position is located in Atlanta, GA with potential relocation and sponsorship assistance depending on candidate qualifications.
Are there any candidate fees on Hirely? ▼
No. Hirely is completely free for candidates. We never charge registration fees or placement fees.
Legitimate employers will never ask you to transfer funds, purchase equipment from unauthorized vendors, or pay application/visa fees. Hirely rigorously monitors listings, but always verify communication is from official corporate email domains.
Learn how to protect yourself against employment fraud