Data Analytics Engineer

4 days ago

San Carlos, California, United States San Mateo County Transit District Full time

JOB

The Information System Analyst III (Data Engineer) reports to the IT Manager, Data Analytics., and is responsible for managing Data, Analytics & Business Intelligence program for the San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (JPB), and the San Mateo County Transportation Authority (TA).This pivotal role demands extensive expertise in Python, SQL, Snowflake, SQL Server, Redshift, ETL tools, and data visualization platforms. The ideal candidate will be responsible for designing, developing and maintaining robust data pipelines and architecture that support our business intelligent initiatives. This role requires a strong understanding of database design, data warehousing, and cloud technologies to ensure efficient processing and storage of large datasets.

EXAMPLE OF DUTIES

Design, build, and optimize ETL/ELT processes using tools like Fivetran, Matillion, Informatica and StreamSets for efficient data ingestion, transformation into data warehouses like Amazon Redshift and SQL Server.Manage and optimize databases like SQL Server, Amazon Redshift, Snowflake including schema design, query optimization, performance tuning, and data modeling.Develop and maintain data processing scripts and automation workflows using Python for data manipulation, integration, and system automation.Implement and monitor data quality checks, ensuring data integrity, accuracy, and adherence to data governance policies.Identify, troubleshoot, and resolve issues related to data pipelines, databases, and data-related systems.Create and maintain comprehensive documentation for data pipelines, data models, and system configurations.Essential DutiesDesign, build, and maintain production-level reports and dashboards using BI tools like Power BI and Tableau to support business operations.Design, develop, and integrate RESTful and SOAP-based web services to enable seamless data exchange between enterprise applications and third-party systems, ensuring scalability, security, and performance.Manage project scope, deliverables, and risks while collaborating with stakeholders to understand their data needs and translate them into technical requirements.Ensure BI solutions are scalable, reliable, and secure, while developing and monitoring key performance indicators (KPIs) to track business performance.Collaborate with cross-functional teams to optimize data workflows and drive analytics projects from inception to completion.Foster self-service capabilities, empowering users to independently access and report on data.Contribute to best practices and mentor other analysts within the Analytics discipline.

  • Data Analytics Engineer

    1 week ago

    San Jose, California, United States Advantest Full time $120,000 - $250,000 per year

    Job DescriptionAdvantest is seeking a versatile Senior Data Analytics Engineer to design, develop, and deploy data solutions that bridge infrastructure, analytics, and machine learning. In this individual contributor role, you will own the full lifecycle of data projects—from building scalable pipelines to developing predictive models—that empower...

  • People Analytics Data Engineer

    1 week ago

    San Francisco, California, United States Anthropic Full time $175,000 - $245,000 per year

    About AnthropicAnthropic's mission is to create reliable, interpretable, and steerable AI systems. We want AI to be safe and beneficial for our users and for society as a whole. Our team is a quickly growing group of committed researchers, engineers, policy experts, and business leaders working together to build beneficial AI systems.We are seeking a People...

  • Data Analytics

    5 hours ago

    San Francisco, California, United States Photon Full time

    We are seeking a hands-on Data Analyst / Data Engineer to support the Client's analytics and finance teams in consolidating data from multiple dental clinics into a centralized Snowflake data warehouse and delivering actionable Power BI dashboards. The role requires a self-motivated individual capable of working independently with limited supervision,...

  • Sr. Data Instrumentation Analytics Engineer

    2 days ago

    San Diego, California, United States Apple Full time

    We're idealists. Inventors. Forever tinkering with products and processes, always on the lookout for better. Whether you work at our global offices, offsite, or even at home, a job at Apple will be demanding. But it also rewards forward-thinking, creative thinking, and hard work. And none of us here would have it any other way. Does an exciting, dynamic, and...

  • Marketing Data Analytics Engineer

    2 days ago

    San Francisco, California, United States Together AI Full time

    Position SummaryWe are seeking a highly analytical and process-oriented Marketing Data Analytics Engineer professional to join our dynamic marketing team. This role will report into the Revenue Strategy and Operations team. The ideal candidate will bridge the gap between marketing strategy and execution, leveraging data to optimize campaigns, streamline...

  • Data Specialists

    6 days ago

    San Francisco, California, United States CyberCube Analytics Full time $124,488 - $134,000 per year

    About CyberCube:The market leader in digital analytics with the mission of delivering the world's leading cyber risk analytics on one of the most critical risks of today and the future.Exceptionally well-funded startup that has raised over $100MM from top-tier investors.Used by 75% of the top 40 US and European cyber insurance carriers & surpassing 100...

  • Senior Analytics Engineer

    1 week ago

    San Francisco, California, United States Tools for Humanity Full time $204,000 - $220,000

    About the Company: World is a network of real humans, built on privacy-preserving proof-of-human technology, and powered by a globally inclusive financial network that enables the free flow of digital assets for all. It is built to connect, empower, and be owned by everyone.About the teamThe Analytics Engineering team bridges the gap between data engineering...

  • Analytics Engineer

    2 days ago

    San Francisco, California, United States Cognition Full time

    We are an applied AI lab building end-to-end software agents.We're the makers of Devin, the first AI software engineer. Cognition is building collaborative AI teammates that enable engineers to focus on more interesting problems and empower engineering teams to strive for more ambitious goals.Our team is small and talent-dense. Among our founding team, we...

  • Analytics Engineer

    1 week ago

    San Francisco, California, United States Cognition AI Full time $120,000 - $180,000 per year

    LocationSan Francisco Bay AreaEmployment TypeFull timeLocation TypeOn-siteDepartmentGTMWe are an applied AI lab building end-to-end software agents.We're the makers of Devin, the first AI software engineer. Cognition is building collaborative AI teammates that enable engineers to focus on more interesting problems and empower engineering teams to strive for...

  • Data analytics architect

    1 week ago

    San Jose, California, United States Samsung SDSA Full time $104,000 - $240,000 per year

    Company Description Our Employees Are Among The Most Talented People In Their Fields And The Key To Our SuccessAt Samsung, we encourage our employees to showcase their talent through our diverse corporate culture. Our strength is our people. Each individual makes an impact to the company and plays a vital role in contributing to the company's success. Our...