Analytics Engineer

Job DetailsPosition Type: Full TimeSalary Range: $105,000.00 - $105,000.00 SalaryAnalytics Engineer Data, Artificial Intelligence, & Solutions (DAIS)  •  Full-Time  •  Remote 211LA is a dynamic, forward-thinking organization committed to fostering a culture of innovation, inclusivity, and professional growth. As a leader in Information and Referral Services, we take pride in providing our employees with a supportive and collaborative environment where they can thrive and contribute to the success of our organization. The Analytics Engineer is a new role on the 211LA DAIS team, created to help develop and own the next-generation data pipeline that anchors our 2026/7 roadmap. The ideal hire is a self-starter who can take open-ended problems and produce high-quality solutions. They’re a strong practitioner of applied AI who understands both foundational and advanced techniques for coaxing excellent output from large language models. They bring a solid command of the modern analytics engineering stack to bear for building and maintaining our full analytics pipeline. Position Details Position: Analytics Engineer Reports To: Director of Data, Artificial Intelligence, & Solutions Department: Data, Artificial Intelligence, & Solutions (DAIS) Employment Type: Full-Time, Exempt Key Responsibilities Develop, own, and maintain the Data team ETL pipeline Build and maintain version-controlled dbt models and a consistent bronze/silver/gold layer shared across the team Support dataset discovery and qualification using deep-search techniques. Onboard discovered data sources from extraction to analytics data mart. Deploy, schedule, and monitor data jobs; diagnose and resolve pipeline failures Apply AI/LLMs thoughtfully across the pipeline to keep pace with an ambitious roadmap while keeping output reliable Build and support BI reports for program managers and mid-to-senior leadership Take open-ended initiatives from scoping through production delivery with high quality Organize and maintain code, tests, and documentation using version control Qualifications Basic Qualifications: Advanced SQL, including aggregation, window/analytic functions, PARTITION expressions, row-level calculations, MERGE statements, and query tuning on columnar warehouses such as Redshift Proficiency in Python for data engineering — pandas, connecting to databases, system-level file management, and writing testable, well-structured modules Working knowledge of dbt (or an equivalent transformation framework): building version-controlled, modular models and a layered bronze/silver/gold architecture Experience with RESTful APIs and integrating external data sources Dimensional modeling and data-warehousing fundamentals Building data-quality tests and schema-evolution workflows Experience deploying and scheduling data jobs — batch pipelines, orchestration, and basic monitoring Solid experience working in a cloud data environment, AWS preferred (S3, Redshift, Secrets Manager, CloudWatch, Lambda, Kinesis, Glue) Ability to build and support BI reports in an industry-standard tool (Tableau preferred) Practical experience applying AI/LLMs to real work, with a strong grasp of prompting fundamentals and advanced techniques (context management, structured output, evaluation) to produce reliable results Version control (Git) and good coding practices — testing, code review, and documentation A self-starter mindset: able to take on open-ended tasks and execute to a high standard with limited direction Preferred Qualifications: Experience productionizing pipelines: containerization, CI/CD, secrets management, observability/alerting, and operator runbooks Familiarity with data discovery, crawling/scraping, and building LLM-in-the-loop evaluation workflows Experience enabling analysts through self-service access, onboarding, and documentation Experience with extract-layer tooling like Fivetran or Stitch Advanced BI tool experience, including administration of a Tableau Cloud environment, dashboarding, and geospatial visualization Disaster Response Expectations: 211 LA serves as a critical component of Los Angeles County's emergency response network. While this is a primarily remote position with standard business hours, employees are required to support emergency operations outside of normal working hours during declared disasters, public emergencies, or other critical incidents. The Analytics Engineer should be able to respond to urgent requests with flexibility and professionalism, helping ensure that accurate, timely data and reporting are available to support operational decision-making. Such situations are infrequent but are an essential part of supporting 211 LA's mission and the communities we serve.   Compensation $105,000 annually, commensurate with experience. Benefits Comprehensive health and wellness benefits Retirement savings plan Professional development opportunities Flexible work arrangements Employee assistance program Physical Demands & Working Conditions The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Ability to lift up to 20 pounds. Prolonged periods sitting at a desk and working on a computer. Equal Opportunity Employer 211LA is an Equal Opportunity Employer and values diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.