Role : Business Intelligence Engineer
Loaction : Exton, PA
The 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.
Requirements
Key Job Responsibilities
- Own the design, development, and maintenance of datasets, reports, analyses, and dashboards to drive key business decisions
- Perform data extraction, manipulation, and production from database tables
- Design, implement, and validate complex logic using queries
- Automate and improve data pipelines, analytical and reporting processes
- Improve code quality, legibility, and optimize BI processes (speed, cost, reliability, etc.)
- Translate complex or ambiguous business problem statements into analysis requirements
- Respond to ad-hoc data query requests to deep dive into unusual patterns and conduct exploratory data analysis, providing insights and recommendations
- Communicate ideas effectively with customers, stakeholders, and peer teams, both verbally and in writing
- Discover the business intent of stakeholders, estimate and communicate feasibility, and create roadmaps for solutions
- Balance customer requirements with technology requirements, understanding system limitations, scaling factors, boundary conditions, and reasons for technical decisions
- Establish working knowledge of business context to recommend BI alternatives and anticipate future requests
- Consider legacy of created processes, limiting the use of short-term workarounds
- Identify risks and bring them to the attention of team and stakeholders with mitigation plans before they become roadblocks
- Stay abreast of changes to underlying data sources and dependent internal engineering teams to minimize outages and downtime of owned systems
- Report key insight trends, using statistical methods (e.g., regression) to address complex business problems while understanding these methods' assumptions and limitations
Basic Qualifications
· 8+ years experience with SQL, including data mining, ETL, and using databases in a business environment with large-scale, complex datasets
· 8+ years experience with data visualization using QuickSight, Tableau, PowerBI, or similar tools (QuickSight preferred)
· Proficiency with Microsoft Excel and/or Smartsheet
· 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 Smartsheet 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)
