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
    Featured Jobs
    Trending Jobs
    Share Job: