We’re looking for a data engineer with analytics experience to join a small data team and spearhead development on our cloud data lakehouse. The ideal candidate will be adept at working cross-functionally to elicit design requirements from business and technology teams, building robust data pipelines, curating meaningful datasets, and provisioning data for end-users, integrations, and other services.

Key Responsibilities

• Work with business teams to understand current and future data needs and provide mechanisms for constructing and storing datasets to support those requirements.
• Work with the R&D teams to influence the design and implementation of new data models.
• Provide expertise in data movement and storage best practices in support of downstream reporting, analytics, and data science initiatives.
• Help design and optimize the business’ database and table schemas for existing applications and future product development.
• Design, implement, and optimize robust ELT pipelines.
• Populate a cloud data lakehouse utilized by data analysts, data scientists, and BI developers.

Skills and Expertise

• 4+ Years designing data models, building ETL pipelines, and wrangling data to solve business problems.
• 2+ Years developing in Spark, with Databricks experience strongly preferred.
• Working experience within the Azure ecosystem.
• Advanced SQL experience working with relational databases.
• Experience building data pipelines, architectures, and datasets, with preference for Delta Lake multi-hop architecture development experience.
• Knowledge of database and data warehouse design best practices for read/write performance.
• Development experience with either Python or Scala.
• Demonstrated understanding of common BI patterns and tabular modeling, with preference for Microsoft Power BI experience.

Corestream is a fast-growing, cutting-edge financial and benefits technology company. We are an industry leader in the delivery of Voluntary Benefits; our proprietary software is the engine for large, Fortune-500 companies to easily and cost-effectively offer unlimited Voluntary Benefits to its employees through payroll deduction.  We have a driven, flexible, and fun team and offer competitive compensation and benefit packages. Although we are over ten years old, we still have a “start-up” culture and when we are in the office we have a casual dress code, weekly yoga, free snacks and beverages, and Friday lunches are on the house.  We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.