Data Platform Engineer

Christ Panos Food Corporation; Itasca (IL); Vor Ort; USD 90.000 - 110.000; Vollzeit

Zusammenfassung

Christ Panos Food Corporation is seeking a highly skilled Data Platform Engineer to manage and modernize our enterprise data ecosystem. You will administer Microsoft SQL Server environments, BI platforms, and cloud-based data integration services to ensure data availability and performance.

The role involves ETL development with SSIS, Azure Data Factory, and building robust analytics using SSAS, SSRS, Tableau Cloud, and Power BI.

Qualifikationen

• Bachelor's degree or equivalent in CS/IS/Data Eng.
• 5+ years of production SQL Server experience.
• Strong ETL/ELT and data warehousing skills.
• Experience with Azure data services and cloud analytics.
• Hands-on BI/reporting with SSRS/Tableau/Power BI.

Aufgaben

• Administer SQL Server and Azure SQL MI, including upgrades and migrations.
• Design and maintain SSIS ETL processes and Azure Data Factory pipelines.
• Develop and optimize SSAS tabular/ multidimensional models.
• Create and manage SSRS reports; support Tableau Cloud and Power BI.
• Collaborate with stakeholders; document architectures and best practices.

Kenntnisse

SQL Server Administration

Azure SQL MI

Performance Tuning

SSIS Development

SSAS Modeling

SSRS Reports

Tableau Cloud

Power BI Administration

Data Warehousing

ETL/ELT Design

Ausbildung

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field

Tools

Azure Data Factory

Tableau Cloud

SSIS

SSAS

SSRS

Power BI

SQL Server

Jobbeschreibung

Description

We are seeking a highly skilled Data Platform Engineer to manage, optimize, and modernize our enterprise data ecosystem. This role is responsible for the administration and support of Microsoft SQL Server environments, business intelligence platforms, cloud-based data integration services, and enterprise reporting solutions.

The ideal candidate combines strong database administration expertise with hands-on experience in data engineering, ETL development, analytics, and cloud data platforms. You will play a key role in ensuring data availability, reliability, performance, and scalability while enabling business users to make data-driven decisions through modern reporting and visualization tools.

Schedule:

Monday - Friday 8:30am - 5:00pm

Compensation:

Starting at $100,000 annual base salary, depending on experience

Key Responsibilities:

SQL Server Administration & Performance Management

• Manage and support Microsoft SQL Server and SQL Azure Managed Instance environments, including installation, configuration, upgrades, maintenance, and migration projects.
• Monitor database performance and proactively optimize queries, indexes, and server resources.
• Implement and manage backup, recovery, disaster recovery, and high-availability solutions.
• Ensure database security, compliance, and data integrity.

Data Integration & ETL Development

• Design, develop, and maintain enterprise ETL processes using SQL Server Integration Services (SSIS).
• Build and support cloud-based data pipelines using Azure Data Factory (ADF).
• Develop and maintain data ingestion, transformation, and loading processes from multiple source systems.
• Troubleshoot and resolve data quality and integration issues.

Business Intelligence & Analytics

• Design, develop, and maintain SQL Server Analysis Services (SSAS) Tabular and Multidimensional models.
• Create and manage enterprise semantic layers, dimensions, measures, and KPIs.
• Create and optimize stored procedures
• Partner with business stakeholders to understand reporting and analytical requirements.

Reporting & Visualization

• Develop, maintain, and support SQL Server Reporting Services (SSRS) reports and reporting environments.
• Support Tableau Cloud environments, including data sources, extracts, dashboards, reporting, permissions, and performance optimization.
• Ensure consistency and accuracy of metrics across enterprise reporting platforms.
• Power BI administration and report creation

Cloud Data Platform Support

• Support modernization initiatives involving Azure-based data services and analytics solutions.
• Assist with migration of legacy BI and ETL processes to cloud-native architectures.
• Implement best practices for performance, scalability, monitoring, and governance.

Collaboration & Documentation

• Work closely with business users, analysts, developers, and IT teams to deliver data solutions.
• Document data architectures, processes, standards, and operational procedures.
• Participate in project planning, troubleshooting, and continuous improvement initiatives

Preferred Qualifications

• Experience with Azure SQL Database, Managed Instance, or other Azure data services.
• Experience with data warehousing, dimensional modeling, and semantic layer design.
• Experience supporting enterprise reporting and self-service analytics platforms.
• Familiarity with Tableau administration and governance best practices.

Key Skills

• Microsoft SQL Server & Azure SQL MI Administration
• Performance Tuning & Optimization
• SSIS Package Development
• Azure Data Factory Pipeline Development
• SSAS Tabular & Multidimensional Modeling
• SSRS Report Development
• Tableau Cloud Administration & Support
• Business Intelligence & Analytics

Requirements

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent experience.
• 5+ years of experience working with Microsoft SQL Server in production environments.
• Strong experience with:
• SQL Server Administration
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Azure Data Factory (ADF)
• Tableau Cloud administration, including managing extracts
• Row-level Security (RLS) across Tableau and SQL Server
• Advanced SQL development and performance tuning skills.
• Experience designing and supporting ETL/ELT processes and data warehousing solutions.
• Strong experience with building Tableau and SQL measures such as prior year and point-in-time metrics
• Strong analytical, troubleshooting, and problem-solving abilities.