Data Analyst/Data Engineer
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
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