Job Summary:
Tesla is seeking a Sr. Data Engineer who will focus on providing automation and data solutions for the Finance and Accounting teams. The role involves designing and creating ETL pipelines, data models, and developing analytics and reporting solutions while collaborating with both business and technical teams.
Responsibilities:
• Design and implement automated data solutions to support various business teams such as Manufacturing, Accounting and Finance
• Own and manage projects from design to production, maintain relationship with stakeholders and collaborate with both business and technical teams to satisfy business needs
• Write, maintain and optimize scripts, processes and jobs that will be used by analytics and reporting solutions
• Build, manage and optimize scalable ETL pipelines using multiple sources apply transformation as per business needs and load data into data warehouse
• Design and refine data models by following best practices and techniques using most effective approaches for reporting and analytics such as star schema
• Identify slow-running processes and bottlenecks, troubleshoot problems, research and resolve issues
• Stay up to date with latest trends in data engineering, experiment with new tools, services, technologies and real-time processing frameworks
• Reverse engineer existing projects or products in use and always look for improvements in processes preferably with open-source technologies
• Collaborate with auditor and compliance teams to ensure that data solutions are in compliance with sox requirements especially on accounting and finance related projects
• Set high technical bar not just for yourself but for entire team, leading by example in coding standards, documentation and best practices
Qualifications:
Required:
• 5+ yrs. of experience in data engineering
• Expert level SQL skills with deep knowledge of relational and analytical databases (ie: MS SQL, Oracle, MySQL, Vertica, Snowflake, etc.)
• Proven experience in data warehousing, including data modeling (dimensional/star/snowflake), large-scale data processing and enterprise warehouse design and maintenance
• Programming proficiency in Python or similar languages for building data pipelines and scalable data solutions
• Migration experience in moving from legacy stack to modern platforms such as Kafka, Airflow, dbt, Snowflake, Trino, including redesign of ETL/ELT workflows and schema refactoring
• Hands-on experience with modern data platforms, distributed technologies, real-time/streaming/event-driven ETL frameworks such as Apache Kafka, Spark, or similar
• Strong understanding of orchestration and transformation frameworks (Airflow, dbt, or similar) and best practices for CI/CD in data engineering
• Familiarity with data analytics and OLAP platforms and best practices for performance tuning and query optimization
• Experience delivering insights with data visualization and reporting tools such as Tableau, Power BI, Looker, etc.
• Excellent communication and collaboration skills, with the ability to work effectively across technical teams and business stakeholders
Company:
Tesla is an electric vehicle and clean energy company that provides electric cars, solar, and renewable energy solutions. Founded in 2003, the company is headquartered in Austin, USA, with a team of 10001+ employees. The company is currently Late Stage.