Sql Data Engineer Jobs

Paladin Consulting is currently hiring a Data Engineerto join our team working onsite at our client's office located in Richardson, TX.

We work with companies that offer environments for our employees to contribute, learn, and advance their career. We treat you like you are part of the family.

Job Title:Data Engineer
Work Location:Richardson, TX
Duration: long term contract
Education/Experience Required:Expertise in Data Extraction, Transformation, Loading, Data Analysis, Data Profiling, and SQL Tuning.

& Responsibilities :

• Designs, codes, tests, and documents software programs of moderate complexity as per the requirement specifications.
• Assists in preparation of requirement specifications, Analyzing the data, design and develop data driven applications including documenting and revising user procedures and/or manuals.
• Participates in design reviews and technical briefings for specific applications.
• Writes documentation to describe program development, logic, coding, and corrections.
• Involved with resolution of Medium to severe complexity software development issues that may arise in a production environment.
• Under general supervision, plans, analyzes, develops, maintains, and enhances client systems as well as supports systems of moderate to high complexity.
• Analyzes, reviews, and alters program to increase operating efficiency or adapt to new requirements.
• Participates in the design, specification, implementation, and maintenance of systems.

Skills & Qualifications :

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL Server, PostgreSQL, SSIS, T-SQL, PL/SQL
• Expertise in Data Extraction, Transformation, Loading, Data Analysis, Data Profiling, and SQL Tuning.
• Excellent written and verbal communication skills. Strong organizational and analytical skills.
• Assemble large, complex data sets that meet functional / non-functional business requirements. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
• Experience with developing CICD pipelines in Jenkins or Azure DecOps.
• AWS / Azure cloud technologies, Agile methodologies and DevOps is a big plus
• Write complex SQL, T-SQL, PL/SQL queries, stored procedures, functions, cursors in SQL Server and PostgreSQL. Peer review other team members code
• Create and manage SSIS packages and/or Informatica to perform day to day ETL activities. Use variety of strategies for complex data transformations using an ETL tool
• Analyze the long running queries/functions/procures, design and develop performance optimization strategy.
• Work with stakeholders including the Product, Data, Design, Frontend and Backend teams to assist with data-related technical issues and support their data infrastructure needs
• Data Engineer with Expertise in Relational & Dimensional Databases in engines like SQL Server, Postgres, Oracle
• Typically has 6 years of relevant work experience. Consideration given to equivalent combination of education and experience.
• Perform DBA activities like maintaining the systems health and performance tuning, manage database access, deployments to higher environments, on-call support, shell scripting and python scripting is a plus
• Bachelor's degree (BA/BS) in a related field such as information systems, mathematics, or computer science.
• Participate in employing the Continuous Deliver and Continuous Deployment (CI/CD) tools for optimal productivity. Collaborate with scrum team members during daily standup and actively engage in sprint refinement, planning, review and retrospective

For more information or to view other opportunities, visit us at www.paladininc.com.

Paladin Consultingis an EEOC employer. www.paladininc.com.

Paladin Consulting is an EEOC employer.