Director, Data Engineering Work from Home

Publishing Concepts LP (PCI) is a Fortune 100 Best Companies to work for headquartered in Dallas Texas. We partner with colleges high schools and service organizations to engage their alumni and members. We receive calls from alumni/members to capture their personal stories for the Oral History Projects collect data to update directories and sell published books along with alumni merchandise. Our purpose is to capture curate and preserve the worlds stories. Join us and work with people who like to have fun and celebrate our unique culture!

Director Data Engineering Job Summary:

The Director of Data Engineering is responsible for ensuring client data is loaded into PCI systems and extracted from PCI systems as per defined specifications and in a timely and accurate manner. Also serves as Lead Developer for the Data team and has extensive experience with Microsoft SQL and MySQL.

Essential Duties:

• Accountable for loading of all client-originated data to the PCI schema
• Data analysis: Ability to design the transformation rules from source to target
• Data transformation: Solid foundation of techniques and best practices
• Thorough understanding of the PCI data schema and requirements
• Testing: Ability to troubleshoot complex problems related to multiple data sources
• Third-party data sources: Understanding how to merge research data
• Collaboration: Work with other teams to provide the best data quality and meet expectations

Director Data Engineering Requirements:

• 4 years experience implementing ETL for Data Warehouse and Business Intelligence solutions
• 4 years experience in RDBMS design and development and performance tuning
• 2 years experience with SSIS 3 years with DTS and T-SQL/ stored procedures required
• 3 years experience with scheduling ETL jobs using SQL Agent and external scheduling tools
• 2 years experience in managing projects and/or team lead
• 3 years of experience with Big Data data streaming Data Lake Infrastructure Data Warehousing and Data Analytics tools
• Experience in cloud migration of Data Services (Azure experience preferred)
• Expert experience with MS SQL Server 2017 R2 database technologies
• Ability to read and write effective modular dynamic (parameterized) and robust code establish and follow already established code standards and ETL framework
• Experience using Business Intelligence Development Studio to build SSIS packages
• Excellent troubleshooting and optimization skills: interpreting ETL logs performing data validation dissecting SSIS code experience with change data capture using expressions scoping of variables commonly used transforms event handlers and logging providers ability to understand and optimize the surrogate key generation and inconsistent data type handling
• Solid understanding of fuzzy grouping fuzzy lookup transforms import and export column transforms
• Experience in performance tuning of the SSIS packages deploying and administering SSIS packages proficient in utilizing scripting in SSIS and replacing ActiveX script tasks in DTS with the script task in SSIS. Familiarity and C# framework is a plus.
• Experience in designing jobs that can be easily promoted from one (development) environment to another (staging to production) seamlessly
• Build and promote an agile development culture within the team while being passionate about high-quality code development and deployment to production.
• Familiarity with Web Services (Restful WSDL SOAP RSS XML)
• Accurate time estimation for completion of tasks
• Excellent written and verbal communication skills for team development and client relations
• Excellent analytical abilities and problem-solving skills
• Handle multiple projects concurrently while meeting deadlines without compromising quality
• Work with geographically distributed teams on technical challenges and process improvements
• BA/BS degree in Mathematics Computer Science or Information Systems preferred or equivalent experience

Supervisory: Yes. Average number of Direct Reports: 1-3

Minimum education preferred for the position:

Bachelors degree preferred especially with a major in Business Computer Science Information Systems or Engineering or equivalent work experience.

Minimum certification/license preferred for the position:

Annual security awareness training and codes in compliance with NIST and OWASP recognized standards.

Minimum experience preferred for the position:

Ten plus years of work experience is required.

Benefits for Director Data Engineering - Free Telemedicine Medical Insurance Health Spending Account (HSA) Medical Dental Vision and Life Insurance Wellness Program 401K with company match PT0 (vacation sick personal holidays half-holidays) Bereavement leave Tuition Reimbursement.

Additional Company Awards

Texas

Great Place to Work: (2 consecutive years)

Best Companies to Work for in Texas (6 consecutive years)

Top 100 Places to Work: Dallas Morning News (7 consecutive years)

Dallas 100: SMU Caruth Inst for Entrepreneurship (3 consecutive years)

Top 100 Places to Work: San Antonio Express-News (2 consecutive years)

San Antonio Business Journal: Best Places to Work (3 consecutive years)

Virginia

Top 100 Places to Work: Inside Business The Hampton Roads Business Journal (2 consecutive years)

Virginia Business: Best Places to Work (3 consecutive years)

Arkansas

Arkansas Business: Best Places to Work (2 consecutive years)

National

Intl. Customer Management Institute (ICMI) - 2021

Top Workplaces- received 7 Culture Excellence Awards

Inc.5000 Fastest Growing Companies in America - 2020 with a growth rate of 102.48% putting us in rarefied company with organizations such as Microsoft Timberland Vizio Intuit Chobani Oracle and

Learn more about PCI is firmly committed to the principle of equal employment opportunity. PCI offers employment opportunities without regard to race color sex age religion national origin disability U.S. military or other prohibited bases of discrimination both state and local. All aspects of the employment relationship (including recruiting hiring training working conditions compensation promotion discipline and termination) are subject to this policy. Candidates must pass a pre-employment background check.

#ZR

***We are interested in every qualified candidate who is eligible to work in the United States. However we are not able to sponsor visas***