Analytics Engineer

Brilliant Corners

Los Angeles (CA)

Hybrid

USD 95,000 - 105,000

Full time

14 days+

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health Care Plan

Retirement Plan

Paid Time Off

Training & Development

Job summary

A non-profit organization in Los Angeles seeks an Analytics Engineer responsible for data consolidation and maintenance across its data infrastructure. The role involves collaborating with data analysts to design data models, automate data pipelines, and support reporting. Candidates should have strong SQL and Python skills along with experience in cloud data platforms. Competitive salary range of $95,000 to $105,000 per year offered with a hybrid work model.

Qualifications

Experience with cloud data warehouses and platforms.
Proven success in data warehousing and infrastructure.
Strong communication skills with technical and non-technical stakeholders.

Responsibilities

Design and maintain data models for reporting and analytics.
Automate and maintain data pipelines.
Collaborate with teams to integrate data from multiple sources.

Skills

SQL

Python

Problem-solving

Interpersonal skills

Tools

Snowflake

Tableau

Git

FiveTran

Job description

Position Summary

The Analytics Engineer is responsible for data consolidation and maintenance across the organization's data infrastructure and various data sources. The engineer works with Data Analysts and other business units to create data models and to build and maintain a cloud data infrastructure. Their work will support recurring and ad-hoc reporting, dashboard creation and maintenance, and data requests from internal and external stakeholders. The Analytics Engineer will also build business intelligence tools to help data analysts do their work more efficiently, such as improved or automated data clean up processes and a self-service analytics platform. They will also collaborate with the Product Development team and IT Operations team on data infrastructure and integration projects focused on transforming data and supplying data between operational systems to meet business needs. Lastly, they are responsible for using best practices to maintain version control and perform internal testing and deploy production-ready code.

Position Responsibilities

Design, develop, implement, and maintain data models used for reporting and analytics.
Work with Data Analysts and other business teams to identify and develop ETL/ELT processes to automate, orchestrate, and maintain data pipelines.
Maintain data documentation and definitions, including data quality standards and business logic for metrics/KPIs, naming and formatting conventions and detailed specifications/documentation for analytics code.
Maintain version control for, test, and continuously integrate analytics code into testing and production environments.
Monitor data models and pipelines to ensure performance meets internal service level agreement.
Collaborate with Data Analysts to build dashboards and visualizations that show trends, patterns, and outliers in the data pipeline and models; maintain current inventory of reports and dashboards and publish this information to business users.
Work with Product Development and other business teams to consolidate and integrate data from and between multiple data sources (such as Salesforce, Financial Systems, HRIS, and other data sources).
Maintain and update (as necessary) existing integration infrastructure, with a focus on streamlining and consolidating processes.
Help evaluate and validate new and existing tools or development needs to suggest improvements and streamline operations.
Support updates/upgrades, configuration and troubleshooting for business intelligence tools.
Help coach Data Analysts on software development best practices.

Requirements

Professional Experience

Proven success in designing, building and maintaining data warehouse and infrastructure that meet business needs.
Experience with SQL.
Experience with Python or R.
Strong problem-solving skills in relation to data and software applications.
Excellent interpersonal skills and verbal/written/virtual communication skills to communicate technical details to both other team members and non-technical stakeholders.
Experience supporting and working with cross-functional teams.

Knowledge, Skills, And Abilities

Prior experience with software development best practices around code (version control using Git, testing, debugging, continuous integration and deployment, clear comments in code).
Experience with cloud data warehouses and platforms like Snowflake, GCP, Azure.
Experience with ETL/ELT tools like FiveTran, Matillion, Stitch.
Experience with DBT, Dataform, Databricks.
Experience with data visualization tools like Tableau, PowerBI, Looker, Sigma.
Experience with Integration Platform-as-a-Service like Workato or Mulesoft.
Clear technical writing experience, including data mapping documents, reports, and presentations.
Experience in a non-profit, human services setting.

Core Competencies

Dealing with Ambiguity: Remains productive and effective in uncertain, rapidly changing situations by quickly analyzing information to adapt approach. Demonstrates flexibility, composure and good judgment despite challenges
Technical Learning: Quickly learns and applies new technical skills, knowledge, and industry expertise. Seeks guidance when needed to ensure quality
Problem Solving: Uses critical thinking to creatively investigate issues from diverse perspectives. Makes evidence-based recommendations addressing short and long-term needs
Total Work Systems: Designs, implements, and improves organization-wide systems to enhance quality and efficiency. Leverages technology and data to standardize workflows and meet stakeholder needs
Organizational Agility: Understands how the organization operates through formal and informal structures. Navigates dynamics, communicates rationale behind policies, and builds relationships to achieve goals
Customer Focus: Proactively understands and meets others\' needs through a service-minded approach. Builds trust, leverages insights, and provides responsive support to align with evolving requirements

Organizational Values

Humanity: Putting people first: We are committed to meeting people where they\'re at, honoring their dignity, diversity, and experience.
Community: Building a better future: Sustainable housing solutions are fostered through partnership, collaboration, and human connection.
Ingenuity: Innovating for transformation: Systems-change requires relentless determination, thinking outside the box and challenging the status quo.

Physical Requirements

Candidates should have physical mobility for tasks such as standing, bending, stooping, kneeling, crouching, reaching, twisting, and walking on uneven surfaces. They should be capable of performing stationary tasks like sitting for up to 6 to 8 hours a day. Additionally, candidates should be able to lift, carry, push, pull light to moderate weights up to 15 pounds safely. Requires mental acuity for analytical reasoning and document interpretation.

Benefits