Sr. Data Engineer designing and developing ETL pipelines with Databricks for data integration and reporting solutions. A hybrid role based in the Madison, WI area with collaboration and problem-solving responsibilities.
Responsibilities
Design, develop, and maintain robust and efficient ETL pipelines and processes on Databricks.
Troubleshoot and resolve Databricks pipeline errors and performance issues.
Maintain legacy SSIS packages for ETL processes.
Troubleshoot and resolve SSIS package errors and performance issues.
Optimize data flow performance and minimize data latency.
Implement data quality checks and validations within ETL processes.
Develop and maintain Databricks pipelines and datasets using Python, Spark and SQL.
Migrate legacy SSIS packages to Databricks pipelines.
Optimize Databricks jobs for performance and cost-effectiveness.
Integrate Databricks with other data sources and systems.
Participate in the design and implementation of data lake architectures.
Support data quality initiatives and implement data cleansing procedures.
Collaborate with business users to understand data requirements for department driven reporting needs.
Maintain existing library of complex SSRS reports, dashboards, and visualizations.
Troubleshoot and resolve SSRS report issues, including performance bottlenecks and data inconsistencies.
Comfortable in entrepreneurial, self-starting, and fast-paced environment, working both independently and with our highly skilled teams.
Collaborate effectively with business users, data analysts, and other IT teams.
Document all development work and procedures thoroughly.
Keep abreast of the latest advancements in data integration, reporting, and data engineering technologies.
Continuously improve skills and knowledge through training and self-learning.
Requirements
Bachelor's degree in computer science, Information Systems, or a related field.
7+ years of experience in data integration and reporting.
Extensive experience with Databricks, including Python, Spark, and Delta Lake.
Strong proficiency in SQL Server, including T-SQL, stored procedures, and functions.
Experience with SSIS (SQL Server Integration Services) development and maintenance.
Experience with SSRS (SQL Server Reporting Services) report design and development.
Experience with data warehousing concepts and best practices.
Experience with Microsoft Azure cloud platform and Microsoft Fabric desirable.
Strong analytical and problem-solving skills.
Excellent communication and interpersonal skills.
Ability to work independently and as part of a team.
Experience with Agile methodologies.
Must be legally authorized to work in the United States.
Associate Data Engineer supporting privacy engineering controls and executing privacy impact assessments in a financial services company. Collaborating across business units to ensure alignment with privacy regulations.
Data Engineer at CVS Health optimizing data pipelines and analytical models. Driving data - driven decisions with healthcare data for improved business outcomes.
Senior Data Engineer at CVS Health developing robust data pipelines for healthcare data. Collaborating with teams to provide actionable insights and integrate them with consumer touchpoints.
Senior Data Engineer supporting AI - enabled financial compliance initiative with data pipelines and ingestion processes. Collaborating with diverse teams in a mission - critical regulated environment.
Data Architect leading the definition and construction of cloud data architecture for Kyndryl. Participating in significant technological modernization initiatives, focusing on Google Cloud Platform.
Senior Data Engineer driving data intelligence requirements and scalable data solutions for a global consulting firm. Collaborating across functions to enhance Microsoft architecture and analytics capabilities.
Experienced AI Engineer designing and building production - grade agentic AI systems using generative AI and large language models. Collaborating with data engineers, data scientists in a tech - driven company.
Intermediate Data Engineer designing and building data pipelines for travel industry data management. Collaborating across teams to ensure reliable data for analytics and reporting.
Data Engineer managing and organizing datasets for AI models at Walaris, developing AI - driven autonomous systems for defense and security applications.
Data Engineer designing and maintaining data pipelines at Black Semiconductor. Collaborating with process, equipment, and IT teams to support manufacturing analytics and decision - making.