Data Engineer II focusing on data ingestion and architecture for SimplePractice's analytics platform. Collaborating across teams to build scalable data systems and maintain data quality
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
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
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
Excellent communication skills
BS/MS degree in Engineering, Mathematics, Physics, Computer Science or equivalent experience
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
Data Engineer II leading development and delivery of data pipelines for Syneos Health. Collaborating with teams to optimize data processing and integrate solutions into production environments.
Lead Data Engineer overseeing data operations and analytics engineering teams for OneOncology. Focused on operational excellence in data platform and model reliability for cancer care improvement.
Senior AWS Software Data Engineer at Boeing focusing on AWS Data services to support digital analytics capabilities. Collaborating with cross - functional teams to design, develop, and maintain software data solutions.
Senior Data Engineer designing and improving software for business capabilities at Barclays. Collaborating with teams to build a data and intelligence platform for Equity Derivatives.
Senior AI & Data Engineer developing and implementing AI solutions in collaboration with clients and teams. Working on projects involving generative AI, predictive analytics, and data mastery.
Consultant driving IA business growth in Deloitte's Artificial Intelligence & Data team. Delivering innovative solutions using data analytics and automation technologies.
Data Engineer responsible for managing data architecture and pipelines at Snappi, a neobank. Collaborating with teams to enable data processing and analysis in innovative banking solutions.
Data Engineer at Destinus developing the data platform to support production and analytics needs. Involves migrating Excel sources to Lakehouse and integrating ERP systems in a hybrid role.
Senior Data Engineer developing solutions within the Global Specialty portfolio at an insurance company. Engaging with diverse business partners to ensure high quality data reporting.
Data Engineer at UBDS Group focusing on designing and optimizing modern data platforms. Collaborating in a multidisciplinary team to develop reliable data assets for analytics and operational use cases.