Senior Data Engineer designing and building data warehouse solutions with Snowflake for a fintech company. Collaborating with cross - functional teams to facilitate data insights and analytics.
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
Data Engineer developing and maintaining data pipelines and applications at EvidenceCare. Collaborating across teams to generate actionable insights from healthcare data for better decision - making.
Data Engineer managing and expanding enterprise business intelligence and data platform. Focusing on Tableau development and administration with a strong engineering background.
Lead Data Engineer overseeing engineers and advancing the data platform at American Family Insurance. Creating tools and infrastructure to empower teams across the company.
Working Student contributing to data engineering projects for AI/ML workflows while gaining hands - on experience with data pipelines and tools.
Data Architect designing end - to - end Snowflake data solutions and collaborating with technical stakeholders at Emerson. Supporting the realization of Data and Digitalization Strategy.
Manager of Data Engineering leading data assets and infrastructure initiatives at CLA. Collaborating with teams to enforce data quality standards and drive integration efforts.
Data Engineer building modern Data Lake architecture on AWS and implementing scalable ETL/ELT pipelines. Collaborating across teams for analytics and reporting on gaming platforms.
Chief Data Engineer leading Scania’s Commercial Data Engineering team for growing sustainable transport solutions. Focused on data products and pipelines for BI, analytics, and AI.
Data Engineer designing and building scalable ETL/ELT pipelines for enterprise - grade analytics solutions. Collaborating with product teams to deliver high - quality, secure, and discoverable data.