Sr. Data Engineer, Accounting, Finance & SOX Compliance
3 Days Old
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
Requirements
- Very strong SQL skills and very good understanding of relational databases (SQL Server, MySQL, Oracle, Vertica, etc.)
- Data warehousing experience, good understanding of data modeling, dimensional modeling, working experience with large scale data
- Programming skills with Python, Java or similar
- Good understanding of open-source distributed systems technologies such as Kafka, Spark
- Expertise in scalable ETL and data pipelines and tools such as (SSIS, Informatica, Airflow, Luigi or similar)
- Knowledge of OLAP databases and tools (SSAS, Hyperion, Cognos etc.)
- Experience with Reporting and data visualization tools (SSRS, PowerBI, Tableau, Looker or similar)
- Excellent communication skills and able to effectively communicate and collaborate with both technical and business teams (such as manufacturing, compliance, finance and accounting)
- Having background in Accounting, Finance, Banking or similar industry is nice to have but not a necessity
Compensation and Benefits
Benefits
Along with competitive pay, as a full-time Tesla employee, you are eligible for the following benefits at day 1 of hire:
- 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.
- Location:
- Fremont
- Job Type:
- FullTime