Application Dev Analyst - 87ID6E

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future.   

         

Overview of the role: 

Hartford Funds is seeking a motivated Developer to join our IT Team and support our enterprise data warehouse. This position focuses on both data management and development, using low-code ETL tools (such as Talend), SQL, and Python for data ingestion and visualization. The ideal candidate will develop effective solutions, while effectively communicating and collaborating with Business Analysts, Project Managers, and the Business Intelligence Team.

Responsibilities of the role:

• Conduct data profiling, source-target mappings, (low-code) ETL and/or Python development, SQL tunings and optimization, testing and implementation
• Provide business and technical analysis for initiatives focusing on Data Warehouse and Business Intelligence solutions
• Influence and provide input on data warehouse design with experienced-based recommendations for optimal structuring of data to support efficient processing
• Develop detailed technical specifications and ETL documentation in collaboration with Data Warehouse Architect and Business Intelligence Developers

Requirements:

• Bachelor's degree in computer science, information technology or another computer-based discipline
• 3 years’ experience developing solutions with a heavy focus on data and data movement
• Advanced Python skills required
• Databases: Strong experience with SQL-based databases (Snowflake is a plus) required
• Platforms: Microsoft / Linux required
• SQL: Expertise and fluency in SQL language required
• Integration Patterns: experience with various integration patterns (e.g., Flat Files, Web Services, etc.) required
• Knowledge of fundamental data modeling concepts (e.g., ER Diagrams, normalization, etc.) required
• Experience working with low-code tools (such as ETL platforms)
• Knowledge of fundamental data modeling concepts (e.g., ER Diagrams, normalization, etc.) is required
• Knowledge of data warehousing techniques (dimensional modeling / star schema, etc.) is required
• Experience writing technical documentation is required
• .Net / C# preferred

• Snowflake / Talend preferred
• Cloud platform experience (AWS/Azure) preferred
• XML/XSLT experience is a plus

• Must be comfortable/excited working in a fast-paced, high impact environment 
• Excellent troubleshooting and problem-solving skills; able to root cause and debug complex code in and efficient manner/with appropriate urgency
• Ability to obtain a good understanding of the business context of a problem to ensure the solution is optimal in solving the business need

Compensation

The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford’s total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is:

$85,000 - $110,000

Equal Opportunity Employer/Sex/Race/Color/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us | Our Culture | What It’s Like to Work Here | Perks & Benefits