Senior Data Engineer / Cloud Data Engineer
Job DetailsJob Title: Senior Data Engineer / Cloud Data EngineerLocation: Indianapolis, INDuration: 6 monthsGBaMS ReqID: 10955336Experience Required: 5-8 yearsDesirable Skill: AI & Gen AI - Products & ToolsPosition SummaryDevelop, deploy, and optimize scalable:Data pipelinesData modelsAnalytics solutionsSupport enterprise-wide business insights and decision-making. Apply expertise in:Cloud Data EngineeringData WarehousingAdvanced SQLPython / PySparkData TransformationsTranslate complex data into actionable business recommendations. Collaborate with cross-functional teams, preferably within the pharmaceutical or healthcare domain. Core ResponsibilitiesData Engineering & Pipeline DevelopmentDevelop and maintain scalable ETL/ELT pipelines using:PythonPySparkSQLSupport structured and unstructured data ingestion. Build robust cloud data infrastructure using:Microsoft FabricAzure SynapseDatabricksAWSImplement end-to-end automation for:Data ingestionStreamingSchedulingMonitoringWork with:Azure FunctionsAzure Data FactoryADLS Gen2Power BIOptimize large-scale big data architectures for performance and scalability. Data Modeling & ArchitectureDesign and maintain multidimensional data models, including:Star SchemaSnowflake SchemaFact tablesDimension tablesViewsStored proceduresManage complex datasets and ensure alignment with functional and non-functional requirements. Develop foundational knowledge of SAP S/4HANA and BW/4HANA data models to support financial analytics. DevOps & DeploymentUtilize GitHub and Azure DevOps for:CI/CDVersion controlAutomated deploymentsManage artifact deployments across multiple environments. Perform:Risk assessmentsImpact analysisImplement process improvements and workflow automation. Analytics & Business PartnershipPartner with business stakeholders to:Gather requirementsUnderstand business problemsTranslate requirements into analytical solutionsDevelop analytics and reporting solutions supporting Global Finance transformation. Develop dashboards and BI solutions using:Power BITableauTranslate analytical outcomes into actionable insights and KPIs. Troubleshoot data-related issues. Perform root cause analysis. Required Qualifications5-8 years of hands-on experience in:Data EngineeringCloud Data WarehousingExperience with cloud data platforms such as:Azure SynapseMicrosoft FabricDatabricksAWS RedshiftSnowflakeExpert-level SQL skills across:Relational databasesCloud data warehousesStrong Python and PySpark skills for:Data transformationPipeline developmentStrong data modeling expertise, including:Dimensional modelingFact and dimension tablesNormalization / denormalizationViewsStored proceduresExperience owning projects end-to-end. Ability to translate business problems into scalable analytical solutions. Experience designing and optimizing large-scale big data pipelines. Experience working with:Structured datasetsUnstructured datasetsStrong visualization skills using:Power BITableauStrong documentation and communication skills. Experience with:Root cause analysisContinuous improvementAgile methodologiesPreferred QualificationsExperience with SQL and NoSQL databases, including:AWS RedshiftPostgreSQLDatabricksPharmaceutical or healthcare data experience. Cloud experience with:AWSAzureMicrosoft Fabric experience is a strong advantage. CI/CD experience using:GitHubAzure DevOpsProgramming experience with:PythonPySparkRScalaOther scripting languagesExposure to AI and Generative AI products and tools. EducationBachelor’s or Master’s degree in:TechnologyComputer ScienceEngineeringRelated fieldKey CompetenciesStrong analytical and problem-solving skills. Excellent communication and stakeholder management. High attention to detail and data quality. Ability to work effectively in fast-paced, dynamic environments. Strategic and critical thinking. Strong cross-functional collaboration and alignment. Key Skills / KeywordsData EngineeringCloud Data EngineeringETL / ELTAzureMicrosoft FabricAzure SynapseAzure Data FactoryADLS Gen2Azure FunctionsDatabricksAWSRedshiftSnowflakeSQLPythonPySparkPower BITableauData ModelingDimensional ModelingStar SchemaSnowflake SchemaSAP S/4HANABW/4HANAGitHubAzure DevOpsCI/CDBig DataData WarehousingAI & Generative AIAnalyticsAgileRoot Cause Analysis