Business Intelligence Analyst(Marketing Analytics)

Strategic Staffing Solutions is currently looking for a Data Engineer, W-2 contract opportunity, for one of its clients!! Data Engineer/BI Engineer (Power BI and Google Analytics) Locations: Charlotte, NC Type: W-2 Contract Schedule: Hybrid Remote: Monday, Friday Onsite: Tuesday, Wednesday, Thursday Position Overview We are seeking a Business Intelligence Engineer / Data Engineer to join our Marketing Analytics team. This position will focus on optimizing existing Python data pipelines, implementing best practices for code documentation and version control, and developing comprehensive Power BI data models to support marketing analytics initiatives. Top Skills (Team Priorities) • Mastery of Power BI (including DAX) • Strong SQL skills • Python expertise • Business Analyst / Technical Analyst experience • Experience with mapping web and app data, including participation data • Google Analytics (GA4) – REQUIRED Key Responsibilities Business Intelligence & Analytics • Design and architect scalable marketing data infrastructure that supports current and future analytical needs • Design and develop Power BI data models tailored for marketing analytics • Create interactive dashboards and reports that provide actionable marketing insights • Collaborate with marketing stakeholders to understand analytical requirements • Build and automate marketing dashboards using Microsoft Power BI • Design PBI dashboard templates to achieve goals for each line of business (LOB) • Optimize data models for 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 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 (GA4) and 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 • SaaS platform familiarity • Salesforce Marketing Cloud experience (nice to have) Key Success Metrics • Successful documentation and cleanup of existing Python codebase within the first 90 days • Implementation of a 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 Additional Information • Enable Skills-Based Hiring: No Qualification Assessment • Must Have Education Requirement: Associate’s Degree “Beware of scams. S3 never asks for money during its onboarding process.”