Job Title: Sr BI Engineer
Location: okay with remote- would love to have someone in the NY area to work hybrid if possible (1-2 days a week)
Duration: 12+ months
PR: $87.50/hr on W2
Description
Hours: Typical 8 hour day
Top 3 Skills
High proficiency in SQL(required), Proficiency in designing, developing, and managing SQL-based ETL pipelines using tools such as Airflow, dbt, or Databricks, 4+ years of business intelligence development experience including designing data models and developing BI dashboards, Proficiency in Tableau, Experience with cloud-based data warehouses (ex. Snowflake, Google BigQuery,
Amazon Redshift).
etting up ETL- Taking codes you write and turning it into a program.
Experience with git and git providers such as Github, Bitbucket, Gitlab(this is a requirement).
Other Skills/Nice to Haves: Experience working with large and complex data sets generated by websites and mobile/tv applications, Experience with Python/Java, Experience with Google BigQuery. Experience with Adobe Analytics, Google Analytics or similar digital analytics tool.
Reporting to the Director of BI Engineering, the Sr. Business Intelligence Engineer will design, develop, and support business intelligence solutions that turn data into actionable insights which support business decision making, analytics, and product development. An ideal candidate should be extremely data-savvy, and should have solid skills in data modeling, data visualization, and overall business intelligence
solutions.
Responsibilities
- Develop, maintain, and optimize business intelligence solutions, including data models, dashboards, and reports.
- Collaborate with cross-functional teams to gather requirements and ensure data solutions meet business needs.
- Ensure data quality and integrity by implementing data validation and monitoring processes.
- Create and manage complex SQL queries including those used in ETL scripts.
- Establish and maintain best practices for the design, development and support of BI solutions.
- Provide technical expertise and guidance to team members and stakeholders.
- Respond and resolve operational problems as necessary. Document, troubleshoot, and resolve day to day data issues.
- Process, clean, and validate the integrity of data to be used for analysis.
- Perform Tableau support work including training and provisioning access.
- Analyze large amounts of information to find patterns and solutions.
- Proactively and continuously pursue professional development and training
Required Qualifications
- 4+ years of business intelligence development experience including designing data models and developing BI dashboards.
- High proficiency in SQL.
- Proficiency in designing, developing, and managing SQL-based ETL pipelines using tools such as Airflow, dbt, or Databricks.
- Proficiency in Tableau
- Experience with cloud-based data warehouses (ex. Snowflake, Google BigQuery, Amazon Redshift).
- Experience collecting business requirements and building reporting solutions to convert large amounts of data into usable information for analysts and business users.
- Familiarity with relational and dimensional database concepts and principles, data modeling, data warehouse design, and data management.
- Strong written and documentation skills for communicating specifications, processes, and metadata to both technical and non-technical audiences.
- Strong organizational, prioritization, and planning skills with an ability to work on multiple projects simultaneously and collaboratively with cross-functional units.
- Strong analytical and problem-solving skills with high attention to detail.
Preferred Qualifications
- Bachelor’s or master’s degree in business, economics, computer science, information systems, statistics, or similar quantitative field.
- Experience working with large and complex data sets generated by websites and mobile/tv applications.
- Experience with Python.
- Experience with Google BigQuery.
- Experience with Adobe Analytics, Google Analytics or similar digital analytics tool.
- Experience with git and git providers such as Github, Bitbucket, Gitlab.