Senior Business Intelligence Developer

Published date Posted on Indeed on Oct 13, 2021 (3 d ago)

Senior MS Business Intelligence SQL ETL Developer

Overview

TalentFish is casting a line for a Senior Microsoft BI SQL ETL Developer skilled in SSRS, Data Modeling and SQL. This is a Full-Time REMOTE position!

  • Key skills needed for this position, in addition to Business Intelligence and ETL, are strong SSRS, Data Modeling and SQL development skills.
  • The right candidate will possess excellent communication skills and have experience working in a consultative client-facing role.
  • Candidates must be able to analyze, understand and resolve business problems using related BI technologies.
  • The ideal candidate will require excellent analytical, interpersonal and communication skills which are necessary to succeed in this role.
  • You will be part of a small collaborative team. Ability to learn quickly and contribute as a hardworking team-player is a must!
  • Experienced in handling onshore clients is highly desired.
  • Must have background in working on data warehouse projects involving building and data modeling.

Education and Experience:

Requirements

  • Experience managing functional requirements for data warehouse and /or reporting.
  • Experience working with teams and guiding junior developers.

Database Experience

  • Experience working with various versions of SQL Server, Oracle or similar.
  • Extensive SQL development experience including stored procedures, functions, views and SSMS.
  • Performance tuning and optimization, indexing, partitioning.

Data Warehouse

  • Experience in designing data marts and data warehouses using Star schema and Snowflake schema.
  • Good exposure in identifying various dimensions and facts to implement data-warehouse architecture.
  • Possess a thorough understanding on data warehouse concepts, dimensional modeling and data warehouse components of an operational data store (ODS), data marts, staging and production environments.

Microsoft BI Stack and Azure Cloud

  • Experience in Microsoft BI tools SSIS and SSRS development and deployment.
  • Extensive experience developing SSRS and SSIS packages for ETL, data cleansing and data transformation with audit logging, error logging and optimization aspects.
  • Hands-on experience creating SSIS workflows with tasks, containers, and various transformations.
  • Experience using Azure Data Factory, pipelines, transformation.
  • Experience in creation of cubes and modifying measures and attributes, creating hierarchies and relationships among dimensions and facts, creation of calculated measures and members in calculations, KPIs, Partitions, and Actions in SSAS.
  • Experience working with different components of Azure data platforms like Azure Data Factory, Azure SQL DB, Azure DWH.
  • Data visualization expertise using Power BI and Data Analysis Expressions (DAX ) language.

TalentFish is an employee-owned company pioneering a new realm in talent acquisition. We are redefining IT staffing by evolving AI, video screening and our unique platform. TalentFish focuses on providing the best employee, consultant, and client experience possible.
At TalentFish we are an Equal Opportunity Employer we embrace and encourage diversity!

Job Type: Full-time

Pay: $100,000.00 - $115,000.00 per year

Benefits:

  • Dental insurance
  • Health insurance
  • Paid time off
  • Vision insurance

Schedule:

  • 8 hour shift

Experience:

  • SQL: 1 year (Preferred)
  • Informatica: 1 year (Preferred)
  • Data warehouse: 1 year (Preferred)

Work Location:

  • Fully Remote

Work Location: Remote


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Piper Companies Piper Companies |
|
2 d ago

Piper Companies is looking for a Database Architect who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Database Architect include:You will be responsible for providing leaders

LOAN IQ DEVELOPER_______________________________________________________________________________________LOCATION: Remote in USHIRE TYPE: Full-timeVERTICAL: Financial Markets_______________________________________________________________________________________Role SummaryeClerx i

Orange Kiwi Solutions Orange Kiwi Solutions |
Today

About UsOrange Kiwi Solutions provides affordable & responsive Prophet 21 expert support to distributors across North America.As a IT Support Technician for Orange Kiwi Solutions, you are responsible for solving complex advanced challenges related to Prophet 21 implementations an

Tradesmax Group Tradesmax Group |
Today

TradesMax is an innovative Fintech company based in Los Angeles, offering U.S. fundamental equity research, real-time financial big data and news. We empower individuals to take control of their financial futures by providing the data tools and services they need to meet their ne

OverviewWe are hiring an experienced Business Intelligence Analyst to join the growing Information Systems team at Hyland. In this role, you will be responsible for understanding business/department needs and goals and will create data-driven analysis and insight to support manag