Summary Position Description:
We are looking for individuals that have a passion for developing databases and providing business insights to various departments across the company. As a Sr. SQL Developer in the Business Intelligence department, you will be responsible for building data marts, reports, and database functionalities that will drive operational processes and business decisions. The Sr. SQL Developer will work closely with stakeholders and subject matter experts to understand requirements, design data models, build data marts, and develop reports.
Critical skill set for this role will be Strong SQL, Data mart, Data modeling, Claims, RAF, HEDIS.
Interpret business requirements, design data models, design data models, build data marts, and develop SSRS and Power BI reports
Design, develop, and unit test new database code to support requirements, using database triggers, stored procedures, and views
Develop ad-hocreports and provide key insights to the business stakeholders
Work closely with business and IT stakeholders to define problems and design large-scale, enterprise class solutions
Translate highly complex concepts into data marts that can be understood by a variety of technical and non-technical audiences
Troubleshoot and resolve data gaps or design deficiencies as they appear
Review and analyze ongoing customer requests
Performs all other related duties as assigned
BS or MSdegree in Computer Sciences, Computer Engineering, Computer Information systems, or related field
5+ years of SQL Server development experience
3+ years of database design and development
Data warehouse and/or data mart design and development experience
Experience writing and tuning SQL queries for optimized performance in a large data volume environment
Experienceworking withHealthcare Payer and/or Managed Care data from a data profiling, analysis, and modeling perspective, with a solid understanding of the relevant Healthcare business processes.
Experience with Power BI is a plus
Excellent analytic and problem solving skills
Good organizational, interpersonal, and teamwork skills
Attention to detail
Good written and verbal communication skills