Data Engineer

This role provides the opportunity to work at the intersection of data engineering and analytics, making a tangible impact on business strategy and operations. You will work with cutting-edge tools, collaborate with diverse teams, and help shape the data strategy across the organization while solving challenging, high-impact problems. Responsibilities:Data Engineering Pipeline Management:Design, develop, and maintain scalable ETL pipelines for ingestion, transformation, and integration of structured and unstructuredOptimize SQL queries, stored procedures, triggers, and automation scripts to handle large, complex datasetsEnsure data quality, integrity, and consistency across multiple systems andImplement error handling, logging, monitoring, and alerting mechanisms for reliable productionCollaborate with DevOps and engineering teams to deploy data workflows and ensure seamless integration with productionData Modeling Governance:Design and implement relational, dimensional, and Master Data Management (MDM) models tailored to finance, operational, and enterpriseDevelop detailed entity-relationship (ER) diagrams and define indexing, partitioning, and normalization strategies for optimalEstablish and enforce data governance, validation rules, standardization policies, and documentation for maintainableImplement slowly changing dimensions (SCDs) and hierarchical structures to support evolving business requirements.Analytics Business Impact: Translate raw operational, financial, and transactional data into actionable insights that drive revenue growth, cost reduction, and process optimization.Develop predictive and prescriptive models for forecasting, anomaly detection, risk assessment, and decision support.Validate, monitor, and improve model accuracy, fairness, explainability, and operationalQuantify the business impact of data initiatives and communicate actionable recommendations to stakeholders.Collaboration Communication:Partner with business intelligence, analytics, finance, operations, and product teams to identify opportunities for data-drivenProduce dashboards, reports, and narratives that clearly communicate insights to non-technical stakeholders.Translate complex technical concepts into business-relevantDocument data models, transformation logic, metadata, and processes for cross-team knowledge sharing.Data Quality Responsible AI:Profile and monitor data to detect inconsistencies, gaps, and anomalies, implementing corrections asEnforce metadata standards, data lineage, and data security, privacy, and compliance best practices.Ensure ethical use of AI/ML models by managing bias, transparency, and operationalMaintain rigorous documentation of assumptions, limitations, and model performance for auditing andRequired Skills Experience:Strong SQL programming (PL/SQL, T-SQL) with hands-on experience in relational databases such as Oracle, SQL Server, andExpertise in data modeling (relational, dimensional, MDM) and database design bestProven experience with ETL tools such as Informatica, Talend, orSolid understanding of data governance, lineage, and qualityExperience in performance tuning, indexing, partitioning, and optimization for largeStrong problem-solving, analytical, and critical-thinkingAbility to work effectively in cross-functional teams and communicate complex technical concepts to business stakeholders. Preferred Qualifications:Experience in financial data management, enterprise MDM projects, or similarFamiliarity with reporting and BI tools such as Power BI, SSRS, orKnowledge of scripting and automation using Python, Shell, or similarExperience deploying predictive or prescriptive models in productionFamiliarity with cloud platforms (AWS, Azure, GCP) and modern data