Data Warehouse Developer

Role description Data Warehouse Developer The Role UST is seeking a Data Warehouse Developer to design, maintain, and enhance the organization’s data warehouse, ETL processes, and reporting solutions. The role develops SQL-based data integrations, creates and modifies SSRS and Power BI reports, optimizes data flows, and works closely with business stakeholders to meet analytical and reporting needs. What You’ll Do Maintain and enhance the data warehouse environment, including merge scripts, loads, extracts, and transformations using SSMS, and ETL processes using SSIS. Develop, optimize, and troubleshoot ETL workflows to support reliable data ingestion and transformation. Perform root cause analysis and resolve issues related to data pipeline failures, data quality, and performance bottlenecks. Plan and implement future enhancements, upgrades, and optimizations for the data warehouse environment. Create, modify, and optimize SQL queries, stored procedures, functions, and scripts for data processing, analytics, and reporting. Use SSMS and Visual Studio for database development, debugging, and deployment. Leverage C# and .NET when needed for custom scripts, application logic, or integrations. Develop, maintain, and enhance SSRS reports, including creating and modifying RDLC files based on business needs. Build, update, and optimize reports and dashboards in Power BI and the SSRS Report Manager. Create and manage SSRS subscriptions to automatically deliver reports via email or shared folders on daily, weekly, or monthly schedules. Ensure reports meet business requirements while maintaining accuracy, usability, and performance. Work closely with business analysts, subject matter experts (SMEs), and management stakeholders across multiple departments to gather, clarify, and translate business requirements. Support ad hoc reporting needs by quickly developing or updating reports, queries, or datasets. Communicate technical concepts clearly to non-technical stakeholders. This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required. What You Need Required Bachelor’s degree in computer science, information systems, data engineering, or a related field. Strong proficiency with SQL, SSMS, SSIS, SSRS, and Visual Studio. Experience with data warehousing concepts, dimensional modeling, and ETL processes. Strong troubleshooting skills for data pipelines, report issues, and SQL performance tuning. Familiarity with C#, .NET, and scripting for automation or integrations. Preferred Experience with Power BI report and dashboard development. Knowledge of CI/CD pipelines, version control (Git), and deployment best practices. Understanding of database performance tuning and optimization. Strong analytical, problem-solving, and communication skills. Location & Compensation Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below. Role Location: [Insert role location] Compensation Range: $62,000 - $93,000 Who We Are Since 1999, UST has worked side by side with the world’s best companies to make a powerful impact through transformation. Headquartered in the United States, UST is powered by technology, driven by AI, inspired by people, and led by our purpose, we partner with our clients from design to operation. Our AI-driven digital solutions, proprietary platforms, engineering, R&D, products, and innovation ecosystem turn core challenges into impactful, disruptive business outcomes. With deep industry knowledge and a future-ready mindset, we infuse expertise, innovation, and agility into our clients’ organizations—delivering measurable value and positive lasting change for them, their cu…

View the full posting and apply