IT Data Engineer

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 Every day, a day to do right. Showing up for people isn’t just what we do. It’s who we are – and have been for more than 200 years. We’re devoted to finding innovative ways to serve our customers, communities and employees—continually asking ourselves what more we can do. Is our policy language as simple and inclusive as it can be? Can we better help businesses navigate our ever-changing world? What else can we do to destigmatize mental health in the workplace? Can we make our communities more equitable? That we can rise to the challenge of these questions is due in no small part to our company values that our employees have shaped and defined. And while how we contribute looks different for each of us, it’s these values that drive all of us to do more and to do better every day. About Us Our Culture What It’s Like to Work Here Perks & Benefits Legal Notice Accessibility Statement Producer Compensation EEO Privacy Policy California Privacy Policy Your California Privacy Choices International Privacy Policy Canadian Privacy Policy Unincorporated Areas of LA County, CA (Applicant Information) MA Applicant Notice Hartford India Prospective Personnel Privacy Notice Apply tot his job