Job DescriptionThe ideal Business Intelligence Engineer (BIE) candidate possesses foundational knowledge spanning data engineering, science, and business analysis. The BIE specializes in data lineage: including the technical systems by which data is generated, how metrics are aggregated, and the extraction and intuitive visualization of deep insights from data.
The candidate must be conversant in both technical and business language, as problems may be loosely defined or structured. Strong communication skills are essential, with equal ability to work with software development engineers and business owners. The role requires functioning with a high level of autonomy, solving challenging problems, and identifying paths to overcome roadblocks.
The BIE gathers product requirements from stakeholders and iterates on feedback from internal end-users. The BIE reverse-engineers existing processes and products to support cross-platform migration efforts.
The position requires a passion for automation and clean, streamlined process design, drawing upon advanced analytical, critical thinking, and problem-solving skills, along with software development experience and an aptitude for creating maintainable, highly reliable, distributed systems.
RequirementsKey Job Responsibilities - Ownthe design, development, and maintenance of datasets, reports, analyses,and dashboards to drive key business decisions
- Performdata extraction, manipulation, and production from database tables
- Design,implement, and validate complex logic using queries
- Automateand improve data pipelines, analytical and reporting processes
- Improvecode quality, legibility, and optimize BI processes (speed, cost,reliability, etc.)
- Translatecomplex or ambiguous business problem statements into analysisrequirements
- Respondto ad-hoc data query requests to deep dive into unusual patterns andconduct exploratory data analysis, providing insights and recommendations
- Communicateideas effectively with customers, stakeholders, and peer teams, bothverbally and in writing
- Discoverthe business intent of stakeholders, estimate and communicate feasibility,and create roadmaps for solutions
- Balancecustomer requirements with technology requirements, understanding systemlimitations, scaling factors, boundary conditions, and reasons fortechnical decisions
- Establishworking knowledge of business context to recommend BI alternatives andanticipate future requests
- Considerlegacy of created processes, limiting the use of short-term workarounds
- Identifyrisks and bring them to the attention of team and stakeholders withmitigation plans before they become roadblocks
- Stayabreast of changes to underlying data sources and dependent internalengineering teams to minimize outages and downtime of owned systems
- Reportkey insight trends, using statistical methods (e.g., regression) toaddress complex business problems while understanding these methods'assumptions and limitations
Basic Qualifications• 2+ years experience with SQL, including data mining, ETL, and using databases in a business environment with large-scale, complex datasets
• 2+ years experience with data visualization using QuickSight, Tableau, PowerBI, or similar tools (QuickSight preferred)
• Proficiency with Microsoft Excel and/or Smart sheet
• Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, or equivalent quantitative field
Preferred Qualifications• Expert level Microsoft Excel skills (complex formulas, PivotTables, Macros, Visual Basic/C#)
• Proficiency with Smart sheet Premium Features (DataTable, Dynamic View, Data Shuttle, Salesforce Connector, etc.)
• Experience with CRMs (Salesforce preferred - SOQL/Lightning report opportunities)
• Experience with scripting languages for data processing and modeling (e.g., Python)
• Experience with statistical analysis packages such as R, SAS, or Matlab
• Experience analyzing and interpreting data using Redshift, Oracle, NoSQL etc.
• Experience in construction or engineering industries
• Experience in technical documentation, including maintaining SOPs, learning & training documentation, user best-practice guides, and PR/FAQs
• Experience with Geo-spatial analytics and software (e.g., ArcGIS)