Tesla Motors, Inc.
What to Expect
We are looking for a Sr. Data Engineer (5+ yrs. of experience) that will be focusing on providing automations and data solutions to Finance and Accounting teams. They will be crucial to support various initiatives such as Accounting Reporting, Analytics, Financial Forecasting and many more. They will make sure to support business teams using various technologies and tools based on needs of the projects. They will be able to handle projects end to end while effectively assuming multiple roles throughout the process. They would be comfortable collaborating with both business and technical teams to deliver automated data driven projects. This position involves designing and creating ETL pipelines, Data Models, developing Analytics and Reporting solutions.
What You'll Do
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
What You'll Bring
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
Compensation and Benefits Benefits
Aetna PPO and HSA plans > 2 medical plan options with $0 payroll deduction
Family-building, fertility, adoption and surrogacy benefits
Dental (including orthodontic coverage) and vision plans, both have options with a $0 paycheck contribution
Company Paid (Health Savings Account) HSA Contribution when enrolled in the High Deductible Aetna medical plan with HSA
Healthcare and Dependent Care Flexible Spending Accounts (FSA)
401(k) with employer match, Employee Stock Purchase Plans, and other financial benefits
Company paid Basic Life, AD&D, short-term and long-term disability insurance
Employee Assistance Program
Sick and Vacation time (Flex time for salary positions), and Paid Holidays
Back-up childcare and parenting support resources
Voluntary benefits to include: critical illness, hospital indemnity, accident insurance, theft & legal services, and pet insurance
Weight Loss and Tobacco Cessation Programs
Tesla Babies program
Commuter benefits
Employee discounts and perks program
Expected Compensation $108,000 - $186,000/annual salary + cash and stock awards + benefits
Pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. The total compensation package for this position may also include other elements dependent on the position offered. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.
#J-18808-Ljbffr
What You'll Do
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
What You'll Bring
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
Compensation and Benefits Benefits
Aetna PPO and HSA plans > 2 medical plan options with $0 payroll deduction
Family-building, fertility, adoption and surrogacy benefits
Dental (including orthodontic coverage) and vision plans, both have options with a $0 paycheck contribution
Company Paid (Health Savings Account) HSA Contribution when enrolled in the High Deductible Aetna medical plan with HSA
Healthcare and Dependent Care Flexible Spending Accounts (FSA)
401(k) with employer match, Employee Stock Purchase Plans, and other financial benefits
Company paid Basic Life, AD&D, short-term and long-term disability insurance
Employee Assistance Program
Sick and Vacation time (Flex time for salary positions), and Paid Holidays
Back-up childcare and parenting support resources
Voluntary benefits to include: critical illness, hospital indemnity, accident insurance, theft & legal services, and pet insurance
Weight Loss and Tobacco Cessation Programs
Tesla Babies program
Commuter benefits
Employee discounts and perks program
Expected Compensation $108,000 - $186,000/annual salary + cash and stock awards + benefits
Pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. The total compensation package for this position may also include other elements dependent on the position offered. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.
#J-18808-Ljbffr