Data Engineer responsible for building reliable ETL/ELT workflows using Azure and Python. Collaborating with teams to deliver clean, structured data and modernize cloud platforms.
About the role
- 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
- Employee Resource Groups (ERGs)
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Data Engineer responsible for data pipelines and analytics solutions across Microsoft ecosystem. Collaborating with stakeholders to ensure reliable data delivery and cloud - first strategies.
Director, Data Architecture & Platforms leading the design of data infrastructures for Pioneer clients. Collaborating with executives and teams on data strategies and modernization initiatives.
Data Engineer at Boeing optimizing aviation operations through data management and machine learning. Collaborating with engineers to implement data science models while ensuring data integrity.
Data Architect designing and implementing analytics and reporting solutions for Taylor Corporation. Collaborating with stakeholders and leading data modeling efforts in a hybrid environment.
BI Data Engineer designing and optimizing Power BI dashboards for Rabobank's Payments & Savings data. Collaborating with cross - functional teams to provide actionable insights from large data sets.
Lead Data Engineer providing technical expertise and mentoring at Westpac. Ensuring platform stability and compliance while driving engineering practices within the squad.
Data Engineer at Uline delivering custom data warehousing solutions for shipping materials distribution. Responsibilities include ETL workflows and data integration management.
MDM Data Engineer managing Profisee MDM platform for Pacific Life. Responsible for data quality, integration and technical support across enterprise systems.
Data Engineer responsible for designing and developing cloud - based data pipelines for ING. Collaborating with international teams focusing on financial risk analytics in the cloud environment.