Data Analyst/Data Engineer

Data Analyst/Data Engineer Job ID: 1362 Job Posted: 11/16/2020 Responsibilities: Conceptualize, build and maintain pre-aggregated datasets, reports and other analytical products Collaborate with business stakeholders to understand business problems and build/automate analytics products such as: Well architected (re-usable, scalable) aggregate tables that meet current and future reporting needs in the EDW Intuitive and actionable dashboards and data visualizations for data-drive decision making using presentation layer BI tools like Tableau, SSRS etc., Develop a deep understanding of the Snowflake EDW, dimensional models and ETL business logic Become a subject matter expert in TFG’s upstream source systems over time Translate data and insights into a meaningful story to drive strategy, action, and decision-making at an executive level Work closely with the Data Platforms team to determine the best strategy for process scheduling and follow best practices set by the team Required Skills: Expert SQL skills, particularly in an analytics / reporting capacity. Significant experience creating and maintaining DW and reporting processes Advanced Data modeling skills (hands-on experience + theoretical understanding) Implementing star-schemas/snowflake-schemas Slowly changing dimensions Advanced SQL skills required Primary/foreign keys, indexes (when to use them) Joins and unions Tables and Views (How are they different? Pros and cons of using) Be able to describe differences between DML/DDL statements Window functions Scalar and aggregate functions Requirements: Master's degree or equivalent in Computer Science, Engineering, Information Technology or Related field. How to Apply: Mail resume to Rakirs Systems LLC, Attn: HR, Work Hours: 9:00 a.m. to 5:00 p.m. HR@rakirssystems.com