Reporting & Analytics

• Tableau
• Power BI
• SQL Server SSRS
• Apache SuperSet
• Google Looker

Data Administration

• Database Administration and Development
  • SQL Server
  • PostgreSQL
  • MySQL/MariaDB
• Cloud Database Administration and Development
  • SnowFlake
  • Azure SQL Server
  • AWS RDS + Aurora
  • AWS Redshift
  • Google BigQuery
  • NoSQL: Mongo, DynamoDB
• Server Administration
  • Windows, Linux

Data Engineering

• Cloud ETL
  • DataBricks
  • AWS Glue, EMR, Redshift, Kafka, etc.
  • Azure Data Factory
  • DBT
• On Prem ETL
  • SQL Server SSIS
  • DBT
  • Apache AirFlow
• Graph Databases and Others
  • Neo4J
  • OpenSearch & ElasticSearch
  • AWS Neptune
• Scripting and Coding
  • SQL, Python, Java, C#

Data Governance

• Data Security, Management, and Auditing
• Data Quality, Ownership, & Organization Structure
• Industry best practices

Data Architecture

• Data Modelling: OLTP, OLAP, Modern Data Warehousing
• Data ETL Architecture: Distributing Compute, Micro-services, Integration
• Data Structure, Integrity, and Accuracy
• Industry best practices

Machine Learning & AI

• Data Insights using modern approaches
• Forecasting, data clustering, and pattern recognition
• Traditional statistical inference when applicable