Power Bi Developer

About the Role:

We are on the lookout for a dynamic Marketing Automation and Data Analytics Specialist, someone who is not only adept in marketing automation/operation but also possesses a keen expertise in data analytics and visualization. This role is tailor-made for individuals who are proficient with tools like Eloqua, Marketo, Salesforce Pardot, and Power BI.

As our Marketing Automation and Data Analytics Specialist, your responsibilities will span across managing and optimizing marketing automation systems and overseeing the migration and enhancement of data systems and dashboards. You will play a pivotal role in blending marketing strategies with data analytics, ensuring the creation of visually appealing and effective reports and dashboards. Collaborating closely with marketing teams, you will help in making data-driven decisions that propel the company forward.

We believe in fostering an environment where initiative and self-direction are valued. While you will receive the necessary guidance and support, the autonomy of your role is a testament to our trust in your abilities and professionalism.

Responsibilities:

• Manage and optimize marketing automation systems (Eloqua, Marketo, Salesforce Pardot) to map and improve business processes.
• Develop, audit, and enhance data systems, ensuring accuracy and efficiency in marketing efforts.
• Build and migrate interactive, visually appealing dashboards and reports.
• Develop and maintain reporting and analytics for marketing efforts, database health, lead scoring, and dashboard performance.
• Handle technical aspects of key marketing systems and integrate them with data visualization tools like Power BI.
• Review and improve existing SQL data sources for effective integration and analytics.
• Collaborate closely with sales, marketing, and analytics teams to define requirements, establish best practices, and ensure successful outcomes.
• Ensure all marketing data, dashboards, and reports are accurate and effectively meet business needs.

Ideal Candidate Qualities:

• Strong commitment to the role with a focus on long-term growth.
• Exceptional communication and collaboration skills across diverse teams.
• High degree of autonomy and ability to work effectively without micromanagement.
• Strong attention to detail and organization skills.

Qualifications:

• Hands-on experience with marketing automation systems and data analytics tools like Eloqua, Marketo, Salesforce Pardot and Power Bi .
• Proven experience in data visualization and dashboard creation using Power BI.
• Experience with SQL, including building and optimizing queries.
• Knowledge of ABM and Intent Signaling technologies is a plus.
• Outstanding analytical skills with an ability to work with complex datasets.
• Familiarity with data collection, cleaning, and transformation processes.

Benefits:

• Work-from-home flexibility.
• Career advancement opportunities and professional development support.
• Supportive and collaborative team environment.

Hiring Process:

The hiring process at InEvolution is thoughtfully designed to ensure alignment between your career goals and our company's objectives. The process will include:

• Initial Phone Screening: A brief conversation to discuss your background and understand your career aspirations.
• Team Introduction Interview: Candidates who excel in the first round will engage in a deeper discussion with our team, providing insights into our work culture and the specificities of the role.
• Technical Assessment: In the final round, you will meet our Technical Director for an in-depth conversation about your technical skills and how these align with the demands of the role.

Daily and monthly responsibilities

• Review and coordinate with business application teams on data delivery requirements.
• Develop estimation and proposed delivery schedules in coordination with development team.
• Develop sourcing and data delivery designs.
• Review data model, metadata and delivery criteria for solution.
• Review and coordinate with team on test criteria and performance of testing.
• Contribute to the design, development and completion of project deliverables.
• Complete in-depth data analysis and contribution to strategic efforts
• Complete understanding of how we manage data with focus on improvement of how data is sourced and managed across multiple business areas.

Basic Qualifications

• Bachelor’s degree.
• 5+ years of data analysis working with business data initiatives.
• Knowledge of Structured Query Language (SQL) and use in data access and analysis.
• Proficient in data management including data analytical capability.
• Excellent verbal and written communications also high attention to detail.
• Experience with Python.
• Presentation skills in demonstrating system design and data analysis solutions.

• Good experience on Power BI Visualizations, DAX queries in Power BI
• Experience in implementing Row Level Security
• Can understand data models, can implement simple-medium data models
• Quick learner to pick up the Application data design and processe

• Expert in SQL, Analyze current ETL/SSIS process
• Hands on experience in data modeling  
• Quick learner to pick up the Application data design and processes
• Data warehouse development and work with SSIS & SSAS (Good to have)

• Sound knowledge of Mongo as a primary skill
• . Should have hands on experience of  MySQL as a secondary skill will be enough
• . Experience with replication , sharding and scaling.
• . Design, install, maintain highly available systems (includes monitoring, security, backup, and performance tuning)
• . Implement secure database and server installations (privilege access methodology / role based access)
• . Help application team in query writing, performance tuning & other D2D issues
• • Deploy automation techniques for d2d operations
• . Must possess good analytical and problem solving skills
• . Must be willing to work flexible hours as needed
• . Scripting experience a plus
• . Ability to work independently and as a member of a team
• . good verbal and written communication skills

We are #hiring for AWS Data Engineer expert to join our team

Job Title: AWS Data Engineer

Experience: 5 Yrs to 10Yrs

Location: Remote

Notice: Immediate or Max 20 Days

Role: Permanent Role

Skillset: AWS, ETL, SQL, Python, Pyspark, Postgres DB, Dremio.

Job Description:

 Able to develop ETL jobs.

Able to help with data curation/cleanup, data transformation, and building ETL pipelines.

Strong Postgres DB exp and knowledge of Dremio data visualization/semantic layer between DB and the application is a plus.

Sql, Python, and Pyspark is a must.

Communication should be good

As the successful candidate, you will be required to:

• Design, develop and maintain data quality assurance framework
• Work in conjunction with BI and Data Engineers to ensure high quality Data Deliverable
• Design and develop testing frameworks to test ETL jobs, BI reports and Dashboards and other data pipelines
• Write SQL scripts to validate data in the data repositories against the data in the source systems
• Write SQL scripts to validate data surfacing in BI assets against the data sources
• Ensure data quality by checking against our ODS and the front-end application
• Track, monitor and document testing results

To be eligible for this role, you should possess the following:

• Demonstrated ability to write complex SQL/TSQL queries to retrieve/modify data
• Ability to work in an Agile environment
• Ability to learn new tools and technologies and adapt to an evolving tech-scape

Envoy Global is an equal opportunity employer and will recruit, hire, train and promote into all job levels the most qualified applicants without regard to race, colour, religion, sex, national origin, age, disability, ancestry, sexual orientation, gender identification, veteran status, pregnancy, or any other protected classification.

Working closely with the Product group and other teams, the Data Engineer is responsible for the development, deployment and maintenance of our data infrastructure and applications. With a focus on quality, error-free data delivery, the Data Engineer works to ensure our data is appropriately available and fully supporting various constituencies across our organization. This is a multifaceted opportunity to work with a small, talented team on impactful projects that are essential to ACUE’s higher education success. As an early member of our tech group, you’ll have the unique opportunity to build critical systems and features while helping shape the direction of the team and the product.