Job Description

Porch's mission is to partner with home service companies and together, delight homeowners from moving to improving and everything in between.  We provide software and services to more than 11,000 home services companies including home inspectors, moving companies, utility companies, and more. Through these relationships and our multiple brands, Porch provides a moving concierge service to homebuyers, helping them save time and make better decisions on critical services. These include insurance, moving, security, TV/internet, and ongoing home maintenance, repair, and improvement projects post-move.

As a leading marketing provider of customer acquisition solutions, V12 combines rich data assets with robust technology to provide brands with end-to-end customer acquisition and retention solutions to achieve maximum ROI. Our data and technology platform links customer records with our proprietary blend of online, offline and digital marketing data for highly personalized, one-to-one consumer marketing, regardless of device or channel. Learn more at www.v12data.com.

Sitting within the Analyst team here at V12, you will be in a hands-on role as the primary source for the initial process design and implementation of V12 core data management applications. You will be responsible for providing a range of services throughout the full customer lifecycle, from technical pre-sales support through implementation and post deployment production support, at all times ensuring that clients' requirements are understood, and technical solutions are mapped against these requirements with a clearly stated ROI for the customer; you will be required to be innovative in showing the client how our suite of applications can be configured to meet their business objectives.

WHAT YOU WILL DO

• Work with MS SQL Server for SQL report, query, and stored procedure development, as well as for SQL data analysis, manipulation, and optimization
• Automate, optimize, and maintain ETL processes in scalable fashion
• Assist with architecture and design of data warehouse and data integration platforms
• Work with analytics, engineering, and business teams to define and build marts and tables to optimize reporting performance
• Assist with database health monitoring and performance optimization and quickly respond to reported data issues
• Import, evaluate and document client data to be utilized to attain stated objectives.
• Using V12 product offerings, develop/implement processes to transform source data into value-added solutions that meet our client's Solution objectives
• Includes data transformation, development of identity based business rules (i.e. matching, householding, etc), exception processing, designated output parameters, derived calculations, and custom reports.
• Develop a workflow using a combination of proprietary & non-proprietary tools. Produce the desired process output, unit test output through the production of sample extracts, processing counts, summary totals and other QC techniques in accordance with established standards.
• Support clients using V12 product suite through software support, process consulting and evaluation.
• Identify, develop, and recognize new opportunities for expanding each Customer's V12 adoption and ensure ongoing adoption of the V12 platform by each customer
• Collaborate effectively with the Sales organization to close incremental revenue and secure long-term renewals

WHAT YOU BRING

• Experience with MS SQL Server (minimum 5 years)
• Experience with T-SQL (minimum 2 years)
• Experience using SQL database tools and resources across multiple environments
• Experience in the development and management of ETL processes and data integration pipelines using tools such as SSIS, etc. a plus
• Experience in scripting languages such as Python, Unix/Windows Shell, etc. a plus
• Data modeling for data intensive application from star schema, dimensional modelling, and data lake architectures a plus
• Ability to work independently and to collaborate effectively across functions as part of a team in a matrixed environment.
• Highly analytical with excellent critical thinking ability learning in a fast-paced environment.
• Brings professionalism, positive energy and enthusiasm to the team. Genuinely enjoys working with clients on complex business problems and creatively solving for those using a varied technology stack.  Has a heart of service to their team and their assigned client portfolio.
• Strong work ethic and high personal standard of quality. Can self-govern.
• Goal oriented, flexible thinker. Embraces change as an opportunity for improvement.  Not satisfied with status quo.

ABOUT PORCH

Launched September 2013, as an online home improvement network connecting homeowners with qualified professionals, Porch has grown into the industry-leading partner for the home. Porch provides software and services to more than 8000 companies across verticals such as home inspection, moving companies, and others associated with the real estate transaction. Through these relationships, Porch helps make moving less stressful for approximately 1/3 of all US homebuyers each month through a variety of services such as insurance, moving, TV/internet, and home automation and security. When homeowners are moved in, Porch helps make maintenance easy with more than 160 different home services offerings through Porch.com. Focused on assisting customers at every stage of the "home journey" – including moving in, installations, assembly, repairs and ongoing maintenance – last year alone, the company facilitated over 2 million home-related projects, generating over $2 billion in revenue for small business owners.