Analytics Engineer
Lucid Software
- Salt Lake City, UT
- Training
- Full-time
- Write complex, production-quality (i.e., accurate, performant, and maintainable) data transformation code to solve the needs of analysts, data scientists, and business stakeholders
- Implement effective data tests to ensure accuracy and reliability of data and ELT pipelines
- Assist in coaching and advising analysts on data modeling, SQL query structure and optimization, and software engineering best practices (e.g., version control, testing, code deployment)
- Assist in designing and maintaining the architecture and organizational structure of our data warehouse
- Collaborate with data engineers on infrastructure projects to implement new systems/tools/processes, ingest and model data from new sources, and pipe data between systems
- Troubleshoot and resolve data issues as they arise
- Ensure that data, systems, business logic, and metrics are well-documented
- Maintain the quality of our analytics codebase by cleaning up old code, identifying and addressing tech debt, and ensuring consistent style
- Other duties as assigned
- Bachelor's degree, ideally in a technical or quantitative field
- 0-2 years of experience within data analytics, engineering or related field
- Comfortable using SQL for data transformations
- Familiarity with version control workflows
- Familiarity with Python or another modern programming language
- Ability to communicate clearly about data to both technical and non-technical audiences
- Experience partnering with people from different educational backgrounds and working collaboratively to solve problems
- Ability to manage time effectively and set and meet deadlines
- Passion for structure, organization, and efficiency, down to the details (e.g. maintaining consistent naming conventions and coding style)
- Relevant experience working with data in an internship, former job, or through academic research
- Advanced degree, ideally in a technical or quantitative field
- Experience with
- Experience with job scheduling platforms such as Airflow
- Experience modeling and working with data from third-party SaaS applications such as Salesforce, Marketo, Zendesk, Netsuite, etc.