Data Engineer

Your Next Career Move Starts Here! The Role: Data EngineerLocation: Raleigh, NCType: Permanent roleWhat You'll Do: Our client is looking for a Data Engineer to join their team and support existing data warehouse systems. This role will initially focus on the client's on-premises environment, working with legacy systems, SQL Server, and established data processes. The ideal candidate enjoys working hands-on with data, investigating complex data structures, and developing a strong understanding of existing systems.A key focus of this position will be data warehousing and dimensional modeling, including slowly changing dimensions. Insurance or financial services experience is beneficial, particularly experience working with claims data. This is an opportunity for someone who enjoys solving data challenges, learning established systems, and contributing to longer-term cloud modernization efforts.Required Qualifications: Strong hands-on experience with SQL and SQL Server, including writing complex queries, analyzing large datasets, investigating data discrepancies, and troubleshooting data-related issues.Deep understanding of data warehousing concepts, dimensional modeling, and database design.Experience designing, developing, maintaining, or troubleshooting slowly changing dimensions, including Type 1 and Type 2 implementations.Experience working with dimension tables, fact tables, and data structures within established or legacy data warehouse environments.Knowledge of logical and physical data modeling, data relationships, data structures, and database design principles.Experience with ETL processes, data integration, data transformation, and data quality validation.Ability to investigate existing data processes, understand how data moves between systems, and identify opportunities to improve accuracy and reliability.Experience maintaining and supporting legacy systems, with the ability to learn existing architecture and processes before implementing changes.Insurance, claims, or financial services experience preferred. Property and casualty insurance experience is beneficial but not required.Familiarity with Snowflake and AWS is a plus, particularly as the organization prepares for future cloud migration efforts.Strong analytical and problem-solving skills, with attention to detail and a genuine interest in digging into complex data and understanding how it works.Ability to document processes, communicate findings, collaborate with technical and business stakeholders, and support knowledge transfer.Willingness to learn existing systems from experienced team members and help ensure continuity as responsibilities transition. Why Golden Technology? Founded in 1997, Golden Technology has grown from a two-person vision into a trusted partner for Fortune 500 clients nationwide. Along the way, we've built a culture centered on family, professional growth, and giving back to our communities through our Golden Community initiatives. Here's what sets us apart: Family-first culture that values balance and support. Career development through mentorship, opportunities, and investment in our people. Community impact by dedicating time, talent, and resources to the places we live and work. What's In It for You Exciting opportunities with innovative companies. Guidance from a recruiting team with decades of experience. A professional, supportive culture built on trust and collaboration. Ready to take the next step? Apply today and let's build your brighter future together.