Data Scientist

HKS   •  

Dallas, TX

Industry: Architecture & Construction


Less than 5 years

Posted 293 days ago

This job is no longer available.


HKS is a team of more than 1,400 architects, interior designers, urban designers, scientists, artists, anthropologists and other professionals working together across industries and across the globe to create places that delight, heal and stimulate peak performance. We have nurtured a culture of extraordinary people with curious and creative minds who are passionate about delivering elegant solutions that solve our clients’ challenges. Our research teams dig deep to discover processes and ideas that improve outcomes--then they share them freely for everyone’s benefit. In all we do, we are mindful of the fragility of all life and of the planet.


Our IT team in our Dallas office is seeking a Data Scientist to design and develop enterprise and department business intelligence, data warehousing, and reporting solutions.


  • Must be familiar with the following data warehousing concepts:
  • Data Warehouse vs Data Mart vs Operational Data Store
  • Relational vs dimensional modeling
  • 3rd normal form database normalization
  • OLTP vs OLAP
  • Star and Snowflake Schemas
  • Create automated and maintainable ETL processes to move data in and out of a data warehouse
  • Maintain database systems and data integrity/quality
  • Proficient with the Microsoft SQL Server Stack (SSMS, SSIS, SSRS, SSAS)
  • Experience with Power BI/Tableau or other data visualization tools
  • Familiar with object oriented programming concepts
  • Experience with Azure database management, C# /.NET development is a plus
  • Provide production support for key business functions
  • Promote and adhere to coding and version control standards
  • Collect and analyze data from disparate sources
  • Effectively communicate and understand business requirements
  • Self-manage tasks within the agile business methodology



  • Adhere to all HKS values, processes, policies, standards and procedures
  • Maintain a high level of customer service through good communication and interact effectively with all levels of management, technical and non-technical users
  • Rely on extensive experience and judgment to plan and accomplish goals
  • Be willing to perform a wide variety of technical tasks
  • Explain requirements and technical scenarios to non-technical people
  • Use problem solving and troubleshooting skills
  • Bring a positive, results oriented attitude to a team
  • Grow and foster individual and team learning


  • Bachelor’s degree from an accredited program or equivalent experiencerequired. Any higher-level degree is a plus
  • 3+ years of experience building/maintaining Transactional and Analytical database management systems
  • 3+ years of experience working with the Microsoft SQL Server stack
  • 3+ years of business intelligence experience
  • Prior experience in an Agile environment is a plus