Senior Data Engineer (Data Services)

Join the True Rx Health Strategists Team as a Senior Data Engineer!

Are you an experienced Senior Data Engineer ready to take your skills to the next level? We are looking for a passionate and talented Senior Data Engineer to join our Data Services Team and help us shape the future of data-driven initiatives! If you’re eager to tackle challenging data architecture problems, work with cutting-edge AWS technologies, and lead impactful data solutions, we want to hear from you!

As a Senior Data Engineer, you will play a pivotal role in ensuring efficient and high-quality data delivery for ongoing projects. You will collaborate with developers, architects, and analysts to design robust data models and optimize data flows, all while driving cross-functional team success. Your expertise will support our organization's data transformation journey, making a real difference to the way data is utilized across projects.

100% remote with expectations of in-office as   needed for meetings and trainings

What You’ll Do:

• Data Modeling & Architecture: Craft and implement scalable AWS-based data models to streamline data conversion, reconciliation, and error handling.
  • Data Analysis & Quality: Dive into complex data to identify and resolve anomalies while aligning processes with business goals.
  • Database & Query Optimization: Fine-tune SQL queries, scripts, and stored procedures in AWS RDS (PostgreSQL, MySQL, SQL Server) to ensure peak performance.
  • Performance Tuning & Troubleshooting: Monitor and optimize ETL and SQL performance, providing expert troubleshooting and root-cause analysis.
  • Collaboration & Stakeholder Engagement: Partner with stakeholders, product managers, and QA teams to validate requirements and deliver on business objectives.
  • Data Pipelines & Integration: Design, build, and optimize seamless data pipelines and integrations.
  • Testing & Documentation: Ensure data accuracy with rigorous validation, thorough documentation of ETL processes, and clear technical specs, including ER diagrams.
  • Team Leadership: Offer guidance and mentorship to fellow data engineers, sharing your expertise to foster continuous improvement.

What You Bring:

• Data Modeling & Warehousing Expertise: 4+ years working with Star & Snowflake schemas and data normalization.
  • ETL & Transformation Mastery: Hands-on experience with tools like Informatica, Talend, or SnapLogic (4+ years).
  • AWS Expertise: In-depth knowledge of AWS services like S3, EC2, CloudWatch, SNS, and RDS; bonus points for Azure/GCP experience.
  • Advanced Database Skills: 5+ years with Oracle, MS SQL, NoSQL (DynamoDB/MongoDB), Snowflake; deep expertise in SQL optimization and schema design.
  • Programming Savvy: Strong SQL and Python skills, plus experience with Spark and SparkSQL.
  • Problem Solver & Communicator: A self-starter with exceptional analytical, problem-solving, and communication abilities. You thrive in collaborative environments and can pivot quickly to meet project needs.
  • Industry Knowledge: Experience in BI, data warehousing, or healthcare/PBM is a plus!

 True Rx Health Strategist Benefits:

• Path to Wellness: Health, Vision, & Dental Insurance, Health Savings Account, and Wellness Incentives for a balanced life.
• Financial Fitness: 401k Matching and Employer-Provided Life Insurance to secure your future.
• Work-Life Harmony: Flex Time, Hybrid/Fully Remote Work, Paid Time Off, and 8 Paid Holidays for a well-rounded lifestyle.

Our Story:
We’ve been pharmacy innovators since the Wright Brothers took flight. For more than 120 years, we have been innovating pharmacy solutions and taking care of patients. True Rx Health Strategists is led by a fourth generation of pharmacists. We are family-owned and continue to provide caring service for clients and patients. Our team of pharmacists and strategists delivers proven programs that find maximum savings and minimum disruption by creating a benefits plan that fits the unique needs of clients and patients. Learn more about us here.

Our Mission:

True Rx Health Strategists cultivates health, integrity, innovation, and care to transcend pharmacy benefit solutions for employers and patients.

Learn more about our remarkable team members.

Our Promise:

As a pharmacist-led company, True Rx Health Strategists has an oath to treat members as patients. With our experience as health care providers, we protect companies against waste in health care spending and work hard to improve the health of employees every day. We get to improve lives by treating employees as our patients. Here are a few words from one of those lives.

True Rx Health Strategists hires equally for culture fit and technical skills and experience. If you have the aptitude and attitude, we can help you grow your career through training, mentoring, increasing responsibility, and being around other rock star team members.
 
True Rx Health Strategists is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, age, status as a protected veteran, among other things, or status as a qualified individual with disability.