Data Engineer

URUS GROUP LP • Madison, WI

76d • Hybrid

About The Position

Join our team as a Sr. Data Engineer in a hybrid role based in the Madison, WI area! We're looking for someone passionate about data, with hands-on experience in Databricks, SQL Server, SSIS, and SSRS, to help drive impactful reporting and robust data solutions. If you're energized by solving complex data challenges and enjoy working collaboratively, we encourage you to apply. The Sr. Data Engineer is responsible for the design, development, and maintenance of data integration and reporting solutions. The ideal candidate will possess expertise in Databricks and strong skills in SQL Server, SSIS and SSRS, and experience with other modern data engineering tools such as Azure Data Factory. This position requires a proactive and results-oriented individual with a passion for data and a strong understanding of data warehousing principles.

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.

Nice To Haves

• Experience with Microsoft Azure cloud platform and Microsoft Fabric desirable.

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.
• Participate in the design and implementation of data warehousing solutions.
• 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.
• Collaborate effectively with business users, data analysts, and other IT teams.
• Communicate technical information clearly and concisely, both verbally and in writing.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Industry: Support Activities for Agriculture and Forestry
• Education Level: Bachelor's degree
• Number of Employees: 1,001-5,000 employees