What are the responsibilities and job description for the Senior Data & BI Engineer position at Net2Source (N2S)?
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)