Business Intelligence Developer

Career Opportunities with Capitol Services

Current job opportunities are posted here as they become available.

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.

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.

• 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

• You are eligible to work in the U.S. without sponsorship and reside in Austin, TX. C2C will not be considered.
• 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.
• 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.
• You have excellent organizational and time management…