Business Intelligence Developer

Capitol Services is currently seeking a Business Intelligence Developer to join our growing team!

Capitol Services was founded in 1978 and has become a leading provider of services to legal and financial professionals nationwide. Our mission is to provide friendly, high-value, and superior service to our clients amid a collaborative atmosphere that encourages a balanced work-life experience for our employees.

Named one of the "Best Places to Work" by the Austin American-Statesman, we know that it takes the right mix of passion, dedication, and fun to make a well-rounded workplace. Joining the Capitol Services team means working with a best-in-class, passionate team of professionals that truly cares about the work we do and the people we do it for. If that sounds like an environment you'd like to be a part of, we'd love to talk to you! Capitol Services is an equal opportunity employer.

About the role: You will be working in our Austin, TX location responsible for developing and maintaining Power BI reports and dashboards that provide key business insights. This role works closely with stakeholders across departments to gather reporting requirements and KPI definitions, design and build effective data visualizations, and ensure the accuracy and efficiency of data extraction and reporting processes, including the development of reusable semantic models. The BI Developer must have strong analytical skills, a solid understanding of databases, and expertise in BI tools to transform raw data into meaningful insights.

This role is a permanent position that involves working full-time and follows a hybrid schedule, Monday through Friday.

What you will do:

• Collaborate with stakeholders to define KPIs and ensure consistent metric definitions across reports and dashboards
• Design, develop, and maintain BI reports and dashboards using Power BI (primary visualization tool)
• Extract, clean, and transform data from various sources (databases, APIs, data warehouses) to prepare datasets for reporting
• Work with business units to understand their reporting needs and translate those into technical requirements for BI solutions
• Write and optimize SQL queries to retrieve and manipulate data from relational databases for reporting purposes
• Analyze and interpret complex datasets to identify trends, patterns, and opportunities for business growth and improvement
• Ensure BI reports and dashboards are optimized for performance, accuracy, and clarity. Identify opportunities for automation and efficiency
• Document data models, data sources, and report generation processes for internal knowledge sharing and future reference
• Conduct thorough testing and validation of BI reports and dashboards to ensure data accuracy and reliability before release
• Provide training to end-users on how to access, interpret, and use BI reports. Offer ongoing support for any BI-related issues or queries
• Create dimensional and relational data models using Power BI data modeling and SQL Server Management Studio, with Azure Data Factory used for data ingestion when applicable
• Implement and maintain Row-Level Security (RLS) and other data governance settings within Power BI

Who you are:

• Requirements: You are eligible to work in the U.S. without sponsorship and reside in Austin, TX. C2C will not be considered.
• Experience: You have a Bachelor’s degree in Business, Information Systems, Computer Science, or equivalent experience. You have 3+ years’ experience in business intelligence, analytics, or data-focused roles. You have strong proficiency in SQL Server (T-SQL) and hands-on experience with Power BI, including data modeling and DAX. You have experience working with data warehouses and centralized BI datasets. You have experience with Power Query (M) for data transformation. You have advanced Microsoft Excel skills for reporting and analytics.
• Preferred: You have worked in a results-driven environment. You have experience supporting finance, operations, sales, or executive reporting. You are certified in Power BI and SQL. You are familiar with SSRS.
• Excellent organizational and time management skills: You have the ability to organize, track, and prioritize a variety of projects and assignments under deadline. You have excellent attention to detail and exhibit a reasonable sense of urgency. You have the ability think analytically, using principles of research to synthesize information from various sources.
• Excellent communication skills: You have excellent verbal and written communication skills. You have strong ability to communicate data-driven insights to non-technical audiences. You communicate in both a professional and friendly manner with coworker and stakeholders.
• Adaptable: You can adapt to evolving business needs and changing priorities. You demonstrate resourcefulness and have the ability to self-motivate and proactively solve problems in complex and nuanced situations. You use research tools and databases with proficiency.
• Positive attitude: You demonstrate a positive customer service attitude. You are courteous and polite, especially when navigating through difficult conversations, problems, or complaints that may arise.
• Exceptional team player: You are able to work in both a team and independent setting within specified time constraints. You maintain a spirt of flexibility and adaptability with coworkers.
• Reliable: You are able to work during our regular business hours in our Austin location. You are a punctual individual and able to follow an assigned work schedule. You are able to maintain client confidentiality at all times.
• Office environment: You are able to remain in a stationary position 75% of the time and work on a computer for prolonged periods.

What we offer you:

• A competitive base salary
• 3 medical plans to choose from including a 100% employer-paid option for the employee
• 100% employer-paid dental and vision benefits for the employee
• 401(k) with scheduled employer contribution
• Employer-paid employee assistance program, as well as life and long-term disability insurance
• 4 weeks of paid time off annually, which begins accruing upon hire, and 10 paid holidays
• Encouraged work-life balance including a hybrid working model after 90 days onsite. Work from home equipment provided following successful training
• Access to building fitness center
• Office team events and learning development opportunities

Please apply with both your resume and cover letter if you think you would make a great addition to our team!

Want to get to know us better? Check out our website, X, and Facebook!

Applicants have rights under Federal Employment Laws. Please review your rights below:

Equal Employment Opportunity (EEO)

Employee Polygraph Protection Act (EPPA)

Family and Medical Leave Act (FMLA)

Please review our Privacy Policy for information on our practices regarding your personal information. Capitol Services participates in E-Verify.