Data Engineer

Microsoft ETL
Full Time
Depends on Experience
Work from home not available Travel not required

Job Description

Are you interested in having a hand in updating and transforming the technical environment of a rock solid stable firm?  They take a highly personalized approach to serving the complex financial needs of individuals, families, business owners, private partnerships, nonprofits and community partners. 

Responsibilities

The Senior Software Engineer - Data is responsible for design, development and maintenance of our Data and Integration platforms.

  • Designing and developing architectures for intake, curation, organization, and dissemination of data in support of Data Engineering and Analytics projects.
  • Develop ETL applications to move/integrate data between operational systems and data warehouse/BI systems. Troubleshoot and resolve technical issues with these applications in the production environment. Perform production deployments.
  • Provides subject matter expertise in addressing projects and issues that encompass a wide range of internal and external systems (Core banking, Wealth, Data Warehousing), components, and processes
  • Work closely with business stakeholders and other engineering teams to research technical requirements and resolve issues
  • Ensure the quality, completeness, security, privacy, and integrity of data throughout the data lifecycle
  • Implement code changes, Conduct SQL Code Reviews and Maintain and improve existing database objects
  • Leverages industry best practices in ETL, data models, query optimizations & analytics; share same with team.
  • Develop, test, and maintain user-facing semantic layers, i.e. cubes, models. Provide production support and troubleshooting as needed

Qualifications

  • 7+years’ Application Development/Engineering experience across a diverse technology base. Demonstrated understanding and successful application of proven database design principles such as: requirements analysis, data normalization, data modeling, risk management and quality assurance and for both On-line Transaction Processing (OLTP) and On-line Analytical Processes (OLAP) database systems.
  • 5+years’ experience with Microsoft ETL and business intelligence technologies including but not limited to SQL Server database, SSIS SSRS and SSAS
  • Strong direct Data Modeling experience using Relational, Dimensional and other approaches related to NoSQL databases.
  • 7+years’ experience with relational databases (SQL server, Oracle), star schemas, exposure to NoSQL database technologies, Big Data Platforms like Hadoop or Cloud services like HDInsight
  • Experience with Azure and/or AWS and Tableau is a plus
  • Financial Services experience is a plus

Posted By

Anne Guyotte

50 Federal Street Boston, MA, 02110

Contact
Dice Id : 10514640
Position Id : 1905-1234
Have a Job? Post it

Similar Positions

Data Engineer
  • CyberCoders
  • Cambridge, MA
Sr. Data Engineer
  • CEI Group
  • Framingham, MA
Lead Data Engineer
  • Gardner Resources Consulting, LLC
  • Boston, MA
Senior Data Analyst
  • Certec Consulting Inc
  • Boston, MA
Data Engineer, Optum Life Science - Boston, MA
  • UnitedHealth Group
  • Boston, MA
Data Engineer
  • Robert Half Technology
  • Boston, MA
Data Modeler (Analytical Systems)
  • Mass Mutual Financial Group
  • Boston, MA
Data Engineer
  • Putnam Investments
  • Boston, MA
Sr. Big Data Architect
  • CGI
  • Burlington, MA
Data Architect
  • The Ceres Group
  • Boston, MA
Data Solutions Architect/Manager
  • HireTalent, LLC
  • Boston, MA