Senior Data Engineer

📋 Description

• Under the guidance of direct supervision, responsible for aiding in the design, development, and maintenance of databases and ETL (Extract, Transform, Load) systems that support business applications and business intelligence for the organization.

• Execute all responsibilities in compliance with the company’s policies and procedures, investor guidelines, as well as all applicable US state and federal laws and regulations governing the company's operations.

• Design, develop, and enhance data integration processes, ETL workflows, and data platforms, while leading the creation of technical designs and functional specifications to ensure optimal performance, scalability, and reliability, contributing to future cloud migration initiatives.

• Collaborate with stakeholders and third-party vendors to define, assess, and align business requirements for scalable data integration, reporting, and business intelligence solutions.

• Spearhead the design and development of automated solutions aimed at improving business processes, productivity, and operational efficiency.

• Oversee ETL jobs and lead troubleshooting efforts for critical production issues, participating in off-hours support rotation and providing Subject Matter Expert (SME) assistance as required.

• Direct the design, implementation, and maintenance of data platforms, along with technical designs and functional specifications to ensure performance, scalability, and reliability.

• Create and maintain thorough documentation of data processes, reports, applications, and procedures to ensure consistency, knowledge sharing, and adherence to organizational standards.

• Design, develop, and deploy scalable reporting and dashboard solutions to enhance business intelligence, data visualization, and operational efficiency, ensuring the implementation of adequate security measures.

⛳️ Requirements

• Advanced expertise in working within the Microsoft SQL Server environment to design, implement, and optimize enterprise data solutions with an emphasis on scalability and performance.

• Strong grasp of ETL concepts, data integration, and transformation processes, along with practical experience in implementing ETL solutions using Microsoft SSIS.

• Familiarity with version control concepts, including experience with Microsoft DevOps for managing code repositories and collaborative development.

• Must possess expert knowledge to lead and manage SDLC processes.

• Advanced proficiency in T-SQL programming, scripting, and optimization techniques, with the ability to write, debug, and optimize complex queries and procedures for enterprise-level applications.

• Capability to comprehend, retain, and apply both oral and/or written instructions or other relevant information.

• Exhibits advanced analytical and problem-solving skills to design and optimize complex data solutions while collaborating effectively across teams.

• High school diploma or equivalent work experience is required; a bachelor’s degree in computer sciences is preferred.

• A minimum of four (4) years of experience in the information technology sector, with a strong focus on relational databases, data integration (ETL), data warehousing, business intelligence, report development, and dashboard design.

• At least four (4) years of experience with ETL tools, specifically SSIS.

• Four (4) or more years of experience with database management systems, particularly MS SQL.

• Strong working knowledge of integrating applications using APIs is preferred.

• Experience with Microsoft BI applications (SSRS, SSAS, Power BI) is a plus.

• Familiarity with cloud-based database management and integration services (e.g., Azure Data Factory, Fabric, Snowflake, or Databricks) to lead and optimize data integration and transformation processes is advantageous.

• Proficiency in programming languages commonly utilized in data engineering, such as Python or Java.

🏝️ Benefits

• Comprehensive healthcare plans available for you and your family, along with a discretionary 401(k) match of 50% on the first 4% of pay contributed.

• Access to a variety of fitness, restaurant, retail (and more!) discounts through our employee portal.

• Tailored training programs designed to help you advance in your career.

• Employee referral bonuses, rewarding you for helping Carrington and Vylla grow.

• Educational reimbursement opportunities.

• The Carrington Charitable Foundation actively contributes to the community by supporting causes that align with the interests of Carrington Associates. For additional information about the Carrington Charitable Foundation and the organizations and programs it supports through specific fundraising efforts, please visit: carringtoncf.org.