Are you a Senior Business Intelligence engineer who is passionate about consulting with all levels of internal stakeholders? Are you incredible with the following technologies: SQL Server, SSIS, SSRS, SSAS, AWS (Lambda, S3, Redshift or Athena), Glue, Python, Data Modeling and most importantly, thrive in a team environment? Are you extremely collaborative and enjoy working with your teammates to impact positive change? Are you looking for your next career opportunity? This position may be for you!!!
Required Skills:
- AWS - Redshift or Athena (must have Lambda and S3 knowledge)
- SQL - Strong background with SSIS, SSAS, SSRS
- Python - must be able to understand, review, and work with the business (coding is a STRONG plus)
- Data Modeling
- Glue
- Looking more data engineering skills (rather than data modeling)
"If candidates have a strong Microsoft background plus have strong Python, Glue, Lambda, and S3 background and have a little Redshift or Athena knowledge but are willing to learn or get more in depth with these skills...we can work with them"
Pluses:
- Data Warehouse experience
- Power BI
- PL/SQL
- C#
- Supply Chain experience
Title: Senior Business Intelligence Engineer
You will become an enabler by, providing support & guidance in defining and delivering their data engineering and analytics needs by turning data into actionable information leveraging on-prem and cloud technologies.
- Demonstrated ability to partner with internal product stakeholders to help define requirements and outcomes for data-focused initiatives
- Ability to decompose large problems and execute smaller, manageable bodies of work to demonstrate continuous architecture delivery
- Architecting and managing scalable data pipelines across on-premise and cloud data repositories
- Create data flow diagrams, and document source to target mapping
- Utilizing their business acumen, analytical mindset, and strong communication/people skills to extract business requirements and translating them into actionable tasks
- Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations etc.
- Create user-facing dashboards that provide key insights at a glance for its specific audience
- Recognize and adopt best practices and cost effective solutions in developing analytical insights on prem and in the cloud
- Provide guidance and mentor junior team members
- Keep current with Business Intelligence data trends and technological innovations
- Execute on POC’s with new technologies, drive innovation, and new ideas
Minimum Requirements, Qualifications, Additional Skills, Aptitude
- 4 Year College Degree from an accredited university in one of the following: Finance, Computer Science Information Systems, Operations Research, Mathematics, Statistics, or related technical field
- 7+ years leveraging Microsoft and its associated array of offerings (SQL, PL/SQL, SSIS, SSRS, SSAS, PowerBI, etc.)
- 5+ years leveraging AWS and its associated array of offerings (Glue, Redshift, Athena, S3, Spectrum, etc.)
- You have deep expertise in Python
- You have collaborated with a development team with established source control (git).
- Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
- Strong experience with business intelligence and data warehousing design principles and industry best practices including multi-dimensional modelling (star schemas, snowflakes, de-normalized models, handling “slow-changing” dimensions)
- Ability to work with stakeholders and changing priorities
- Ability to learn and apply new technologies to business problems
- Data Warehouse experience
- Hands-on experience developing with PowerBI
- You have collaborated with a development team with established source control (git).
- Strong experience with business intelligence and data warehousing design principles and industry best practices including multi-dimensional modelling (star schemas, snowflakes, de-normalized models, handling “slow-changing” dimensions)
- Ability to learn and apply new technologies to business problems
You would be a great fit if:
- You love a challenge and problem solving
- Enjoy learning and working with new technologies
- You are extremely articulate and concise
- You are proactive and resourceful with a drive to match
- You have an intrinsic curiosity for tinkering with data products
- You recognize the importance of data storytelling
- You have excellent written and verbal skills
- You are hardworking and have a strong work ethic
- You are a quick learner and able to apply new technologies to business problems