Senior Data Engineer with Data Analytics

Role Overview

Contribute to the success of technology initiatives by analyzing, designing, developing, testing, deploying, and supporting enterprise data analytics and reporting solutions.

What You Will Do

Design, develop, test, deploy, operate, and maintain scalable data analytics, business intelligence, and reporting solutions using Azure, SQL Server, Power BI, OLAP, and related database reporting tools.

Why It Might Be a Fit

The ideal candidate combines strong software engineering discipline with deep experience in SQL Server, Azure data services, Power BI, OLAP/semantic modeling, data warehousing, and reporting methodologies.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent work experience.
• Five to six years of relevant experience in software development, data analytics, business intelligence, data engineering, database reporting, or related technology roles.
• Hands-on experience with SQL Server, T-SQL, relational database design, query optimization, and production reporting or analytics solutions.
• Experience developing business intelligence reports, dashboards, data models, or analytics products using Power BI or comparable enterprise reporting tools.
• Working knowledge of Agile delivery practices and modern software development lifecycle principles.
• Demonstrated ability to work effectively in a small-team environment where responsibilities may span business analysis, technical design, coding, testing, deployment, troubleshooting, and production support.
• Advanced proficiency with Power BI, including data modeling, DAX, Power Query, report optimization, workspace practices, refresh strategies, and role-based security concepts.
• Strong experience with SQL Server reporting, analytics, and data integration patterns, including dimensional modeling, star schemas, stored procedures, indexing, query tuning, SSIS package development/support, ETL/ELT workflows, SSRS, or comparable reporting frameworks.
• Experience designing, developing, maintaining, troubleshooting, and modernizing SSIS packages for data movement, transformation, scheduling, exception handling, logging, and production support.
• Experience designing OLAP, semantic, or analytical models for complex business reporting, trend analysis, KPI measurement, and self-service analytics.
• Familiarity with Azure data and analytics services such as Azure SQL Database, Azure Data Factory, Azure Analysis Services, Synapse Analytics, Microsoft Fabric, Data Lake, or related cloud-native capabilities.
• Ability to apply AI-centric practices and tools to improve solution design, development productivity, automated testing, documentation, data analysis, and operational support while maintaining responsible governance and human review.
• Comfortable working as a senior hands-on contributor in a lean team, including shifting between analyst, developer, tester, release support, and production support responsibilities as priorities require.
• Understanding of data governance, data quality, lineage, metadata, privacy, risk, security, and compliance considerations in an enterprise financial services environment.
• Strong analytical and problem-solving skills with the ability to diagnose complex database, reporting, ETL/SSIS, performance, and data reconciliation issues.
• Ability to translate business needs into scalable technical designs and communicate technical concepts clearly to engineers, product owners, business stakeholders, vendors, and leadership.
• Experience working in Agile teams with product owners, scrum masters, architects, developers, analysts, testers, and operations partners to deliver incremental value.
• Demonstrated ownership mindset, including the ability to prioritize work, size tasks appropriately, communicate blockers early, mentor others, and drive continuous improvement.
• Solid understanding of DevOps, CI/CD, version control, automated testing, release management, monitoring, and production support practices for data and reporting solutions.

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law

Tagged as: Data Analysis