What are the responsibilities and job description for the Data Engineer position at Software Guidance & Assistance?
Job Details
Software Guidance & Assistance, Inc., (SGA), is searching for a Data Engineer and onsite lead for a CONTRACT assignment with one of our premier Financial Services clients in New York, NY.
As the onsite lead and a Data Engineer, you will be a member of the Data Governance and Technology development team within the Non-Financial Risk Technology team, with specific focus in developing data solutions. In this role you will be primarily responsible for the development of data workflows, pipelines, views, and stored procedures, working with the user community, in addition to performing data analysis and firming up requirements from the users. You will also be working closely with data providers, data scientists, other data developers, and data analytics teams to facilitate the implementation of client-specific business requirements and requests.
Responsibilities :
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
As the onsite lead and a Data Engineer, you will be a member of the Data Governance and Technology development team within the Non-Financial Risk Technology team, with specific focus in developing data solutions. In this role you will be primarily responsible for the development of data workflows, pipelines, views, and stored procedures, working with the user community, in addition to performing data analysis and firming up requirements from the users. You will also be working closely with data providers, data scientists, other data developers, and data analytics teams to facilitate the implementation of client-specific business requirements and requests.
Responsibilities :
- Design, implement, and maintain databases and datastores, ensuring optimal performance, scalability, and data integrity.
- Write complex SQL queries to analyse data and create views for reporting purposes for downstream consumers.
- Interact with business customers/users, understand their requirements, and translate them into technical requirements.
- Implement and enforce data security and access controls, ensuring compliance with industry standards and regulations.
- Conduct database capacity planning, forecasting future requirements, and implementing necessary scaling strategies.
- Troubleshoot and resolve complex database-related issues, collaborating closely with development and operations teams.
- Utilize Python/Shell scripting to automate database tasks, such as data extraction, transformation, loading, monitoring, and maintenance.
- Monitor and optimize database performance, identifying and resolving bottlenecks, and implementing performance tuning techniques.
- Stay up to date with the latest advancements in RDBMS systems, Postgres DB, scripting languages (Python/Shell), as well as other data engineering tools and evaluate their potential application within our organization.
- Bachelor's degree in computer science, software engineering, information technology, or related field required.
- At least 10 years of experience in data development and solutions in highly complex data environments with large data volume
- At least 7 years of SQL experience with the ability to write ad-hoc and complex SQL queries.
- At least 5 years of Python experience with ability to write good python code.
- Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions.
- Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels.
- Self-starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to competing priorities.
- Strong problem-solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities.
- Experience with Reporting tool like Tableau, Power BI would be a plus.
- Experience on any ETL tool is added advantage.
- Knowledge of using GIT and Jenkins/CI_CD pipeline for automated code deployment.
- Knowledge and Experience of Graph DB (Star dog DB) will be an added advantage, including ontology modelling, data integration, semantic graph querying, and reasoning capabilities
- Experience with Agile development methodologies
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
