Sr. Data Engineer, BI Accounting & Finance

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, 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, Supply Chain, 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

Very strong SQL skills and very good understanding of data warehousing (SQL Server, MySQL, ClickHouse, 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

RegardsSunitha BasaniSr US IT Recruiter - Prospance INC.,Email ID: sunitha.basani@prospanceinc.comPhone: +1 510-438-3120Website: www.prospanceinc.comSunitha Basanimandeep.adhikari321@gmail.comHi ,

Please find the Job Description for Sr. Data Engineer, BI Accounting & Finance with Tesla Motors and Please let me know if you are Interested.

Job Title : Sr. Data Engineer, BI Accounting & Finance

Location: Fremont, CA(Onsite) Only LOCALSInterview Mode: In-personDirect Client: Tesla Motors

JOB DESCRIPTION

Sr. Data Engineer, BI Accounting & Finance

Design and implement automated data solutions to support various business teams such as Manufacturing, Supply Chain, 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

Very strong SQL skills and very good understanding of data warehousing (SQL Server, MySQL, ClickHouse, 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

Job Types: Full-time, Contract

Pay: $60.00 - $70.00 per hour

Work Location: In person

Prospance Inc

Latest Jobs

Sr. Data Engineer

Data Engineer