Sr. Data Warehouse Engineer

Tekniforce; North Carolina; Hybrid; USD 110,000 - 140,000; Full time

Job summary

Tekniforce in Raleigh, North Carolina is seeking a Sr. SQL Developer to design, optimize, and expand data workflows within our enterprise data environment.

You will work on EDW improvements, data marts, ETL/ELT processes, and collaborate with governance and security teams in a hybrid, full-time role. The ideal candidate has 8+ years of data engineering or related experience, advanced SQL skills, and a solid grasp of data warehousing and modeling.

Qualifications

• 8+ years of experience in data engineering, ETL/ELT development, or database administration.
• Insurance industry experience preferred.
• Advanced SQL knowledge and experience with relational databases.
• Strong understanding of data warehouse, data lake, and data modeling concepts.
• Experience optimizing SQL queries and database performance.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently while collaborating with cross-functional teams.
• BA/BS degree in Data, Computer Science or related field.

Responsibilities

• Design, develop, and optimize scalable ETL/ELT processes to support data integration.
• Collaborate with data analysts and business stakeholders to understand data requirements.
• Work independently on assigned projects to support business initiatives within agile delivery teams.
• Ensure data quality and consistency by identifying and resolving data integrity issues.
• Implement and monitor data governance, security, and compliance policies.
• Support performance tuning of SQL queries and database structures.
• Automate data workflows and improve monitoring and alerting processes.
• Troubleshoot and resolve complex data pipeline and infrastructure issues.
• Document and standardize best practices for data engineering processes.

Skills

Advanced SQL

ETL/ELT development

Data warehousing

Data modeling

Performance tuning

Data governance security

Agile delivery

Communication

Education

BA/BS in Data or Computer Science

Job description

We are looking for a Sr. SQL Developer. This is a hybrid, full-time permanent hire position in Raleigh, North Carolina with our client. In this role as a Sr. SQL Developer, you will be responsible for complex data workflows, optimization, and data modeling. As a Sr. SQL Developer, you will be improving the Enterprise Data Warehouse (EDW), building out new data marts for business, refining ETL/ELT processes, and working more closely with data governance, performance tuning, and automation. Sorry no visa transfer or sponsorship available at this time.

Responsibilities as a Sr. SQL Developer:

• Design, develop, and optimize scalable ETL/ELT processes to support data integration
• Collaborate with data analysts and business stakeholders to understand data requirements
• Work independently on assign projects to support business initiatives within agile delivery teams
• Ensure data quality and consistency by identifying and resolving data integrity issues
• Implement and monitor data governance, security, and compliance policies
• Support performance tuning of SQL queries and database structures
• Automate data workflows and improve monitoring and alerting processes
• Troubleshoot and resolve complex data pipeline and infrastructure issues
• Document and standardize best practices for data engineering processes

Required skills and qualifications as a Sr. SQL Developer:

• 8+ years of experience in data engineering, ETL/ELT development, or database administration
• Insurance industry experience preferred
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Solid understanding of data warehouse, data lake, and data modeling concepts
• Experience optimizing SQL queries and database performance
• Strong analytical, problem-solving, and communication skills
• Ability to work independently while collaborating with cross-functional teams
• BA/BS degree (Data, Computer Science or other related field of study preferred)