Senior Data & BI Engineer

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

The pay range that the employer in good faith reasonably expects to pay for this position is $34.67/hour - $54.18/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Salary : $35 - $54