The Division :
Market Leader , a subsidiary of Constellation Software Inc., is a pioneer in lead generation and contact management systems, and has been helping agents and teams manage, grow, and thrive since 1999.
Market Leader proudly serves over 200,000 agents and teams across the United States and Canada.
The Position :
Market Leader is looking for a motivated SQL Developer who will have strong architectural, coding and design skills, with broad experiences from which to draw.
You will have solved complex technical problems, and be able to lead the development of creative, efficient solutions in both broad collaborative and deep individual efforts.
The candidate is expected to help maintain current product features and address ongoing system issues that are prioritized by the Engineering Leadership, System Operations, Support, and Development team leads.
Ability to analyze, debug, and identify and fix root causes of ongoing issues will be critical to your success. You must be great at tracking down issues and bugs and coming up with the proper fix.
You are also expected to deliver features and designs on small- or mid-sized projects and estimate schedules for these projects.
Candidate must be able to recognize business needs and identify opportunities for optimization, reuse, cost reduction and overall system efficiency.
Our SDLC and toolset is agile and highly collaborative with industry leading practices such as wiki documentation, issue tracking system and distributed version control systems.
This position is great for developers who want to work in a commercial SAAS product development environment, and for someone who can get things done and loves to learn.
The selected candidate will work out of the Contour Software Karachi / Lahore resource center office, as an extension of the division-based R&D department.
Primary responsibilities include but not limited to :
Development of high-quality database solutions
Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
Research required data
Build appropriate and useful reporting deliverables
Analyze existing SQL queries for performance improvements
Suggest new queries
Develop procedures and scripts for data migration
Provide timely scheduled management reporting
Investigate exceptions with regard to asset movements
Required Qualifications & Skills :
University degree in Computer Science, Information Systems, or related discipline.
At least 3 years of proficient experience working with Microsoft SQL Server stored procedures, views, troubleshooting, etc.
A demonstrable track record of writing and optimizing SQL queries and stored procedures
Excellent understanding of T-SQL.
Ability to learn new skills quickly to make a measurable difference
Understanding of data models such as normalized, de-normalized, star schema, and snowflake
Ability to multi-task and thrive in a fast paced, rapidly changing, and complex environment
Possesses strong architectural, design, programming, and debugging experience. Must be a top-notch problem solver.
Strong experience in performance and integration testing of software products, with proven ability to analyze and present results.
Demonstrated ability to work effectively both within a team and cross-group to drive identification and resolution of issues to ship under tight deadlines.
Must be highly motivated with a strong passion for and commitment to software quality.
Ability to prioritize and manage work to meet critical project timelines in a fast-paced environment.
Excellent communication skills, ability to make and influence decisions, and drive open discussions to closure.
Must excel in both individual and group settings.
Demonstrated ability to work effectively on small cross functional teams.
Must be a great team player and collaborator.
Must be self-driven and demonstrate creative thinking capabilities.
Must have great communication skills with the ability to explain and write clear technical designs and ideas to peers, QA, and management team members.
Nice to have :
Understanding of data architecture principles, and how ETL flows affect the data architecture
Demonstrated knowledge of all phases of Software Development Lifecycle
Exciting Benefits we offer :
Medical Coverage Self & Dependents
Parents Medical Coverage
Employee Performance-based bonuses
Home Internet Subsidy
Profit Sharing Plan Tenured Employees Only
Child Care Facility
Company Provided Lunch / Dinner
Professional Development Budget
Recreational area for in-house games
Sporadic On-shore training opportunities
Friendly work environment