Kloudhire

Senior Data Warehouse Developer/Programmer/Analyst Loc:Boston, MA

Senior Data Warehouse Developer/Programmer/Analyst Loc:Boston, MA

Posted on : 09-08-2023
Job Type : Full Time only
Salary : 100,000 - 200,000

Job Description:

Responsibilities

Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS), Informatica, AND/OR Big data Stack - Hadoop, Green Plum, AWS, No SQLAnalyze, develop and automate DOI data requests, Internal and external data calls/reports using SQL, SSIS, SSRS, and SharePoint.
Documenting technical requirements / modifications for the design of new reports
Working with guidance from architects to develop an improved ETL process using SSIS or Informatica,Partnering with business users to scope programming efforts and develop time estimates
Assessing potential limitations and risks associated with the solutions
Providing recommendations on the evolution of the architecture of the overall data warehouse and business intelligence platform/capability
Continual performance tuning, Capacity planning for future growth needsWork with Homesites development team to implement solutions
Ability to work both independently and in groupsCapacity to solve problems related to dataIntricacies of working with financial data
Works collaboratively across business units and IT to facilitate business requirements gathering for reportsAnalyze new and existing business processes utilizing metrics and analytics tools, and make suggestions for change
Evaluate and interpret end user information requirements, and develop and implement appropriate technical solutions

Qualifications:

7+ years of relevant experience in reporting/analytical design and information architecture using Microsoft BI Stack (SSIS, SSAS, SSRS) or Informatica
Understanding of traditional DW/BI components (ETL, Staging, DW, ODS, Data Marts, BI Tools)Intermediate programming and computation skills, preferably with Perl, Python Java, BASH/Shell Scripting and/or C/C++Knowledge in complex environments building and deploying MPP Databases, Hadoop ecosystem, in-memory data grids, BI/DW, or equivalent enterprise scenariosRDBMS related product experience is strongly preferred (SQL Server, Oracle, Postgres,, etc.)
Working knowledge of Hive SQL or Spark and UNIX scripting or any interface that sits on Hadoop, Hadoop stack components, NOSQLMPP working knowledge such as EMC Greenplum, Paracel, TeradataETL Tools such as Informatica would be preferred.
Direct experience working on a large scale data warehouse or Hadoop platform is a very strong assetInsurance experience is preferred
Experience in user experience testing and analysisSQL programmer
Excellent organization skillsStrong verbal and written presentation skills
Energetic self starter who has the ability to work with minimal supervision

Latest Jobs

Oracle Cloud SCM Lead

Oracle Cloud SCM Lead

Location

Apply

Artificial Narrow AI

Artificial Narrow AI

Location

Apply

Artificial Narrow AI

Artificial Narrow AI

Location

Apply

Artificial Intelligence

Artificial Intelligence

Location

Apply

Artificial Intelligence

Artificial Intelligence

Location

Apply

PL/SQL Developer / Reports Dev...

PL/SQL Developer / Reports Dev...

Location

Apply

Featured Jobs

Data Scientist

Data Scientist

Location

Apply

Data Scientist Tech Lead

Data Scientist Tech Lead

Location

Apply

Oracle Manufacturing Consultan...

Oracle Manufacturing Consultan...

Location

Apply

Staff Data Scientist, Growth &...

Staff Data Scientist, Growth &...

Location

Apply

Java Lead Developer

Java Lead Developer

Location

Apply

Trending Jobs

Lead Azure Data Engineer

Lead Azure Data Engineer

Location

Apply

Team Lead

Team Lead

Location

Apply

Head of Engineering Operations...

Head of Engineering Operations...

Location

Apply

Data Analyst

Data Analyst

Location

Apply

Artificial Intelligence

Artificial Intelligence

Location

Apply

View All Jobs In This Company

Email Now

Send your resume at support@kloudhire.com