Summary
We are seeking an experienced Analytics Engineer to join our Data Management team. In this role you will be responsible for designing building and maintaining data transformation pipelines that convert raw data into actionable wellmodeled datasets for business intelligence reporting and advanced analytics. Working closely with software engineerswho manage data ingestion and the underlying data platformand other stakeholders you will empower our organization with reliable highquality data products. This role bridges the gap between raw data and meaningful insights ensuring our data ecosystem supports strategic decisionmaking.
Essential Duties and Responsibilities include the following. Other duties may be assigned.
- Design develop and maintain scalable transformation pipelines that shape raw data into structured analyticsready models using SQL Python and modern data orchestration tools.
- Collaborate with data analysts data scientists and business stakeholders to define and implement target data models that meet analytical and reporting needs.
- Capture data quality rules and implement testing frameworks (e.g. data validation unit tests) to ensure the reliability integrity and correctness of transformed data.
- Create and maintain clear documentation of data models transformation logic and pipeline processes to support team collaboration and knowledge sharing.
- Stay current with industry trends and tools advocating for best practices in data transformation version control (e.g. Git) and analytics engineering workflows.
- Monitor pipeline performance and troubleshoot issues in collaboration with data platform engineers ensuring seamless data flow from ingestion to analytics.
Qualifications:
- 46 years of experience in analytics engineering data engineering or a related role with a strong focus on data transformation and modeling.
Technical Skills:
- Proficiency in SQL for querying and transforming large datasets.
- Experience with data transformation tools like dbt (data build tool) or similar.
- Familiarity with Python or another scripting language for pipeline development.
- Knowledge of data orchestration platforms (e.g. Apache Airflow Prefect).
- Experience with modern data platforms (e.g. Databricks Snowflake BigQuery).
- Proficiency in data warehousing techniques (star schema data vault 2.0
- Experience with version control systems (e.g. Git).
- Ability to translate business needs into technical data models and transformation workflows.
- Proven ability to work crossfunctionally with software engineers analysts and business stakeholders in a fastpaced environment.
- Strong focus on data quality testing and documentation to ensure trustworthy outputs.
- Comfortable troubleshooting complex data issues and optimizing performance.
What We Offer
- Great Place to Work Certified: Join a team recognized for an environment of innovation and growth.
- Collaborative & Inclusive Culture: Work alongside smart passionate peers who value ownership and continuous learning.
- Modern Work Environment: Enjoy a stateoftheart office in Raleighs North Hills combined with a hybrid work model that balances teamwork and flexibility.
- Competitive Compensation & Benefits: Comprehensive healthcare 6 401k matching generous PTO (including floating holidays) and One Pass for fitness subscriptions.
- Community & Giving: Benefit from 50 charitable gift matching and paid volunteer time to support nonprofit causes.
Required Experience:
Senior IC