Senior Data Modeler/Platform Engineer

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

Responsibilities

• Develops database models to meet business requirements.
• Defines data requirements and business rules.
• Performs physical data modeling.
• Implements and tests database design.
• Plans for collection method, data cleansing, and normalization of enterprise data to support decision-making and reporting.
• Ensures integrity of data, software, and hardware.
• Coordinates data models, dictionaries, and other database documentation across multiple applications.
• Partners with data transformation teams to ensure design is properly communicated.
• Develops policies and procedures related to development and support of new and ongoing systems.

Requirements

• Bachelor's degree or equivalent work experience
• At least 8 years experience within a total information technology (IT) environment.
• At least 5 years experience with the development and implementation of logical and physical data models.
• At least 5 years experience with tools, facilities and techniques for managing and administering data.
• Advanced expertise in SQL Server (on-prem) and experience modernizing legacy data platforms to cloud-based architectures
• Hands‑on experience building data pipelines and ETL/ELT workflows using tools like Python, AWS Glue, or similar
• Practical experience with AWS data services (S3, RDS/Aurora, Redshift) and designing scalable data lake or warehouse solutions
• Proven ability to implement hybrid connectivity and data movement between on‑prem SQL Server and AWS (e.g., replication, migration, synchronization)
• Experience enabling Power BI reporting on cloud or hybrid data platforms with a focus on performance optimization
• Strong proficiency in C#, ASP.NET, and REST API development with experience supporting data‑driven applications
• Familiarity with DevOps and deployment practices, including CI/CD pipelines, automation, and containerization (Docker/Kubernetes)