Apply on Employer Site

Brilliant Corners · 1 day ago

Analytics Engineer

San Francisco, CA

Full-time

Hybrid

Mid Level

$95K/yr - $105K/yr

Brilliant Corners is a company focused on providing innovative housing and housing-related services to vulnerable individuals in California. The Analytics Engineer will be responsible for data consolidation and maintenance across the organization's data infrastructure, collaborating with various teams to create data models and support reporting needs.

ConsultingNon ProfitReal Estate

Comp. & Benefits

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. As well as, 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

Qualification

SQLPythonRETL/ELT toolsCloud data platformsData visualization toolsSoftware development best practicesOrganizational agilityInterpersonal skillsProblem-solving skillsTechnical writing

Required

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

Prior experience with software development best practices around code (version control using Git, testing, debugging, continuous integration and deployment, clear comments in code), especially implementing such practices in organizations

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