Senior Data & BI Engineer - Charlotte, NC (Onsite)

Job Title: Senior Data & BI Engineer

Location: Charlotte, NC (Onsite)

Job Description:             

• We are seeking a highly experienced Senior Data & Business Intelligence Engineer with over 10+ years of expertise in data modelling, visualization, database engineering, and production support.
• The ideal candidate will have deep hands-on experience with Power BI, Tableau, SQL Server, and ETL tools, along with strong exposure to data engineering, performance tuning, and enterprise production environments.

Key Responsibilities

• Data Visualization & BI Development
• Design and develop interactive dashboards and reports using Power BI and Tableau
• Build visually compelling insights using charts, maps, heatmaps, and advanced visualizations
• Develop complex DAX calculations, KPIs, and time intelligence metrics
• Create and manage calculated fields and advanced analytics logic
• Publish reports to Power BI Service and manage data refresh schedules
• Implement Row-Level Security (RLS) to control access
• Data Engineering & Modelling
• Design and implement data models (relationships, hierarchies, calculated columns)
• Perform data extraction, transformation, and loading using Power Query, SSIS, and Informatica
• Build scalable and efficient data warehouse solutions
• Work with structured and semi-structured data including SQL Server and MongoDB
• Database Development & Administration
• Develop and optimize complex T-SQL queries, stored procedures, triggers, and functions
• Design and maintain database objects (tables, views, indexes)
• Perform query optimization and performance tuning
• Implement indexing and partitioning strategies to improve performance
• Manage SQL Server environments (2008/2012/2016 & Azure SQL)
• Production Support & Operations
• Monitor and maintain production systems ensuring high availability and reliability
• Handle incident management, RCA, and ticket tracking (ServiceNow/JIRA)
• Support code deployment, release management, and production fixes
• Perform environment monitoring (SIT, UAT, Prod) and validations
• Database Maintenance & Reliability
• Implement backup and recovery strategies (full, differential, log backups)
• Design and test disaster recovery plans
• Perform regular maintenance: index rebuilds, statistics updates, patching
• Set up monitoring tools for database health and performance
• Data Migration & Performance Optimization
• Lead data migration initiatives from legacy systems to modern platforms
• Optimize large datasets using advanced data structures and indexing techniques
• Improve query performance and reduce load times significantly
• Collaboration & Delivery
• Participate in full SDLC lifecycle (requirements → design → development → testing → deployment)
• Create Functional Specification Documents (FSDs) and technical documentation
• Gather requirements and convert them into JIRA stories and deliverables
• Collaborate with cross-functional teams in agile environments
• Maintain documentation in Confluence

Required Skills & Qualifications

• Core Skills
• Power BI (DAX, Power Query, Data Modelling, RLS)
• Tableau (Dashboarding, Calculated Fields, Visual Analytics)
• SQL Server (T-SQL, Performance Tuning, Database Design)
• ETL Tools: SSIS, Informatica
• Reporting Tools: SSRS, Crystal Reports
• Data Platforms & Technologies
• SQL Server (On-Prem & Azure SQL)
• Oracle Database
• MongoDB (basic knowledge)
• Windows Server environments
• Additional Skills
• Python (basic to intermediate knowledge)
• Autosys, JIRA, ServiceNow
• Production deployment & support processes
• Data Quality & Analysis

Experience

• 10+ years in Data Engineering / BI / Database Development
• Strong experience in enterprise data environments and production systems
• Proven track record in performance optimization and large-scale data handling

Preferred Qualifications

• Experience in financial services / large enterprise environments (nice-to-have given your WF context)
• Strong analytical mindset with focus on data-driven decision-making
• Excellent communication and documentation skills

Key Traits

• Highly proactive and detail-oriented
• Strong problem-solving and troubleshooting skills
• Ability to work under pressure in production environments
• Continuous learner with passion for emerging data technologies