SQL Database Developer Analyst

Profile

Position Summary
The SQL Database Developer Analyst role is responsible for analyzing defined business requirements, constructing the functional design, writing the code, and testing to ensure the finalized solution meets those business requirements. The SQL Database Developer Analyst is also responsible for maintaining, supporting, and upgrading the existing data warehouse and other reporting data repositories. This individual will apply proven communication skills, problem-solving skills, and knowledge of best practices to guide development on issues related to the design, development, and deployment of mission-critical reporting data repositories.
The position will report to the Assistant VP of Database Development and Data Architecture.
Primary Responsibilities
Design, code, test, and deploy advanced database solutions using T-SQL and SQL Server Integration Services (SSIS).
Provides development and analytical support for the data warehouse using SQL Server databases and Integration Services (SSIS) packages.
Identify root causes impacting query performance and provide corrective measures.
Experience using version management such as TFS/Git/GitHub/Azure DevOps with an agile methodology.
Mentor and review work of other database developers.
Qualifications
Required Qualifications
3 years of experience of software development, data engineering, business intelligence, or related field with track record of manipulating, integrating, processing large data from various data sources such as csv, xml, json, and other major database systems.
3 years of strong Transact-SQL (TSQL) including writing common-table expressions (CTE), dynamic SQL, windows functions, or cross joins.
Experience in designing, building, and supporting data warehouses
Working knowledge of Kimball and Inmon data warehousing design patterns and principles
Excellent understanding of MS SQL Server including creating databases, tables, stored procedures, views, functions, indexes, and joins.
Preferred Qualifications
Associate or Bachelor degree in computer science/information systems
Knowledge of in-memory OLTP and columnstore indexes.
Experience with Azure cloud services is a plus.
Knowledge creating cubes and tabular models in SQL Server Analysis Services (SSAS).
Ability to design entity relationship models and system flowcharts.
Personal Attributes
Excellent communication and organizational skills
Ability to work independently
RoundPoint’s Employee Value Proposition:
Grow. Make a difference. Have fun along the way.
Our mission is to serve our homeowners and all of their homeownership needs. We do this by embracing challenges, executing with excellence, and fostering a positive work culture that encourages personal and professional growth. We are on the fast track to becoming the premier marketplace for all things home, and the National Mortgage News and Best Companies Group just named us one of 2019's Best Mortgage Companies to Work For! Without a doubt, RoundPointers are what make this company a great place to work! That’s why we hire individuals who share our core values: Energy, Ethics, Execution, Everyone, and Earn it!
As a RoundPointer, we will empower you to innovate, provide meaningful solutions, set goals and crush them, play hard, and give back to the community! Our secret sauce is our mantra, All In. All Win. Together, we can achieve great things!
Physical Demands & Working Conditions
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job:
The employee is regularly required to talk or hear.
The employee is required to sit for extended periods of time and is occasionally required to stand and walk.
The employee must regularly use hands to finger, handle, or feel objects and is regularly required to reach with hands and arms; the employee may occasionally climb or balance, and stoop, kneel, crouch, or crawl.
The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus.
The noise level in the work environment is usually quiet to moderate, and no extreme conditions are present.

Company info

Sign Up Now - MiamiCrossing.com