Senior Data and BI Engineer

We are looking for Senior Data and BI Engineer for our client in Charlotte NC.

Job Title: Senior Data and BI Engineer

Job Location: Charlotte NC

Job Type: Contract

Job Overview:

Requirement/Must Have:

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

Responsibilities:

• 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.
• 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.
• 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).
• 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.
• 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.
• 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.
• 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.

Nice to Have:

• Experience in financial services / large enterprise environments.
• Strong analytical mindset with focus on data-driven decision making.

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.
• SQL Server (On-Prem & Azure SQL).
• Oracle Database.
• MongoDB (basic knowledge).
• Windows Server environments.
• Python (basic to intermediate knowledge).
• Autosys, JIRA, ServiceNow.

Qualification And Education:

• Excellent communication and documentation skills.
• 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.