Microsoft BI/ Data Engineer

Hybrid in Queens, NY, US • Posted 7 hours ago • Updated 7 hours ago
Full Time
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

  • API
  • Analytical Skill
  • Analytics
  • Backup & Restore
  • Business Intelligence
  • C#
  • Change Control
  • Cloud Computing
  • Dashboard
  • Data Flow
  • Data Marts
  • Data Migration
  • Data Quality
  • Data Security
  • Data Warehouse
  • Database
  • Database Administration
  • Database Performance Tuning
  • Documentation
  • ELT
  • Extract
  • Transform
  • Load
  • Microsoft
  • Microsoft Azure
  • Microsoft SQL Server
  • Microsoft BI
  • Microsoft Power BI
  • Microsoft SSIS

Summary

  • Regardless of seniority or role, uphold mission, core values, and guiding principles by providing an exceptional service experience to colleagues and members alike through consistent demonstration of our service excellence behaviors.
  • Develop and maintain ETL/ELT processes using SSIS, Fabric Pipelines, and/or Azure Data Factory, including advanced Script Tasks (C# or ) to automate file operations and apply custom business logic.
  • Develop and implement solutions in Microsoft PowerBI and Microsoft Fabric, including Lakehouse/Warehouse modeling, Dataflows Gen2, Pipelines, and Semantic Models; support the modernization of existing ETL and reporting assets into Fabric and Azure cloud-based frameworks.
  • Design, develop, and optimize complex T-SQL stored procedures, functions, and database objects for high-volume OLTP and Data Warehouse environments, with expertise in transaction isolation levels, table hints, deadlocks, linked servers, OPENQUERY, triggers, and column-level encryption.
  • Perform advanced database performance tuning, including execution plan analysis, indexing strategies, partitioning, and transaction optimization.
  • Contribute to the design and enhancement of OLTP and OLAP data models, ensuring alignment with business, analytical, and performance requirements.
  • Build and support integrations that consume or expose REST APIs, including testing, validation, and troubleshooting using Postman and related API tools.
  • Create and govern dashboards and visual analytics in Power BI or Tableau, ensuring accuracy, compliance with governance standards, and proper alignment with semantic models.
  • Verify and maintain data quality and integrity across the data warehouse, semantic models, dashboards, reports, and data extracts.
  • Troubleshoot and resolve database, ETL, reporting, data quality, performance, capacity, replication, and distributed data issues; participate in incident resolution and root-cause remediation.
  • Maintain thorough documentation, adhere to change control processes, and support regulatory, cybersecurity, and data protection compliance.
  • Collaborate with Product Managers, Analysts, Engineers, and cross-functional teams to enhance BI and data platform capabilities.
    What we're seeking
  • Bachelor s degree in Engineering or Computer Science
  • 6 years of experience in reports and data warehouse development
  • 5 years software development experience on Microsoft BI Platform including, , MS SQL Server
  • 4 years of experience in DB Development (OLTP) using MS SQL
  • 2 years of experience in building Data Marts using dimensional models
  • 2 years of experience in building Dashboards and KPI visualization on Power BI and/or Tableau
  • Strong reporting and data warehouse development skills on issues that are complex and evaluative in nature where troubleshooting may call for referencing an advanced knowledge base
  • Large data migration experience
  • Hands on experience using Oracle
What makes you stand out
  • Maintaining code/scripts in TFS for multiple environments
  • Cloud technology like Microsoft Azure, MS Power BI and Microsoft Fabric.
  • DBA activities like database backup and restore.
  • Data extraction using API
  • Handling data in XML
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91088966
  • Position Id: 8956213
  • Posted 7 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Queens, New York

2d ago

Easy Apply

Full-time

Depends on Experience

Hybrid in New York, New York

Today

Easy Apply

Full-time

105000 - 140000

Hybrid in New York, New York

2d ago

Easy Apply

Full-time

Depends on Experience

Remote or New York, New York

Today

Full-time

USD 104,832.00 - 142,272.00 per year

Search all similar jobs