Data Analyst Jobs

Advantage Tech is looking for a Data Analyst/Engineer to join their client's team as a consultant.

*** 3 Month Contract***

As a Data Analyst on the Data Analytics Team, you will be integral on this journey. Your primary area of responsibility will be building a strong data ecosystem which supports a new company-wide business intelligence and analytics environment.

You will assist in the design and development of standardized datasets derived from multiple systems of record. A key area of success for this role is developing or applying existing development and scripting skills in process automation to orchestrate data pipelines from business systems, data lakes and third-party data repositories.

You will be creating and loading dimensional models that will be used for analysis and reporting. As you work on projects and enhancements you will assist in refining data governance within business processes and the technical tool chain. A key to success in this role is to quickly learn the meaning of business data and understand the business domain. Your skills will be leveraged to accurately identify key data and build the system processes which will extract, transform, and load the data that is used in key business decisions.

Position Responsibilities:

• Develop data products using continuous deployment and automated data integration practices
• Scale and tune data pipelines, data sets and SQL queries
• Provide production support for integration and transformation pipelines
• Collaborate with business teams to identify data models and data sets for analytical consumption.
• Build real-time and batch data integrations from disparate source systems into the data lake/data warehouse
• Designing dimensional models and be able to cleanse and transform raw data into structured format
• Follow defined data governance framework and enterprise data models
• Participate in code reviews and provide feedback to the team
• Participate in agile story authoring, sizing, and demo sessions for developed features
• Apply standard methodologies to analyze, design, develop, and deploy data management solutions.
• Build and maintain scalable ETL processes using workflow automation tools
• Administer and maintain data pipelines used for loading data into the data warehouse

Position Requirements:

• Must be able to read/write SQL in the following environments (SQL Server, Oracle, DB2)
• Experience working with one or more columnar storage systems (Snowflake, Redshift, Big query, etc)
• Experience working in cloud data environments (AWS, Azure)
• Knowledge and skills with Power BI will be important, not critical
• Ability to multi-task and change priorities
• Strong business communications skills for requirements gathering and development
• Exposure to data streaming tools and technologies like Kafka, TensorFlow or similar
• Must have completed at least one full cycle of building a data lake and/or a data warehouse

?

Nice To Have

• Worked with or built Data Lakes, Data Warehouse in a hybrid environment (cloud / on-premises)
• Experience with end-to-end supply chain or merchandising
• Basic knowledge and understanding of statistics
• Proficiency with Excel including building macros
• Experience working in an IBM DB2, SQL Server or Oracle environment
• Experience working with CRM systems like Salesforce