Data Engineer

• Will be responsible for Development and Testing of Data Integration Workflows (ETL Packages, Stored Procedures, UDF, Ad Hoc-Queries), Test Plans and Test Cases using Microsoft Technologies such as SSIS, SSAS and SQL Server Database, as well as company-wide Document Management.
• On a day to day the individual is expected to work closely with development team and the analyst team.
• This is an opportunity to join an IT team which maintains a broad portfolio of business-critical vendor and custom applications., * Responsible for ETL and Data PL/SQL coding and unit testing based on the design provided by the Enterprise Data Lead.
• May have responsibility for development of a part of a larger project or to develop a project more independently.
• Hand off back and forth with offshore developers in a collaborative fashion.
• Collaborate with business analysts, testers and business users to effectively prioritize development activities within resource constraints.
• Provide in-depth technical support for the assigned applications.
• Create relevant and up to date technical documentation of assigned applications.
• Able to learn new technology practices, platforms, and tools and keeps up to date with the latest technology trends.
• Provide appropriate training to users on the use of assigned applications.

Insurance, Risk Management, Testing, SQL Server Integration Services (SSIS), Database Extract Transform and Load (ETL), Test Case, SQL Server Analysis Services (SSAS), Stored Procedures, Microsoft SQL Server, Microsoft Product Family, * Undergraduate degree in Computer Science, Engineering, Software Engineering or Mathematics, or equivalent work experience.

• Minimum 5-8 years of experience with:
• Microsoft SSIS, SSAS and Relational Database technologies.
• Exposure to web services (SOAP, XML, etc.)
• SQL Server including T-SQL or PL/SQL.
• Data warehousing- Data Modeling, Data Profiling.
• Experience implementing coding best practices via code reviews and code inspection tools.
• Experience in implementing Code Version Control like GitHub, SourceAnywhere.
• Experience working with Property and Casualty Insurance Data or a company.
• Experience with dimensional modeling and data marts.
• Achievement-Oriented: Demonstrates persistence and perseverance in achieving concrete and tangible outcomes by taking action to get optimum results when encountering obstacles or resistance.
• Collaborative: Develops and maintains effective working relationships across functional and divisional lines by readily sharing information, knowledge, and resources.
• Detail-Oriented: Displays thoroughness and accuracy in quality communications and deliverables through the application of technical skills and industry/product knowledge.
• Service-Oriented: Conveys a genuine desire and ability to anticipate and meet customer needs and creates and nurtures mutually beneficial relationships within AEGIS and with AEGIS Members and brokers.
• Work Ethic: Takes ownership for one’s responsibilities by acting with integrity and holding oneself accountable to continuous improvement.
• Leadership (if applicable): Motivates employees to exercise their talents to the fullest and holds them accountable for their best efforts; provides support to develop potential skills for improved individual growth and trains and empowers subordinates effectively.

Salary: $125000-$150000/Year.

ECLARO’s client is a leading insurance company providing risk management services and products to the energy industry. Their vast experience throughout North America spans all sides of energy infrastructure. If you’re up to the challenge, then take a chance at this rewarding opportunity!