Data Analytics Engineer

Summary

Join uShip's data team as a Data Analytics Engineer and contribute to building smarter, data-driven solutions. You will design and implement ETL processes, develop and maintain PostgreSQL databases, and create Metabase dashboards. This role requires strong SQL and Python skills, experience with data modeling and ETL pipelines, and excellent communication abilities. You will collaborate with various teams to understand data needs and deliver actionable insights. The position offers a competitive salary, remote or hybrid work options, and a comprehensive benefits package.

Requirements

• Strong proficiency in SQL, with experience in PostgreSQL for database design, management, and optimization
• Solid understanding of Python for data processing and transformation tasks
• Experience with Metabase for building interactive dashboards, reports, and data visualizations
• Experience in data modeling, ETL pipelines, and data integration
• 3+ years of experience working in a data analytics role
• Proven experience in data transformation and creating scalable data workflows
• Experience working with large datasets and high-performance databases
• Familiarity with AWS Sagemaker and data science development best practices
• Familiarity with cloud data platforms (AWS, GCP, Azure)
• Experience using GitHub and a CI/CD pipeline
• Knowledge of version control systems (e.g., Git)
• Strong problem-solving skills and the ability to work independently and in a team
• Good communication skills, with the ability to explain technical concepts to non-technical stakeholders

Responsibilities

• Design and implement ETL (Extract, Transform, Load) processes to clean, organize, and prepare data for analysis
• Develop and optimize complex data transformation workflows using SQL, Python, Estuary and other transformation tools
• Work with large datasets to ensure data accuracy, consistency, and integrity
• Develop and maintain PostgreSQL databases, including the design of tables, views, and indexes for optimized query performance
• Write efficient SQL queries for data extraction, aggregation, and transformation
• Troubleshoot and resolve database performance issues
• Set up and maintain Metabase dashboards and reports for key stakeholders
• Collaborate with cross-functional teams to understand reporting needs and translate them into actionable visualizations
• Automate reporting and insights generation via Metabase
• Work closely with analytics team members, data engineers, developers, product owners, and business stakeholders to understand their data needs and deliver actionable insights
• Write clear documentation for data processes, code, and reports to ensure transparency and reproducibility

Preferred Qualifications

Experience with other data visualization tools (e.g., Tableau, Power BI)

Benefits

• Remote or hybrid work options
• Monthly Wellness Reimbursements
• Home office Reimbursements
• Company paid meal delivery pass, plus monthly credit
• 100% Paid Health and Dental available
• 401(k) matching, no vesting
• Stock Options
• Pet Insurance