TekniPlex

Senior Data Engineer

TekniPlex

full-time

Posted on:

Location Type: Remote

Location: Pennsylvania • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

CloudCyber SecurityERPETLMS SQL ServerSQLSSIS

About the role

  • Design, develop, and maintain enterprise reporting and business intelligence solutions using Microsoft technologies (SSRS, SSIS, SSAS, SQL Server, Visual Studio).
  • Build and optimize complex SQL queries to support analytics, reporting, and operational use cases.
  • Develop and manage ETL pipelines to ingest, transform, and integrate data from multiple sources (ERP systems, APIs, flat files).
  • Architect and maintain data warehouses and dimensional data models.
  • Design and manage SSAS cubes to support advanced analytics and reporting.
  • Ensure data accuracy and integrity through ongoing data quality monitoring and issue resolution.
  • Optimize performance of reports, dashboards, and data pipelines.
  • Implement and maintain data security, access controls, and governance standards.
  • Collaborate with cross-functional teams including application development, infrastructure, and cybersecurity.
  • Support and enhance automation using PowerShell, Power Automate, and other scripting tools.
  • Participate in on-call rotations and support ITIL-based incident and change management processes.
  • Contribute to documentation, knowledge transfer, and continuous improvement initiatives.

Requirements

  • 7+ years of experience in SQL-based data engineering, reporting, or business intelligence.
  • Strong expertise in Microsoft SQL Server (2012–current) and related tools (SSRS, SSIS, SSAS).
  • Advanced SQL skills, including complex joins, subqueries, aggregations, and performance tuning.
  • Experience designing and building data warehouses and data models.
  • Proficiency in ETL development and data integration from multiple sources.
  • Experience working with APIs and system integrations.
  • Strong scripting experience (PowerShell preferred).
  • Familiarity with ERP systems (e.g., Infor, SAP, PRMS) and underlying data structures.
  • Experience working in Agile environments and cross-functional teams.
  • Strong analytical, problem-solving, and communication skills.
  • Ability to work independently and manage multiple priorities.
  • Experience with Power BI or modern data visualization tools.
  • Exposure to cloud-based data platforms or modern data architectures.
  • Experience leveraging AI or automation in data management workflows.
  • Bilingual (English/Spanish).
Benefits
  • Occasional travel (up to 10%)
  • Participation in on-call support rotation
  • Work environment may include collaboration with global and offshore teams
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLSSRSSSISSSASSQL ServerETLdata warehousingdata modelingPowerShelldata integration
Soft Skills
analytical skillsproblem-solvingcommunication skillsindependencetime management