Senior Data & BI Engineer

Role: Senior Data & BI Engineer Location: Charlotte, NC (Onsite) Position Type : Contract JOB DESCRIPTION We are seeking a highly experienced Senior Data & Business Intelligence Engineer with over 10+ years of expertise in data modeling, 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 & Modeling • 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 Modeling, 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 Best Regards, Bismillah Arzoo (AB)