Job Summary
- The Data Engineer will be responsible for designing, developing, and maintaining robust data pipelines, databases, and integration solutions that support the organization’s analytics, reporting, and operational data needs. The ideal candidate must demonstrate advanced proficiency in SQL, Windows OS, and key data engineering tools, with strong capability in C#, .NET Core, Python, and business intelligence technologies.
Key Responsibilities
Data Architecture & Engineering
- Design, build, and optimize scalable data pipelines and ETL workflows using SSIS and other integration tools.
- Develop, maintain, and optimize relational databases, data warehouses, and operational data stores.
- Implement data modeling best practices to support analytics, reporting, and business intelligence initiatives.
Database Management & SQL Development
- Write advanced SQL queries, stored procedures, functions, and jobs on MSSQL Server.
- Perform data extraction, transformation, and loading (ETL) across multiple database environments.
- Ensure data quality, integrity, and availability across integrated systems.
Application & API Development
- Develop and maintain data-driven applications and services using C#, .NET Core, and related frameworks.
- Build and optimize APIs, backend services, and microservices supporting data processing and automation.
Data Analytics & Business Intelligence
- Develop and manage SSRS reports and dashboards for business stakeholders.
- Perform multidimensional data analysis using SSAS (where required).
- Build interactive dashboards and BI visualizations with Power BI or Tableau.
DevOps & Version Control
- Use Azure DevOps for project management, code versioning, and task automation.
- Work with Git for version control and collaborative development.
- Assist in CI/CD activities and containerization efforts where applicable (Docker/Kubernetes).
Operating Systems & Environment Management
- Work primarily within the Windows operating environment.
- Utilize intermediate knowledge of Linux distributions (RedHat, CentOS, Ubuntu, Debian) where necessary.
Required Skills & Competencies
Windows, Structured Query Language (SQL), C#, .NetCore, ASP.NET Zero, Python, Angular, React, Bootstrap 5 (Minimum), HTML 5, JavaScript/Jquery, TypeScript, SQL Server Analysis Services (SSIS), Power BI/Tableu, and Azure DevOps.
Qualifications
- Bachelor’s degree in Computer Science, Data Engineering, Information Technology, or related field.
- 3–5+ years of professional experience in data engineering, ETL development, or database management.
- Strong background in software development and data integration.
- Experience collaborating in agile development environments (Azure DevOps preferred).
Key Competencies
- Strong analytical and problem-solving skills.
- Excellent attention to detail and ability to work with large datasets.
- Strong communication skills and ability to engage cross-functional teams.
- Ability to work under pressure and meet strict timelines.