IT Developer – Data Management

The Hartford • Wayne, PA

113d • $85,000 - $110,000

About The Position

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.

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
• Strong experience with SQL-based databases (Snowflake is a plus) required
• Expertise and fluency in SQL language required
• 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 data warehousing techniques (dimensional modeling / star schema, etc.) is required
• Experience writing technical documentation is required

Nice To Haves

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

Responsibilities

• 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

Benefits

• 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.

What This Job Offers

• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees