Job ID: JOB_ID_9094
Job Title: Data Engineer
We are looking for a Sr. Data Engineer with 5+ years of experience focusing on providing automations and data solutions to Finance and Accounting teams. This role is crucial for supporting various initiatives such as Accounting Reporting, Analytics, and Financial Forecasting. The engineer will support business teams using various technologies and tools based on project needs, handling projects end-to-end and assuming multiple roles. Collaboration with both business and technical teams to deliver automated data-driven projects is essential. The position involves designing and creating ETL pipelines, Data Models, and 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 relationships with stakeholders, 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 a data warehouse.
- Design and refine data models by following best practices and techniques using effective approaches for reporting and analytics, such as star schema.
- Identify slow-running processes and bottlenecks, troubleshoot problems, and research and resolve issues.
- Stay up-to-date with the latest trends in data engineering, experimenting with new tools, services, technologies, and real-time processing frameworks.
- Reverse engineer existing projects or products and look for improvements in processes, preferably with open-source technologies.
- Collaborate with auditor and compliance teams to ensure data solutions comply with SOX requirements, especially for accounting and finance-related projects.
- Set a high technical bar for the entire team, leading by example in coding standards, documentation, and best practices.
What You’ll Bring
- Very strong SQL skills and a good understanding of relational databases (SQL Server, MySQL, Oracle, Vertica, etc.).
- Data warehousing experience, with a good understanding of data modeling, dimensional modeling, and 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, able to effectively communicate and collaborate with both technical and business teams (such as manufacturing, compliance, finance, and accounting).
Domain Experience: Accounting, Finance, Banking or similar industry.
Special Requirements
Interview mode: Onsite interviews required. Domain: Accounting, Finance, Banking or similar industry. Compliance: SOX requirements.
Compensation & Location
Salary: $100,000 – $150,000 per year (Estimated)
Location: Fremont, CA
Recruiter / Company – Contact Information
Email: amitvikalg@gmail.com
Recruiter Notice:
To remove this job posting, please send an email from
amitvikalg@gmail.com with the subject:
DELETE_JOB_ID_9094