Data Engineer

Method360; San Francisco (CA); Remote; USD 90,000 - 130,000; Full time

Job summary

A growing tech company is seeking a Data & Analytics Engineer to enhance its data infrastructure and support various business functions. The role involves maintaining data workflows, developing data solutions using SQL, Python, and visualization tools, while ensuring optimal data delivery. Candidates should hold a Master's in Information Systems or Business Analytics and have strong proficiency in tools like Snowflake and Matillion.

Qualifications

• Masters in Information Systems or Business Analytics Required.
• Experience with SQL and AWS; proficient in Matillion, Snowflake, Power BI.
• Ability to build data models and perform data quality checks using Python.

Responsibilities

• Maintain and develop a scalable database/data warehouse.
• Build views to visualize data on Power BI.
• Design, build, and launch Relational and Dimensional Data Models.

Skills

Data Warehouse Management

SQL

AWS

Data Visualization

Python

Education

Masters Information Systems

Masters Business Analytics

Tools

Matillion

Snowflake

Power BI

Tableau

SAP FICO

SAP SD

Job description

Title: Data & Analytics Engineer

Duration: Full Time Employment

Job Location: Remote with some travel to client sites

Job Responsibilities and Requirements:

• Maintain and develop a scalable database/data warehouse through integrating disparate data housed across numerous organizational systems and different business lines, by loading structured data into appropriate schemas and tables while handing Change Data Capture (CDC)
• Perform/maintain end-to-end data infrastructure required for optimal extraction, transformation, and loading of data to target Database leveraging programming language SQL, AWS platform, Extract Load Transform (ELT) tool Matillion, cloud data warehouse Snowflake
• Build views to visualize data on Power BI
• Optimize / maintain workflows / scripts for ELT (Extract Load Transform)/ETL (Extract Transform and Load) and data warehouse job
• Design, build and launch Relational and Dimensional Data Models
• Work on ERP Platforms like SAP Finance Accounting & Controlling (FICO) and Sales Distribution (SD) modules helping business optimize their supply chain, revenue, margin, bill of materials (BOM) and profit analysis by providing the drill-down capability to track blocks and pain-points in the process flow
• Maintain data sources and workflows / data pipelines across different systems
• Maintain different data/analytics solutions including proficiency in Matillion, Snowflake and visualization tools Power BI, and Tableau to ensure data delivery to team members and ad-hoc reporting requirements
• Build Testing platforms and perform data quality checks helping organization-optimizing data-centric solutions that drive the business towards efficiency or productivity leveraging Python programming.
• Masters Information Systems or Business Analytics Required
  
  

Method360 is proud to be an Equal Opportunity Employer