Analytics Engineer

Analytics EngineerData, Artificial Intelligence, & Solutions (DAIS) • Full-Time • Remote211LA 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 DetailsPosition: Analytics EngineerReports To: Director of Data, Artificial Intelligence, & SolutionsDepartment: Data, Artificial Intelligence, & Solutions (DAIS)Employment Type: Full-Time, ExemptKey ResponsibilitiesDevelop, own, and maintain the Data team ETL pipelineBuild and maintain version-controlled dbt models and a consistent bronze/silver/gold layer shared across the teamSupport 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 failuresApply AI/LLMs thoughtfully across the pipeline to keep pace with an ambitious roadmap while keeping output reliableBuild and support BI reports for program managers and mid-to-senior leadershipTake open-ended initiatives from scoping through production delivery with high qualityOrganize and maintain code, tests, and documentation using version controlQualificationsBasic Qualifications:Advanced SQL, including aggregation, window/analytic functions, PARTITION expressions, row-level calculations, MERGE statements, and query tuning on columnar warehouses such as RedshiftProficiency in Python for data engineering — pandas, connecting to databases, system-level file management, and writing testable, well-structured modulesWorking knowledge of dbt (or an equivalent transformation framework): building version-controlled, modular models and a layered bronze/silver/gold architectureExperience with RESTful APIs and integrating external data sourcesDimensional modeling and data-warehousing fundamentalsBuilding data-quality tests and schema-evolution workflowsExperience deploying and scheduling data jobs — batch pipelines, orchestration, and basic monitoringSolid 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 resultsVersion control (Git) and good coding practices — testing, code review, and documentationA self-starter mindset: able to take on open-ended tasks and execute to a high standard with limited directionPreferred Qualifications:Experience productionizing pipelines: containerization, CI/CD, secrets management, observability/alerting, and operator runbooksFamiliarity with data discovery, crawling/scraping, and building LLM-in-the-loop evaluation workflowsExperience enabling analysts through self-service access, onboarding, and documentationExperience with extract-layer tooling like Fivetran or StitchAdvanced BI tool experience, including administration of a Tableau Cloud environment, dashboarding, and geospatial visualizationDisaster 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.BenefitsComprehensive health and wellness benefitsRetirement savings planProfessional development opportunitiesFlexible work arrangementsEmployee assistance programPhysical Demands & Working ConditionsThe 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 Employer211LA 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. #J-18808-Ljbffr Information-and-Referral-Federation-of-Los-Angeles-County