OVA.Work
Posted 67 days agoVerified live 1d ago
Analytics Engineer
Brief overview
Remote
UndergradOr in progress
2+ yrsMinimum
SQLPostgreSQLMySQLSQL ServerOracleSnowflakeAmazon RedshiftGoogle BigQueryAzure SQL DatabaseStar SchemaSnowflake SchemaFact TablesDimension TablesSlowly Changing DimensionsData VaultNormalizationDenormalization
About the company
OVA.Workova.work
OVA is the most advanced Automated, Intelligent, intuitive On-boarding platform for Staffing Firms of all sizes.
Job description
Summary
OVA.Work is seeking a skilled Analytics Engineer to bridge the gap between data engineering and business analytics. The ideal candidate will be responsible for building reliable and well-modeled datasets for business intelligence and reporting, ensuring high-quality, analytics-ready data.
Responsibilities
- Design, build, and maintain scalable analytics data models
- Develop and optimize ETL/ELT pipelines for data transformation
- Build reliable data marts and semantic layers for business reporting
- Create reusable datasets for BI tools and self-service analytics
- Ensure data quality, consistency, and governance across platforms
- Optimize SQL queries and improve warehouse performance
- Collaborate with Data Engineers, Data Scientists, Product Managers, and Business Analysts
- Automate data validation and testing
- Document data models, transformations, and business logic
- Monitor data pipelines and resolve production issues
- Support dashboard development for business intelligence teams
Skills
- Advanced SQL
- Complex JOINs
- Window Functions
- Common Table Expressions (CTEs)
- Stored Procedures
- Views
- Query Optimization
- Data Partitioning
- Indexing
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- Snowflake
- Amazon Redshift
- Google BigQuery
- Azure SQL Database
- Star Schema
- Snowflake Schema
- Fact Tables
- Dimension Tables
- Slowly Changing Dimensions (SCD)
- Normalization
- Denormalization
- Semantic Layer Design
- Dbt (Data Build Tool)
- Apache Airflow
- Azure Data Factory
- AWS Glue
- Google Cloud Dataflow
- Talend
- Informatica
- SSIS
- Python-based ETL
- SQL
- Python
- Bash
- AWS
- Microsoft Azure
- Google Cloud Platform (GCP)
- Amazon S3
- AWS Redshift
- Azure Synapse Analytics
- Azure Data Lake
- Google BigQuery
- Google Cloud Storage
- Databricks
- Snowflake
- Amazon Redshift
- Google BigQuery
- Azure Synapse Analytics
- Microsoft Fabric
- Databricks
- Power BI
- Tableau
- Looker
- LookML
- Microsoft Excel
- Data Validation
- Data Lineage
- Metadata Management
- Data Catalog
- Data Governance
- Data Profiling
- Data Quality Testing
- Git
- GitHub
- GitLab
- Azure DevOps
- CI/CD
- Docker
- Kubernetes (Basic)
- Strong analytical and problem-solving skills
- Excellent communication and stakeholder management
- Attention to detail
- Ability to translate business requirements into technical solutions
- Collaboration and teamwork
- Time management and prioritization
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related field
- 2–6+ years of experience in analytics engineering, data engineering, or business intelligence
- Hands-on experience with dbt and cloud data warehouses
- Experience with Agile/Scrum methodologies
- Dbt Fundamentals Certification
- Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Google Professional Data Engineer
- AWS Certified Data Engineer – Associate
- Snowflake SnowPro Core Certification
- Scala
Qualifications
Must Haves
- Advanced SQL
- Complex JOINs
- Window Functions
- Common Table Expressions (CTEs)
- Stored Procedures
- Views
- Query Optimization
- Data Partitioning
- Indexing
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- Snowflake
- Amazon Redshift
- Google BigQuery
- Azure SQL Database
- Star Schema
- Snowflake Schema
- Fact Tables
- Dimension Tables
- Slowly Changing Dimensions (SCD)
- Normalization
- Denormalization
- Semantic Layer Design
- dbt (Data Build Tool)
- Apache Airflow
- Azure Data Factory
- AWS Glue
- Google Cloud Dataflow
- Talend
- Informatica
- SSIS
- Python-based ETL
- SQL
- Python
- Bash
- AWS
- Microsoft Azure
- Google Cloud Platform (GCP)
- Amazon S3
- AWS Redshift
- Azure Synapse Analytics
- Azure Data Lake
- Google BigQuery
- Google Cloud Storage
- Databricks
- Snowflake
- Amazon Redshift
- Google BigQuery
- Azure Synapse Analytics
- Microsoft Fabric
- Databricks
- Power BI
- Tableau
- Looker
- LookML
- Microsoft Excel
- Data Validation
- Data Lineage
- Metadata Management
- Data Catalog
- Data Governance
- Data Profiling
- Data Quality Testing
- Git
- GitHub
- GitLab
- Azure DevOps
- CI/CD
- Docker
- Kubernetes (Basic)
- Strong analytical and problem-solving skills
- Excellent communication and stakeholder management
- Attention to detail
- Ability to translate business requirements into technical solutions
- Collaboration and teamwork
- Time management and prioritization
Nice to Haves
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related field
- 2–6+ years of experience in analytics engineering, data engineering, or business intelligence
- Hands-on experience with dbt and cloud data warehouses
- Experience with Agile/Scrum methodologies
- dbt Fundamentals Certification
- Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Google Professional Data Engineer
- AWS Certified Data Engineer – Associate
- Snowflake SnowPro Core Certification
- Scala
Benefits
- Work_model: [remote, onsite]
