Data Modeling Engineer (SQL,PL/SQL,ETL,Snowflake,Python,JavaScript)

Goli Tech
Roanoke, TX, US
Full-time

Job Description

Job Description

The Role

Client technology team is looking for a Data Engineer who'll play a crucial role in designing, developing, and maintaining data pipelines and infrastructure.

Your expertise will ensure efficient data acquisition, processing, and staging. Here are the key responsibilities and qualifications :

Responsibilities :

  • Relational Data Modeling :
  • Design and optimize relational database structures (e.g., Oracle, SQL).
  • Create data models that align with business requirements.
  • SQL and PL / SQL Development :
  • Write and optimize SQL and PL / SQL queries for data retrieval and manipulation.
  • Develop stored procedures for data processing.
  • Snowflake Development :
  • Proficiency in Snowflake for data warehousing.
  • Experience with Snow SQL and Snowpark.
  • ETL (Extract, Transform, Load) :
  • Build ETL pipelines using tools like SnapLogic and Informatica.
  • Extract data from various sources, transform it, and load it into target systems.
  • Programming Skills :
  • Proficiency in Python and JavaScript for scripting and automation.
  • Cloud Technologies :
  • Exposure to AWS cloud services for data storage and processing.
  • Reporting :
  • Preferred experience with Power BI for data visualization.

Qualifications :

  • Education and Experience :
  • Bachelor's degree in computer science, Information Systems, or related field.
  • Relevant experience as a Data Engineer.
  • Technical Skills :
  • Solid understanding of data modeling principles.
  • Proficiency in SQL, PL / SQL, and database development.
  • ETL expertise using SnapLogic or similar tools.
  • Knowledge of data warehousing concepts (e.g., Snowflake).
  • Scripting skills in Python and JavaScript.
  • Soft Skills :
  • Analytical approach and problem-solving abilities.
  • Effective communication and collaboration.

The Team

Client Performance Attribution technology team is responsible for the production of daily transaction-based attribution analytics at the holding's level for use by the application's consumers who include Senior Investment Staff, Portfolio Managers, Chief Investment Officers, Research groups, Distribution Channels, Board of Trustees & Shareholders.

The highly sophisticated performance attribution system is continually improving in response to challenges posed by, among others, changes in investment management strategy, the introduction of new investment products, and changes to upstream or interfacing applications!

Required Skills : SQL,JavascriptThis is a high PRIORITY requisition. This is a PROACTIVE requisition

6 days ago
Related jobs
Goli Tech
Westlake, Texas

SQL and PL/SQL Development: </li><li>Write and optimize SQL and PL/SQL queries for data retrieval and manipulation. The Role</p><p>Client technology team is looking for a Data Engineer who'll play a crucial role in designing, developing, and maintaining data pipelines an...

Vision It US
Westlake, Texas

SQL and PL/SQL Development: </li><li>Write and optimize SQL and PL/SQL queries for data retrieval and manipulation. The Role</p><p>Client technology team is looking for a Data Engineer who'll play a crucial role in designing, developing, and maintaining data pipelines an...

Promoted
INSPYR Solutions
TX, United States

As part of the Data Engineering team, the Lead Python Data Engineer will work closely with Business domain experts and Data Scientists to solve real-world oil and gas midstream problems using advanced analytics, machine learning, and artificial intelligence. We are currently seeking an experienced P...

Promoted
VED Software Services, Inc.
Southlake, Texas

If they have Batch experience using Java or Python will be a plus but knowing Java and Python is more essential than experience with Batch. We are searching for talented Software Engineers to join our newly formed Enterprise Software Engineering organization comprised of hundreds of skilled engineer...

Promoted
VED Software Services, Inc.
Southlake, Texas

If they have Batch experience using Java or Python will be a plus but knowing Java and Python is more essential than experience with Batch. We are searching for talented Software Engineers to join our newly formed Enterprise Software Engineering organization comprised of hundreds of skilled engineer...

Promoted
Fidelity TalentSource LLC
Westlake, Texas

The Health Care Technology Group (HCG) supports the recordkeeping and administration of Health Benefits (Medical, Dental and Vision plans) as well as the Health Savings and Reimbursement Account plans on behalf of Fidelity's corporate clients, their employees and retirees. Inquisitive analytical ski...

Randstad
Roanoke, Texas

SQL is a must Experience with Extract, Transform & Load and ELT development is required Familiarity and good understanding of Data Models - relational and dimension models is required Experience with AWS cloud technology is required Experience with multiple database technologies required. Experience...

C&L Group
Coppell, Texas

Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflake SQL. Experience in creating and analyzing SQL and PL/SQL procedures for data integration. Experience in Data Lineage Analysis, Data Profiling Mapping Integration, ETL Validation Cleansing Masking Sub sett...

The University of Texas at Austin
Texas

The Data ETL Engineer develops extract, transform, and load (ETL) procedures using integration tools such as Informatica for complex data models that reflect academic and administrative business processes at the University of Texas at Austin. The Data ETL Engineer plays a critical part in establishi...

Tekvivid Inc
Coppell, Texas

Skills:Data Management Snowflake cloud warehouse ETL pipelines in and outof data warehouse Python and Snowflake SQL scripts using Unix shellData Lineage Analysis Data Profiling Mapping Integration ETLValidation Cleansing Masking Subsetting. Canyou explain the process of loading data into Snowflake u...