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

Lorven Technologies Inc
Charlotte, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 105K

Job location

Charlotte, United States of America

Tech stack

Query Performance
Confluence
JIRA
CA Workload Automation Ae
Business Intelligence
Big Data
Databases
Crystal Reports (Reporting Software)
Information Engineering
ETL
Data Migration
Data Mining
Data Structures
Data Visualization
Database Design
Database Development
FS Design Studio
Issue Tracking Systems
Python
Microsoft SQL Server
SQL Azure
Windows Server
MongoDB
Oracle
Performance Tuning
Systems Development Life Cycle
Query Optimization
Release Management
Power BI
Software Deployment
SQL Stored Procedures
SQL Server Reporting Services
SQL Server Integration Services
Tableau
T-SQL
Visual Analytics
Backup and Restore
Enterprise Data Management
Informatica Powercenter
System Availability
Powerquery
Semi-structured Data
Data Management
Tools for Reporting
Legacy Systems
ServiceNow

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., * 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, ABM Industries is seeking an Electrical Field Test Technician (NETA III / IV or equivalent experience) to join our Electrical Power Services team. The Electrical Field Test Technic…
  • 22 days ago

Requirements

  • 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., * 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, * 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

Apply for this position