Data Engineer

Position: Data Engineer
Location: Charlotte, NC (Remote)
Hiring: Contract / Fulltime

JD:

The Data Engineer is responsible for designing, developing, and maintaining the infrastructure and systems required for data storage, processing, and analysis. They play a crucial role in building and managing the data pipelines that enable efficient and reliable data integration, transformation, and delivery for all data users across the enterprise. You will collaborate with various groups within the Technology organization and across the firm to deliver high-value technology solutions and achieve organizational success.

• Designs and develops data pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systems
• Collaborate with architects, data scientists, AI engineers, and analysts to manage data as an asset and optimize models and algorithms for data quality, security, and governance
• Integrates data from different sources, including databases, data warehouses, APIs, and external systems
• Ensures data consistency and integrity during the integration process, performing data validation and cleaning as needed.
• Transforms raw data into a usable format by applying data cleansing, aggregation, filtering, and enrichment techniques.
• Optimizes data pipelines and data processing workflows for performance, scalability, and efficiency
• Monitors and tunes data systems identify and resolves performance bottlenecks and implements caching and indexing strategies to enhance query performance.
• Implements data quality checks and validations within data pipelines to ensure the accuracy, consistency, and completeness of data.
• Takes authority, responsibility, and accountability for exploiting the value of enterprise information assets and of the analytics used to render insights for decision making automated decisions and augmentation of human performance.

Required Skills:

• Years of Experience: 8+ years in Data Engineering
• Education: Bachelor s degree in computer science, Data Science, Software Engineering, Information Systems, or related field.
• Data Pipeline Design & Development (ETL/ELT, data integration, transformation)
  Designs and develops data pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systems
• Business Intelligence & Analytics (prescriptive & predictive) 8+ years of experience including analytics (prescriptive, predictive), business intelligence, and data science
• Microsoft Technologies (Azure Data Factory, Azure Databricks, Synapse, CosmosDB, Power BI, Fabric, SQL Server IaaS/PaaS)
• Informatica Cloud (CIH, DIH, CD Master Data Management, Data Quality)
• Snowflake
• Programming Languages: Python, SQL, C#, Java
• 8+ years of experience including data modelling, data warehousing, analytics, business intelligence, and governance
• Data Quality, Governance & Compliance
• APIs & External System Integration- Integrates data from different sources, including databases, data warehouses, APIs, and external systems.
• Performance Optimization & Scalability- Optimizes data pipelines and workflows for performance, scalability, and efficiency" + "Monitors and tunes data systems, identifies and resolves performance bottlenecks.