DKKD Staffing is seeking a Senior Business Intelligence Developer in Westlake Village, CA, to design and implement data solutions using SQL Server, SSIS, and Power BI. The role requires strong communication skills and a commitment to quality assurance.
Direct message the job poster from DKKD Staffing CEO/CHO/CPO DKKD Staffing - Executive & Technology Staffing (building IT/HR teams) REQUIRED CITIZENSHIP: US Citizen or Permanent/ Legal Resident Green Card - Client cannot accept EAD, H1, etc. Looking for upbeat, positive people who are great communicators. TITLE: BI Developer LOCATION: Westlake Village, CA 91361 HYBRID: 1-2 days weekly SALARY RANGE: $150K> (with 10% bonus) # of EMPLOYEES IN COMPANY: TECHNOLOGY: Power BI, SSRS, Microsoft SQL, SSIS, ETL, PL/SQL, T-SQL, TFS, Git, SVN WHY THE NEED: Company growing REQUIRED CITIZENSHIP: US Citizen or Permanent/ Legal Resident Green Card Please send answers to both sets of questions to Di@DKKDstaffing.com and cc DawnWilson@DKKDstaffing.com Part 1 APPLICATION QUESTIONS Legal Name & Preferred Name or Nickname: Best Contact Info (Cell & email): Your Linked In: Why looking for a new job: Availability for interviews and a new job: Where do you live (City, State, Zip): Desired geographical work location: Are you open to 100% onsite, hybrid and/or remote: Are you open to relocation if required: Are you open to travel if needed and have an active passport if needed: Are you authorized to work in US (Please indicate US, Green Card or Other): Hourly/Salary Expectations: (We need a range) $ Sizes of staff managed and their titles (include # of direct reports): Budgetary Responsibility: $ Education/Certs/Degrees (also indicate which certs are active): Who Referred You/ How Did You Hear About Job/ DKKD Staffing: PART 2 Q&A - WHEN APPLYING PLEASE SUPPLY the ANSWERS to THESE QUESTIONS AS WELL (Years of total experience, last year used and any examples of work that will showcase capabilities) 5+ years of SQL experience working with Microsoft SQL Server in a data warehousing, data mart or equivalent environment: ( e.g., 5 years | 2024) Tell us about your experience designing and working with SQL Server in a data warehouse environment. How have you approached schema design, performance tuning, and evolving solutions based on growing data or changing business needs? 5+ years of ETL experience using SSIS: ( e.g., 5 years | 2024) How have you used SSIS to manage end-to-end ETL pipelines? Describe how you handle incremental loads, transform raw mortgage data for analytics, and implement error logging or data validation. Experience using database programming languages (PL/SQL, T-SQL): ( e.g., 5 years | 2024) Give a real-world example of a complex stored procedure you’ve written (in either PL/SQL or T-SQL). What challenge did it solve, and how did you ensure it scaled well with growing data? Source code control tool experience (TFS, Git, SVN, etc.): ( e.g., 5 years | 2024) What’s your experience using Git, TFS, or SVN in a BI environment? How do you manage version control for SSIS packages, SQL scripts, or Power BI reports in a collaborative development process? Data modeling and database design experience: ( e.g., 5 years | 2024) How do you approach designing a data model for mortgage-related reporting (e.g., application pipeline, loan approvals)? What considerations drive your use of star vs. snowflake schema, surrogate keys, and normalization? Report and dashboard creation (e.g. using SSRS or Power BI): ( e.g., 5 years | 2024)Power BI Dashboard Development: Describe your full development process when building a Power BI dashboard from scratch—data prep, modeling, DAX, visualization, and user testing. What makes a Power BI report ‘executive-ready’ in your view? Report Design in Power BI vs. SSRS: In which scenarios have you preferred Power BI over SSRS (or vice versa)? For example, how would you handle monthly loan statements versus interactive dashboards for internal teams? Performance Optimization: ( e.g., 5 years | 2024) What tools or techniques do you use to troubleshoot and optimize performance in Power BI and SQL Server reporting environments—especially with large mortgage or financial datasets? JOB DESCRIPTION Senior Business Intelligence Developer Our client primarily originates and manages investor loans secured by 1–4-unit residential rental and small commercial properties. We are seeking to hire a full-time Senior Business Intelligence Developer. The ideal candidate will have a track record of delivering successful technical implementations and performing data analysis, combined with excellent customer service skills. be responsible for working on multiple databases, ETL, reporting, and analysis projects, using SQL Server, SSIS, SSRS, and Power BI. have knowledge of, and experience with, best practices related to object oriented and procedural programming languages, data modeling and database design, QA and testing, and process design. experience with and demonstrated use of industry standard development tools such as Visual Studio, source code control (.git or TFS), SQL Server Management Studio, and similar tools. further contribute to executing and developing the company’s data environment and lifecycle processes, including tasks such as effort estimation, prioritization, requirements documentation, testing, deployment and post-implementation support. Important additional attributes include: attention to detail, a commitment to quality assurance and testing, and an ability to meet deadlines and effectively translate customer needs into technical solutions. Duties and Responsibilities Designing, developing, and testing ETL jobs, SSRS reports, Power BI dashboards, and SQL Server objects such as Functions and Stored Procedures. Using common testing patterns and best practices to ensure that data processes are robustly developed and adhere to business requirements Monitoring process and database performance and optimizing customize database queries, as necessary Participating in requirements gathering, testing, and post-deployment support activities with technical and non-technical team members Providing data analysis and support, including but not limited to resolving reported data anomalies and assisting business staff Required Skills and Experience 5+ years of SQL experience working with Microsoft SQL Server in a data warehousing, data mart or equivalent environment 5+ years of ETL experience using SSIS Experience using database programming languages (PL/SQL, T-SQL) Data modeling and database design experience preferred Report and dashboard creation (e.g. using SSRS or Power BI) preferred Strong written, verbal, and graphical communications skills with the ability to express complex technical concepts effectively Ability to work well with people from different disciplines with varying degrees of technical experience Education Requirements Bachelor’s Degree with a specialization in MIS, Computer Science, Mathematics or Statistics (or equivalent experience) Benefits become effective on the first day of the month following 30 days of employment and include: 401(k) with 3% matching contribution Employee Stock Purchasing Program Health insurance Life insurance Paid time off Paid Holidays Pet Insurance Vision insurance Join us on Linked In: www.LinkedIn.com/in/DianeKrehbiel More jobs on: www.DKKDstaffing.com Seniority level Seniority level Mid-Senior level Employment type Employment type Full-time Job function Job function Information Technology Industries Technology, Information and Media and Real Estate Referrals increase your chances of interviewing at DKKD Staffing by 2x Get notified about new Business Intelligence Developer jobs in Westlake Village, CA . Don't see a job that matches your experience? Submit your resume here! Santa Monica, CA $109,400.00-$146,700.00 3 weeks ago Chatsworth, CA $98,000.00-$120,000.00 3 days ago Santa Monica, CA $114,900.00-$154,100.00 3 weeks ago Software Development Engineer, Level 1 (Direct-to-Consumer Streaming) Santa Monica, CA $99,000.00-$110,000.00 2 days ago Santa Monica, CA $142,516.00-$199,870.00 2 months ago Santa Monica, CA $114,900.00-$161,300.00 1 week ago Santa Monica, CA $148,000.00-$167,500.00 2 weeks ago Santa Monica, CA $104,600.00-$146,800.00 2 days ago Santa Monica, CA $104,600.00-$153,500.00 3 weeks ago Santa Monica, CA $138,900.00-$203,900.00 1 month ago Software Development Engineer, Level 1 (Entry Level) Senior Full-Stack / React Software Engineer Santa Monica, CA $190,000.00-$190,000.00 1 week ago Full Stack Engineer / React, Nodejs, AI / Onsite in West LA Malibu, CA $145,745.00-$186,688.00 6 days ago Santa Monica, CA $152,200.00-$223,600.00 1 week ago Camarillo, CA $90,000.00-$130,000.00 2 weeks ago Westlake Village, CA $130,000.00-$160,000.00 2 weeks ago Full Stack Engineer - TypeScript, React, Node.js NO H-1B or C2C Software Development Engineer, Amazon Ads Santa Monica, CA $129,300.00-$223,600.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
DKKD Staffing is seeking a Senior Business Intelligence Developer in Westlake Village, CA, to design and implement data solutions using SQL Server, SSIS, and Power BI. The role requires strong communication skills and a commitment to quality assurance.