Negotiable
Outside
Remote
USA
Summary: The role of Sr. Data Modeler involves creating and managing data models, primarily using Snowflake and ER Studio, while working fully remote for a duration of 6+ months. Candidates must have a strong background in data modeling, SQL, and ETL development, particularly within Azure environments. The position prioritizes those with advanced expertise in data modeling concepts and tools, as well as familiarity with BI and reporting support. This role is classified as outside IR35 and requires candidates to reside in the PST time zone.
Key Responsibilities:
- Create and manage data models using ER Studio and Snowflake.
- Develop advanced SQL queries and ETL processes using tools like SSIS and Azure Data Factory.
- Support data pipelines and ensure data integrity within the Azure ecosystem.
- Provide BI and reporting support, troubleshooting tools like Tableau and Power BI.
- Utilize version control systems such as Git and Azure DevOps.
- Potentially use scripting languages like PowerShell for daily tasks.
Key Skills:
- Experience as a Data Modeler, not just a developer.
- Proficiency in Snowflake and ER Studio.
- Advanced SQL skills, including T-SQL and query optimization.
- Experience with ETL tools, particularly SSIS and Azure Data Factory.
- Familiarity with Azure DevOps and Azure Data Lake.
- Knowledge of BI tools like Tableau and Power BI.
- Experience with version control systems such as Git.
- Scripting skills in PowerShell (nice to have).
- Knowledge of C# and Python (not required, but helpful).
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Role: Data Modeler
Location: Fully remote, but must currently reside in PST
Duration; 6+Months
Job Description
Top Skills' Details
- Experience Data Modeler not just a developer
- Snowflake
- Experience creating new data models in data modeling tools like ER Studio
Above is the minimum criteria, however candidates who meet the below description in addition to top skills above will be prioritized:
- Expert Data Modeling
- Conceptual, logical, and physical modeling
- Dimensional models, star schemas, fact/dimension entities
- ER Studio (primary tool)
- Snowflake
- Advanced experience with Snowflake, especially in Azure-hosted environments
- SQL & ETL Development
- Advanced SQL (T-SQL, stored procedures, query optimization)
- ETL tools: SSIS, Azure Data Factory
- Experience building and supporting data pipelines
- Azure Ecosystem
- Azure DevOps (required)
- Azure Data Lake, Azure SQL Server (preferred)
- BI & Reporting Support
- Familiarity with Tableau, Power BI, SSRS (for troubleshooting, not report creation)
- Version Control
- Experience with Git, Azure DevOps, or Subversion
- Scripting (Nice to Have)
- PowerShell (potential daily use)
C# and Python (not required, but helpful)