Data Engineer

Overview: Have multiple concurrent initiatives, all of which requiring Data Engineering support to work closely with their Data Science team: compute infrastructure migration, tech debt reduction, expansion of tool into new use case.

2 products they develop and maintain on his team, both in support of Caremark and PBM as a business and both in support of underwriting and client consulting stakeholder:

• ACCT Price Benchmarking Tool - Suite of tools to help them understand Caremark deal values. Deals consist of ~50 parameters to define key pricing terms, driving complexity to determine whether a deal is “good” or “bad.” ACCT takes pricing components and other parameters, data from clients similar to one another, and generates a comparison.
• Excel based with a pipeline built by their data science team (unsure how specifically). Needs to be finished porting to GCP Dataflow, refine the pipeline, and a bunch of other enhancements.
• Could support new feature development once the backlog is complete.

• Data ingestion coming from 2 different sources: o A legacy system that is excel file based, parsing and scraping excel files. o EOS, modern infra with a GCP back end. Have 2 pipelines puling from both sources into GCP for unified source of truth.

• Caremark benefit engine: tool used to make recommendations for how clients could change benefit structures to achieve cost targets. How do changes affect members? How would cost structure change if parameters are updated? Overarching goal is to make it a client-facing product, rolling out 2027 (currently is only internal).
• Legacy SAS code that needs to be migrated into Python and others
• Provide support for modeling work - feature engineering, building datasets for data science teams.

Role Notes:

• Roughly 60-70% data pipeline work, 30-40% data curation, data modeling, generation of cleaned datasets for DS teams.
• Broad theme of what are data engineering support needed to make data science team effective: feature engineering that supports model builds.
• Ideal candidate would have CI/CD skills, help put deployment rails in place, becoming more organized and implement best practices around code deployment and sharing/”not deploying on someone’s laptop”
• Experience in GCP is important - BigQuery, but would consider “trade-offs” i.e. if a candidate has experience in drug claims and AWS/Azure, they may be able to ramp up more quickly and he would consider that.
• 5+ years of experience - relatively Senior level, self-starter, doesn’t need hand-holding.

Team structure:

• Team of 5 data scientists split across the 2 projects and 2 data engineers working fractionally across 5 different things. Lack of capacity is driving their gaps in data engineering workflows and pipelines.
• 2 Data Scientists on ACCT: 1 Senior, 1 relatively Junior.
• The Senior data scientist is building the data pipelines (which is out of his wheelhouse), so they are not as performant as they should be.
• Lou is the Architect for this product - not particularly deep on data engineering topics.
• Ideally this Engineer would have perspective on best practices and perspective of how to do things. Would be supported by existing data engineers - ability to point to resources, bounce ideas off of, but ideally they wouldn’t be doing code reviews.
• Caremark Benefit Engine is 3 people split across that project - all data science, more technical depth.
• Very parallel, technical folks, data scientists who understand business context, where to find things., * Supports the creation and operation of Big Data AI/machine learning solutions, using complex healthcare data to produce actionable insights
• Leads and participates in the design, build and management of large-scale data structures and pipelines and efficient Extract/Load/Transform (ETL) workflows.
• Uses strong data analysis skills to profile and validate source datasets to recommend solutions.
• Collaborates with data science team to define and build datasets for training of analytic data models.
• Leverages data management experience to design large scale data structures that support efficient consumption of analytic results.
• Uses strong programming skills in Python, Java or any of the major languages to develop efficient ETL to collect and standardize data to generate insights and addresses reporting needs.
• Develops software to deliver both batch and real time analytics

• 5+ years of relevant work experience in Data Engineering/ETL Development
• 5+ years of SQL experience with large datasets
• 2+ years experience with Spark, Python, or Java to build robust data pipelines
• 5+ years of progressively complex related experience.
• Experience leveraging Cloud Technologies (GCP Preferred, AWS, Azure) for ETL and data analysis
• Strong SQL and data analysis experience; data exploration, profiling, and validation.
• Strong collaboration and communication skills within and across teams., * Experience with API integration design and development, including authentication, data mapping, and error handling.
• Experience working with Healthcare or Health insurance data
• Understanding of data science methods and statistics, Agile Programming Methodologies, Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Artificial Intelligence (AI), Authentication, Backlog Prioritization, Benchmarking, Best Practices, Big Data, Cloud Computing, Code Reviews, Communication Skills, Computer Programming, Computer Science, Consulting, Continuous Deployment/Delivery, Continuous Integration, Customer Relations, Data Analysis, Data Collection, Data Management, Data Mapping, Data Modeling, Data Science, Data Sets, Data Structures, Database Extract Transform and Load (ETL), Error Handling, GCP (Good Clinical Practices), Health Insurance, Healthcare, Java, Laptop PC, Machine Learning, Microsoft Windows Azure, Organizational Skills, Pricing, Problem Solving Skills, Product/Service Launch, Python Programming/Scripting Language, SQL (Structured Query Language), Software Development, Software Porting, Statistics, Team Player, Training Data Sets, Underwriting, Use Cases, Work From Home

Title: Data Engineer Organization: Tekfortune Inc. Location: Edina Description: Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for world s leading organizations in a broad range of industries. In this quickly changing economic landscape, virtual recruiting and remote work are critical for the future of work. To support the active project demands and skills gaps, our staffing experts can help you find the best job for you., Tekfortune Inc. Tekfortune is a software solutions company providing project development and staff augmentation services to companies in various industries including Healthcare, Banking, Finance, Telecommunication and Aviation.

Tekfortune Inc delivers solutions to a wide variety of organizations of various sizes and industries. Our clients include mid-market to Fortune 1000 companies spanning across industries such as: Insurance, Financial, Pharmaceutical, Manufacturing, Retail and many others.

In Tekfortune Inc, we are offering selection of services and solutions at very reasonable rates. With years of experience in the placement and recruitment Industry and over time we have acquired the knowledge essential to comprehend the exact need and dependence on customers. Therefore we provide the customers the best and also the brightest candidates for vacancies. Moreover, by understanding the working interest of customers who is able to place them within the companies where they are able to get maximum opportunity for professional growth.

Tekfortune Inc has a strong emphasis on quality. Its goal would be to achieve client satisfaction by looking into making deliveries satisfaction of customer’s business needs. Our ability to quickly identify and effectively employ proven fundamental principles, techniques and resources yields highly desirable results for our clients.

We understand that each industry and organization share a level of uniqueness that requires a tailored approach in order to deliver specific solutions. Such factors as client culture, industry regulations, organizational maturity, financial health and many more items may impact our approach to delivering client solutions.

Having served a wide variety of clients has provided Tekfortune the ability to build subject matter expertise across numerous industries. Our industry expertise combined with our specialized knowledge of Business Process Improvement, Requirements Management and Program & Project Management provides a powerful combination and a tremendous value to our clients.

We are run by a group of industry experts who have decades of experience in delivering custom solutions to our clients.