Job description

Job title: BI & Data Solution LeadFTE OpportunityLocation: Austin TX (onsite 2 days/week)Summary of ResponsibilitiesThe 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 ResponsibilitiesDevelop 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.EducationBachelor’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 & SkillsRequired3+ 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 support to 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.PreferredExperience using databases and data warehouses (e.g. SQL, Azure Synapse, Snowflake, AWS Redshift).Familiarity with ETL processesFamiliarity with API-based data integrations.Knowledge of data governance and security best practices.Job CompetenciesStrong 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 EmployerApex 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 employeeservices@apexsystems.com or 844-463-6178.

Requirements