Data Engineer II managing the data ingestion efforts at SimplePractice, supporting the data-driven journey and analytics across the enterprise.
Responsibilities
Partner with analysts to build scalable systems that help unlock the value of data from a wide range of sources such as backend databases, event streams, and marketing platforms
Consult with our Product and Engineering Teams in the creation of new data in the production environment
Create company wide alignment through standardized metrics across the company
Promote importance of dimensional data models in communicating across the organization
Manage the complete data stack from ingestion through data consumption
Connect our teams and their workflows to centralized and secure databases
Build tools to increase transparency in reporting company wide business outcomes
Define and promote data engineering best practices
Design scalable data solutions leveraging cloud data technologies, preferably in AWS
Help define data quality and data security framework to measure and monitor data quality across the enterprise
Excellent problem-solving & critical-thinking skills to meet complex data challenges and requirements in a fast paced, rapidly changing environment
Requirements
4+ years of progressive professional experience preferred
BS/MS degree in Engineering, Mathematics, Physics, Computer Science or equivalent experience
Excellent communication skills
Top-notch SQL, statistical/window functions, complex data types
Expert in relational technology, data modeling, and in dimensional modeling
Expert in at least two database engines, preferably MySQL, Snowflake, or Postgres
Metadata-driven and database-centric concepts
Database performance
Expert at ETL and ETL tools, including Airflow/Prefect, DBT, Airbyte, Fivetran
ELT and schema-on-read concepts
Data ingestion tools, such as Kafka, DMS, Singer
At least one programming language, preferably Python
Unix/Linux scripting, such as bash
Experience with APIs, such as via curl
Experience with achieving performance through parallelism
DAGs
Experience with cloud-based infrastructure, particularly AWS
Cloud storage, S3
Data storage formats, such as Parquet, ORC
Experience with external tables
Unstructured and semi-structured data types, JSON
Experience with at least one visualization tool, preferably, Looker, Tableau, Sisense
Benefits
Privatized Medical, Dental & Vision Coverage
Work From Home stipend
Flexible Time Off (FTO), wellbeing days, paid holidays, and Summer Fridays
Monthly Meal Reimbursement
Holiday Bonus, 15-day Aguinaldo
Hybrid Work Schedule & Catered Lunch
A relocation bonus for candidates joining us from a different city
Senior Data Engineer designing and optimizing data platforms for clients using Microsoft Azure, Microsoft Fabric, Power BI, and Databricks. Working closely with clients to deliver scalable solutions.
Data Engineer providing technical expertise on mission - critical NAVSUP OIS program. Work involves data architecture and database management in AWS GovCloud environments.
Senior Data Engineer focusing on data infrastructure for an AI - driven insurtech startup based in Nepal. Collaborating with teams to optimize data models and maintain data quality.
Senior Professional Consultant leading architecture and design for SAP BW and SAC solutions at Freudenberg. Collaborating with stakeholders and optimizing performance of data landscapes.
Senior Data Engineer designing and managing data architectures to transform large - scale data into insights for Humana. Involves leading technical discussions and implementing best data practices.
Data Engineer II at Early Warning Services developing data science tools and infrastructure. Collaborating on software enhancements and mentoring interns in a hybrid work environment.
Senior Data Architect responsible for optimizing data architecture and supporting data - driven business decisions at TruStage. Leading technical guidance for data architecture and cross - functional team collaboration.
Senior Data Architect developing data architecture plans at The Hartford, collaborating with internal teams to align data standards and practices. Leading complex solutions with a focus on operational effectiveness.
Senior Solution Architect defining architecture framework for SA‑CCR in regulatory risk. Collaborating with stakeholders to ensure compliance and efficient data governance.