Remoote.app

Work from anywhere. Start here.

Free resume builderCompaniesLog in
Apply

Data Warehouse Engineer

Posted 12 days agoViewed

View full description

💎 Seniority level: Middle, 3+ years

🔍 Industry: Telecom

🏢 Company: RNRS Solutions

⏳ Experience: 3+ years

Requirements:
  • 3+ years of experience as a Data Warehouse Engineer or in a similar role.
  • Strong experience with SQL and ETL tools such as Talend, Informatica, or Apache NiFi.
  • Hands-on experience with cloud-based data warehouses (e.g., AWS Redshift, Google BigQuery, Azure Synapse) is highly desirable.
  • Proficiency in scripting languages (Python, Shell scripting) for automation and data manipulation.
  • Familiarity with data modeling, schema design, and query optimization.
  • Strong understanding of data governance, security, and performance tuning in large-scale environments.
Responsibilities:
  • Design, develop, and maintain scalable data warehouse systems to meet the company’s growing data demands.
  • Ensure the integrity and accuracy of data stored in the warehouse by implementing ETL processes and data validation protocols.
  • Collaborate with data analysts, data scientists, and other stakeholders to understand business requirements and translate them into efficient data warehouse solutions.
  • Optimize the performance of the data warehouse by analyzing query performance and improving data structures.
  • Develop and maintain documentation for data warehouse architecture, processes, and systems.
  • Monitor and troubleshoot data flows, ensuring high availability and security of the data.
  • Participate in data migrations and ensure seamless integration of new data sources into the warehouse.
Apply

Related Jobs

Apply
🔥 Senior Data Warehouse Engineer
Posted about 2 months ago

📍 EU

🧭 Full-Time

🔍 Gaming

🏢 Company: Thrill Labs

  • Experience building high-scale DWH models and pipelines before
  • SQL is your primary language
  • You understand Kimball and Inmon and their trade-offs
  • Practical experience with dbt (or similar)
  • Practical experience with Airflow or Dagster
  • Knowledge of Clickhouse is a big plus
  • Experience with CDC solutions is a plus
  • Able to translate business requirements/requests into technical specifications
  • Build rock-solid data models
  • Create the ETL process for data storage in Clickhouse and prepare data for our Analytics and Operational team's consumption, including real-time processing
  • Close collaboration with your stakeholders

SQLETLAirflowClickhouseData engineeringRESTful APIsData modeling

Posted about 2 months ago
Apply
Apply
🔥 Sr. Data Warehouse Engineer
Posted 3 months ago

🔍 Health Plan

  • 8-10 years of experience as a Data Engineer
  • Strong ETL experience (SSIS, data warehousing concepts)
  • Health plan experience strongly preferred
  • Experience with bringing external data sources into data marts
  • Strong business knowledge of health plan operations and data
  • In-depth knowledge of SQL, data warehouses, and data transformation techniques
  • Proven experience with designing and building data pipelines
  • Expert knowledge of metadata management and related tools
  • Advanced knowledge of data ETL concepts, processes, and tools such as MS SSIS, ADF
  • Advanced knowledge of Python
  • Ability to read and understand various data structures
  • Ability to work independently and as part of a team
  • Strong analytical, technical, and troubleshooting skills
  • Ability to assess requirements from multiple sources and their impact on potential solutions
  • Ability to work in a complex environment
  • Ability to be organized and proficient at tracking tasks, defining next steps, and following project plans
  • Advanced knowledge of database and data warehousing concepts, including data lakes, relational and dimensional database design concepts, and data modeling practices
  • Intermediate knowledge of Jupyter Notebooks
  • Familiarity with Agile project management methods such as SCRUM, Lean, and/or Kanban
  • Advanced knowledge of healthcare data structures, workflows, and concepts, from Electronic Health Record systems like Epic
  • Knowledge of Azure cloud platform, Fabric data platform, ADF, and DevOps is highly preferred
  • Develop and maintain data pipelines, API-based or file-based data flows between source systems and the data warehouse
  • Use innovative tools and techniques to automate common data preparation and integration tasks with the goal of reducing defects and ensuring data quality
  • Implement best practices to ensure the integrity of data with exception-handling routines
  • Provides source to target mapping development, support, and maintenance.
  • Lead troubleshooting efforts and formulate interdisciplinary task force groups for ETL issues
  • Design, develop, and deploy data structures and data transformations in the enterprise data warehouse using Python, SSIS, ADF
  • Maintain and extend the Epic Caboodle platform and develop custom Caboodle data modeling components
  • Form relationships and coordinate with business stakeholders to identify data needs, clarify requirements, and implement solutions
  • Contribute to the department's short-term and long-term strategic plan
  • Make appropriate recommendations on the management of data extraction, and analysis
  • Maintain knowledge of the current regulations and technologies related to data management
  • Assist with data governance initiatives in the areas of data quality, data security, metadata, and master data management
  • Actively contribute to all aspects of the data project lifecycle including request intake and acknowledgment, project estimation, time-tracking, and prioritization of tasks.
  • Be an exemplary team player with excellent collaboration skills
  • Exhibit outstanding customer service skills with stakeholders
  • Perform other duties as required or assigned.
Posted 3 months ago
Apply
Apply
🔥 Sr. Analytics Engineer (Data Warehouse Engineer)
Posted 3 months ago

📍 United States

🧭 Full-Time

💸 135000.0 - 180000.0 USD per year

🔍 Software Development

🏢 Company: Smartsheet👥 1001-5000💰 $3,200,000,000 Post-IPO Debt 8 months ago🫂 Last layoff over 2 years agoSaaSEnterpriseSoftware

  • 10+ years of experience in advanced data modeling using Data Vault (DV 2.0), dbt, and Snowflake.
  • Proven experience in building analytics systems with data transformation, dependency, and workload management (Data Vault, AutomateDV, dbt core, Airflow, Snowflake, GitLab, SQL).
  • Proven experience with building and maintaining business analytics layers and semantic layers to enable self-service for non-technical end-users.
  • Strong production experience supporting and maintaining analytics/data warehouse solutions with mission-critical datasets.
  • Familiarity with data governance principles for maintaining datasets to enable a single source of truth.
  • Familiarity with self-serve product analytics tools (Amplitude, Thoughtspot, Tableau, Gainsight, etc.).
  • Knowledge of code management and CI/CD practices (GitLab, Airflow, Snowflake, Terraform).
  • Familiarity with AWS solutions such as S3, EC2, VPC.
  • Leading the implementation of efficient and scalable systems that optimize data transformations from our data lake in Snowflake into clean, documented data products.
  • Contribute to the design standards and architectural principle standards, designs and processes.
  • Build and maintain a governed, robust, reliable, and scalable analytics system (DW/DV).
  • Collaborating with BI analysts and data scientists to provide proper data accessibility guidelines.
  • Foster data democratization via activation of data on critical platforms like Smartsheet platform, Amplitude, Thoughtspot , Gainsight.
  • Create and contribute to frameworks that improve data quality and observability to identify and resolve issues faster.
  • Create and implement data testing plans, encompassing data validation, data quality assessment, and regression testing, to identify anomalies, inconsistencies, or errors in produced datasets.
  • Mentor and guide teams and help drive high standards across the team by conducting design reviews and engineering ideation forums.
  • Collaborate with cross-functional teams to assess data privacy needs and define data masking strategies aligned with industry compliance standards (e.g., GDPR, HIPAA, CCPA).

AWSLeadershipPythonSQLApache AirflowData AnalysisData MiningETLSnowflakeCross-functional Team LeadershipAmplitude AnalyticsTableauAlgorithmsData engineeringData StructuresCommunication SkillsAnalytical SkillsCollaborationCI/CDProblem SolvingRESTful APIsMentoringOrganizational skillsComplianceExcellent communication skillsActive listeningRisk ManagementData visualizationStakeholder managementData modelingData analyticsData management

Posted 3 months ago
Apply

Related Articles

How to Overcome Burnout While Working Remotely: Practical Strategies for Recovery

Posted about 1 month ago

How to Overcome Burnout While Working Remotely: Practical Strategies for Recovery

Burnout is a silent epidemic among remote workers. The blurred lines between work and home life, coupled with the pressure to always be “on,” can leave even the most dedicated professionals feeling drained. But burnout doesn’t have to define your remote work experience. With the right strategies, you can recover, recharge, and prevent future episodes. Here’s how.



Read More

Top 10 Skills to Become a Successful Remote Worker by 2025

Posted 6 days ago

Top 10 Skills to Become a Successful Remote Worker by 2025

Remote work is here to stay, and by 2025, the competition for remote jobs will be tougher than ever. To stand out, you need more than just basic skills. Employers want people who can adapt, communicate well, and stay productive without constant supervision. Here’s a simple guide to the top 10 skills that will make you a top candidate for remote jobs in the near future.

Read More

Weekly Digest: Remote Jobs News and Trends (August 11 - August 18, 2024)

Posted 9 months ago

Google is gearing up to expand its remote job listings, promising more opportunities across various departments and regions. Find out how this move can benefit job seekers and impact the market.

Read More

Weekly Digest: Remote Jobs News and Trends (August 5 - August 11)

Posted 10 months ago

Read about the recent updates in remote work policies by major companies, the latest tools enhancing remote work productivity, and predictive statistics for remote work in 2024.

Read More

Tech Layoffs and the New Dynamics of Remote Jobs

Posted 10 months ago

In-depth analysis of the tech layoffs in 2024, covering the reasons behind the layoffs, comparisons to previous years, immediate impacts, statistics, and the influence on the remote job market. Discover how startups and large tech companies are adapting, and learn strategies for navigating the new dynamics of the remote job market.

Read More