Data Engineer, BI Accounting & Finance

ArrowCore Group; Fremont (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology solutions provider is seeking a Data Engineer in Fremont, CA to develop automated data solutions for Finance and Accounting teams. The role involves designing ETL pipelines, collaborating with business stakeholders, and ensuring compliance with SOX. Ideal candidates will have strong SQL skills, experience with data warehousing, and proficiency in programming languages like Python or Java. A background in finance is advantageous. The contract is for 12 months.

Qualifications

• Strong understanding of data warehousing and dimensional modeling.
• Experience in scalable ETL and data pipelines.
• Background in Accounting, Finance, or related field is a plus.

Responsibilities

• Design and implement automated data solutions for various business teams.
• Build and optimize ETL pipelines from multiple data sources.
• Collaborate with auditor and compliance teams to ensure data solutions meet SOX requirements.

Skills

Very strong SQL skills

Programming skills with Python or Java

Good understanding of distributed systems technologies (Kafka, Spark)

Excellent communication skills

Experience with reporting and data visualization tools (SSRS, PowerBI, Tableau)

Tools

ETL tools (SSIS, Informatica, Airflow)

OLAP databases and tools (SSAS, Hyperion, Cognos)

Job description

Data Engineer (3‑5 years experience)

We are looking for a Data Engineer focusing on providing automation and data solutions to Finance and Accounting teams. The role supports initiatives such as Accounting Reporting, Analytics, and more, collaborating with business and technical teams to deliver automated, data‑driven projects. Responsibilities include designing and creating ETL pipelines, data models, and developing analytics and reporting solutions.

Location: Fremont, CA
Contract: 12 month

Responsibilities

• 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 stakeholder relationships and collaborate with both business and technical teams to satisfy business needs
• Write, maintain and optimize scripts, processes and jobs used by analytics and reporting solutions
• Build, manage and optimize scalable ETL pipelines using multiple sources, apply transformations as per business needs and load data into the datawarehouse
• Design and refine data models following best practices and techniques to support reporting and analytics (e.g., 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 seek improvements in processes, preferably with open‑source technologies
• Collaborate with auditor and compliance teams to ensure that data solutions comply with SOX requirements, especially on accounting and finance related projects
• Set a high technical bar, leading by example in coding standards, documentation and best practices

Qualifications

• Very strong SQL skills and understanding of data warehousing (SQL Server, MySQL, ClickHouse, Vertica, etc.)
• Experience in data warehousing, data modeling and dimensional modeling, working 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 ability to collaborate effectively with technical and business teams (manufacturing, compliance, finance, accounting)
• Background in Accounting, Finance, Banking or similar industry is nice to have but not a necessity

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability or veteran status.