The BI Engineer will gather business requirements, write SQL queries, build and validate Power BI dashboards, and ensure data integrity across analytics functions.
LightEdge is seeking a skilled BI Engineer to support data & analytic functions enterprise-wide. This individual will deliver end-to-end data solutions that includes: gathering business requirements for reporting dashboards, perform data analysis, write SQL queries, ensure data integrity and build dashboards. They will partner closely with stakeholders to build high quality solutions that unlock insights from the data and drives business efficiencies. They will be seen as a data subject matter expert, providing consultation to others on best practices.
Responsibilities
- Gather and document business requirements for reporting and analytics requests
- Write SQL queries applying complex joins and business logic to accurately pull data needed for reporting and analytics
- Administer Power BI cloud instance: provide appropriate access to users, train new users, publish and maintain certified data sources
- Build Power BI dashboards by connecting Snowflake data and creating actionable visuals
- Validate, analyze and document new datasources
- Help establish and follow proper data governance, compliance and security practices
- Partner with stakeholders to translate business needs into actionable data insights using Snowflake and Power BI
- Train and mentor less experienced team members
- Collaborate with data engineers to ensure data in Snowflake is correct and supports reporting needs
Education and Experience
- 5+ years of experience in data/analytics roles including writing SQL and building dashboards
- Proficient with python or other coding software
- Experience with a cloud data warehouse (Snowflake, Redshift, Databricks, etc.)
- Proven ability to work with stakeholders to turn business needs into actionable data insights
- Intermediate skills in writing SQL
- Skilled in building dashboards (Tableau, Power BI, Domo, etc.)
- Strong business acumen and communication skills
- Experience with data quality and validation practices
- Basic understanding of Data Governance
- Desire and ability to leverage AI responsibly in order to unlock efficiencies
- Ability to work in a fast-paced environment with an entrepreneurial mindset
Top Skills
Power BI
Python
Snowflake
SQL
LightEdge Solutions Austin, Texas, USA Office
2916 Montopolis Drive, Austin, TX, United States, 78741
Similar Jobs
Legal Tech
The Power BI Developer will analyze data, create dashboards and reports, and provide insights to support business decisions at Witherite Law Group.
Top Skills:
DaxExcelPower AutomatePower BIPower QueryPythonSQL
Healthtech • Insurance
The BI Engineer will design and develop data integrations for Enterprise BI Data Marts, working on data architecture, analytics solutions, and collaborating with stakeholders to enable insights.
Top Skills:
AdfAdlsAzureAzure SqlAzure SynapseDatabricksDevOpsHadoopHdfsHiveHqlMpp Platforms (Teradata)Power BIPysparkRdbmsScalaSparkSQLSqoop
Information Technology
The BI Developer designs, develops, and maintains BI infrastructure, creating reports and dashboards to support business decisions, while collaborating with finance and IT departments.
Top Skills:
Azure Data FactoryAzure Data WarehouseCognosData BricksMdxPl/SqlPower BISsasSsisSsrsTableauTsql
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
