Data Analytics Engineer Enjoy turning raw data into game-changing insights? At uShip, we’re a small but mighty data team looking for a Data Analytics Engineer to join our mission of building smarter, data-driven solutions. In this role, you’ll wear two hats: crafting robust data pipelines to keep our information flowing smoothly and diving deep into analysis to uncover trends that fuel our growth. It’s a role that bridges the gap between raw data wrangling and actionable insights, requiring both coding chops and a knack for problem-solving. We’re a tight-knit team, and your work will directly shape our products, decisions, and future. If you love coding, problem-solving, and telling stories with data, we’d love to have you on board! Responsibilities
- Data Engineering & Transformation:
- 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.
- Database Development (PostgreSQL):
- 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.
- Data Visualization (Metabase):
- 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.
- Collaboration & Reporting:
- 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.
Qualifications
- Technical Skills:
- 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.
- Experience:
- 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
- Experience with other data visualization tools (e.g., Tableau, Power BI).
- Knowledge of version control systems (e.g., Git).
- Soft Skills:
- 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.
Onboarding
- First 30 Days: Onboarding & Internal Knowledge Absorption
- Understand company data, systems, and workflows.
- Build relationships with key stakeholders.
- Set up your development environment and learn the tools.
- Days 31-60: Implementation and Optimization
- Manage data engineering and analytics tasks.
- Build new ETL pipelines and data transformation workflows.
- Improve data reporting and visualization in Metabase.
- Days 61-90: Ownership and Strategic Initiatives
- Own key data engineering and analytics workflows.
- Find and implement data scalability and performance improvements.
- Collaborate across functions and generate proactive insights.
Location: Austin, TX 78701, remote or hybrid optional team environment
Salary: $120-150k base salary ($140-170k estimated total comp)
*Unfortunately, we are unable to employ remote employees in the following locations: New York City, Massachusetts, Montana, Hawaii, Alaska, California, and anywhere outside of the U.S.
*We are unable to transfer or sponsor visas
*No agencies or independent contractors please
Top Skills
What We Do
uShip.com is the world’s largest and most trusted transportation marketplace primarily serving the freight, household goods and vehicle shipping markets. Consumers and businesses can compare and book upfront quotes, name their own price or receive auction style bids from over 225,000 customer-reviewed Transportation Service Providers, ranging from independent owner-operators to the largest freight carriers and brokers.
Launched in 2004, Austin-based uShip operates globally with localized sites in the U.S., Canada, UK, Germany, France, Spain, The Netherlands, Austria, the European Union, Central and South America