What are the responsibilities and job description for the Hiring: Business (Data) Analyst for Denver, CO (Onsite) position at Key2Source INC?
Role: Business (Data) Analyst
Location: Denver, CO (Onsite)
Required skills:
o Experience: 4-6 years
o Develop Data Solutions: Analysed, Design and build applications and data pipelines using AWS, Databricks, Redshift, and Snowflake.
o ETL/ELT Development: Analyze standards and procedures for, and design data extraction, transformation, and loading (ETL/ELT) processes for both batch and real-time data.
o Database Management: Design DataLakes and Data Warehouses, and work with databases like Oracle and SQL Server.
o SQL Expertise: Write advanced SQL queries, including performance tuning, to support data analysis and application needs.
o Full-Cycle Development: Handle the entire software development lifecycle for data warehouse applications, from requirements analysis to implementation, testing, and debugging.
o System Integration: Integrate, enhance, and fine-tune Enterprise Data Warehouses to consolidate data from various sources