Data Engineer
Company Description
GoHealth has an ambitious mission: to improve the health care system in America. Achieving this mission relies on hiring and developing great people, which is why our team is our top priority. We encourage employees to do their best work through innovation and risk taking. Our environment is fun yet constructive, thanks to leaders whose doors are always open. And most importantly, we’ll never stop investing in you and your career.
Job Description
GoHealth is looking for a Data Engineer responsible for the design, development, and maintenance of a data warehouse for the company. We are seeking candidates who have extensive experience in data modeling and warehouse builds that meet the complex requirements of various business units. The Data Engineer will own the development of infrastructure necessary for centralized reporting, data science, predictive analytics, and machine learning.
Responsibilities:
- Work in conjunction with a Warehouse Architect to design, build, and deploy a data warehouse in the cloud
- Create automated data pipelines to the data warehouse from a variety of sources including MySQL, AWS, CouchDB, JSON, XML, and flat files
- Ensure quality, validity and consistency of all data points, metrics and KPIs
- Perform all required validation testing and adhere to development standards and processes
- Collaborate with users making reports, dashboards, and running statistical analysis to ensure data is transformed into a format that can be easily utilized by them
- Create and maintain documentation and metadata for the data warehouse and data pipelines
- Ensure compliance with regulatory requirements for data transmission, storage, and data access
- Identify inefficiencies and rigid processes, and design solutions increasing automation and scalability
- Ability to work with the rest of the BI Team to cross-train and provide support for other BI tasks like ETL Development, Cube Maintenance, Data Analytics and Requirements Gathering
Qualifications
- Bachelor’s Degree in computer science or equivalent experience required
- 5+ years’ experience in database development, preferably on cloud-based infrastructure
- Experience developing data lakes and other data storage and processing solutions with tools such as SQL Server, MySQL, Postgres, Cassandra, Hbase, Solr, Spark and/or equivalent
- Experience supporting Advanced Analytics/Data Mining/Data Science/Neural Networks (including integration tools like Python, R, TensorFlow, etc)
- Expert understanding of data warehousing concepts and dimensional data modeling
- Advanced ability in SQL 2012 and above, experience in MySQL preferred but not required
- Proven experience extracting data from a variety of data sources (MySQL, Excel, Access, SharePoint, Azure, Text files) both on-premise and in the cloud
- Experience with source control tools like Git, BitBucket/SourceTree, SVN or TFS
- Strong analytical and problem solving ability with strong attention to detail and accuracy
- Ability to handle multiple tasks and adapt to a constantly changing environment
- Self-starter with the ability to work independently and take initiative
- Excellent written and oral communication skills, with the ability to articulate complex processes to individuals of varying technical abilities
Additional Information
- Open vacation policy
- 401k match program
- Medical, life, dental, and vision benefits
- Flexible spending accounts
- Subsidized gym memberships
- Commuter and transit benefits
- Professional growth opportunities
- Casual dress code
- Generous employee referral bonuses
- Happy hours, ping-pong tournaments, and more company-sponsored events
- GoHealth is an Equal Opportunity Employer