BI & Data Solution Lead

Job#: 2081513

Job Description:

• Job title: BI & Data Solution Lead
• FTE Opportunity
• Location: Austin TX (onsite 2 days/week)

Summary of Responsibilities

The BI & Data Solutions Lead is responsible for maintaining Texas RE's data warehouse to support business intelligence and predictive analytics initiatives. This role will participate in the selection of data warehousing and ETL solutions, ensuring a scalable and maintainable platform that meets the organization's needs.

The successful candidate will work closely with internal stakeholders to develop reporting and visualization capabilities using tools such as Microsoft Power BI, ensuring that Texas RE employees can effectively analyze and utilize data for decision-making. Additionally, they will provide guidance and training to business users on BI tools and data best practices.

This position reports to the Director, IT Infrastructure & Cyber & Physical Security.

Essential Job Responsibilities

• Develop and maintain business intelligence solutions using tools like Microsoft Power BI, providing dashboards, reports, and real-time analytics for internal and external stakeholders.
• Work with business units to identify key data sources and define data models for predictive analysis and strategic decision-making.
• Lead the activity and operations of the Texas RE data repository, integrating data from multiple sources.
• Evaluate and recommend ETL solutions, determining whether to build or buy components of the data pipeline.
• Establish processes to ensure data reliability, accuracy, and consistency across all sources.
• Document data management, transformation, and analysis best practices to support ongoing data initiatives.
• Participate and support Texas RE committees, ERO activities, and industry working groups/task forces.
• Provide training and guidance to employees on BI tool usage, with future training on SQL querying as needed.
• Collaborate with IT leadership and business units to align data strategy with organizational goals.
• Provide ongoing development and maintenance of data stores and/or warehouses to ensure scalability, security, and availability.
• Ensure that data security and governance practices align with Texas RE's security policies.
• Create and maintain technical documentation, including system configurations, data mappings, and training materials.
• Participate and support Texas RE committees, regional activities, and industry working groups/task forces.
• Perform other tasks and activities as assigned.

Education

• Bachelor's degree in Business, Computer Science, Data Science, Engineering, Statistics, or a related field.
• OR six (6) years of related work experience in addition to the minimum work experience requirement.

Experience & Skills
Required

• 3+ years of experience using Microsoft Power BI or an equivalent reporting/visualization tool.
• Strong analytical and problem-solving skills, with the ability to translate business needs into structured data solutions.
• Excellent written and verbal communication skills, with the ability to explain data concepts to non-technical stakeholders.
• Experience providing training and supportto employees on BI tools.
• Strong SQL skills for query, data extraction, transformation, and analysis.
• Experience working within a data warehouse or similar structured data environment.
• Experience working with ETL processes and data integration methodologies.
• Ability to assess, recommend, and implement BI and data warehouse solutions.

Preferred

• Experience using databases and data warehouses (e.g. SQL, Azure Synapse, Snowflake, AWS Redshift).
• Familiarity with ETL processes
• Familiarity with API-based data integrations.
• Knowledge of data governance and security best practices.

Job Competencies

• Strong communication skills to work with both technical and non-technical stakeholders.
• Ability to identify business opportunities through data analysis.
• High attention to detail and data accuracy.
• Self-motivated and proactive, capable of leading a data warehousing initiative in a small organization.
• Comfortable balancing strategic decision-making with hands-on implementation.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.