Senior Data Engineer

About the Role

We are seeking a highly skilled Senior Data Engineer to build and maintain scalable, highperformance data solutions that unify information from multiple systems into a single, trusted source of truth. This role spans the full data engineering lifecycle, including ingestion, transformation, integration, modeling, and performance optimization. The ideal candidate will have strong handson expertise in dimensional modeling, ETL development (ADF, SSIS, Python), advanced SQL, and data quality management, while also supporting analytics and reporting teams. The position requires close collaboration with business stakeholders and adherence to engineering best practices to deliver accurate, consistent, and analyticsready data across the organization.

This role involves designing, developing, and maintaining enterprise-grade data warehouse solutions supporting reporting, analytics, and operational workloads.

Responsibilities

• Data Engineering: Design, develop, and maintain enterprise-grade data warehouse solutions supporting reporting, analytics, and operational workloads.
• Single Source of Truth: Integrate and standardize data from multiple systems to establish a unified, trusted data foundation.
• Scalable Data Solutions: Translate business requirements into scalable data models and robust engineering solutions.
• Dimensional Modeling: Convert business entities into wellstructured facts and dimensions using dimensional modeling best practices.
• Data Modeling: Design and maintain relational schemas, ER models, and optimized normalization/denormalization strategies.
• ETL Development: Develop, enhance, and maintain ETL pipelines using ADF, Microsoft SSIS, Python, or similar tools.
• Data Quality Assurance: Ensure data accuracy, consistency, and reliability throughout ingestion and transformation processes.
• Data Integration: Integrate data from Oracle NetSuite, Salesforce, Ragic, SQL Server, MySQL, Excel, and other internal/external systems.
• SQL Development: Write and maintain complex SQL queries, stored procedures, functions, triggers, and views.
• Performance Optimization: Implement indexing strategies, tune queries, and optimize database performance for efficiency and speed.
• Issue Resolution: Troubleshoot and resolve data, performance, and availability issues in production environments.
• Reporting & Analytics Enablement: Support reporting and analytics initiatives using Power BI, SSRS, or similar tools.
• Collaboration: Work closely with developers, analysts, and business stakeholders to gather requirements and deliver endtoend solutions.
• Documentation: Maintain comprehensive documentation for data models, ETL pipelines, database objects, and workflows.
• Governance & Change Management: Follow best practices for version control, deployment, and change management using Git and JIRA.

Qualifications

• Must have Bachelors or Masters degree in Computer Science, Information Technology, or a related field.
• 7+ years of experience with Azure SQL, Microsoft SQL Server and Data Engineering solutions.

Required Skills

• Strong expertise in SQL Serverbased data warehousing.
• Hands-on experience Dimensional Modeling using Facts and Dimensions.
• Expertise in ADF, SSIS and Python for ETL development.
• Advanced SQL skills (complex queries, stored procedures, performance tuning).
• Strong experience in Power BI & SSRS for reporting and data visualization.
• Strong understanding of relational database design, indexing, and performance tuning.
• Ability to write complex SQL scripts, stored procedures and views.
• Familiarity with Git, JIRA, and collaborative development workflows.
• Problem-solving mindset and analytical skills.
• Excellent communication and documentation abilities.

Preferred Skills

• Experience with cloud data platforms such as Azure Fabric, or similar.
• Exposure to cloud-based ETL and data processing tools (Databricks).
• Knowledge of CI/CD pipelines for database and data platform deployments.
• Experience with MySQL/Oracle or other relational databases.
• Experience with automation and scripting (PowerShell).
• Relevant certifications (e.g., Microsoft Azure Database, AWS Database Specialty).

Equal Opportunity Statement

We are committed to diversity and inclusivity.