LEAD SQL DEVELOPER /ARCHI

9 days ago
$55 - $65/hour (Estimated)Reston, VADAtec Solutions

SQL ARCHITECT

REMOTE POSITION

-Taking ownership of the development side of working with SQL Server.
-Take ownership of existing database code and schema, as well as trouble shooting and improving.
-Ensure production and development environments and maintenance.
-Responsible for all aspects of database design, development and deployment.
-Produce ER data models.
-Advise on enhancing data integrity and availability.
-Constantly improve the SQL Server environment, and processes.
-Manage Integrity, Index Tuning, and Production refresh of SQL Server databases.

  • Data Analytics:
  • Derive business insights from data analysis and dashboards built to measure effectiveness of care agent tool improvements vs. cost/satisfaction performance metrics.
  • Write complex SQL queries for data analysis.
  • Partner with team members and senior leadership to identify improvement opportunities for investigative analysis.
  • Identify additional source data systems for use in analytics.
  • Present findings and recommendations to the Senior Leadership Team.
  • Data Engineering:
  • Work with Complex SQL, Functions, and Stored Procedures to implement data ETL solutions from various sources within and outside Comcast.
  • Implement processes that ensure and continuously improve data integrity.
  • Be the technical subject matter expert who provides guidance and direction to fellow team members, including contracted/offshore resources.
  • Keep up-to-date with new technology within the data analytics/engineering discipline and identify cost and process-improving opportunities.
  • Design, implement, and maintain end-to-end cloud data warehouse solution, including data modeling and network security architectur
  • Work with vendors to conduct proof-of-concepts for new tools.
  • Work with data platform/experience teams and source system owners to implement cloud data streams.
  • Skills
  • Expertise using data visualization tools such as Tableau/QuickSight.
  • Expertise using ETL tools such as Pentaho/Databricks/Apache NiFi.
  • Expertise in coding in SQL and Python/Spark.
  • Experience with databases such as Netezza/SQL Server/Snowflake.
  • Experience with streaming data (AWS Kinesis and Kafka).
  • Familiarity with Amazon Web Services.
  • Familiarity in coding with Javascript, Linux Shell Scripting, Scala, Perl, or Powershell.
  • Familiarity with Big Data platforms (Hadoop, Hive).
  • Familiarity with predictive analytics/machine learning.

Job Types: Full-time, Contract

Job Types: Full-time, Contract