Senior Data Engineer
New
C
Capital BankBanking
We are currently hiring only within our core locations which include Maryland (MD), District of Columbia (DC), Virginia (VA), Pennsylvania (PA), Delaware (DE), Indiana (IN), Illinois (IL), South Carolina (SC), North Caroline (NC), Florida (FL).Full-TimeSenior
Salary$115,000 - $130,000 annually
Apply NowOpens the employer's application page
Job Details
- Experience
- 6+ years of experience in data engineering, ETL, database management
- Required Skills
- PythonETLJavaMicrosoft Power BIMicrosoft SQL ServerSnowflakeTableauAzureData engineering
Requirements
- Bachelor’s degree or higher in Computer Science, Information Systems, or a related field.
- 6+ years of experience in data engineering, ETL, and database management.
- 3+ years of experience designing and building data lakes and data warehouses using platforms like Azure Fabrik, Snowflake, Amazon Redshift, or Google BigQuery.
- 2+ years of experience using data visualization tools like Power BI, Sisense, Google Looker, or Tableau.
- Expertise in cloud-based database platforms, such as Azure SQL, Amazon RDS, Google Cloud Spanner, and Snowflake.
- Proficiency with data integration tools such as Apache Kafka, Apache Spark, Talend, or Informatica.
- Advanced SQL skills and familiarity with Python or Java.
- Experience with CI/CD tools (e.g., GitLab, Azure DevOps, Jenkins) and data pipeline monitoring tools (e.g., Airflow, Apache NiFi, Azure Data Factory).
- Experience with managing data transfers and file processes, including SFTP and secure data pipelines.
- Strong understanding of database security best practices, including encryption and access controls.
Responsibilities
- Serve as the expert for ETL and DB solutions, collaborating with business stakeholders and IT teams to define requirements, gather data, and implement optimized data solutions.
- Design, implement, and maintain data systems in Snowflake to ensure data scalability and accessibility.
- Implement and manage data lakes and data warehouses, creating pipelines and data models to enable efficient analytics and reporting.
- Establish and document strategies for managing data transfer processes, including secure file transfers (SFTP), batch data processing, and real-time streaming.
- Build and optimize ETL pipelines for data extraction, transformation, and loading into operational databases or analytical platforms.
- Integrate and support data visualization tools such as Power BI, Sisense, Google Looker, or Tableau.
- Plan, coordinate, and implement database migrations, upgrades, and patches with minimal downtime.
- Define and enforce database governance policies, including data integrity, security, and compliance.
- Analyze and resolve database performance issues by optimizing queries, indexes, and schema designs.
View Full Description & ApplyYou'll be redirected to the employer's site
