Strada
Indianapolis
501-1,000 employees
Social impact org improving lives by forging clearer and more purposeful pathways between education and employment.
Prior Listings
Analytics Engineer
Analytics Engineer
This job is no longer open
The Analytics Engineer is part of a remote work team that is responsible for real-time business metrics aggregation, data warehousing and querying, schema and data management as well as a number of other analytics infrastructure systems. The incumbent, along with the remote work team, will strive to architect, develop, and deploy world-class data systems to empower every tier of our mission-driven company, as well as build scalable systems that enable self-service access to sophisticated data and analyses.
Essential Job Functions:
- Design, build, and maintain data models foundational to the company’s internal and client-facing reporting and analytics.
- Investigate bug root causes and implement fixes.
- Design, build, and support a data warehouse for the company’s business.
- Create and support various ELT scripts, jobs, and technologies.
- Tune and optimize data storage technologies.
- Review pull requests and test team member’s code and features.
- Interact with data analysts and power users to define metrics to build data models.
- Collaborate with team members to remove blockers and design new features.
- Function as data expert to advise users on the usage of structured and unstructured data.
- Support APIs, tools, and 3rd party products to extract data from Cloud/SaaS applications.
Education Requirements:
- Bachelor’s degree in Computer Technology, Information Systems or related field (preferred)
Experience Requirements:
- Minimum of two (2) years of applicable work experience
- Knowledge and experience with data warehousing architecture and data modeling best practices
- Ability to build and optimize data sets and architectures Experience with cloud base data warehousing such as Snowflake
- Ability to clean and transform data for use in analytics and reporting
- Exposure to one or more EL tools and a solid understanding of pipelines; understanding of third-party data integration tools such as Fivetran, Stitch
- Ability to build processes that support data transformation, workload management, data structures, dependency and metadata
- Expert knowledge of SQL
- Experience with dbt
- Excellent analytic skills associated with working on structured datasets
- Care deeply about data quality and governance; able to document data and definitions
- Experience with Github and CI/CD practices
- Experience working in an Agile software development environment that is highly collaborative
- Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement
- Able to prioritize, work independently in a less structured, remote work setting
- Team player and receptive to giving and receiving feedback, with the ability to effectively collaborate with and communicate complex topics to an audience of diverse backgrounds and skills
Experience Preferences:
- Background and experience in higher education
- Experience with Looker and LookML
- Experience with Salesforce Education Data Architecture
- Experience with Infrastructure as code such as Terraform
$90,000 - $110,000 a year
TYPICAL PHYSICAL & MENTAL DEMANDS: Requires prolonged sitting with some bending, stooping and stretching; eye-hand coordination and manual dexterity sufficient to operate a keyboard, telephone, and other office equipment. Requires sufficient range of hearing and eyesight to record, prepare and communicate appropriate reports on a laptop computer. Also requires moderate to intense concentration due to complexity and/or need to meet deadlines, and flexibility to readily adapt to a changing environment.
We really want to get to know you as a person, and the unique skills and gifts that you can bring to the position. Therefore, we highly encourage you not to use an AI program during the application/consideration process.
This job is no longer open