Data Platform Engineer

The Data Platform Engineer is responsible for designing, maintaining, and optimizing the organization’s hybrid data infrastructure across on-premises and cloud environments and ensuring that it supports the strategic goals and objectives of the organization. This role ensures that data pipelines, storage systems, and analytics platforms operate efficiently, securely, and at scale., * Design, configure, and maintain hybrid data environments (e.g., SQL Server, Azure Data Lake, Azure Synapse, Power BI Service).

• Implement and manage Azure services such as Data Factory, Synapse Pipelines, Storage Accounts, and Key Vault.
• Automate deployments using CI/CD pipelines (Azure DevOps, GitHub Actions, or equivalent).
• Collaborate with the Database Administrator (DBA) and Senior Data Engineer to optimize performance and resource allocation.
• Monitor system health using Azure Monitor, SQL Agent, or third-party tools.
• Proactively identify and resolve data bottlenecks and infrastructure issues.
• Enforce data access controls, encryption, and authentication policies.
• Integrate cloud and on-prem security models using Azure AD and RBAC.
• Develop and maintain efficient data pipelines using ETL/ELT methodologies and best-practice dimensional and relational modeling techniques.
• Leverage DevOps principles and tools to automate the deployment, scaling, and monitoring of all core data platform infrastructure and services.
• Troubleshoot, analyze, and resolve complex data integration and performance challenges across the data platform to maintain stability and accuracy.
• Complete all required training applicable to this position.
• Regular and predictable attendance is an essential function of this position.
• Other duties, as assigned.

Data Management, Cloud Computing, Systems Analysis, Data Storage, Microsoft SQL Server, Data Lake, Microsoft Windows Azure, Power BI, DevOps, GitHub, * Bachelor’s degree in computer science, Information Systems or related field is required; a master’s degree is preferred.

• 6+ years of relevant experience or an equivalent combination of education, training, and experience.
• Proven work experience as a ETL Developer, Data Engineer,
• Proficiency in in Azure Data Services (Data Factory, Synapse, Storage, Functions, Key Vault, Monitor).
• Expertise in Microsoft SQL Server, SSIS, and Windows Server administration.
• Working knowledge of data warehousing, data lake architectures, data modeling and ETL processes.
• Familiarity with scripting (PowerShell, Python, T-SQL).
• Excellent communication and documentation skills.
• Familiarity with scripting (PowerShell, Python, T-SQL).
• Knowledge of network and infrastructure methodologies.
• Must be able to pass a detailed background check and drug screen, The physical and mental demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to remain in a stationary position at a workstation. This position requires constant use of hands and fingers for typing and operating a computer and other office equipment. The employee must possess the ability to communicate information and ideas in writing and verbally. Occasional standing, walking, bending, and lifting of items weighing up to 15 pounds may be required. Close visual acuity is needed to read, analyze data, and view a computer terminal for extended periods.

• The expected pay range for this position is $79,202-$102,925/year
• Paid Time Off (PTO) - 16 days annually + 9 Company paid holidays
• Competitive benefits - Medical, Rx, Dental, Vision, 401(k), Parental Leave, Life and Disability Insurance and more. You can review our benefits at www.weltman.com/careers for more information.
• Promotional opportunities from within the Firm
• Employee Perks available from Verizon, Car Dealerships, Local Movie Theaters, Theme Parks, etc. Positive office environment with regularly scheduled parties, contests, and community support initiatives
• On site “Bistro To Go” vending and fresh foods available
• Free parking
• Free onsite fitness center for all employees

Physical and Mental Demands