Explore more
About the role
- Collect, analyze, and interpret large datasets to drive strategic decisions across the organization.
- Build dashboards and reports using BI tools to track performance and identify trends.
- Partner with cross-functional teams (product, sales, support, executives) to deliver data-driven insights that inform decision-making.
- Collaborate directly with customers to understand data requirements and provide tailored analytical support.
- Develop and optimize SQL queries to extract, transform, and analyze data from multiple sources.
- Support the data infrastructure by working with Snowflake, Redshift, MySQL, MSSQL, and PostgreSQL environments.
- Translate business needs into analytical solutions and present findings in a clear, compelling manner.
Requirements
- 3–5 years of professional experience in data engineering, with hands-on responsibility for building and maintaining production data pipelines.
- Strong proficiency in SQL and solid experience using Python (or a similar language) for data transformation, automation, and pipeline development.
- Experience working with cloud data warehouses and relational databases such as Snowflake, Amazon Redshift, BigQuery, MySQL, or PostgreSQL.
- Hands-on experience with ETL/ELT frameworks and orchestration tools (e.g., dbt, Airflow, Prefect, Fivetran, or similar).
- Working knowledge of data modeling concepts, including fact/dimension tables, schema design, and optimization for analytics and product use cases.
- Ability to troubleshoot data quality issues and improve pipeline reliability, performance, and monitoring.
- Strong collaboration and communication skills, with experience working closely with analytics, product, and engineering partners.
- Experience working with healthcare-related data or other regulated datasets (HIPAA familiarity a plus).
Benefits
- Healthcare coverage for you and your family
- Paid time off (PTO) and paid holidays
- Performance-based bonuses and company equity opportunities
- Fully remote work environment with flexible schedules
- Collaborative and thriving team culture guided by Adoreal’s core values
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLPythonETLELTdata modelingdata transformationdata pipeline developmentdata analysisdashboard buildingreporting
Soft Skills
collaborationcommunicationanalytical thinkingproblem-solvingcustomer engagementstrategic decision-makingpresentation skillscross-functional teamworktroubleshootingadaptability