Sr Data Engineer - Richardson, United States - ARCHE

Description

Sr Data Engineer #5820-1


Job Description:

• Bachelor's degree (BA/BS) in a related field such as information systems, mathematics, or computer science.
• Typically has 6 years of relevant work experience. Consideration given to equivalent combination of education and experience.
• Excellent written and verbal communication skills. Strong organizational and analytical skills.
• Expertise in Data Extraction, Transformation, Loading, Data Analysis, Data Profiling, and SQL Tuning.
• Data Engineer with Expertise in Relational & Dimensional Databases in engines like: SQL Server, Postgres, Oracle, etc.
• Strong experience with specialization in Data Warehousing, Decision support Systems and extensive experience in implementing cloud native data ingestion framework.
• 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

• 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
• 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
• 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
• 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
• 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
• AWS / Azure cloud technologies, Agile methodologies and DevOps is a big plus
• Experience with developing CICD pipelines in Jenkins or Azure DevOps.

Responsibilities:

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

An additional requirement for this role is the ability to comply with COVID-19 health and safety protocols, including COVID-19 vaccination proof and/or rigorous testing.

Equal Opportunity Employer

Genesis Management Consulting Global is an Equal Opportunity-Affirmative Action Employer.

As a company we promote and are committed to equal employment opportunities for all regardless of the persons gender, race, color, religion, ancestry, sex, age, national origin, marital status, sexual orientation, disability, Veteran status, or gender identity.

If you have special needs or a disability which requires our accommodation, please make us aware when applying.

#J-18808-Ljbffr