Sr Data Engineer

Talentify; Fremont (CA); On-site; USD 83,000 - 90,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Commuter benefits

401K with company match

Job summary

Talentify is seeking a Sr. Data Engineer in Fremont, CA to design and implement automated data solutions for Finance and Accounting. You will build ETL pipelines and data models, enabling analytics and reporting across business teams.

With 5+ years of experience, you will collaborate with both business and technical teams, optimize data flows, and drive end-to-end data projects in a contract-to-hire arrangement.

Qualifications

• Strong SQL skills and relational DB expertise (SQL Server, MySQL, Oracle, Vertica, etc.).
• Data warehousing and data modeling experience, large-scale data.
• Programming in Python or Java.
• Open-source distributed systems (Kafka, Spark).
• ETL pipelines and tools (SSIS, Informatica, Airflow, Luigi).
• OLAP databases/tools (SSAS, Hyperion, Cognos).
• Reporting/visualization (SSRS, PowerBI, Tableau, Looker).
• Excellent communication with technical and business teams.
• Accounting/Finance domain experience is a plus.

Responsibilities

• Design and implement automated data solutions for Finance/Accounting teams.
• Own projects from design to production with stakeholders.
• Write and optimize scripts and jobs for analytics and reporting.
• Build scalable ETL pipelines from multiple sources to data warehouse.
• Refine data models using star schema and best practices.
• Identify bottlenecks, troubleshoot and resolve issues.
• Stay updated on data engineering trends and new tools.
• Collaborate with audit/compliance for SOX alignment.
• Lead by example with coding standards and docs.

Skills

SQL skills

Relational databases

Python

Java

Kafka

Spark

ETL pipelines

SSIS

Informatica

Airflow

Luigi

OLAP

SSAS

PowerBI

Tableau

Looker

Communication

Finance domain familiarity

Tools

Kafka

Spark

SSIS

Informatica

Airflow

Luigi

SSAS

Hyperion

Cognos

PowerBI

Tableau

Looker

Job description

JOB TITLE: Sr. Data Engineer
LOCATION: Fremont, CA
DURATION: 6+ Month Contract to Hire
RATE RANGE: $60-65/hour

POSITION SUMMARY:

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.

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

QUALIFICATIONS:

• 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

BENEFITS SUMMARY:

Individual compensation is determined by skills, qualifications, experience, and location. Compensation details listed in this posting reflect the base hourly rate or annual salary only, unless otherwise stated. In addition to base compensation, full-time roles are eligible for Medical, Dental, Vision, Commuter and 401K benefits with company matching.

IND123