Key skills
PythonSQLETLData EngineeringAnalyticsBIBusiness IntelligencePower BIBigQueryStatistical AnalysisAWSGitHubVersion ControlCRMCommunicationSales
About this role
Business Intelligence Engineer / Data Engineer
Hybrid Role
Compensation: $64
ABOUT THE ROLE
Our client is seeking a highly skilled Business Intelligence Engineer/Data Engineer to join their Marketing Analytics team. In this role, you will focus on optimizing and maintaining Python data pipelines, implementing best practices for code documentation and version control, and developing comprehensive Power BI data models to drive marketing analytics initiatives. You will play a key role in designing scalable marketing data infrastructure, building interactive dashboards, and collaborating with stakeholders to deliver actionable insights. The position also involves developing and maintaining ETL processes, troubleshooting data pipeline issues, and establishing coding standards and documentation protocols. Success in this role will be measured by your ability to document and clean up the existing Python codebase, implement robust error reporting systems, develop comprehensive Power BI data models, reduce data pipeline errors, and enhance marketing insights through improved BI solutions.
WHAT YOU'LL DO
Hybrid Role
Compensation: $64
ABOUT THE ROLE
Our client is seeking a highly skilled Business Intelligence Engineer/Data Engineer to join their Marketing Analytics team. In this role, you will focus on optimizing and maintaining Python data pipelines, implementing best practices for code documentation and version control, and developing comprehensive Power BI data models to drive marketing analytics initiatives. You will play a key role in designing scalable marketing data infrastructure, building interactive dashboards, and collaborating with stakeholders to deliver actionable insights. The position also involves developing and maintaining ETL processes, troubleshooting data pipeline issues, and establishing coding standards and documentation protocols. Success in this role will be measured by your ability to document and clean up the existing Python codebase, implement robust error reporting systems, develop comprehensive Power BI data models, reduce data pipeline errors, and enhance marketing insights through improved BI solutions.
WHAT YOU'LL DO
- Design and architect scalable marketing data infrastructure to support current and future analytical needs
- Develop and optimize Power BI data models and interactive dashboards tailored for marketing analytics
- Create and automate marketing dashboards and reporting solutions using Microsoft Power BI
- Design Power BI dashboard templates to meet the goals of each line of business (LOB)
- Collaborate with marketing stakeholders to gather, understand, and translate analytical requirements
- Ensure data accuracy, consistency, and performance across all BI solutions
- Use Python for advanced data analysis, modeling, automation, and audience segmentation
- Develop scripts for marketing reporting, anomaly detection, and audience segmentation
- Develop audience segmentation and clustering models to identify high-value customer groups and optimize campaign targeting
- Develop and maintain data pipelines and ETL processes to integrate GA4 and other marketing platforms and data products
- Maintain and optimize existing Python scripts for data extraction and file transfer processes
- Debug, troubleshoot, and monitor data pipeline issues to ensure reliable data flow
- Implement comprehensive error reporting and monitoring systems
- Ensure all code adheres to security protocols and compliance requirements
- Document all code and processes in GitHub with clear, maintainable documentation
- Create technical documentation and data governance frameworks to ensure data quality and consistency
- Refactor and clean up existing codebase for improved maintainability and scalability
- Implement version control best practices using GitHub
- Establish coding standards and documentation protocols
- Conduct code reviews and ensure quality assurance processes
- Bachelor's degree in Computer Science, Data Science, Engineering, or related field
- 5+ years of experience in data engineering or business intelligence roles
- Strong proficiency in Python programming and data manipulation libraries
- Extensive experience with Power BI development and data modeling
- Solid understanding of marketing analytics concepts and KPIs
- Experience with GitHub and version control systems
- Knowledge of data security protocols and compliance requirements
- Strong problem-solving and debugging skills
- Excellent documentation and communication skills
- Command of Google Analytics / Google BigQuery (GBQ) (preferred)
- Experience with cloud platforms (AWS) (preferred)
- Experience with marketing automation platforms and CRM systems (Sales Cloud) (preferred)
- Command of SQL and database management systems (preferred)
- Familiarity with data visualization best practices (preferred)
- Understanding of statistical analysis and data science concepts (preferred)
- Certification in Power BI or related BI tools (preferred)
- Opportunity to work in a dynamic, data-driven marketing analytics environment
- Collaborate with cross-functional teams and marketing stakeholders
- Contribute to impactful marketing strategies through advanced analytics and BI solutions
- Flexible hybrid work arrangement
- Competitive compensation
- Professional growth and development opportunities