Sr. Analytics Engineer
Crane Worldwide Logistics
- Houston, TX
- Permanent
- Full-time
- Serve as a steward high-level health of the enterprise data warehouse, managing the lifecycle of data assets
- Perform code reviews for data model updates
- Design and develop data models for business and application domains
- Create and QC the SQL transformation pipelines to convert raw data into modeled data
- Identify refactoring opportunities for DAG scalability
- Establish and implement standards for dbt, SQL, data quality, automated testing, and documentation
- Troubleshoot and optimize SQL queries
- Monitor and optimize overall run performance for data warehouse build process
- Coach BI Engineers and non-BI team contributors on best practices
- Provide feedback to the data platform team that builds tooling and infrastructure, owning the developer experience of the data modeling & publication process
- Own key data models as needed
- Practical knowledge of data modeling and data design strategies
- Advanced SQL skills—readable, fast queries are your default
- Hands-on dbt (or dataform, sqlmesh, etc) experience
- Comfortable coaching and mentoring other team members
- Hands-on experience using and optimizing OLAP query engines
- Meticulous about correctness and quality of work
- Comfortable navigating a complex data ecosystem: ability to see big picture while also digging into the details
- Specific experience with Snowflake
- Dbt macros or Jinja
- Practical programming experience in a team environment
- Experience with Terraform or infrastructure as code
- Required: multiple years as a developer or engineer in the data/BI/analytics space
- Preferred: prior experience as an analytics engineer, data architect or similar role
- Quarterly Incentive Plan
- 136 hours of Paid Time Off which equals 17 days for the year, that can be used for Sick Time or for Personal Use
- Excellent Medical, Dental and Vision benefits
- Tuition Reimbursement for education related to your job
- Employee Referral Bonuses
- Employee Recognition and Rewards Program
- Paid Volunteer Time to support a cause that is close to your heart and contributes to our communities
- Employee Discounts
- Wellness Incentives that can go up to $100 per year for completing challenges, in addition to a discount on contribution rates