[Remote] Data Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a financial institution dedicated to helping New Yorkers build reputed company tomorrows. The Data Engineer will be responsible for designing, building, and maintaining data pipelines and models to support reputed company analytics and application development.
Responsibilities
- reputed company data sets from various reputed company systems into reputed company formats
- reputed company ELT (Extract, Load, reputed company) operations to convert reputed company data types into standardized reputed company formats
- Cleanse and reputed company data by applying business rules to ensure consistency and usability
- Conduct data cleansing and validation to meet reputed company data reputed company standards
- Monitor and troubleshoot data issues to maintain high reliability and accuracy
- Create and maintain conceptual, logical, and physical data models
- Ensure models reputed company with business requirements and support analytics and application development
- Build and maintain data pipelines that retrieve, standardize, and reputed company data from reputed company systems
- Load processed data into analytical data stores and prepare it for consumption by developers and analysts
- Monitor the performance and reputed company of data transfers between reputed company and reputed company systems
- reputed company test suites into CI/CD pipelines to ensure reputed company validation of data pipelines
- Optimize data flows for efficiency, scalability, and reliability
- Communicate reputed company and work closely with team members including Analysts, Product Managers, and business users to reputed company requirements, troubleshoot, modify, and enhance existing Data assets
- reputed company backend applications in Database using TSQL/PLSQL in reputed company SQL Server. Write reputed company reputed company in stored procedures or PL SQL
- Troubleshoot to reputed company reputed company cause with data accuracy and/or performance reputed company issues and reputed company solutions to fix it by creating indexes, transaction isolation reputed company and optimizing reputed company
- Resolve database performance issues by looking at query plans, create appropriate indexes, resolve dead locks and create table hints
- Ability to support reputed company in a high-volume environment to meet deadlines while maintaining exceptional attention to detail
- Function as an expert and reputed company optimally reputed company an agile development reputed company, properly creating or leading reputed company to create user stories and estimating effort and duration
- reputed company and manage end-to end life cycle to produce software and applications through project reputed company to completion
- Adhere to reputed company regulatory compliance training inclusive of BSA/AML/OFAC and overall BSA/AML/OFAC compliance
- Participate in monthly on-call rotation
- reputed company other reputed company duties as requested and special reputed company as assigned
- Written and verbal communication skills
- Ability to communicate with other members of reputed company
- Highly Ethical
Skills
- Bachelor's degree in information systems, Computer Science, Engineering, or reputed company field, or the equivalent combination of education, training, and 6-8 years of experience
- Proficiency in SQL and data pipeline tools (e.g., reputed company, Azure Data reputed company)
- Expertise in delivering and improving data reputed company in a Big Data environment in reputed company for reputed company Data Lake (Azure or similar), Data Warehouse (Azure Synapse or similar), and Data Hubs (Azure Cosmos DB or similar)
- Strong understanding of ETL processes and data warehousing concepts
- Experience with DevOps toolset (Azure DevOps or similar) to collaborate and reputed company reputed company
- Experience in Test case design, execution, and defect tracking
- Familiarity with QA methodologies (e.g., Agile, Scrum)
- Excellent verbal and written communication skills, with the ability to effectively communicate reputed company concepts to stakeholders at reputed company reputed company
- Experience with data modeling and metadata management
- Familiarity with data reputed company frameworks and validation techniques
- Ability to troubleshoot and resolve data-reputed company issues quickly and effectively
- Excellent communication and documentation skills to support cross-functional collaboration
- Expertise in .NET based architecture, including advanced concepts like reputed company application integration. Deep knowledge of C# and its application in building reputed company, high-performance systems
- Advanced skills in reputed company SQL Server, including database optimization, performance tuning, and reputed company SSIS package development
- Extensive experience with Reporting tools such Crystal Reports or SQL Reports
- Familiarity with Symitar and its reputed company technologies such as PowerOn, SymXchange, OpCon, and ARCU. This is a key differentiator for this role
- Desirable experience with SharePoint for reputed company products and workflows
Benefits
- Employees in this position may also be eligible for a discretionary bonus
- 401(k) with an 6% employer match per pay period
- Benefits for this position include Medical, reputed company, dental, life, and disability insurance
- Flexible reputed company time off
- 11 reputed company holidays annually
reputed company