- Design, develop and maintain relational and dimensional databases supporting the data warehouse and data marts
- Create entity relationship diagrams, data dictionaries and mapping documents
-Utilize advanced transact-SQL, including stored procedures, ETL and OLAP tools to implement solutions
- Support implemented solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
- Perform code inspections and re-factor code to meet standards
- Participate in data model reviews, walkthroughs, application and module performance analysis
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
HR@insightglobal.com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
- Advanced SQL development experience and designing complex SQL queries/business components
- Experience with PowerShell as a scripting language and C# as a programming language
- Ability to perform routine DBA including setting up access policy, data migrations, ETL operations, troubleshooting, and performance optimization
- Experience performing QA processes and analyzing data, act as a BA if needed
Financial/mortgage experience is a plus
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.