Remote Power Query Jobs in McKinney, TX (NOW HIRING)

The Data Engineer role is responsible for designing, building, and maintaining scalable data pipelines, integrations, and data models that support enterprise reporting, analytics, data migration, and operational decision-making. This role works within established architectural frameworks while contributing to the continued modernization of XTG's data platform. This role plays a key part in supporting the organization's transition to modern cloud-based data platforms, including Microsoft Fabric, Power BI, Azure DevOps, and Dynamics 365 data integration initiatives.
The Exponential Technology Group (XTG) is a specialist in the electronic component distribution and design engineering services industries. XTG is part of the TTI Family of Companies. This opportunity is remote with the ideal candidate being located in DFW, Phoenix, Atlanta or Raleigh-Durham
ACCOUNTABILITIES:
Design, develop, test, and maintain data pipelines, dataflows, notebooks, and integration processes across enterprise systems.
Build and support data ingestion frameworks using Microsoft Fabric, Lakehouse/Warehouse architecture, SQL, and cloud-based data engineering patterns.
Develop and maintain Bronze, Silver, and Gold layer data structures to support reporting, analytics, and downstream business processes.
Create scalable ETL/ELT processes to extract, cleanse, transform, and load data from ERP, CRM, operational, and third-party systems.
Partner with business stakeholders, analysts, and application teams to clarify data requirements and translate them into technical solutions.
Support data migration and integration efforts related to Dynamics 365 and other enterprise platform initiatives.
Develop and maintain SQL queries, stored procedures, views, data models, and transformation logic.
Implement data quality checks, validation rules, logging, error handling, and monitoring within data pipelines.
Troubleshoot and resolve issues related to data accuracy, pipeline failures, source system changes, performance, and integration errors.
Contribute to data architecture, governance, naming standards, documentation, and reusable engineering patterns.
Use Azure DevOps, Git, branching strategies, and CI/CD practices to manage source control and deployment of data engineering assets.
Collaborate with reporting and analytics teams to support Power BI semantic models, dashboards, and enterprise reporting needs.
Provide guidance and support to junior team members, analysts, or business users as needed.
Continuously expand technical knowledge across Microsoft Fabric, Azure, Power BI, Dynamics 365, and modern data engineering practices.
Additional duties as assigned.
EDUCATION & EXPERIENCE
Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field, or equivalent professional experience.
4+ years of professional experience in data engineering, business intelligence, analytics engineering, or enterprise data integration.
Experience building and maintaining data pipelines, ETL/ELT processes, data warehouses, lakehouses, or cloud-based analytics platforms.
Experience working with enterprise systems such as ERP, CRM, financial, operational, or supply chain platforms preferred.
Experience supporting data migration, system integration, or enterprise reporting initiatives preferred.
SKILLS & CERTIFICATIONS

• Strong SQL development skills, including query optimization, joins, aggregations, views, stored procedures, and data validation logic.
• Hands-on experience with Microsoft Fabric, Azure Synapse, Azure Data Factory, Databricks, or similar cloud data platforms.
• Working knowledge of Power BI, semantic models, data modeling, and reporting data structures.
• Ability to work independently on complex technical tasks while collaborating with business and technical stakeholders.
• Strong documentation skills, including technical designs, data mappings, source-to-target logic, and operational procedures.
• Exposure to or interest in AI-assisted development, automation, metadata-driven frameworks, or agentic AI tooling.
• Microsoft certifications related to Fabric, Azure Data Engineering, Power BI, or Data Fundamentals preferred but not required.

What we offer our team members:

• A great benefits package that includes (but is not limited to): Medical/ Dental/ Vision, 401(k)/Roth plan with matching, Healthcare Savings Accounts.
  Educational Assistance (Tuition Reimbursement).
• Ongoing training throughout your employment with opportunities to participate in professional and personal development programs.
• A strong focus on giving back to our communities through philanthropic opportunities.
• Great culture and opportunities for growth and advancement.

This is a summary of the primary accountabilities and requirements for this position. The company reserves the right to modify or amend accountabilities and requirements at any time at its sole discretion based on business needs. Any part of this job descriptions is subject to possible modification to reasonably accommodate individuals with disabilities.
This position requires use of information or access to hardware which is subject to the International Traffic in Arms Regulations (ITAR). To perform the position, you must be a U.S. Person as defined by ITAR. ITAR defines a U.S. person as a U.S. Citizen, U.S. Permanent Resident (i.e. 'Green Card Holder'), Political Asylee, or Refugee.
Visa sponsorship is not available for this role. Only candidates authorized to work in the United States will be considered.
XTG is an Equal Opportunity Employer, and we support protected veterans and individuals with disabilities through our affirmative action program.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.