Dbt Data Engineer Jobs in Raleigh, NC (NOW HIRING)

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility.

Job Summary

Responsibilities

Strategic Leadership & Governance

• Set the vision and strategy for data initiatives across key product teams, including Enterprise Reporting, Ceded Reinsurance, and Actuarial IT.
• Partner with senior business stakeholders to align data initiatives with enterprise goals.
• Lead cross-functional agile teams to deliver high-quality data products and platforms that create business value.

Data Platform Oversight

• Lead the roadmap, architecture, and lifecycle management of enterprise data platforms, including Snowflake-based data lakes, data warehouses, and Azure pipelines.
• Ensure reliable development, deployment, and support of ETL/ELT frameworks using tools such as Snowflake, DBT, Databricks, Python, Qlik, Airflow, and ADF.

Business Intelligence & Reporting

• Lead strategy and development for Sigma, Power BI, SSRS, and dashboarding solutions.
• Partner with business teams to deliver actionable insights, self-service reporting, and financial and statutory reporting support.

Enterprise Data & Reporting Support

• Provide strategic and technical leadership for teams supporting enterprise reporting and data, actuarial modeling, reserving data flows, and ceded reinsurance data provisioning.
• Ensure timely, accurate, and audit-ready data for reporting platforms, actuarial processes, and reinsurance calculations and reporting.

Program Management & Delivery

• Lead multiple delivery teams across the U.S. and offshore locations, maintaining sprint velocity and roadmap execution.
• Ensure delivery complies with SOX, SOC 2, and NYDFS requirements.
• Manage vendor relationships, contract negotiations, and budget planning.

Innovation, Modernization & Quality

• Promote modern agentic AI, DevOps, CI/CD, Git, and orchestration practices across data engineering and reporting pipelines.
• Drive innovation in AI/ML, data observability, and self-service capabilities to improve business outcomes.
• Ensure strong documentation, test coverage, and audit trails across data processes and platforms.

Skills & Experience

• 12+ years of experience in data platforms, data engineering, and business intelligence.
• 7+ years of leadership experience managing multidisciplinary teams across data engineering, reporting, actuarial data, or reinsurance.
• Strong experience in insurance (P&C), finance, actuarial, or risk domains is highly preferred.
• Deep knowledge of cloud technologies, especially Azure and Snowflake, with familiarity in Power BI, SSIS, and SSRS.
• Must demonstrate strong proximity to delivery (not just oversight), including ability to review code, guide engineering teams on "how to build," and step in to course-correct technical execution when needed.
• Proven experience engaging directly with SVP-level stakeholders to drive and negotiate requirements, with accountability for outcomes rather than operating as a downstream delivery partner.
• Working, hands-on proficiency in Python within data engineering contexts, with the ability to apply it in pipelines or guide teams in its practical use (not just theoretical exposure)
• Experience with regulatory compliance and audit standards, including SOX, SOC 2, and NYDFS.
• Proven success leading large-scale data transformation programs and cross-functional delivery teams.
• Ability to mentor senior managers, architects, and subject matter experts, with strong stakeholder management and influencing skills.
• Demonstrated experience building data capabilities and tools to support analytics, research, and actuarial functions in an insurance environment.
• Strong proficiency in SQL, Python, or similar programming languages.
• Experience with orchestration tools such as Airflow.
• Experience with cloud platforms and tools such as Snowflake and Databricks.
• Ability to work independently while managing priorities and collaborating across teams.
• Excellent collaboration and relationship-building skills.
• Comfort with ambiguity and the ability to break complex problems into manageable steps.
• Strong analytical skills and the ability to derive insights from data.
• Strong problem-solving and critical-thinking skills.
• Excellent verbal and written communication skills, with the ability to tailor messages for technical and non-technical audiences, including senior executives.
• Flexibility to adapt to changing priorities and requirements.
• Ability to lead and mentor mid-level and junior team members in delivering high-quality solutions to complex business challenges.
• Curiosity and creativity in exploring modern technologies and new data sources.
• Ability to document data sources and technical solutions effectively.
• Ability to balance competing priorities across portfolios and resources.
• Ability to build strong partnerships across the organization to support strategic goals.
• Commitment to continuously improving team capabilities and workflows.

Education

• Master's or Bachelor's degree in computer science, data science, or a related field is required.

#LI-Hybrid
#LI-ZP1

For individuals assigned or hired to work in the location(s) indicated below, the base salary range is provided. Range is as of the time of posting. Position is incentive eligible.

For Jersey City: $148,400 - $230,322/year

For Hartford: $133,500 - $207,289/year

• Total individual compensation (base salary, short & long-term incentives) offered will take into account a number of factors including but not limited to geographic location, scope & responsibilities of the role, qualifications, talent availability & specialization as well as business needs. The above pay range may be modified in the future.

• Arch is committed to helping employees succeed through our comprehensive benefits package that includes multiple medical plans plus dental, vision and prescription drug coverage; a competitive 401k with generous matching; PTO beginning at 20 days per year; up to 12 paid company holidays per year plus 2 paid days of Volunteer Time Offer; basic Life and AD&D Insurance as well as Short and Long-Term Disability; Paid Parental Leave of up to 10 weeks; Student Loan Assistance and Tuition Reimbursement, Backup Child and Elder Care; and more. Click here to learn more on available benefits.

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you.If this job isn't the right fit but you're interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch's Talent Acquisition team.