This is a remote position.

Job Summary

We are hiring a Database Analyst / Report Writer to support an AWS-based data warehouse and drive data-driven decisions across the business. Maintain, optimize, and expand a Medallion Architecture (Bronze → Silver → Gold) and build dynamic Power BI reporting. Lead migration and modernization of legacy Microsoft SQL Server workloads into AWS services such as Glue, S3, Athena, and Redshift. Strong SQL performance tuning is essential.

Key Responsibilities

• Lead migration of Microsoft SQL Server databases to AWS data warehouse services (Glue, S3, Athena, Redshift)
  

• Refactor and optimize T-SQL for Athena or Redshift SQL compatibility and performance
  

• Design, build, and maintain ETL pipelines that extract from on-prem SQL Server, transform with AWS Glue (PySpark or SQL), and load into S3 Medallion layers
  

• Model cloud-native schemas using Glue Catalog and Athena; manage partitioning and schema evolution
  

• Profile and tune complex SQL across SQL Server and AWS using execution plans and indexing
  

• Oversee ingestion using AWS Lambda, Step Functions, and Glue jobs; ensure accuracy and completeness
  

• Manage S3 data lake layers and version control across Raw or Bronze, Silver, and Gold
  

• Validate data integrity and lineage; prevent duplication and schema drift
  

• Build and enhance Power BI datasets and dashboards connected to the Gold layer
  

• Implement and manage Power BI gateway and incremental refresh
  

• Create reusable DAX measures and consistent BI data models
  

• Translate business KPIs and ad hoc needs into scalable BI solutions
  

• Collaborate with DevOps on AWS performance, IAM, and permissions for Glue or Athena
  

• Implement data governance with Lake Formation, CloudTrail, Secrets Manager, and Config
  

• Integrate external APIs and third-party data sources
  

• Track work in Jira and contribute to architecture reviews and roadmap planning
  

• Monitor ETL performance and troubleshoot discrepancies; drive continuous improvement
  

Requirements

Qualifications

• 3+ years in database analysis, data warehousing, or SQL Server migration
  

• Expert T-SQL and ANSI SQL, including joins, window functions, indexing, query plan analysis, and performance optimization in SQL Server and AWS Athena or Redshift
  

• Hands-on experience migrating SQL Server databases to cloud, preferably AWS
  

• Proven Power BI development with strong data modeling and DAX
  

• Practical experience with AWS data tools: Glue, S3, Athena, Lambda, Step Functions, and Redshift or RDS
  

• Strong data modeling, normalization, and schema design
  

• Familiarity with ETL orchestration and monitoring in AWS
  

• Experience using Jira for task tracking
  

• High attention to detail and analytical problem solving
  

Preferred Skills

• AWS Schema Conversion Tool and Database Migration Service
  

• Migrating SSIS workflows to Glue, Lambda, or Step Functions
  

• Data type and collation conversions and translating T-SQL logic to PySpark or Glue SQL
  

• API-based ingestion and third-party data integration
  

• Data governance, security compliance, and audit best practices
  

• Data lineage tracking and automated quality checks
  

• Power BI Service administration and refresh automation
  

Bonus

• Blockchain data integration or audit logging
  

• Cross-platform reporting ecosystems such as Power BI to API to applications
  

• Python and boto3 for AWS automation and migration scripting
  

Remote Work Requirements

All our positions are fully remote (work from home). To ensure smooth operations, performance, and compliance with our standards, all team members must meet the following requirements:

Internet and Power Backup
• Minimum 100 Mbps fiber internet connection
• Battery backup or power solution for your internet connection to prevent downtime during outages

Device and Hardware
• Bring Your Own Device (BYOD) with battery backup
• Noise-cancelling headset for clear communication on calls and meetings

Minimum Device Specifications
• Intel i5 processor or higher
• 8–16+ GB RAM
• Less than 5 years old
• Device must be dedicated solely to work purposes (no personal use permitted) to ensure cybersecurity compliance