BI Engineer
Overhaul
full-time
Posted on:
Location Type: Office
Location: Austin • Texas • United States
Visit company websiteExplore more
About the role
- Ongoing support and maintenance of existing Power BI dashboards, ad hoc analyses and data extracts
- Collate data from various source systems and databases, cleanse, transform and prepare data for Power BI reporting and ad hoc analysis
- Build dashboards and ad hoc reports to synthesize and aggregate data across multiple sources for internal and external stakeholders
- Interpret data, and analyze results using statistical techniques
- Creation of clear written and visual artifacts to drive decision making
- Reinforce a high level of governance alignment with general client's guidelines across all data deliverability
- Ensure safety and accuracy of information across all data solutions delivered by the team
- Prepare and maintain BI reporting and analysis documentations
- Work closely with the other areas of the Business (such as IT and Data & Analytics) on design and implementation to ensure business requirements are being met accurately and in a scalable matter and communicated to the business at large
Requirements
- Extensive experience with reporting using Power BI and similar tool sets
- Design and develop database objects, tables, stored procedures, views and triggers
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
- Design and develop ETL processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
- In-depth knowledge of standard concepts, practices and procedures related to database management
- Proven analytical problem solving and debugging skills
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
- Design and develop enterprise and departmental business intelligence and data warehousing solutions
- Performs ad-hoc analysis using SQL query language within the database systems using a process-oriented approach
- Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake
Benefits
- Competitive starting base salary
- Progressive advancement opportunity and career mobility
- Top employee health and well- being benefits
- Rotating company ‘Perks at work’ program
- Employee Assistance Program
- Care giver/adoption/family leave
- Flexible Time Off Policy
- Flexible working
- Free parking
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Power BISQLETL processesdatabase managementdata warehousingdata analysisstatistical techniquesdata cleansingdata transformationad-hoc reporting
Soft Skills
analytical problem solvingcommunicationcollaborationattention to detailgovernance alignmentdecision makingtroubleshootingindependencescalabilitydocumentation