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