Data Engineer/Architect - Contract - W2 Only - Nashville TN

iTech Solutions - Nashville, TN

Full-time - Mid Level

Nashville, TN

Professional, Scientific, and Technical Services

About the position

The Data Engineer/Architect position is a contract role focused on designing and developing enterprise data solutions. The role involves leading complex engineering projects, creating data warehouses and lakes, and enabling strategic decision-making through analytics. The ideal candidate will possess deep technical expertise and provide thought leadership within Information Management.

Responsibilities

• Provide expert content and professional leadership on complex engineering assignments and projects.
• Design and develop a consolidated, conformed enterprise data warehouse and data lake, storing critical data across customer, provider, claims, client, and benefits domains.
• Design, develop, and implement methods, processes, tools, and analyses to sift through large datasets stored in a data warehouse or data mart to uncover relationships and patterns.
• Participate in delivering a definitive enterprise information environment that enables strategic decision-making capabilities through analytics and reporting.
• Exercise considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives.
• Use deep professional knowledge and acumen to advise functional leaders.
• Provide thought leadership within Information Management, while contributing to broader projects that require an understanding of wider business implications.

Requirements

• Design, develop, and maintain ETL platforms for various business use cases that are fault-tolerant, highly distributed, and robust.
• Analyze large sets of structured and semi-structured data for business analytics and ETL design.
• Translate business needs and vision into roadmaps, project deliverables, and organizational strategies.
• Design and implement ETL solutions leveraging cloud-native platforms.
• Collaborate with analytics and business teams to design data models that feed business intelligence tools, increasing data accessibility and encouraging data-driven solutions.
• Experience with data modeling techniques for cloud data stores and on-prem databases such as Teradata and Teradata Vantage (TDV).
• Proficiency in SQL, relational and non-relational databases, query optimization, and data modeling.
• Strong experience designing and developing data pipelines for data ingestion and transformation using Spark.
• Distributed computing experience using Python and PySpark.
• Solid understanding of AWS services such as Glue, Athena, S3, Lambda, and CloudFormation.

Nice-to-haves

• Preferred experience in ETL development within Teradata Vantage and data migration from on-prem to Teradata Vantage.
• Preferred working knowledge in implementing data lake ETL using AWS Glue, Databricks, etc.
• Cloud certifications such as AWS Certified Solutions Architect, Google Cloud Professional Cloud Architect are preferred.

Benefits

• Equal Opportunity Employer
• Professional development opportunities