Senior MS Business Intelligence SQL ETL Developer
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:
- Experience managing functional requirements for data warehouse and /or reporting.
- Experience working with teams and guiding junior developers.
- 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.
- 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
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
- 8 hour shift
- SQL: 1 year (Preferred)
- Informatica: 1 year (Preferred)
- Data warehouse: 1 year (Preferred)
- Fully Remote
Work Location: Remote
Let us know
Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:
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
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 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