Description
Hybrid Onsite Every Other Week in Westlake, TX
Our client seeks a Senior Data Engineer to design, build, and optimize data solutions that enable personalized customer experiences. The role involves database design and development, data modeling, ETL/ELT pipeline creation, complex SQL and stored procedure work, and CI/CD enablement for Python applications. You will collaborate across teams in an Agile environment to deliver reliable and scalable data platforms supporting benefits-related digital solutions for enterprise clients.
Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.
Rate: $60.00 to $70.00/hr. w2
Responsibilities
Design and build new databases, including schema design and data modeling for single and multi-tenant solutions.
Develop, maintain, and tune ETL/ELT pipelines leveraging SQL, Python, and tools such as Informatica or similar.
Create and optimize complex SQL queries and stored procedures to support analytics and application workloads.
Implement and maintain CI/CD pipelines, including Jenkins-based deployments for Python applications.
Collaborate within Agile teams to decompose legacy processes and refactor components for performance and reliability.
Author and maintain technical documentation and contribute to standards and best practices.
Show the full description
Support QA and testing activities with strong understanding of methodologies and test coverage.
Contribute to data platform operations, tuning, and governance across multiple projects.
Experience Requirements
5+ years in technology with 3+ years building and deploying data solutions.
Expertise in SQL with experience building complex queries and stored procedures.
Hands-on ETL/ELT experience; Informatica or similar tools is a plus.
Proficiency with Python for ELT pipelines and application deployment workflows.
Experience building Jenkins pipelines and maintaining CI/CD practices.
Background in systems analysis, debugging, tuning, and refactoring.
Strong data modeling and database design experience.
Knowledge of MySQL and Snowflake is preferred.
Familiarity with Agile frameworks and cross-team collaboration.
Experience with Git/GitHub and CI/CD toolsets such as Jenkins, Udeploy.
QA and testing expertise with demonstrable application of methodologies.
Nice to have: Azure or AWS fundamentals, BI tools such as Tableau or Power BI, data science exposure, AI prompt engineering exposure.