Senior Data Engineer

This is a fully remote position, open to applicants in Colorado.

📋 Description

• Design, develop, and sustain robust enterprise data warehouse solutions that cater to data science, artificial intelligence, and business intelligence needs.

• Architect scalable ETL/ELT pipelines for the efficient transformation of raw data into structured, analytics-ready formats.

• Build and oversee API integrations, including hands-on development of APIs.

• Utilize T-SQL and Azure Data Factory to create, optimize, and manage workflows for data integration.

• Employ Microsoft Fabric notebooks for transformation and orchestration when suitable, leveraging Lakehouse and Warehouse for additional storage.

• Guarantee high data quality, integrity, and performance through thorough query tuning and process optimization.

• Collaborate with data scientists, software developers, business intelligence teams, and stakeholders to develop and implement data solutions that fulfill business requirements.

• Convert business requirements into technical solutions and ensure smooth coordination between engineering and other teams.

• Lead the creation of scalable and reliable data models, optimizing them for performance and usability.

• Propel continuous improvements in data engineering processes and practices to maintain efficiency and alignment with industry best practices.

• Monitor system performance and proactively implement enhancements to maximize efficiency and scalability.

• Troubleshoot and resolve data-related issues to guarantee dependable data delivery.

⛳️ Requirements

• Over 5 years of hands-on experience in data warehousing, data engineering, or a related role.

• Extensive experience with T-SQL, including advanced query development and performance tuning.

• At least 5 years working as a SQL Server / Azure SQL DBA, focusing on performance tuning, index and statistics management, execution-plan analysis, and proactive capacity planning.

• Proficient in pipeline development and configuration using Azure Data Factory (ADF).

• Familiarity with Microsoft Fabric, including notebooks and pipelines for transformation, Lakehouse, and Warehouse.

• Expertise in Python for data engineering tasks, encompassing data manipulation and workflow management.

• Strong understanding of data modeling, data architecture, and best practices in data governance.

• Experience managing sensitive/PII data while supporting data quality and governance in a regulated financial services environment.

• Proven experience preparing clean, analytics- and ML-ready datasets for data science and AI workloads.

• Exceptional problem-solving abilities and the capacity to work independently as well as collaboratively.

• Strong communication skills to effectively engage with both technical teams and non-technical stakeholders.

🏝️ Benefits

• 401(k)

• Dental insurance

• Disability insurance

• Employee discounts

• Health insurance

• Life insurance

• Paid time off

• 12 paid holidays per year

• Paid training

• Referral program

• Vision insurance

• Bonus

• Referral bonuses