Sr. Analytics Engineer
Houston, Texas, United States
Applications have closed
Crane Worldwide Logistics
Essential Job Functions
- 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
Building dashboards and creating analyses will not be a core part of this position. This is a high-leverage role that maintains the library and map of our data ecosystem: your primary customers are analysts and engineers.
Skills and Attributes
- 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
Preferred Skills
- Specific experience with Snowflake
- Dbt macros or Jinja
Nice to have but not required
- Practical programming experience in a team environment
- Experience with Terraform or infrastructure as code
Education and Experience
- 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
WHY SHOULD YOU WORK FOR CRANE?
At Crane, we believe in providing our employees with excellent benefits at a Great Place to Work.
We offer:
- 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
Come join the leader in logistics and take your career in the right direction.
Disclaimer:
The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
We maintain a drug-free workplace and perform pre-employment substance abuse testing.
This position requires the final candidate to successfully pass an E-Verify Check.
More Information: http://www.dhs.gov/e-verify
Company benefits are contingent upon meeting eligibility requirements and plan conditions.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Data quality Data warehouse dbt OLAP Pipelines Snowflake SQL Terraform Testing
Perks/benefits: Health care Wellness
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open MLOps Engineer jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Power BI Developer jobs
- Open Junior Data Scientist jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open PhD-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs