Develop and manage the modernization of the current data infrastructure at Dodge & Cox using computer applications software and specialized database programs. This includes developing processes for loading and transforming large volumes of structured and semi-structured data, participating in data warehouse development by defining metadata and security standards, and performing a variety of tasks to facilitate completion of projects. The role involves coordinating communication with different departments, writing documentation and specifications, and testing. It also includes mentoring contracted professionals in engineering best practices and effective use of cloud infrastructure and tools, performing technical design reviews and code reviews, creating and updating CI/CD pipelines for deployments, and creating processes for cloud disaster recovery and implementing them when necessary. The position requires applying knowledge of application development on SQL/Oracle databases, .NET, SSIS, and cloud-based data solutions in Azure Data Factory, Data Lake Storage, .NET, and Snowflake. The role also involves designing software or customizing software for the development of modern data and analytics solutions in a hybrid cloud model, including leading team activities such as technical direction, standard development practices, and production support. The lead will work with internal data engineers and architects, and lead the modernization of current data infrastructure, including cloud-based data warehouse, data lakes, and data mart solutions. Additionally, the role involves leading and contributing to the contracted team responsible for data ingestion processes, performance, administration, and design of database structures. The position requires analyzing, documenting, and recommending optimal software solutions for data ingestion processes, performance, administration, and database structure design, including performing research and proof of concepts to advise on decisions regarding emerging technologies. The lead will understand the data landscape (tooling, tech stack, source systems, etc.) and work closely with technology teams to improve data collection, quality, reporting, and analytics capabilities. Travel is NOT required. The position is based in San Ramon, Contra Costa County, CA, and in San Francisco, San Francisco County, CA. A limited telecommuting option of one day per week is available.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Job Type
Full-time
Career Level
Senior