SQL Server DBA & BI Developer — SSRS, SSAS, T-SQL | U.S. Remote, Pacific Hours

Summary We are seeking a U.S.-based Microsoft SQL Server Administrator & BI Developer who can start promptly and work during Pacific Time business hours. You will partner with our Senior SQL Developer and business users to maintain a reliable SQL Server environment, develop stored procedures and SSRS reports, support SSAS, automate data imports and exports, and help users understand their data. We need someone who can manage database operations and also deliver accurate, practical solutions for the business. WHAT YOU WILL DO Administer SQL Jobs, SSRS, and SSAS, including permissions, monitoring, and scheduled jobs. Develop, test, and optimize T-SQL stored procedures, queries, views, and functions alongside our Senior SQL Developer. Build and maintain SSRS reports, parameters, subscriptions, deployments, and access controls. Support SSAS models/cubes, processing and refresh schedules, security, and troubleshooting. Automate data imports, exports, and transformations using SQL Server Agent, T-SQL, and suitable ETL tools such as SSIS. Add data validation, reconciliation, logging, failure alerts, and safe restart procedures to workflows. Investigate data discrepancies and performance issues; explain findings and recommended actions to business users. Document report definitions, scripts, data flows, and operating procedures, and maintain changes in source control. EXPERIENCE WE ARE LOOKING FOR Strong production SQL Server and T-SQL development experience. Proven SSRS report development and administration experience. Hands-on SSAS administration or support experience; specify Tabular, Multidimensional, or both. Experience with automated data workflows and error recovery. Strong troubleshooting, business communication, and documentation skills. U.S.-based and available during Pacific Time business hours. SSIS, PowerShell, Power BI, Git, data warehousing, DAX, MDX, and high availability/disaster recovery experience are helpful. Please identify the tools you have actually used in production. INITIAL DELIVERABLES We will agree on priorities with the selected contractor. Initial deliverables are expected to include: 1. Job training and documentation of the SQL environment through close interaction with the Sr SQL Developer. 2. Development of working relationship with internal stakeholders. 3. A working import/export improvement with validation, failure logging, and documented recovery steps. 4. A concise technical handoff covering the changes and ongoing support needs. Pay: $74,100.00 - $100,000.00 per year Benefits: Professional development assistance Shift availability: Day Shift (Required) Work Location: Remote

View the full posting and apply