Sign upLog in

Sr Data Engineer

TekWissen LLC

Frisco, TX

Apply
JOB DETAILS
SALARY
$54.29–$54.29
SKILLS
Apache Spark, Application Programming Interface (API), Artificial Intelligence (AI), Business Intelligence, Business Model, Cadence, Centers for Disease Control and Prevention (CDC), Change Management, Cisco Unity, Code Reviews, Communication Skills, Computer Science, Continuous Deployment/Delivery, Continuous Improvement, Continuous Integration, Contract Negotiation, Data Management, Data Modeling, Data Quality, Data Visualization, DevOps, Dimensional Modeling, Diversity, Documentation, Engineering, Enterprise Architecture, Git, HRIS/HRMS, Human Resources Analytics, Incident Response, Information Architecture, Information Technology & Information Systems, Information/Data Security (InfoSec), Integration Testing, Interoperability, Leadership, Machine Tool, Mentoring, Microsoft Product Family, Microsoft SQL Server, Microsoft Windows Azure, NCR Teradata, On Call, Oracle Database, Power BI, Privacy Regulations, Problem Solving Skills, Product Demonstration, Product Development, Product Support, Product/Service Launch, Python Programming/Scripting Language, Reconciliation, Regulatory Compliance, Reliability Engineering, SQL (Structured Query Language), Service Level Agreement (SLA), ServiceNow, Snowflake Schema, Software Engineering, Standards Development, Streaming Technology, Team Player, Technical/Engineering Design, Test Automation, Unit Test, Validation Testing, Workforce Management
LOCATION
Frisco, TX
POSTED
1 day ago
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation, information technology and services
Position: Sr Data Engineer
Location: Frisco, TX 75034
Duration: 12 Months
Job Type: Temporary Assignment
Work Type: Hybrid
Job Description
  • The Senior Data Engineer is a data engineer who can sit with HR business stakeholders to understand their objectives, decompose those needs into a clear technical plan, and then execute that plan end-to-end - from identifying the authoritative source system all the way through to the semantic layer in Microsoft Fabric and the visualizations that put insight in front of the business.
  • This is a hands-on senior individual contributor role for someone who can speak fluently with both a HR business executive and a platform architect, and who can personally build everything in between: ingestion, data contracts, modeling, transformation, testing, semantic layer, and BI.
  • The Senior Data Engineer must be located in the United States.
WHAT THIS ROLE LOOKS LIKE END-TO-END
  • A typical engagement for this role spans the full lifecycle of a data product:
  • Sit with HR business partners to understand the business objective, the decision the data needs to support, and the questions the business is trying to answer.
  • Decompose the business need into a technical solution design - identifying the authoritative source of record, the data contract required from that source, the modeling approach, the storage pattern, the transformation logic, the semantic layer design, and the visualization that closes the loop.
  • Identify the authoritative source system for each required data element and confirm fit for purpose with the source-system owner.
  • Land raw data into the unified ingestion framework using standard ingestion patterns (batch, CDC, streaming, API) as appropriate to the source.
  • Define and document data contracts between source systems and the analytics platform, including schema, SLAs, refresh cadence, and change protocols.
  • Design and implement conceptual, logical, and physical data models for the domain, aligned to the enterprise business glossary.
  • Build production-grade pipelines in Databricks (PySpark, Spark SQL, Delta Lake) and/or Snowflake (including Iceberg tables) depending on the storage pattern that best fits the data product.
  • Implement data quality, validation, and testing across the pipeline - unit tests, integration tests, data quality checks, reconciliation, and anomaly alerting.
  • Build the semantic layer in Microsoft Fabric (Fabric IQ, OneLake-backed semantic models) so business consumers see business-meaningful entities, measures, and definitions - not raw tables.
  • Build and certify the consuming visualizations in Power BI (or comparable BI), then partner with the business on adoption, feedback, and iteration.
  • Own the data product after launch - monitoring, KTLO, incident response, SLA adherence, and continuous improvement.
HOW THE TEAM WORKS TOGETHER
  • The HR Analytics engineering team operates as a single team across the country and India, with clear layers and a shared way of working:
  • The HR Analytics engineering team is structured in three layers that work together: an Information Architect who owns end-to-end architecture and engineering standards; Principal Data Engineers who set the engineering bar and lead the data engineering team; and Senior Data Engineers, Data Engineers, and Associate Data Engineers who deliver data products across the full vertical.
  • The team operates across the country (Frisco, TX) and India (Hyderabad) and in the country locations in PST Timezone, with engineers in all regions partnering across the timezone gap to keep delivery moving and to share ownership of data products end-to-end.
  • Business engagement happens through the team's senior engineering and architecture leadership, with broader engineering team participation that grows over time as engineers build domain context and earn trust with stakeholders.
  • Work flows from a business need into a technical solution design, then into a build that spans ingestion through the unified framework, data modeling, transformation across Snowflake and Databricks, semantic layer in Microsoft Fabric, and visualization in Power BI - with quality, testing, documentation, and reliability owned across the whole vertical.
  • The team operates a DevOps model - engineers own their data products in production, share an on-call schedule, and rotate the operations role across the team.
  • This role is a senior delivery engineer who owns data products end-to-end and partners closely with India-based engineers across the timezone gap to keep delivery moving around the clock.
CORE RESPONSIBILITIES
  • Partner directly with HR business stakeholders to elicit objectives and translate them into solution designs with clear technical decomposition from source to visualization.
  • Identify authoritative source systems for each data element and negotiate data contracts with source-system owners, including schema, SLAs, refresh cadence, and change management.
  • Land source data into the team's unified ingestion framework using the appropriate ingestion pattern (batch, CDC, streaming, API).
  • Design and implement conceptual, logical, and physical data models, including standard data definitions and business glossary alignment for the HR domain.
  • Build production-grade pipelines and data products across Snowflake (including Iceberg tables) and Databricks (Delta Lake, Unity Catalog), choosing the storage and compute pattern that fits the use case.
  • Apply medallion (bronze, silver, gold) architecture and the team's engineering standards to all data product builds, including naming conventions, documentation, and code review practices.
  • Design and build the semantic layer in Microsoft Fabric (Fabric IQ, OneLake) so that business consumers interact with certified, business-meaningful models.
  • Design and build Power BI visualizations and reports that close the loop with the business, working iteratively with HR partners on adoption and refinement.
  • Implement comprehensive testing across the pipeline - unit tests, integration tests, data quality checks, reconciliation logic, and SLA-driven alerting.
  • Own pipeline KTLO (Keep the Lights On) for delivered data products, including monitoring, incident response, and ongoing reliability improvements.
  • Write and maintain comprehensive documentation including source-to-target mappings, data lineage, data dictionaries, SLA definitions, semantic model definitions, and runbooks.
  • Contribute to and uphold the team's DevOps practices - Git, CI/CD, automated testing, code review.
  • Mentor mid-level and junior engineers, share knowledge through demos and training sessions, and raise the engineering standard of the team around you.
REQUIRED QUALIFICATIONS
  • Bachelor's degree in Computer Science, Software Engineering, Information Management, or equivalent experience in field - plus 7+ years of related work experience.
  • Must be located in the United States.
  • 7+ years of hands-on data engineering experience delivering production data pipelines and data products in large enterprise environments.
  • Demonstrated ability to sit with business stakeholders, understand their objectives, and personally decompose those objectives into a technical solution design spanning ingestion, modeling, storage, semantic layer, and visualization.
  • Expert proficiency in SQL and Python, including PySpark and Spark SQL for distributed data transformation.
  • Hands-on experience with Databricks including Delta Lake, Unity Catalog, and workflow orchestration.
  • Hands-on experience with Snowflake at production scale, including experience with Iceberg tables and modern open table formats.
  • Hands-on experience with Microsoft Fabric including OneLake and Fabric IQ semantic layer design, and a track record of publishing certified data products for downstream consumption.
  • Hands-on experience building data visualizations and reports in Power BI, including semantic model design that bridges Fabric models to BI consumption.
  • Experience landing data through a unified ingestion framework and defining data contracts with source-system owners, including schema, SLAs, and change protocols.
  • Strong data modeling skills - conceptual, logical, and physical - including dimensional modeling, normalized modeling, and modern lakehouse modeling patterns.
  • Experience implementing data quality frameworks and pipeline testing, including unit tests, integration tests, data quality checks, and reconciliation.
  • Experience with DevOps practices for data pipelines - Git, CI/CD, and automated testing.
  • Excellent communication skills - able to convey technical concepts to business stakeholders and translate business objectives into technical requirements.
  • Strong problem-solving skills and the ability to operate independently on complex technical problems in ambiguous, high-pressure environments.
PREFERRED QUALIFICATIONS
  • Experience with HR data domains - talent acquisition, workforce analytics, compensation, learning, performance, or people analytics.
  • Hands-on experience with Workday, ServiceNow HR, or comparable HR systems of record as authoritative sources for analytics.
  • Experience with real-time streaming technologies including Kafka, Azure Event Hub, Delta Live Tables, or Spark Structured Streaming.
  • Experience with AI/ML pipelines, feature stores, or building data products that support generative AI and ML workloads.
  • Familiarity with legacy data platforms such as Teradata, Oracle, or SQL Server in interoperating or migration contexts.
  • Azure certifications or demonstrated experience with Azure-native data platform services beyond Fabric and Databricks.
  • Familiarity with Client'sOmni lakehouse platform, MagentaBuilt integrations, or enterprise IT architecture standards.
  • Experience with data privacy and regulatory compliance for HR data (GDPR, CCPA, employee data protection).
  • Experience with data observability tooling and modern data quality platforms.
TekWissen Group is an equal opportunity employer supporting workforce diversity.

About the Company

T

TekWissen LLC

WE THE TEKWISSEN PEOPLE

TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.

To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.

Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.

It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.

Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.



COMPANY SIZE
100 to 499 employees
INDUSTRY
Computer/IT Services
FOUNDED
2009
WEBSITE
http://www.tekwissen.com/

Resume Resources

Free Resume TemplatesFree Resume Builder