Work In Texas Jobs

Work In Texas

Job Information

Kforce SQL Server Developer in Georgetown, Texas

Kforce has a client in search of a SQL Server Developer with BI experience in Georgetown, Texas (TX).Summary:As part of the IT function, the Senior SQL Developer will be responsible for designing and developing systems for managing data, data analysis, reporting and building business intelligence reports. You will be interacting with stakeholders, both internally and externally at our IT vendors to develop and maintain systems used for managing data such as data warehouse, data stores and other business intelligence systems.Responsibilities:

  • Highly skilled writing SQL queries, DML and DDL, CDC/Change tracking patterns, indexes and performance tuning

  • Design and develop and modify/maintain ETL processes that load data for the data warehouse using ETL tools (transitioning from SSIS to Azure integration technologies) and SQL code

  • Provide performance and scale tuning in selected technology stacks for ETL, data querying, and information management platforms

  • Implement traditional data warehouse schema and star schema data models

  • Collaborate with analytic reporting team to design reports and reporting portals, supporting subscriptions, enabling advanced filtering for ad hoc querying, and performance tuning

  • Collaborate with and mentor analytics and business units on reporting and business process automation solutions

  • 7 years of experience in advanced Microsoft SQL Server is preferred

  • 5 years of BI experience, using integration tools such as SSIS and reporting suites such as SSRS, Power BI or other dashboard tools is a must

  • 5 years of advanced knowledge of MS Excel (Pivot tables, VLOOKUP's, VBA Macros)

  • 2 years of experience in Amazon Relational Database, and Microsoft Azure SQL Database

  • Hands-on expertise in designing and building Kimball-style Star schema database models is a plus

  • Extensive experience developing data-intensive solutions against an RDBMS, such as SQL Server. Highly skilled writing SQL queries, DML and DDL, indexes and performance tuning

  • Experience in SSRS, SSIS, SSAS and BI tools

  • Experience in Database Administration, Data Warehouse is preferred

  • Experience operating on in an Agile scrum environment is preferred

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.Compensation Type:Years