Job Title: DATA ANALYTICS/SOLUTIONS ARCHITECT

Location: Denver, CO

Duration Long Term

ROLE AND RESPONSIBILITIES:

· Focusing on deep technical background in data management and visualization· 3+ years of experience with Business Intelligence tech stack· Work with different user groups to understand their data needs and design solutions accordingly Implementing BI solutions, both client-facing and internal· Dashboards· Reports· KPIâ??s· Predictive analytics Database architecture and optimization· Design database architecture to meet BI and reporting needs, and future analytics needs· Design/Implement star and/or snowflake schemas, Table structure, location, partitioning, Indexes, Constraints, Keys, Data Types, Column Store Indexes SQL Development and optimization· Develop SQL queries, procedures, functions, views for BI and reporting purposes· Develop queries for complex reports· Analyze and tune SQL performance· Optimize SQL queries ETL Implementation· Analyze ETL requirements· Design/Implement ETL process· Monitor and maintain ETL processes· Experience in ETL/data integration tools like Informatica, MSFT SSIS, Oracle Warehouse Builder, Data Integrator, Lavastorm