Data Engineer, Business Intelligence
MerchantE
·
Posted:
July 31, 2023
·
Other
About the position
The job overview for this position is that MerchantE is seeking talented engineers to join their team and help build their future as they transition to a modern architecture on the cloud. The role will involve working on challenging problems in a high-volume and mission-critical environment. The responsibilities include designing, implementing, and maintaining systems for collecting and analyzing business intelligence data, creating dashboards and databases for efficient data collection and evaluation, and collaborating with the data engineering team to improve the efficiency of data pipelines. Additionally, the role will involve developing complex data models and design patterns for BI/Analytics reporting requirements and providing guidance on ELT/ETL, data modeling, and reporting deliverables.
Responsibilities
- Design, implement, and maintain systems used to collect and analyze business intelligence data
- Create dashboards, databases, and other platforms that allow for efficient collection and evaluation of BI data
- Build the reporting data model and help the data engineering team with creating views, SQL scripts
- Perform ETL/ELT and SQL coding using AWS cloud-based solutions and downstream enablement in analytics
- Provide data engineering with functional and technical requirements to improve efficiency of data pipelines
- Develop complex data models and design patterns for BI/Analytics reporting requirements
- Design and develop scalable reporting, dashboards, and data solutions using analytics
- Take part in requirements gathering, logical design, physical design, implementation, testing, and deployment
- Provide best practices and guidance regarding the use of ELT/ETL, data modeling, and reporting deliverables.
Requirements
- Design, implement, and maintain systems used to collect and analyze business intelligence data
- Create dashboards, databases, and other platforms for efficient collection and evaluation of BI data
- Build the reporting data model and assist the data engineering team with creating views and SQL scripts
- Perform ETL/ELT and SQL coding using AWS cloud-based solutions for analytics
- Provide functional and technical requirements to improve efficiency of data pipelines
- Develop complex data models and design patterns for BI/Analytics reporting
- Design and develop scalable reporting, dashboards, and data solutions using analytics
- Participate in requirements gathering, logical design, physical design, implementation, testing, and deployment
- Provide best practices and guidance for ELT/ETL, data modeling, and reporting deliverables
Benefits
- Modern and inspiring work environment
- Collaborative and innovative culture
- Valued ideas and contributions
- Opportunity to work on challenging problems
- No H1B or F-1 visa sponsorship available
- Competitive salary and benefits package
- Opportunity for growth and career development
- Work with cutting-edge technology and cloud architecture
- Collaborate with internal and external teams
- Opportunity to work with BI tools and data visualization
- Experience with ETL processes and data modeling
- Experience with SQL and complex query writing
- Experience with public cloud platforms (AWS, Microsoft Azure, Google Cloud)
- Experience with data warehousing (Redshift or Snowflake)
- Experience with Agile engineering practices