Data Engineer building scalable data pipelines and collaborating with teams at Ekimetrics. Involved in data quality, governance, and maintaining data integrity.
About the role
- 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
- Employee Resource Groups (ERGs)
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Data Engineer developing data solutions and scalable systems at SimplePractice. Collaborating with teams to enhance analytics and decision - making for health and wellness clinicians.
Senior Data Engineer responsible for designing and implementing cloud - native data platforms for LPL Financial. Collaborating with stakeholders to enhance party reference data services and solutions.
Data Engineer in charge of designing and building data integration pipelines with Informatica and AWS technologies. Work collaboratively to deliver high - quality solutions in an agile environment.
Senior Software Engineer specializing in data engineering and infrastructure for cloud - native solutions at Cloudera. Leading technical direction and mentoring engineers in a high - impact role.
Senior Data Engineer at Sonatype responsible for building data pipelines and BI solutions. Collaborating with teams to design infrastructures empowering analytics and decision - making.
Lead Data Engineer responsible for driving data initiatives at Lennar, one of the nation's leading homebuilders. Manage projects, ensure scalability, and collaborate with stakeholders to meet organizational goals.
Financial Data Engineer Intern assisting with model integration and process automation at Transamerica. Focused on data engineering tasks with collaboration across IT and Finance teams.
Data Engineer managing reliable data pipelines and solutions using Microsoft Azure and Python. Collaborating across teams to meet business data needs in a scalable environment.
Data Engineer responsible for building ELT pipelines and operating data platforms at Auctionet. Collaborate closely with analytics and infrastructure teams in Stockholm.