Data Engineer

Company Overview:

Ringmaster is a leading provider of healthcare solutions, specializing in Pharmacy Benefit Management (PBM) services. We have a dedicated focus on broker distribution channels, and we are committed to delivering innovative PBM solutions through our valued broker partners.

Job Description 

We are seeking a talented Lead Data Engineer to join our team. The ideal candidate will be responsible for designing and implementing scalable data pipelines for our organization. If you are passionate about data and technology, we would love to hear from you. 

 Data engineering is the practice of transforming raw data into useful information. It requires a deep understanding of data architectures, data warehousing, databases, and analytics tools. The goal is to create an efficient system for collecting, processing, analyzing, and visualizing large amounts of data from various sources. 

Goals 

• Ensure the accuracy of data. 

• Promote data quality. 

• Transform data into more useful formats. 

• Democratize data – enabling fellow employees to party on the data. 

Key Responsibilities 

• Build data systems 

• • Design and construct data products and services, including databases, data pipelines, and data models. 

• • Builds out new API integrations to support continuing increases in data volume and complexity. 

• • Identifies, designs and implements internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes. 

• • Builds required infrastructure for optimal extraction, transformation and loading (ETL) of data from various data sources using AWS and SQL technologies. 

• Collect and store data 

• • Acquire datasets that meet business needs, and ensure data is stored securely. 

• • Assemble large, complex sets of data that meet non-functional and functional business requirements. 

• Data Operations / Testing & Maintenance 

• • Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it. 

• • Writes unit/integration tests, contributes to engineering wiki, and documents work. 

• • Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues. 

• • Design data integrations and data quality framework. 

• • Test and maintain data systems and infrastructure. 

• Collaborate with others 

• • Collaborates with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization. 

• • Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues. 

• Ensure compliance 

• • Ensure compliance with data governance, security policies, regulatory agencies and partner requirements. 

• Select technology 

• • Choose the appropriate technology for a company’s needs, such as SQL and NoSQL databases, and cloud-based warehouse technologies. 

• • Defines company data assets (data models) in order to populate data models. 

• Write code 

• • Write code for required customization. 

• Develop tools 

• • Create new data validation methods and data analysis tools. 

• • Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition. 

Skills & Basic Qualifications 

• BS or MS degree in Computer Science or a related technical field 

• 4+ years of Python and Java development experience 

• Knowledge of big data tools such as MongoDB, Kafka, and Hadoop 

• Understanding of data warehouse and Extract, Transform, Load (ETL) tools like Amazon Redshift 

• 4+ years of experience with with cloud computing tools such as AWS, Azure, and GCP 

• 4+ years of SQL experience (No-SQL experience is a plus) 

• 4+ years of experience with schema design and dimensional data modeling 

• Experience with automation and scripting 

• Knowledge of machine learning. 

• Knowledge of basic data visualization in Excel, Tableau and PowerBI 

• Ability in managing and communicating data warehouse plans to internal stakeholders 

• Experience designing, building, and maintaining data processing systems 

• Experience working with either a Map Reduce or an MPP system on any size/scale 

• Knowledge of best practices and IT operations in an always-up, always-available service 

• Experience with or knowledge of Agile Software Development methodologies 

• Excellent problem solving and troubleshooting skills 

• Process oriented with great documentation skills 

• Excellent oral and written communication skills with a keen sense of customer service 

Education 

• BS or MS degree in Computer Science or a related technical field