Senior Data Modeler — Cloud Data Architect

Jobtailor; Colorado; On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor is seeking an experienced Data Architect/Senior Data Engineer in Colorado to design and implement scalable data models, data pipelines, and cloud-based data platforms. The role focuses on integrating on-prem SQL Server with AWS services, enabling robust Power BI reporting, and collaborating with DevOps practices across CI/CD pipelines.

Your work will include building and modernizing data architectures, developing ETL/ELT workflows with Python and AWS Glue, and ensuring data integrity

Qualifications

• Bachelor's degree or equivalent work experience.
• 8+ years in an IT environment.
• 5+ years with logical and physical data models.
• 5+ years with data management tools and techniques.
• Advanced SQL Server (on-prem) and cloud modernization experience.
• Hands-on data pipelines/ETL/ELT using Python, AWS Glue or similar.
• Experience with AWS data services (S3, RDS/Aurora, Redshift) and data lake/warehouse design.
• Hybrid connectivity between on-prem SQL Server and AWS.
• Power BI reporting on cloud or hybrid data platforms with performance focus.
• C#, ASP.NET, REST API development for data-driven apps.
• DevOps, CI/CD, automation, Docker/Kubernetes familiarity.

Responsibilities

• Develops database models to meet business requirements.
• Defines data requirements and business rules.
• Performs physical data modeling.
• Implements and tests database design.
• Plans data collection, cleansing, and normalization for decision support.
• Ensures data, software, and hardware integrity.
• Coordinates data models and documentation across applications.
• Partners with data transformation teams to communicate designs.
• Develops policies and procedures for ongoing systems.

Skills

SQL Server

C#

ASP.NET

REST API

Power BI

Python

AWS Glue

AWS S3

Redshift

Kubernetes

Docker

CI/CD

Data modeling

Education

Bachelor's degree or equivalent work experience

Tools

Docker

Kubernetes

Power BI

AWS

SQL Server Management Studio

Job description

Jobtailor is seeking an experienced Data Architect/Senior Data Engineer in Colorado to design and implement scalable data models, data pipelines, and cloud-based data platforms. The role focuses on integrating on-prem SQL Server with AWS services, enabling robust Power BI reporting, and collaborating with DevOps practices across CI/CD pipelines.

Your work will include building and modernizing data architectures, developing ETL/ELT workflows with Python and AWS Glue, and ensuring data integrity