BI Engineer Job Description
BI Engineer Duties & Responsibilities
To write an effective BI engineer job description, begin by listing detailed duties, responsibilities and expectations. We have included BI engineer job description templates that you can modify and use.
Sample responsibilities for this position include:
BI Engineer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for BI Engineer
List any licenses or certifications required by the position: OSHA, AWS, BI, DHS, DAWIA, MCSE, ITIL, CDMP, SW, SAP
Education for BI Engineer
Typically a job would require a certain level of education.
Employers hiring for the BI engineer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Technical, Statistics, Mathematics, Information Systems, Business, Education, Information Technology, Math
Skills for BI Engineer
Desired skills for BI engineer include:
Desired experience for BI engineer includes:
BI Engineer Examples
BI Engineer Job Description
- Develop ETL packages to be run to move data from one system to another
- Schedule packages to be run from JAMS in such a way that conflicts are avoided
- Manage ELT packages in a TFS repository
- Write packages that will operate in multiple scopes using the same package
- Create packages that are easily maintained by junior staff
- Work in a self-organizing team environment where you determine your tasks in coordination with your team
- Collaborate with development and business experts to gain an understanding of complex business logic
- Gather and analyze business requirements to build new data jobs and tables, implement automated processes/workflows to support data initiatives both internally and with external marketing partners
- 25%-Partner with leaders to identify needs and gather requirements
- Understanding the Data Warehouse and leveraging BI tools to create standard reports, dashboards and other components
- 8+ years of experience in architecting, designing and implementing Business Intelligence & Visualization solutions using Tableau and/or Microstrategy
- Tableau Certification and/or Microstrategy Developer/Architect certified
- Excellent data modeling skills with experience in working with very large scale databases including star schemas and snowflake schemas
- Strong understanding of different subject areas of eCommerce business including but not limited to Site Metrics, Internet Marketing, Experimentation, Financial reporting
- Deep knowledge of SQL coding, stored procedures, UDFs, and query optimization
- Influences organization, customers, suppliers and peers within industry on the contribution of own specialism
BI Engineer Job Description
- Two years of experience preferred with SQL Server Analysis Services and MDX query language
- Two years of experience preferred SQL Server database administration
- Two years of experience with SQL Server Integration Services or similar ETL tool
- Operating, maintaining and running the Data Warehouse and BI solutions
- Performing additional job duties and responsibilities as being part of the development team such as collaborating with the BI Architect to develop a robust solution
- Working closely with stakeholders, subject matter experts
- Should have minimum 5 years of relevant experience in SAP Business Objects XIR3/4.x
- Strong experience in Web Intelligence reports development using BI Launchpad (Infoview) / Webi Rich Client
- Knowledge of building Universes using IDT/Universe Designer
- Experience in Crystal Reports development
- Good understanding of underlying data technologies such as Redshift, SQL Server
- Understanding on Business Intelligence Dimensional Modelling, Star Schemas, Slowly Changing Dimensions
- Understanding of ETL process and development
- Lead delivery of new BI and Analytics Platforms
- Influences organization, customers, suppliers and peers within industry
- Advises on the available standards, methods, tools and applications relevant to Business Intelligence, Data Analytics and Data Science and can make correct choices from alternatives
BI Engineer Job Description
- Work with internal customers and other IT disciplines to understand requirements – the data and insight needed to power operational performance, customer experience and competitive advantage, in order to iteratively deliver effective BI solutions across the enterprise
- Work with the BI Team to drive data quality and security standards and practices, using your data lifecycle and classification experience to deliver safe and credible information
- Stay current with leading-edge “big data”/NoSQL/virtualization technologies and patterns, and influence and actively participate in the use of newer platforms, tools and methods for efficient and rapid delivery of high-value BI solutions
- Partner with the Engineering Manager, Engineers, and BI Analysts to build complete BI solutions
- Model data and metadata for pre-built reporting
- Design and implement ELT and ETL data processing solutions from both on-premise (Teradata, Wherescape) and AWS (S3, Redshift)
- Continual performance and query tuning
- Contribute new and innovative ideas to the Enterprise Reporting and BI platform roadmap
- Provide occasional on-call production support after hours
- Design and implement disaster recovery and business continuity plan for data and services
- Expert/Advanced SQL programming skills required
- At least 5 years’ experience administering and supporting a SAP Business Objects server platform
- At least 2 years’ experience with Windows Server and/or Linux server administration
- 4 years’ experience as Business Intelligence platform owner or lead tech engineer
- 1 year experience with big data technologies Hadoop, Mongo, and Cassandra
- SAP Business Intelligence Platform certification
BI Engineer Job Description
- Troubleshoot and resolve issues occurred in daily operations
- Build monitoring reports for various systems, databases and services
- Migrate database, tools, services and applications to AWS cloud
- Maintain and continuous improve the process, tools and configurations for automatic data integration and delivery
- Support diagnosing and fixing problems during release process
- Tracks and reports on the test execution in a timely manner with attention given to
- Achieving a high level of quality
- Work as part of a team to test DWH/BI ODS AND/OR Reports
- Create test plan and align it with overall scope
- Design and create test cases based on business requirements
- Bachelors degree required, ideally with a technical focus
- Minimum 2 years of experience in developing reporting, dashboards, and business analysis with a focus on marketing technologies and solutions
- Highly flexible with an ability to execute well in a fast-paced environment
- Experience with Vertica, MySQL or other database systems
- A strong analytical nature with a focus on performance optimization
- Experience with Hadoop infrastructure
BI Engineer Job Description
- Raise Defects on time and should bring them to closure when it meets business requirements
- Ability and desire to take charge of projects and help drive to completion
- Demonstrated ability to work independently with a team
- Passion for analytics, technology and troubleshooting
- Great personality with strong ambitions to succeed and seek out new challenges and growth opportunities
- Understand OLAP architecture and how the cube interacts with data warehouse model
- Quickly iterate and prototype on key business metrics to arrive at a finished product that aligns with end user expectations
- Understand the fundamentals of a dimensional data warehouse model and how to optimize the way data is organized for consumption in BI tool
- Define and implement relational structures, dimensional data marts/models and cubes for the needs of analytics
- Designs, builds, tests, deploys and maintains cubes and reports
- Experience in working with a range of data tools for example, Ab Initio, Informatica, DataFlux, Datanomic, Trillium, Teradata, IBM InfoSphere DataStage SQL, Access/Excel, Tableau, MicroStrategy
- Ability to write Bash, Perl, Python scripts for monitoring, regular maintenance, and automation of tasks
- 5+ years of experience in executing BI / data warehouse projects
- Minimum Bachelor’s degree in Business, IT or similar field such as Technology
- Learning new things – technology is always changing
- Detailed oriented – will need to juggle multiple deals at once keep track of time