Demo
Salary Resume Critique Job Openings

Data AnalystEngineer Data Modeling Analytics

ACCEL BI CORPORATION
Seattle, WA Full Time
POSTED ON 1/17/2025
AVAILABLE BEFORE 4/17/2025

We seek a Senior Data Analyst / Engineer with expertise in data modeling, analytics, and ETL processes to join our team. The ideal candidate will have significant experience with data modeling for analytic services, working with tabular and multidimensional models, and troubleshooting complex data warehouse and reporting system issues. This role requires a deep understanding of cloud-based data analytics services, particularly within the Microsoft Azure ecosystem, and a strong background in data integration, reporting, and optimizing data workflows.

Key Responsibilities :

  • Design, develop, and manage tabular and multidimensional data models for analytic services, ensuring optimal performance and scalability.
  • Troubleshoot and analyze data warehouse and report system issues, identify root causes, and implement effective solutions.
  • Write complex SQL queries to extract and manage large datasets, ensuring efficient data retrieval.
  • Using tools like Power BI or Tableau, develop interactive visual reports and dashboards with filters, variables, and drill-down capabilities.
  • Design and manage ETL processes, ensuring seamless data integration from on-premises and cloud-based sources.
  • Schedule and automate ongoing data processing jobs to ensure reliable data pipelines.
  • Optimize data processing workflows for improved performance and reliability.
  • Ensure data security through role-based access control (RBAC), encryption, and industry standards (e.g., HIPAA) compliance.
  • Collaborate with cross-functional teams to design scalable data solutions that meet growing data volumes and user demands.
  • Document technical processes, data models, and system configurations for development and operational purposes.
  • Implement high availability and disaster recovery processes to ensure business continuity.
  • Optimize resource usage and cost efficiency in cloud-based data solutions.
  • Stay up-to-date with emerging technologies and best practices in data engineering and analytics.

Qualifications :

  • Extensive experience with data warehouse modeling and development, including experience with both tabular and multidimensional models.
  • Strong understanding of Microsoft Azure services, particularly Azure Data Warehouse (DW), Azure Data Factory, and other Azure analytics services.
  • Experience writing complex queries in SQL Server and Oracle to manage large-scale datasets.
  • Hands-on experience with Power BI, SSRS, Tableau, and similar visualization tools for creating interactive reports and dashboards.
  • Familiarity with Python or other scripting languages for data manipulation and automation.
  • Strong understanding of data security measures, including encryption and role-based access control (RBAC).
  • Knowledge of industry data compliance regulations, such as HIPAA.
  • Ability to design scalable data solutions that handle large data volumes and user demand.
  • Experience with process optimization, including improving data models' and ETL workflows' performance and reliability.
  • Good understanding of high availability and disaster recovery concepts.
  • Experience with issue tracking and project management tools like Jira and familiarity with Agile software development methodologies.
  • Strong communication skills and ability to work collaboratively across teams.
  • Ability to maintain and create technical documentation for both development and operational purposes.

    • Desired Skills :

  • Experience with machine learning techniques and their integration into data analytics workflows.
  • Certifications in relevant technologies (e.g., Microsoft Solutions Developer, Oracle, Google Cloud, etc.) that demonstrate expertise in data analytics and cloud technologies.
  • Experience with ERWIN or similar data modeling tools for database design and structure.

    • Salary Range : $120,000 - $160,000 per year

    Flexible work from home options available.

    J-18808-Ljbffr

    Salary : $120,000 - $160,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data AnalystEngineer Data Modeling Analytics?

    Sign up to receive alerts about other jobs on the Data AnalystEngineer Data Modeling Analytics career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $121,246 - $165,092
    Income Estimation: 
    $152,894 - $210,289
    Income Estimation: 
    $62,090 - $81,673
    Income Estimation: 
    $76,293 - $101,657
    Income Estimation: 
    $76,293 - $101,657
    Income Estimation: 
    $97,729 - $131,248
    Income Estimation: 
    $97,729 - $131,248
    Income Estimation: 
    $121,246 - $165,092
    Employees: Get a Salary Increase
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Not the job you're looking for? Here are some other Data AnalystEngineer Data Modeling Analytics jobs in the Seattle, WA area that may be a better fit.

    Sr. Data Engineer, Analytics Engineering

    PitchBook Data, Seattle, WA

    Manager, Engineering - Data Governance

    Starburst Data, Seattle, WA

    View More Jobs

    AI Assistant is available now!

    Feel free to start your new journey!