Business Intelligence Engineer/ Data Engineer
Role details
Job location
Tech stack
Job description
performance and scalability + Ensure data accuracy and consistency across all BI solutions + Use Python to perform advanced data analysis, modeling and automation + Develop scripts to streamline marketing reporting, anomaly detection and audience segmentation + Develop audience segmentation and clustering models to identify high-value customer groups and optimize campaign targeting Data Engineering & Pipeline Management + Develop data pipelines and ETL processes to integrate GA4 with other marketing platforms and data products. + Maintain and optimize existing Python scripts for data extraction and file transfer processes + Debug and troubleshoot 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 Code Management & Best Practices + Create technical
Requirements
documentation and data governance frameworks to ensure data quality and consistency. + Clean up and refactor existing codebase for improved maintainability + Implement version control best practices using GitHub + Establish coding standards and documentation protocols + Conduct code reviews and ensure quality assurance processes Required Qualifications + Bachelor's degree in Computer Science, Data Science, Engineering, or related field + 5+ years of experience in data engineering or business intelligence roles + Command of Google Analytics / Google BigQuery (GBQ) + 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 Preferred Qualifications + Experience with cloud platforms (AWS) + Experience with marketing automation platforms and CRM systems (Sales Cloud) + Command of SQL and database management systems + Familiarity with data visualization best practices + Understanding of statistical analysis and data science concepts + Certification in Power BI or related BI tools Key Success Metrics + Successful documentation and cleanup of existing Python codebase within first 90 days + Implementation of robust error reporting system + Development of comprehensive Power BI data models for marketing analytics + Reduction in data pipeline errors and improved system reliability + Enhanced marketing insights through improved BI solutions About US Tech Solutions: US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit