Data Engineer

Summary

Join Azurity Pharmaceuticals as a principal data engineer, partnering with stakeholders to analyze corporate needs and provide data architecture solutions. Design, build, and maintain data pipelines, workflows, and database structures, ensuring data quality and consistency. Optimize data flow and collection, collaborating with colleagues to create coherent solutions and identify process improvements. Maintain documentation, monitor data processing systems, and provide scripting support (P-SQL, T-SQL, Python). This remote position requires a Bachelor’s degree and one year of relevant experience, offering flexible hours and travel to Azurity locations (Atlanta, Raleigh, Boston) no more than monthly.

Requirements

• Bachelor’s degree or foreign equivalent in computer science, computer information systems, mathematics, or a related field, plus one year of experience in the job offered or as a data engineer creating data models and data flow diagrams; performing data mining; using segmentation techniques, Python Scripting and SQL; building ETL data pipelines from scratch; building an ETL testing pipeline
• Travel to Azurity locations (Atlanta, Raleigh, Boston) not more than monthly with each trip lasting one to five days
• 40 hours /week, flexible hours matching multiple time zones
• Remote work nationwide in the EST time zone
• Must be able to sit for long periods of time
• While performing the duties of this job, the employee is frequently required to stand; walk; sit; talk and/or hear
• May occasionally climb stairs and/or ride elevators
• The employee must occasionally lift and/or move up to 25 pounds
• Employee must be able to manipulate keyboard, operate a telephone and hand-held devices
• Other miscellaneous job duties as required

Responsibilities

• Serve as the principal data engineer for data warehouse initiatives
• Partner with product owners and business stakeholders to analyze corporate needs
• Provide data architecture and solutions that meet business data insights and reporting requirements
• Design, build, and maintain data pipelines, workflows, data modeling, and database structures
• Implement data storage solutions and ensure data quality and consistency
• Optimize data flow and collection for efficiency
• Collaborate with data scientists, software developers, and commercial operations colleagues to create coherent solutions
• Find and recommend process improvements, particularly transitioning from manual processes to automation
• Ensure compliance with information security and privacy policies in data architecture and data warehouse capabilities
• Provide scripting and software development support as needed (P-SQL, T-SQL, Python)
• Create and maintain documentation, including sources to target data mapping and systems architecture diagrams
• Monitor, support, and troubleshoot data processing systems to improve data analytics platforms

Benefits

• Competitive compensation package, including an annual bonus based on company performance
• Incentive compensation program that allows you to earn more - even over plan
• Car reimbursement program and gas card for both business and personal use
• Excellent medical, dental, vision, and prescription coverage
• Hybrid work model, allowing you to work two days from home and three days in the office
• ���Bagel Tuesday” perk
• Retirement Savings Plan (401K) is designed to help you secure a comfortable retirement by matching dollar for dollar up to 5%
• Generous time off policy, which offers up to 15 vacation days annually + rollover (up to 40 hours) as well as five sick/wellness days
• Extra week off to spend quality time with your family and recharge
• Over the course of the year, Azurity recognizes 13 holidays
• Summer-Hours perk, available between Memorial Day and Labor Day
• Tuition reimbursement for undergraduate and graduate level courses or certifications
• Azurity High Five peer recognition platform allows you to celebrate your colleagues' accomplishments and receive recognition for your own outstanding work